DBA Data[Home] [Help]

APPS.CSTACPCS dependencies on MTL_SUPPLY

Line 236: FROM MTL_SUPPLY SUP,

232: SYSDATE,
233: i_prog_id,
234: i_prog_appl_id,
235: i_user_id
236: FROM MTL_SUPPLY SUP,
237: RCV_SHIPMENT_HEADERS RSH
238: WHERE
239: SUP.ITEM_ID IN
240: (select inventory_item_id from mtl_per_close_dtls OLD

Line 444: | MTL_SUPPLY stores the intransit_owning_org_id.

440: | (ii)Items 'in transit' that hav been shipped from
441: | this org to another org and the fob is
442: | receipt in this case.
443: | Note : We dont have to verify the fob because
444: | MTL_SUPPLY stores the intransit_owning_org_id.
445: | Note : We take a fresh snapshot of Intransit info
446: | for each run, therefore, sum from the beginning
447: | of time until now.
448: |-----------------------------------------------------*/

Line 481: FROM MTL_SUPPLY SUP,

477: SYSDATE,
478: i_prog_id,
479: i_prog_appl_id,
480: i_user_id
481: FROM MTL_SUPPLY SUP,
482: RCV_SHIPMENT_HEADERS RSH
483: WHERE
484: INTRANSIT_OWNING_ORG_ID = I_ORG_ID AND
485: SUP.SUPPLY_TYPE_CODE IN ('SHIPMENT','RECEIVING') AND