DBA Data[Home] [Help]

APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_ITEM_ID_LID

Line 3224: from MSC_ITEM_ID_LID t1,

3220: msucc.TO_UOM_CLASS,
3221: msucc.CONVERSION_RATE,
3222: msucc.DISABLE_DATE,
3223: msucc.SR_INSTANCE_ID
3224: from MSC_ITEM_ID_LID t1,
3225: MSC_ST_UOM_CLASS_CONVERSIONS msucc
3226: WHERE t1.SR_INVENTORY_ITEM_ID(+)= msucc.Inventory_Item_ID
3227: AND t1.sr_instance_id(+)= msucc.sr_instance_id
3228: AND DECODE( t1.INVENTORY_ITEM_ID, NULL, msucc.Inventory_ITEM_ID,0 )= 0

Line 3246: from MSC_ITEM_ID_LID t1,

3242: msuc.DEFAULT_CONVERSION_FLAG,
3243: msuc.DISABLE_DATE,
3244: msuc.SR_INSTANCE_ID,
3245: msuc.Inventory_Item_ID SR_Inventory_Item_ID
3246: from MSC_ITEM_ID_LID t1,
3247: MSC_ST_UOM_CONVERSIONS msuc
3248: WHERE t1.SR_INVENTORY_ITEM_ID(+)= msuc.Inventory_Item_ID
3249: AND t1.sr_instance_id(+)= msuc.sr_instance_id
3250: AND DECODE( t1.INVENTORY_ITEM_ID, NULL, msuc.Inventory_ITEM_ID,0 )= 0