APPS.MSC_RESOURCE_AVAILABILITY dependencies on MSC_ITEM_ID_LID

Line 2247: MSC_ITEM_ID_LID t1

2243: msnria.shift_date,
2244: msnria.from_time,
2245: msnria.to_time
2246: FROM msc_st_net_res_inst_avail msnria,
2247: MSC_ITEM_ID_LID t1
2248: WHERE msnria.sr_instance_id = MSC_CL_COLLECTION.v_instance_id
2249: and t1.sr_instance_id (+) = msnria.sr_instance_id
2250: and t1.sr_inventory_item_id (+) = msnria.equipment_item_id
2251: and msnria.organization_id=org_id;

Line 2543: ||' MSC_ITEM_ID_LID t1'

2539: ||' :v_current_date,'
2540: ||' :v_current_user,'
2541: ||' :v_last_collection_id'
2542: ||' FROM msc_st_net_res_inst_avail msnria,'
2543: ||' MSC_ITEM_ID_LID t1'
2544: ||' WHERE msnria.sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2545: ||' and t1.sr_instance_id (+) = msnria.sr_instance_id'
2546: ||' and t1.sr_inventory_item_id (+) = msnria.equipment_item_id'
2547: ||' and msnria.organization_id = ' ||c_rec1.organization_id;