APPS.WMS_XDOCK_PEGGING_PUB dependencies on PO_LINES_ALL

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

1743: NULL AS secondary_uom_code,
1744: MIN(pod.project_id) AS project_id,
1745: MIN(pod.task_id) AS task_id,
1746: NULL AS lpn_id
1747: FROM po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
1748: po_distributions_all pod, po_line_types plt, mtl_units_of_measure muom
1749: WHERE poh.type_lookup_code IN ('STANDARD','PLANNED','BLANKET','CONTRACT')
1750: AND NVL(poh.cancel_flag, 'N') IN ('N', 'I')
1751: AND NVL(poh.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')

Line 1803: FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl, po_lines_all pol, po_line_types plt,

1799: NULL AS secondary_uom_code,
1800: MIN(pod.project_id) AS project_id,
1801: MIN(pod.task_id) AS task_id,
1802: NULL AS lpn_id
1803: FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl, po_lines_all pol, po_line_types plt,
1804: po_line_locations_all poll, po_distributions_all pod, mtl_units_of_measure muom
1805: WHERE rsh.shipment_num IS NOT NULL
1806: AND rsh.receipt_source_code = 'VENDOR'
1807: AND rsh.asn_type in ('ASN','ASBN')