APPS.MSC_CL_WIP_ODS_LOAD dependencies on MSC_ST_RESOURCE_REQUIREMENTS

Line 3314: FROM MSC_ST_RESOURCE_REQUIREMENTS msrr

3310: msrr.WIP_ENTITY_ID,
3311: msrr.OPERATION_SEQ_NUM,
3312: msrr.ORIG_RESOURCE_SEQ_NUM,
3313: msrr.SR_INSTANCE_ID
3314: FROM MSC_ST_RESOURCE_REQUIREMENTS msrr
3315: WHERE msrr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3316: AND msrr.DELETED_FLAG= MSC_UTIL.SYS_YES;
3317:
3318: lv_DEPARTMENT_ID NUMBER;

Line 3461: ||' MSC_ST_RESOURCE_REQUIREMENTS msrr,'

3457: ||' msrr.TOUCH_TIME, '
3458: ||' msrr.ACTIVITY_NAME, '
3459: ||' msrr.OPERATION_NAME '
3460: ||' FROM '||lv_supplies_tbl||' ms,'
3461: ||' MSC_ST_RESOURCE_REQUIREMENTS msrr,'
3462: ||' MSC_ITEM_ID_LID miil'
3463: ||' WHERE msrr.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
3464: ||' AND ms.PLAN_ID= -1'
3465: ||' AND ms.SR_INSTANCE_ID= msrr.SR_INSTANCE_ID'

Line 3723: ||' MSC_ST_RESOURCE_REQUIREMENTS msrr, '

3719: ||' :v_current_user, '
3720: ||' :v_current_date, '
3721: ||' :v_current_user '
3722: ||' FROM '||lv_supplies_tbl||' ms, '
3723: ||' MSC_ST_RESOURCE_REQUIREMENTS msrr, '
3724: ||' MSC_ITEM_ID_LID miil '
3725: ||' WHERE msrr.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
3726: ||' AND ms.PLAN_ID= -1'
3727: ||' AND ms.SR_INSTANCE_ID= msrr.SR_INSTANCE_ID'