APPS.MSC_CL_ITEM_ODS_LOAD dependencies on MSC_TRADING_PARTNERS

Line 3345: MSC_TRADING_PARTNERS mtp,

3341: msi.REPAIR_PROGRAM
3342: FROM MSC_ITEM_ID_LID t3,
3343: MSC_ITEM_ID_LID t2,
3344: MSC_ITEM_ID_LID t1,
3345: MSC_TRADING_PARTNERS mtp,
3346: MSC_ST_SYSTEM_ITEMS msi
3347: WHERE t1.SR_INVENTORY_ITEM_ID= msi.sr_inventory_item_id
3348: AND t1.sr_instance_id= msi.sr_instance_id
3349: AND t2.SR_INVENTORY_ITEM_ID(+)= msi.base_item_id

Line 4091: ||' MSC_TRADING_PARTNERS mtp, '

4087: ||' msi.PEGGING_SUPPLY_WINDOW_DAYS '
4088: ||' FROM MSC_ITEM_ID_LID t3, '
4089: ||' MSC_ITEM_ID_LID t2, '
4090: ||' MSC_ITEM_ID_LID t1, '
4091: ||' MSC_TRADING_PARTNERS mtp, '
4092: ||' MSC_ST_SYSTEM_ITEMS msi '
4093: ||' WHERE t1.SR_INVENTORY_ITEM_ID = msi.sr_inventory_item_id '
4094: ||' AND t1.sr_instance_id = msi.sr_instance_id '
4095: ||' AND t2.SR_INVENTORY_ITEM_ID(+) = msi.base_item_id '