DBA Data[Home] [Help]

APPS.MSC_CL_WIP_ODS_LOAD dependencies on MSC_ST_DEMANDS

Line 2613: MSC_ST_DEMANDS msd

2609: msd.ORIGINATION_TYPE,
2610: msd.SR_INSTANCE_ID,
2611: msd.ORGANIZATION_ID
2612: FROM MSC_ITEM_ID_LID t1,
2613: MSC_ST_DEMANDS msd
2614: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2615: AND msd.ORIGINATION_TYPE IN (2,3,4,25,50) /* ds change change 50 eam demand */
2616: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES
2617: AND t1.SR_INVENTORY_ITEM_ID(+)= msd.inventory_item_id

Line 2783: ||' MSC_ST_DEMANDS msd'

2779: ||' FROM MSC_ITEM_ID_LID t1,'
2780: ||' MSC_ITEM_ID_LID t2,'
2781: ||' MSC_ITEM_ID_LID t3,'
2782: || lv_supplies_tbl||' ms,'
2783: ||' MSC_ST_DEMANDS msd'
2784: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2785: ||' AND msd.ORIGINATION_TYPE IN (2,3,4,25,50)' /* 50 eam demand: ds change change*/
2786: ||' AND msd.DELETED_FLAG= '||MSC_UTIL.SYS_NO
2787: ||' AND t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id'

Line 2994: ||' MSC_ST_DEMANDS msd'

2990: ||' FROM MSC_ITEM_ID_LID t1,'
2991: ||' MSC_ITEM_ID_LID t2,'
2992: ||' MSC_ITEM_ID_LID t3,'
2993: || lv_supplies_tbl||' ms,'
2994: ||' MSC_ST_DEMANDS msd'
2995: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2996: ||' AND msd.ORIGINATION_TYPE IN (2,3,4,25,50)' /* 50 eam demand: ds change change*/
2997: ||' AND msd.DELETED_FLAG= '||MSC_UTIL.SYS_NO
2998: ||' AND t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id'