DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 266: FROM po_distributions_all d

262: org_freight_tl.organization_id = l.org_id)
263: , pvc.first_name || ' ' || pvc.last_name
264: , pvc.phone
265: , decode((SELECT COUNT(d.po_distribution_id)
266: FROM po_distributions_all d
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,

Line 270: FROM po_distributions_all d,

266: FROM po_distributions_all d
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