DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on PO_HEADERS_ALL

Line 1772: FROM po_headers_all poh, po_lines_all pol, po_line_locations_all poll,

1768: NULL AS secondary_uom_code,
1769: MIN(pod.project_id) AS project_id,
1770: MIN(pod.task_id) AS task_id,
1771: NULL AS lpn_id
1772: FROM po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
1773: po_distributions_all pod, po_line_types plt, mtl_units_of_measure muom
1774: WHERE poh.type_lookup_code IN ('STANDARD','PLANNED','BLANKET','CONTRACT')
1775: AND NVL(poh.cancel_flag, 'N') IN ('N', 'I')
1776: AND NVL(poh.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')