DBA Data[Home] [Help]

APPS.MSC_CL_ITEM_ODS_LOAD dependencies on MSC_TRADING_PARTNERS

Line 3352: MSC_TRADING_PARTNERS mtp,

3348: msi.DMD_SATISFIED_PERCENT
3349: FROM MSC_ITEM_ID_LID t3,
3350: MSC_ITEM_ID_LID t2,
3351: MSC_ITEM_ID_LID t1,
3352: MSC_TRADING_PARTNERS mtp,
3353: MSC_ST_SYSTEM_ITEMS msi
3354: WHERE t1.SR_INVENTORY_ITEM_ID= msi.sr_inventory_item_id
3355: AND t1.sr_instance_id= msi.sr_instance_id
3356: AND t2.SR_INVENTORY_ITEM_ID(+)= msi.base_item_id

Line 4112: ||' MSC_TRADING_PARTNERS mtp, '

4108: ||' msi.PEGGING_SUPPLY_WINDOW_DAYS '
4109: ||' FROM MSC_ITEM_ID_LID t3, '
4110: ||' MSC_ITEM_ID_LID t2, '
4111: ||' MSC_ITEM_ID_LID t1, '
4112: ||' MSC_TRADING_PARTNERS mtp, '
4113: ||' MSC_ST_SYSTEM_ITEMS msi '
4114: ||' WHERE t1.SR_INVENTORY_ITEM_ID = msi.sr_inventory_item_id '
4115: ||' AND t1.sr_instance_id = msi.sr_instance_id '
4116: ||' AND t2.SR_INVENTORY_ITEM_ID(+) = msi.base_item_id '