DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 253: FROM po_distributions_all d

249: org_freight_tl.organization_id = l.org_id)
250: , pvc.first_name || ' ' || pvc.last_name
251: , pvc.phone
252: , decode((SELECT COUNT(d.po_distribution_id)
253: FROM po_distributions_all d
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,

Line 257: FROM po_distributions_all d,

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