APPS.MSC_CL_WIP_ODS_LOAD dependencies on MSC_ST_RESOURCE_REQUIREMENTS

Line 3289: FROM MSC_ST_RESOURCE_REQUIREMENTS msrr

3285: msrr.WIP_ENTITY_ID,
3286: msrr.OPERATION_SEQ_NUM,
3287: msrr.ORIG_RESOURCE_SEQ_NUM,
3288: msrr.SR_INSTANCE_ID
3289: FROM MSC_ST_RESOURCE_REQUIREMENTS msrr
3290: WHERE msrr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3291: AND msrr.DELETED_FLAG= MSC_UTIL.SYS_YES;
3292:
3293: lv_DEPARTMENT_ID NUMBER;

Line 3429: ||' MSC_ST_RESOURCE_REQUIREMENTS msrr,'

3425: ||' msrr.TOUCH_TIME, '
3426: ||' msrr.ACTIVITY_NAME, '
3427: ||' msrr.OPERATION_NAME '
3428: ||' FROM '||lv_supplies_tbl||' ms,'
3429: ||' MSC_ST_RESOURCE_REQUIREMENTS msrr,'
3430: ||' MSC_ITEM_ID_LID miil'
3431: ||' WHERE msrr.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
3432: ||' AND ms.PLAN_ID= -1'
3433: ||' AND ms.SR_INSTANCE_ID= msrr.SR_INSTANCE_ID'

Line 3675: ||' MSC_ST_RESOURCE_REQUIREMENTS msrr, '

3671: ||' :v_current_user, '
3672: ||' :v_current_date, '
3673: ||' :v_current_user '
3674: ||' FROM '||lv_supplies_tbl||' ms, '
3675: ||' MSC_ST_RESOURCE_REQUIREMENTS msrr, '
3676: ||' MSC_ITEM_ID_LID miil '
3677: ||' WHERE msrr.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
3678: ||' AND ms.PLAN_ID= -1'
3679: ||' AND ms.SR_INSTANCE_ID= msrr.SR_INSTANCE_ID'