DBA Data[Home] [Help]

APPS.MSC_CL_WIP_ODS_LOAD dependencies on MSC_ST_DEMANDS

Line 2638: MSC_ST_DEMANDS msd

2634: msd.ORIGINATION_TYPE,
2635: msd.SR_INSTANCE_ID,
2636: msd.ORGANIZATION_ID
2637: FROM MSC_ITEM_ID_LID t1,
2638: MSC_ST_DEMANDS msd
2639: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2640: AND msd.ORIGINATION_TYPE IN (2,3,4,25,50,70) /* ds change change 50 eam demand */
2641: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES
2642: AND t1.SR_INVENTORY_ITEM_ID(+)= msd.inventory_item_id

Line 2808: ||' MSC_ST_DEMANDS msd'

2804: ||' FROM MSC_ITEM_ID_LID t1,'
2805: ||' MSC_ITEM_ID_LID t2,'
2806: ||' MSC_ITEM_ID_LID t3,'
2807: || lv_supplies_tbl||' ms,'
2808: ||' MSC_ST_DEMANDS msd'
2809: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2810: ||' AND msd.ORIGINATION_TYPE IN (2,3,4,25,50)' /* 50 eam demand: ds change change*/
2811: ||' AND msd.DELETED_FLAG= '||MSC_UTIL.SYS_NO
2812: ||' AND t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id'

Line 3019: ||' MSC_ST_DEMANDS msd'

3015: ||' FROM MSC_ITEM_ID_LID t1,'
3016: ||' MSC_ITEM_ID_LID t2,'
3017: ||' MSC_ITEM_ID_LID t3,'
3018: || lv_supplies_tbl||' ms,'
3019: ||' MSC_ST_DEMANDS msd'
3020: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
3021: ||' AND msd.ORIGINATION_TYPE IN (2,3,4,25,50)' /* 50 eam demand: ds change change*/
3022: ||' AND msd.DELETED_FLAG= '||MSC_UTIL.SYS_NO
3023: ||' AND t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id'