DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on HR_LOCATIONS_ALL

Line 271: hr_locations_all hrloc,

267: WHERE d.line_location_id = sub.subcontract_po_shipment_id),
268: 1,
269: ( SELECT hremp.full_name || ' ' || hrloc.location_code
270: FROM po_distributions_all d,
271: hr_locations_all hrloc,
272: hr_employees hremp
273: WHERE hrloc.location_id(+) = d.deliver_to_location_id AND
274: hremp.employee_id(+) = d.deliver_to_person_id AND
275: d.line_location_id = sub.subcontract_po_shipment_id),

Line 307: hr_locations_all hrloc,

303: po_line_locations_all loc,
304: jmf_subcontract_orders sub,
305: mtl_system_items_vl mtl,
306: po_vendor_sites_all pvsa,
307: hr_locations_all hrloc,
308: hr_locations_all hrloc2,
309: po_vendor_contacts pvc,
310: (select distinct project_id, segment1 AS project_number
311: from pa_projects_all

Line 308: hr_locations_all hrloc2,

304: jmf_subcontract_orders sub,
305: mtl_system_items_vl mtl,
306: po_vendor_sites_all pvsa,
307: hr_locations_all hrloc,
308: hr_locations_all hrloc2,
309: po_vendor_contacts pvc,
310: (select distinct project_id, segment1 AS project_number
311: from pa_projects_all
312: union