APPS.MSC_CL_WIP_ODS_LOAD dependencies on MSC_ST_RESOURCE_INSTANCE_REQS

Line 2158: FROM MSC_ST_RESOURCE_INSTANCE_REQS msrir

2154: msrir.ORIG_RESOURCE_SEQ_NUM,
2155: msrir.SR_INSTANCE_ID,
2156: msrir.SERIAL_NUMBER,
2157: msrir.RES_INSTANCE_ID
2158: FROM MSC_ST_RESOURCE_INSTANCE_REQS msrir
2159: WHERE msrir.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2160: AND msrir.DELETED_FLAG= MSC_UTIL.SYS_YES;
2161:
2162: lv_DEPARTMENT_ID NUMBER;

Line 2225: ||' MSC_ST_RESOURCE_INSTANCE_REQS msrir,'

2221: ||' msrir.RESOURCE_ID, '
2222: ||' msrir.SERIAL_NUMBER, '
2223: ||' t1.INVENTORY_ITEM_ID equipment_item_id'
2224: ||' FROM '||lv_supplies_tbl||' ms,'
2225: ||' MSC_ST_RESOURCE_INSTANCE_REQS msrir,'
2226: ||' MSC_ITEM_ID_LID t1'
2227: ||' WHERE msrir.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2228: ||' AND ms.PLAN_ID= -1'
2229: ||' AND ms.SR_INSTANCE_ID= msrir.SR_INSTANCE_ID'

Line 2340: ||' MSC_ST_RESOURCE_INSTANCE_REQS msrir, '

2336: ||' :v_current_user, '
2337: ||' :v_current_date, '
2338: ||' :v_current_user '
2339: ||' FROM '||lv_supplies_tbl||' ms, '
2340: ||' MSC_ST_RESOURCE_INSTANCE_REQS msrir, '
2341: ||' MSC_ITEM_ID_LID t1 '
2342: ||' WHERE msrir.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2343: ||' AND ms.PLAN_ID= -1 '
2344: ||' AND ms.SR_INSTANCE_ID= msrir.SR_INSTANCE_ID '