DBA Data[Home] [Help]

APPS.MSC_CL_ITEM_ODS_LOAD dependencies on MSC_ST_SUPPLIER_CAPACITIES

Line 2045: MSC_ST_SUPPLIER_CAPACITIES mssc

2041: mssc.SR_INSTANCE_ID
2042: FROM MSC_TP_ID_LID mtil,
2043: MSC_TP_SITE_ID_LID mtsil,
2044: MSC_ITEM_ID_LID t1,
2045: MSC_ST_SUPPLIER_CAPACITIES mssc
2046: WHERE t1.SR_INVENTORY_ITEM_ID= mssc.inventory_item_id
2047: AND t1.sr_instance_id= mssc.sr_instance_id
2048: AND mtil.SR_TP_ID = mssc.SUPPLIER_ID
2049: AND mtil.SR_INSTANCE_ID = mssc.SR_INSTANCE_ID

Line 2079: MSC_ST_SUPPLIER_CAPACITIES mssc

2075: mssc.SR_INSTANCE_ID
2076: FROM MSC_TP_ID_LID mtil,
2077: MSC_TP_SITE_ID_LID mtsil,
2078: MSC_ITEM_ID_LID t1,
2079: MSC_ST_SUPPLIER_CAPACITIES mssc
2080: WHERE t1.SR_INVENTORY_ITEM_ID= mssc.inventory_item_id
2081: AND t1.sr_instance_id= mssc.sr_instance_id
2082: AND mtil.SR_TP_ID = mssc.SUPPLIER_ID
2083: AND mtil.SR_INSTANCE_ID = mssc.SR_INSTANCE_ID

Line 2102: MSC_ST_SUPPLIER_CAPACITIES mssc,

2098: mssc.SR_INSTANCE_ID
2099: FROM MSC_TP_ID_LID mtil,
2100: MSC_TP_SITE_ID_LID mtsil,
2101: MSC_ITEM_ID_LID t1,
2102: MSC_ST_SUPPLIER_CAPACITIES mssc,
2103: MSC_SUPPLIER_CAPACITIES msc1
2104: WHERE t1.SR_INVENTORY_ITEM_ID= mssc.inventory_item_id
2105: AND t1.sr_instance_id= mssc.sr_instance_id
2106: AND mtil.SR_TP_ID = mssc.SUPPLIER_ID