DBA Data[Home] [Help]

APPS.MSC_CL_ITEM_ODS_LOAD dependencies on MSC_ST_ITEM_SUPPLIERS

Line 2005: MSC_ST_ITEM_SUPPLIERS msis,

2001: msis.SR_INSTANCE_ID
2002: FROM MSC_TP_ID_LID mtil,
2003: MSC_TP_SITE_ID_LID mtsil,
2004: MSC_ITEM_ID_LID t1,
2005: MSC_ST_ITEM_SUPPLIERS msis,
2006: MSC_UNITS_OF_MEASURE muom
2007: -- MSC_UNITS_OF_MEASURE muom1
2008: WHERE t1.SR_INVENTORY_ITEM_ID= msis.inventory_item_id
2009: AND t1.sr_instance_id= msis.sr_instance_id

Line 2152: MSC_ST_ITEM_SUPPLIERS msis

2148: mtil.TP_ID SUPPLIER_ID, mtsil.TP_SITE_ID SUPPLIER_SITE_ID
2149: FROM MSC_TP_ID_LID mtil,
2150: MSC_TP_SITE_ID_LID mtsil,
2151: MSC_ITEM_ID_LID t1,
2152: MSC_ST_ITEM_SUPPLIERS msis
2153: WHERE t1.SR_INVENTORY_ITEM_ID= msis.inventory_item_id
2154: AND t1.sr_instance_id= msis.sr_instance_id
2155: AND mtil.SR_TP_ID = msis.SUPPLIER_ID
2156: AND mtil.SR_INSTANCE_ID = msis.SR_INSTANCE_ID

Line 2207: MSC_ST_ITEM_SUPPLIERS msis,

2203: Msis.SR_INSTANCE_ID
2204: FROM MSC_TP_ID_LID mtil,
2205: MSC_TP_SITE_ID_LID mtsil,
2206: MSC_ITEM_ID_LID t1,
2207: MSC_ST_ITEM_SUPPLIERS msis,
2208: MSC_UNITS_OF_MEASURE muom
2209: WHERE t1.SR_INVENTORY_ITEM_ID= msis.inventory_item_id
2210: AND t1.sr_instance_id= msis.sr_instance_id
2211: AND mtil.SR_TP_ID = msis.SUPPLIER_ID