DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on HR_LOCATIONS_ALL

Line 258: hr_locations_all hrloc,

254: WHERE d.line_location_id = sub.subcontract_po_shipment_id),
255: 1,
256: ( SELECT hremp.full_name || ' ' || hrloc.location_code
257: FROM po_distributions_all d,
258: hr_locations_all hrloc,
259: hr_employees hremp
260: WHERE hrloc.location_id(+) = d.deliver_to_location_id AND
261: hremp.employee_id(+) = d.deliver_to_person_id AND
262: d.line_location_id = sub.subcontract_po_shipment_id),

Line 294: hr_locations_all hrloc,

290: po_line_locations_all loc,
291: jmf_subcontract_orders sub,
292: mtl_system_items_vl mtl,
293: po_vendor_sites_all pvsa,
294: hr_locations_all hrloc,
295: hr_locations_all hrloc2,
296: po_vendor_contacts pvc,
297: (select distinct project_id, segment1 AS project_number
298: from pa_projects_all

Line 295: hr_locations_all hrloc2,

291: jmf_subcontract_orders sub,
292: mtl_system_items_vl mtl,
293: po_vendor_sites_all pvsa,
294: hr_locations_all hrloc,
295: hr_locations_all hrloc2,
296: po_vendor_contacts pvc,
297: (select distinct project_id, segment1 AS project_number
298: from pa_projects_all
299: union