APPS.WMS_XDOCK_PEGGING_PUB dependencies on PO_DISTRIBUTIONS_ALL

Line 1748: po_distributions_all pod, po_line_types plt, mtl_units_of_measure muom

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')
1752: AND pol.po_header_id = poh.po_header_id

Line 1773: FROM po_distributions_all pod2

1769: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,
1770: l_inventory_item_id,
1771: poh.vendor_id)) <> 3
1772: AND NOT EXISTS (SELECT 'Invalid Destination'
1773: FROM po_distributions_all pod2
1774: WHERE pod2.po_header_id = poll.po_header_id
1775: AND pod2.po_line_id = poll.po_line_id
1776: AND pod2.line_location_id = poll.line_location_id
1777: AND NVL(pod2.destination_type_code, pod2.destination_context) IN

Line 1804: po_line_locations_all poll, po_distributions_all pod, mtl_units_of_measure muom

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')
1808: AND rsh.shipment_header_id = rsl.shipment_header_id

Line 1826: FROM po_distributions_all pod2

1822: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,
1823: l_inventory_item_id,
1824: rsh.vendor_id)) <> 3
1825: AND NOT EXISTS (SELECT 'Invalid Destination'
1826: FROM po_distributions_all pod2
1827: WHERE pod2.po_header_id = poll.po_header_id
1828: AND pod2.po_line_id = poll.po_line_id
1829: AND pod2.line_location_id = poll.line_location_id
1830: AND NVL(pod2.destination_type_code, pod2.destination_context) IN

Line 2190: FROM po_distributions_all

2186: SELECT muom.uom_code, pod.project_id, pod.task_id
2187: FROM po_line_locations_all poll, mtl_units_of_measure muom,
2188: (SELECT po_header_id, po_line_id, line_location_id,
2189: MIN(project_id) AS project_id, MIN(task_id) AS task_id
2190: FROM po_distributions_all
2191: WHERE po_header_id = l_supply_header_id
2192: AND line_location_id = l_supply_line_id
2193: GROUP BY po_header_id, po_line_id, line_location_id
2194: HAVING COUNT(DISTINCT NVL(project_id, -999)) = 1

Line 2215: FROM po_distributions_all

2211: SELECT muom.uom_code, pod.project_id, pod.task_id
2212: FROM rcv_shipment_lines rsl, po_line_locations_all poll, mtl_units_of_measure muom,
2213: (SELECT po_header_id, po_line_id, line_location_id,
2214: MIN(project_id) AS project_id, MIN(task_id) AS task_id
2215: FROM po_distributions_all
2216: WHERE po_header_id = l_supply_header_id
2217: AND line_location_id = l_supply_line_id
2218: GROUP BY po_header_id, po_line_id, line_location_id
2219: HAVING COUNT(DISTINCT NVL(project_id, -999)) = 1