/* 仕入先(全件) */
[ldbGetObjectsCount_supplier]
select COUNT(*) as CNT
from M_SUPPLIER
where FLG_DELETE = '0'
and (CD_SUPPLIER, DT_START, DT_END) in (
	select CD_SUPPLIER
		,max(DT_START)
		,max(DT_END)
	from M_SUPPLIER
	where FLG_DELETE = '0'
	and KBN_SUPPLIER = '1'
	group by CD_SUPPLIER)


[ldbGetObjects_supplier]
select CD_SUPPLIER
	,NAME_SUPPLIER
from M_SUPPLIER
where FLG_DELETE = '0'
and (CD_SUPPLIER, DT_START, DT_END) in (
	select CD_SUPPLIER
		,max(DT_START)
		,max(DT_END)
	from M_SUPPLIER
	where FLG_DELETE = '0'
	and KBN_SUPPLIER = '1'
	group by CD_SUPPLIER)
order by &2

/* 荷送先(全件) */
[ldbGetObjectsCount_shipment]
select COUNT(*) as CNT
from M_SHIPMENT
where FLG_DELETE = '0'
and (CD_SHIPMENT, DT_START, DT_END) in (
	select CD_SHIPMENT
		,max(DT_START)
		,max(DT_END)
	from M_SHIPMENT
	where FLG_DELETE = '0'
	group by CD_SHIPMENT)


[ldbGetObjects_shipment]
select CD_SHIPMENT
	,NAME_SHIPMENT
from M_SHIPMENT
where FLG_DELETE = '0'
and (CD_SHIPMENT, DT_START, DT_END) in (
	select CD_SHIPMENT
		,max(DT_START)
		,max(DT_END)
	from M_SHIPMENT
	where FLG_DELETE = '0'
	group by CD_SHIPMENT)

/* 銘柄(全件) */
[ldbGetObjectsCount_wp]
select COUNT(*) as CNT
from M_WP
where FLG_DELETE = '0'
and (CD_WP, DT_START, DT_END) in (
	select CD_WP
		,max(DT_START)
		,max(DT_END)
	from M_WP
	where FLG_DELETE = '0'
	group by CD_WP)


[ldbGetObjects_wp]
select CD_WP
	,NAME_GRADE as NAME_WP
from M_WP
where FLG_DELETE = '0'
and (CD_WP, DT_START, DT_END) in (
	select CD_WP
		,max(DT_START)
		,max(DT_END)
	from M_WP
	where FLG_DELETE = '0'
	group by CD_WP)

/* 得意先(全件) */
[ldbGetObjectsCount_customer]
select COUNT(*) as CNT
from M_CUSTOMER
where FLG_DELETE = '0'
and (CD_CUSTOMER, DT_START, DT_END) in (
	select CD_CUSTOMER
		,max(DT_START)
		,max(DT_END)
	from M_CUSTOMER
	where FLG_DELETE = '0'
	group by CD_CUSTOMER)


[ldbGetObjects_customer]
select CD_CUSTOMER
	,NAME_CUSTOMER
from M_CUSTOMER
where FLG_DELETE = '0'
and (CD_CUSTOMER, DT_START, DT_END) in (
	select CD_CUSTOMER
		,max(DT_START)
		,max(DT_END)
	from M_CUSTOMER
	where FLG_DELETE = '0'
	group by CD_CUSTOMER)
order by &2

/* 納品先(全件) */
[ldbGetObjectsCount_derivery]
select COUNT(*) as CNT
from M_DERIVERY
where FLG_DELETE = '0'
and (CD_DERIVERY, DT_START, DT_END) in (
	select CD_DERIVERY
		,max(DT_START)
		,max(DT_END)
	from M_DERIVERY
	where FLG_DELETE = '0'
	group by CD_DERIVERY)


[ldbGetObjects_derivery]
select CD_DERIVERY
	,NAME_DERIVERY
from M_DERIVERY
where 1 = 1
and FLG_DELETE = '0'
and (CD_DERIVERY, DT_START, DT_END) in (
	select CD_DERIVERY
		,max(DT_START)
		,max(DT_END)
	from M_DERIVERY
	where FLG_DELETE = '0'
	group by CD_DERIVERY)

/* パルパー */
[ldbGetObjectsCount_pulper]
select COUNT(*) as CNT
from M_PULPER


[ldbGetObjects_pulper]
select CD_PULPER
	,NAME_PULPER
from M_PULPER
order by &2

/* 製品(全件) */
[ldbGetObjectsCount_product]
select COUNT(*) as CNT
from M_PRODUCT
where FLG_DELETE = '0'
and (CD_PRODUCT, DT_START, DT_END) in (
	select CD_PRODUCT
		,max(DT_START)
		,max(DT_END)
	from M_PRODUCT
	where FLG_DELETE = '0'
	group by CD_PRODUCT)


[ldbGetObjects_product]
select CD_PRODUCT
	,NAME_PRODUCT
from M_PRODUCT
where FLG_DELETE = '0'
and (CD_PRODUCT, DT_START, DT_END) in (
	select CD_PRODUCT
		,max(DT_START)
		,max(DT_END)
	from M_PRODUCT
	where FLG_DELETE = '0'
	group by CD_PRODUCT)
order by &2

/* 特記事項(全件) */
[ldbGetObjectsCount_note]
select COUNT(*) as CNT
from M_NOTE
where FLG_DELETE = '0'


[ldbGetObjects_note]
select CD_NOTE
	,NOTE
from M_NOTE
where FLG_DELETE = '0'
order by &2


/* 担当者 */
[ldbGetObjectsCount_activestaff]
select COUNT(*) as CNT
from M_STAFF
where FLG_DELETE = '0'

[ldbGetObjects_activestaff]
select CD_STAFF
	,NAME_STAFF
	,KANA_STAFF
	,FLG_DELETE
from M_STAFF
where FLG_DELETE = '0'
order by &2

[ldbGetObjectsCount_activecustomer]
select COUNT(*) as CNT
from M_CUSTOMER
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&3', 'yyyymmdd')
and DT_END >= TO_DATE('&3', 'yyyymmdd')

[ldbGetObjects_activecustomer]
select CD_CUSTOMER
	,NAME_CUSTOMER
	,FLG_DELETE
from M_CUSTOMER
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&3', 'yyyymmdd')
and DT_END >= TO_DATE('&3', 'yyyymmdd')
order by &2

[ldbGetObjectsCount_activederivery]
select COUNT(*) as CNT
from M_DERIVERY
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&3', 'yyyymmdd')
and DT_END >= TO_DATE('&3', 'yyyymmdd')
and CD_CUSTOMER = TO_NUMBER('&4')

[ldbGetObjects_activederivery]
select CD_DERIVERY
	,NAME_DERIVERY
	,FLG_DELETE
from M_DERIVERY
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&3', 'yyyymmdd')
and DT_END >= TO_DATE('&3', 'yyyymmdd')
and CD_CUSTOMER = TO_NUMBER('&4')
order by &2

[ldbGetObjectsCount_activederivery_search]
select COUNT(*) as CNT
from M_DERIVERY
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&3', 'yyyymmdd')
and DT_END >= TO_DATE('&3', 'yyyymmdd')


[ldbGetObjects_activederivery_search]
select CD_DERIVERY ,
	NAME_DERIVERY ,
	FLG_DELETE
from M_DERIVERY
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&3', 'yyyymmdd')
and DT_END >= TO_DATE('&3', 'yyyymmdd')
order by &2;


[ldbGetObject_activeproduct]
select m2.CD_PRODUCT ,
	m2.NAME_PRODUCT ,
	m2.CD_GREAD ,
	m3.NAME_GREAD
--#24394 2022.06.17 MOD STT
--from M_DERIVERY_PRODUCT m1 ,
--	M_PRODUCT m2 ,
--	M_GREAD m3
from M_DERIVERY_PRODUCT m1
inner join M_PRODUCT m2
on (m2.CD_PRODUCT = TO_NUMBER('&4') and m2.DT_START <= TO_DATE('&2', 'yyyymmdd') and m2.DT_END >= TO_DATE('&2', 'yyyymmdd'))
left join M_GREAD m3 on (m3.CD_GRADE = m2.CD_GREAD)
--#24394 2022.06.17 MOD END
where m1.FLG_DELETE = '0'
and m1.DT_START <= TO_DATE('&2', 'yyyymmdd')
and m1.DT_END >= TO_DATE('&2', 'yyyymmdd')
and m1.CD_DERIVERY = TO_NUMBER('&3')
--#24394 2022.06.17 MOD STT
--and m2.CD_PRODUCT = TO_NUMBER('&4')
--and m2.DT_START <= TO_DATE('&2', 'yyyymmdd')
--and m2.DT_END >= TO_DATE('&2', 'yyyymmdd')
--and m3.CD_GRADE (+) = m2.CD_GREAD
--#24394 2022.06.17 MOD END


[ldbGetObjectsCount_activeproduct]
select COUNT(*) as CNT
--#24394 2022.06.17 MOD STT
--from M_DERIVERY_PRODUCT m1 ,
--	M_PRODUCT m2 ,
--	M_GREAD m3
from M_DERIVERY_PRODUCT m1
inner join M_PRODUCT m2 on (m2.CD_PRODUCT = m1.CD_PRODUCT and m2.DT_START <= TO_DATE('&3', 'yyyymmdd') and m2.DT_END >= TO_DATE('&3', 'yyyymmdd'))
left join M_GREAD m3 on (m3.CD_GRADE = m2.CD_GREAD)
--#24394 2022.06.17 MOD END
where m1.FLG_DELETE = '0'
and m1.DT_START <= TO_DATE('&3', 'yyyymmdd')
and m1.DT_END >= TO_DATE('&3', 'yyyymmdd')
and m1.CD_DERIVERY = TO_NUMBER('&4') --#24394 2022.06.17 MOD STT
--and m2.CD_PRODUCT = m1.CD_PRODUCT
--and m2.DT_START <= TO_DATE('&3', 'yyyymmdd')
--and m2.DT_END >= TO_DATE('&3', 'yyyymmdd')
--and m3.CD_GRADE (+) = m2.CD_GREAD
--#24394 2022.06.17 MOD END


[ldbGetObjects_activeproduct]
select m2.CD_PRODUCT
	,m2.NAME_PRODUCT
	,m2.CD_GREAD
	,m3.NAME_GREAD
--#24394 2022.06.17 MOD STT
--from M_DERIVERY_PRODUCT m1 ,
--	M_PRODUCT m2 ,
--	M_GREAD m3
from M_DERIVERY_PRODUCT m1
inner join M_PRODUCT m2 on (m2.CD_PRODUCT = m1.CD_PRODUCT and m2.DT_START <= TO_DATE('&3', 'yyyymmdd')
and m2.DT_END >= TO_DATE('&3', 'yyyymmdd'))
left join M_GREAD m3
on (m3.CD_GRADE = m2.CD_GREAD)
--#24394 2022.06.17 MOD END
where m1.FLG_DELETE = '0'
and m1.DT_START <= TO_DATE('&3', 'yyyymmdd')
and m1.DT_END >= TO_DATE('&3', 'yyyymmdd')
and m1.CD_DERIVERY = TO_NUMBER('&4')
--#24394 2022.06.17 MOD STT
--and m2.CD_PRODUCT = m1.CD_PRODUCT
--and m2.DT_START <= TO_DATE('&3', 'yyyymmdd')
--and m2.DT_END >= TO_DATE('&3', 'yyyymmdd')
--and m3.CD_GRADE (+) = m2.CD_GREAD
--#24394 2022.06.17 MOD END
order by &2


[ldbGetObjectsCount_activeproduct_search]
select COUNT(*) as CNT
from M_PRODUCT m2
where m2.DT_START <= TO_DATE('&3', 'yyyymmdd')
and m2.DT_END >= TO_DATE('&3', 'yyyymmdd')
and m2.FLG_DELETE = '0'


[ldbGetObjects_activeproduct_search]
select m2.CD_PRODUCT
	,m2.NAME_PRODUCT
from M_PRODUCT m2
where m2.DT_START <= TO_DATE('&3', 'yyyymmdd')
and m2.DT_END >= TO_DATE('&3', 'yyyymmdd')
and m2.FLG_DELETE = '0'
order by &2

[ldbGetObjectsCount_activesupplier]
select COUNT(*) as CNT
from M_SUPPLIER
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&3', 'yyyymmdd')
and DT_END >= TO_DATE('&3', 'yyyymmdd')
and KBN_SUPPLIER = '1'
--#24381 2022.06.16 MOD STT
--order by &2
--#24381 2022.06.16 MOD END

[ldbGetObjects_activesupplier]
select CD_SUPPLIER
	,NAME_SUPPLIER
	,FLG_DELETE
from M_SUPPLIER
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&3', 'yyyymmdd')
and DT_END >= TO_DATE('&3', 'yyyymmdd')
and KBN_SUPPLIER = '1'
order by &2

[ldbGetObjectsCount_active2supplier]
select COUNT(*) as CNT
from M_SUPPLIER
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&3', 'yyyymmdd')
and DT_END >= TO_DATE('&3', 'yyyymmdd')
order by &2

[ldbGetObjects_active2supplier]
select CD_SUPPLIER
	,NAME_SUPPLIER
	,FLG_DELETE
from M_SUPPLIER
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&3', 'yyyymmdd')
and DT_END >= TO_DATE('&3', 'yyyymmdd')
order by &2

[ldbGetObject_activeshipment]
select CD_SHIPMENT -- 荷送先コード
	,NAME_SHIPMENT -- 荷送先名称
	,ABBR_SHIPMENT -- 荷送先略称
	,KANA_SHIPMENT -- 荷送先かな
	,ZIP_SHIPMENT -- 郵便番号
	,ADD_SHIPMENT -- 住所
	,TEL_SHIPMENT -- 電話番号
	,FAX_SHIPMENT -- ＦＡＸ番号
	,POST_SHIPMENT -- 荷送先担当部署
	,STAFF_SHIPMENT -- 荷送先担当者
	,CD_SUPPLIER -- 仕入先コード
	,CD_TRANSPORT -- 直近運送会社コード
	,CD_AREA -- 直近地域コード
	,FLG_DELETE -- 削除フラグ
from M_SHIPMENT
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&2', 'yyyymmdd')
and DT_END >= TO_DATE('&2', 'yyyymmdd')
and CD_SHIPMENT = TO_NUMBER('&3')

[ldbGetObjectsCount_activeshipment]
select COUNT(*) as CNT
from M_SHIPMENT
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&3', 'yyyymmdd')
and DT_END >= TO_DATE('&3', 'yyyymmdd')
and CD_SUPPLIER = TO_NUMBER('&4')
--#24381 2022.06.16 MOD STT
--order by &2
--#24381 2022.06.16 MOD END

[ldbGetObjects_activeshipment]
select CD_SHIPMENT
	,NAME_SHIPMENT
	,FLG_DELETE
from M_SHIPMENT
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&3', 'yyyymmdd')
and DT_END >= TO_DATE('&3', 'yyyymmdd')
and CD_SUPPLIER = TO_NUMBER('&4')
order by &2


[ldbGetObjectsCount_activeshipment_search]
select COUNT(*) as CNT
from M_SHIPMENT
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&3', 'yyyymmdd')
and DT_END >= TO_DATE('&3', 'yyyymmdd')
--#24381 2022.06.16 MOD STT
--order by &2
--#24381 2022.06.16 MOD END

[ldbGetObjects_activeshipment_search]
select CD_SHIPMENT
	,NAME_SHIPMENT
	,FLG_DELETE
from M_SHIPMENT
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&3', 'yyyymmdd')
and DT_END >= TO_DATE('&3', 'yyyymmdd')
order by &2

[ldbGetObject_activewp]
select m2.CD_WP
	,m2.NAME_GRADE
	,m2.CD_GRADE
from M_SHIPMENT_WP m1 ,	M_WP m2
where m1.FLG_DELETE = '0'
and m1.CD_WP = TO_NUMBER('&5')
and m1.DT_START <= TO_DATE('&2', 'yyyymmdd')
and m1.DT_END >= TO_DATE('&2', 'yyyymmdd')
and m1.CD_SHIPMENT = TO_NUMBER('&4')
and m2.FLG_DELETE = '0'
and m2.CD_WP = m1.CD_WP
and m2.DT_START <= TO_DATE('&2', 'yyyymmdd')
and m2.DT_END >= TO_DATE('&2', 'yyyymmdd')

[ldbGetObjectsCount_activewp]
select COUNT(*) as CNT
from M_SHIPMENT_WP m1 ,	M_WP m2
where m1.FLG_DELETE = '0'
and m1.DT_START <= TO_DATE('&3', 'yyyymmdd')
and m1.DT_END >= TO_DATE('&3', 'yyyymmdd')
and m1.CD_SHIPMENT = TO_NUMBER('&5')
and m2.FLG_DELETE = '0'
and m2.CD_WP = m1.CD_WP
and m2.DT_START <= TO_DATE('&3', 'yyyymmdd')
and m2.DT_END >= TO_DATE('&3', 'yyyymmdd')

[ldbGetObjects_activewp]
select m2.CD_WP
	,m2.NAME_GRADE
from M_SHIPMENT_WP m1 ,	M_WP m2
where m1.FLG_DELETE = '0'
and m1.DT_START <= TO_DATE('&3', 'yyyymmdd')
and m1.DT_END >= TO_DATE('&3', 'yyyymmdd')
and m1.CD_SHIPMENT = TO_NUMBER('&5')
and m2.FLG_DELETE = '0'
and m2.CD_WP = m1.CD_WP
and m2.DT_START <= TO_DATE('&3', 'yyyymmdd')
and m2.DT_END >= TO_DATE('&3', 'yyyymmdd')
order by &2

[ldbGetObjectsCount_activewp_search]
select COUNT(*) as CNT
from M_WP m2
where m2.FLG_DELETE = '0'
and m2.DT_START <= TO_DATE('&3', 'yyyymmdd')
and m2.DT_END >= TO_DATE('&3', 'yyyymmdd')

[ldbGetObjects_activewp_search]
select m2.CD_WP
	,m2.NAME_GRADE
from M_WP m2
where m2.FLG_DELETE = '0'
and m2.DT_START <= TO_DATE('&3', 'yyyymmdd')
and m2.DT_END >= TO_DATE('&3', 'yyyymmdd')
order by &2


[ldbGetObject_activewpsp]
select m3.CD_WP_SUPPLIER
	,m3.NAME_GRADE_SUPPLIER
from M_WP_SUPPLIER m3
where m3.FLG_DELETE = '0'
and m3.DT_START <= TO_DATE('&3', 'yyyymmdd')
and m3.DT_END >= TO_DATE('&3', 'yyyymmdd')
and m3.CD_SUPPLIER = '&4'
and m3.CD_WP = '&5'


[ldbGetObjectsCount_activewpsp]
select COUNT(*) as CNT
from M_WP_SUPPLIER m3
where m3.FLG_DELETE = '0'
and m3.DT_START <= TO_DATE('&3', 'yyyymmdd')
and m3.DT_END >= TO_DATE('&3', 'yyyymmdd')
and m3.CD_SUPPLIER = '&4'
and m3.CD_WP = '&5'


[ldbGetObjects_activewpsp]
select m3.CD_WP_SUPPLIER
	,m3.NAME_GRADE_SUPPLIER
from M_WP_SUPPLIER m3
where m3.FLG_DELETE = '0'
and m3.DT_START <= TO_DATE('&3', 'yyyymmdd')
and m3.DT_END >= TO_DATE('&3', 'yyyymmdd')
and m3.CD_SUPPLIER = '&4'
and m3.CD_WP = '&5'
order by m3.CD_WP_SUPPLIER
		
[ldbGetObject_activewpsupplier]
select CD_WP_SUPPLIER
	,NAME_GRADE_SUPPLIER
from M_WP_SUPPLIER
where FLG_DELETE = '0'
and CD_SUPPLIER = TO_NUMBER('&4')
and CD_WP = TO_NUMBER('&5')
and DT_START <= TO_DATE('&2', 'yyyymmdd')
and DT_END >= TO_DATE('&2', 'yyyymmdd')

[ldbGetObjectsCount_activewpsupplier]
select COUNT(*) as CNT
from M_WP_SUPPLIER
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&3', 'yyyymmdd')
and DT_END >= TO_DATE('&3', 'yyyymmdd')
and CD_SUPPLIER = TO_NUMBER('&4')
and CD_WP = TO_NUMBER('&5')

[ldbGetObjects_activewpsupplier]
select CD_WP_SUPPLIER
	,NAME_GRADE_SUPPLIER
from M_WP_SUPPLIER
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&3', 'yyyymmdd')
and DT_END >= TO_DATE('&3', 'yyyymmdd')
and CD_SUPPLIER = TO_NUMBER('&4')
and CD_WP = TO_NUMBER('&5')
order by &2


[ldbGetObjectsCount_activegrade]
select COUNT(*) as CNT
from M_GREAD
--#24381 2022.06.16 MOD STT
--order by &2
--#24381 2022.06.16 MOD END

[ldbGetObjects_activegrade]
select CD_GRADE
	,NAME_GREAD
from M_GREAD
order by &2

[ldbGetObjectsCount_activetransport]
select COUNT(*) as CNT
from M_TRNSPORT
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&3', 'yyyymmdd')
and DT_END >= TO_DATE('&3', 'yyyymmdd')
--#24381 2022.06.16 MOD STT
--order by &2
--#24381 2022.06.16 MOD END

[ldbGetObjects_activetransport]
select CD_TRANSPORT
	,NAME_TRNSPORT
	,FLG_DELETE
from M_TRNSPORT
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&3', 'yyyymmdd')
and DT_END >= TO_DATE('&3', 'yyyymmdd')
order by &2

[ldbGetObjectsCount_activearea]
select COUNT(*) as CNT
from M_AREA f1 , M_FREIGHT f2
where f1.CD_AREA = f2.CD_AREA
and f2.NUM_AREA = 1
and f2.DIV_TRANSPORT = 0
and f2.CD_TRANSPORT = to_number('&3')
--#24381 2022.06.16 MOD STT
--order by f1.&2
--#24381 2022.06.16 MOD END

[ldbGetObjects_activearea]
select f1.CD_AREA
	,f1.NAME_AREA
from M_AREA f1 , M_FREIGHT f2
where f1.CD_AREA = f2.CD_AREA
and f2.NUM_AREA = 1
and f2.DIV_TRANSPORT = 0
and f2.CD_TRANSPORT = to_number('&3')
order by f1.&2


[ldbGetObjectsCount_activetruck]
select COUNT(*) as CNT
from M_CARNUMBER
--#24426 2022.06.17 MOD STT
--where CD_TRANSPORT = '&4'
where CD_TRANSPORT = to_number('&4')
--#24426 2022.06.17 MOD END
--#24426 2022.06.17 MOD STT
--order by &2
--#24426 2022.06.17 MOD END

[ldbGetObjects_activetruck]
select CD_CARNUMBER
	,NAME_CARNUMBER
from M_CARNUMBER
where CD_TRANSPORT = '&4'
order by &2


[ldbGetObject_activeshipmentwp]
select CD_SHIPMENT -- 荷送先コード
	,CD_WP -- 銘柄コード
	,PRICE_LAST -- 直近単価
	,DT_LAST_RECEIVE -- 最終受入日
	,FLG_DELETE -- 削除フラグ
from M_SHIPMENT_WP
where FLG_DELETE = '0'
and DT_START <= TO_DATE('&2', 'yyyymmdd')
and DT_END >= TO_DATE('&2', 'yyyymmdd')
and CD_WP = TO_NUMBER('&4')
and CD_SHIPMENT = TO_NUMBER('&3')

[ldbGetObject_activefreight]
select CD_TRANSPORT -- 運送会社コード
	,CD_AREA -- 地域コード
	,NUM_AREA -- エリア番号
	,DIV_TRANSPORT -- 運送タイプ区分
	,PRICE_FREIGHT -- 運賃
	,UNIT_FREIGHT -- 単位
	,FLG_DELETE -- 削除フラグ
from M_FREIGHT
where FLG_DELETE = '0'
and CD_TRANSPORT = TO_NUMBER('&2')
and CD_AREA = TO_NUMBER('&3')
and NUM_AREA = 1
and DIV_TRANSPORT = 0

[ldbGetObject_activefsc]
select 'FSC' FLG_FSC
from M_WP
where FLG_DELETE = '0'
and CD_WP = TO_NUMBER('&2')
and FLG_FCS = 1

[ldbGetObject_activefsccd]
select FLG_FCS FSC_CD
from M_WP
where FLG_DELETE = '0'
and CD_WP = TO_NUMBER('&2')

[ldbGetObject_activestockwp]
SELECT
	 SUM(f1.WEIGHT_STOCK) WEIGHT_STOCK
	,SUM(f1.MONEY_STOCK) MONEY_STOCK
--#24382 2022.06.16 MOD STT
--	,DECODE(NVL(SUM(f1.WEIGHT_STOCK), 0), 0, NULL, ROUND(SUM(f1.MONEY_STOCK) / SUM(f1.WEIGHT_STOCK), 1)) UNIT_PRICE_STOCK
	,case coalesce(SUM(f1.WEIGHT_STOCK), 0) when 0 then NULL else ROUND(SUM(f1.MONEY_STOCK) / SUM(f1.WEIGHT_STOCK), 1) end UNIT_PRICE_STOCK
--#24382 2022.06.16 MOD END
FROM (
	-- (前月の)故紙在庫データ
	SELECT
		 + SUM(f1.WEIGHT_STOCK) as WEIGHT_STOCK
		, + SUM(f1.MONEY_STOCK) as MONEY_STOCK
	FROM T_STOCK_WP f1
	WHERE f1.DTS_YM = SUBSTR('&2', 1, 6)
	AND f1.CD_WP = '&5'
	AND f1.CD_GRADE = '&6'
	AND f1.FLG_DELETE = 0
) f1

[ldbGetObjectsCount_activewarehouse]
select COUNT(*) as CNT
from M_WAREHOUSE
where FLG_DELETE = '0'
and ((CD_WAREHOUSE = 0) or (CD_TRANSPORT = '&4'))

[ldbGetObjects_activewarehouse]
select CD_WAREHOUSE
	,NAME_WAREHOUSE
	,FLG_DELETE
from M_WAREHOUSE
where FLG_DELETE = '0'
and ((CD_WAREHOUSE = 0) or (CD_TRANSPORT = '&4'))
order by &2

[ldbGetObjectsCount_activewarehouseall]
select COUNT(*) as CNT
from M_WAREHOUSE
where FLG_DELETE = '0'


[ldbGetObjects_activewarehouseall]
select CD_WAREHOUSE
	,NAME_WAREHOUSE
	,FLG_DELETE
from M_WAREHOUSE
where FLG_DELETE = '0'
order by &2

/* 売上区分 */
[ldbGetObjectsCount_divsale]
select 2 as CNT
from dual

[ldbGetObjects_divsale]
select '0' CD_DIVSALE
	,'売上' NAME_DIVSALE
from dual
union all
select '1' CD_DIVSALE
	,'売上額調整' NAME_DIVSALE
from dual

/* 支払区分 */
[ldbGetObjectsCount_divpayment]
select 2 as CNT
from dual

[ldbGetObjects_divpayment]
select '0' CD_DIVPAYMENT
	,'支払' NAME_DIVPAYMENT
from dual
union all
select '1' CD_DIVPAYMENT
	,'調整' NAME_DIVPAYMENT
from dual

/* 入金区分 */
[ldbGetObjectsCount_divdeposit]
select 2 as CNT
from dual

[ldbGetObjects_divdeposit]
select '0' CD_DIVDEPOSIT
	,'入金' NAME_DIVDEPOSIT
from dual
union all
select '1' CD_DIVDEPOSIT
	,'出荷額調整' NAME_DIVDEPOSIT
from dual

/* 仕入先マスタ締日 */
[ldbGetObjectsCount_supplier_close]
select COUNT(*) as CNT
from M_SUPPLIER
where FLG_DELETE = '0'
and DT_START <= last_day(to_date('&3' || '&4' , 'yyyymm'))
and DT_END >= to_date('&3' || '&4' || '01' , 'yyyymmdd')
and DTD_CLOSE is not null
and CD_SUPPLIER = to_number('&5')
order by &2

[ldbGetObjects_supplier_close]
select distinct lpad(DTD_CLOSE , 2 , '0') CD_CLOSE
	,lpad(DTD_CLOSE , 2 , '0') DTD_CLOSE
from M_SUPPLIER
where FLG_DELETE = '0'
and DT_START <= last_day(to_date('&3' || '&4' , 'yyyymm'))
and DT_END >= to_date('&3' || '&4' || '01' , 'yyyymmdd')
and DTD_CLOSE is not null
and CD_SUPPLIER = to_number('&5')
order by &2

/* 得意先マスタ締日 */
[ldbGetObjectsCount_customer_due]
select COUNT(*) as CNT
from (
	select lpad(DUE_CUSTOMER1 , 2 , '0') CD_DUE
		,lpad(DUE_CUSTOMER1 , 2 , '0') DUE_CUSTOMER
	from M_CUSTOMER
	where FLG_DELETE = '0'
	and DT_START <= last_day(to_date('&3' || '&4' , 'yyyymm'))
	and DT_END >= to_date('&3' || '&4' || '01' , 'yyyymmdd')
	and DUE_CUSTOMER1 is not null
	and CD_CUSTOMER = to_number('&5')
	union
	select lpad(DUE_CUSTOMER2 , 2 , '0') CD_DUE
		,lpad(DUE_CUSTOMER2 , 2 , '0') DUE_CUSTOMER
	from M_CUSTOMER
	where FLG_DELETE = '0'
	and DT_START <= last_day(to_date('&3' || '&4' , 'yyyymm'))
	and DT_END >= to_date('&3' || '&4' || '01' , 'yyyymmdd')
	and DUE_CUSTOMER2 is not null
	and CD_CUSTOMER = to_number('&5')
	union
	select lpad(DUE_CUSTOMER3 , 2 , '0') CD_DUE
		,lpad(DUE_CUSTOMER3 , 2 , '0') DUE_CUSTOMER
	from M_CUSTOMER
	where FLG_DELETE = '0'
	and DT_START <= last_day(to_date('&3' || '&4' , 'yyyymm'))
	and DT_END >= to_date('&3' || '&4' || '01' , 'yyyymmdd')
	and DUE_CUSTOMER3 is not null
	and CD_CUSTOMER = to_number('&5')
)

[ldbGetObjects_customer_due]
select lpad(DUE_CUSTOMER1 , 2 , '0') CD_DUE
	,lpad(DUE_CUSTOMER1 , 2 , '0') DUE_CUSTOMER
from M_CUSTOMER
where FLG_DELETE = '0'
and DT_START <= last_day(to_date('&3' || '&4' , 'yyyymm'))
and DT_END >= to_date('&3' || '&4' || '01' , 'yyyymmdd')
and DUE_CUSTOMER1 is not null
and CD_CUSTOMER = to_number('&5')
union
select lpad(DUE_CUSTOMER2 , 2 , '0') CD_DUE
	,lpad(DUE_CUSTOMER2 , 2 , '0') DUE_CUSTOMER
from M_CUSTOMER
where FLG_DELETE = '0'
and DT_START <= last_day(to_date('&3' || '&4' , 'yyyymm'))
and DT_END >= to_date('&3' || '&4' || '01' , 'yyyymmdd')
and DUE_CUSTOMER2 is not null
and CD_CUSTOMER = to_number('&5')
union
select lpad(DUE_CUSTOMER3 , 2 , '0') CD_DUE
	,lpad(DUE_CUSTOMER3 , 2 , '0') DUE_CUSTOMER
from M_CUSTOMER
where FLG_DELETE = '0'
and DT_START <= last_day(to_date('&3' || '&4' , 'yyyymm'))
and DT_END >= to_date('&3' || '&4' || '01' , 'yyyymmdd')
and DUE_CUSTOMER3 is not null
and CD_CUSTOMER = to_number('&5')
order by &2

/* 対象区分 */
[ldbGetObjectsCount_divadjustment]
select 2 as CNT
from dual

[ldbGetObjects_divadjustment]
select '0' CD_DIVADJUSTMENT
	,'故紙' NAME_DIVADJUSTMENT
from dual
union all
select '1' CD_DIVADJUSTMENT
	,'製品' NAME_DIVADJUSTMENT
from dual

/* 金種 */
[ldbGetObjectsCount_divmoneykind]
select 2 as CNT
from dual

[ldbGetObjects_divmoneykind]
select '0' CD_MONEYKIND
	,'現金' NAME_MONEYKIND
from dual
union all
select '1' CD_MONEYKIND
	,'手形' NAME_MONEYKIND
from dual

/* FSC */
[ldbGetObjectsCount_divfsckind]
select 1 as CNT
from dual

[ldbGetObjects_divfsckind]
select '1' CD_FSCKIND
	,'FSC' NAME_FSCKIND
from dual

[ldbGetObjects_divfsckind_Log]
select '1' CD_FSCKIND
	,'FSC' NAME_FSCKIND
from dual
union all
select '2' CD_FSCKIND
	,'FSC(Contorolled Wood)' NAME_FSCKIND
from dual