APPS.MSC_RESOURCE_AVAILABILITY dependencies on MSC_ITEM_ID_LID

Line 2259: MSC_ITEM_ID_LID t1

2255: msnria.shift_date,
2256: msnria.from_time,
2257: msnria.to_time
2258: FROM msc_st_net_res_inst_avail msnria,
2259: MSC_ITEM_ID_LID t1
2260: WHERE msnria.sr_instance_id = MSC_CL_COLLECTION.v_instance_id
2261: and t1.sr_instance_id (+) = msnria.sr_instance_id
2262: and t1.sr_inventory_item_id (+) = msnria.equipment_item_id
2263: and msnria.organization_id=org_id;

Line 2555: ||' MSC_ITEM_ID_LID t1'

2551: ||' :v_current_date,'
2552: ||' :v_current_user,'
2553: ||' :v_last_collection_id'
2554: ||' FROM msc_st_net_res_inst_avail msnria,'
2555: ||' MSC_ITEM_ID_LID t1'
2556: ||' WHERE msnria.sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2557: ||' and t1.sr_instance_id (+) = msnria.sr_instance_id'
2558: ||' and t1.sr_inventory_item_id (+) = msnria.equipment_item_id'
2559: ||' and msnria.organization_id = ' ||c_rec1.organization_id;