DBA Data[Home] [Help]

APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_ITEM_ID_LID

Line 3214: from MSC_ITEM_ID_LID t1,

3210: msucc.TO_UOM_CLASS,
3211: msucc.CONVERSION_RATE,
3212: msucc.DISABLE_DATE,
3213: msucc.SR_INSTANCE_ID
3214: from MSC_ITEM_ID_LID t1,
3215: MSC_ST_UOM_CLASS_CONVERSIONS msucc
3216: WHERE t1.SR_INVENTORY_ITEM_ID(+)= msucc.Inventory_Item_ID
3217: AND t1.sr_instance_id(+)= msucc.sr_instance_id
3218: AND DECODE( t1.INVENTORY_ITEM_ID, NULL, msucc.Inventory_ITEM_ID,0 )= 0

Line 3236: from MSC_ITEM_ID_LID t1,

3232: msuc.DEFAULT_CONVERSION_FLAG,
3233: msuc.DISABLE_DATE,
3234: msuc.SR_INSTANCE_ID,
3235: msuc.Inventory_Item_ID SR_Inventory_Item_ID
3236: from MSC_ITEM_ID_LID t1,
3237: MSC_ST_UOM_CONVERSIONS msuc
3238: WHERE t1.SR_INVENTORY_ITEM_ID(+)= msuc.Inventory_Item_ID
3239: AND t1.sr_instance_id(+)= msuc.sr_instance_id
3240: AND DECODE( t1.INVENTORY_ITEM_ID, NULL, msuc.Inventory_ITEM_ID,0 )= 0