APPS.WMS_RULES_WORKBENCH_PVT dependencies on PO_HEADERS_ALL

Line 1568: from po_headers_all poh,

1564: -- MOAC: _ALL tables replace views in next three select statements
1565: -- existing where clauses sufficient to stripe by OU
1566:
1567: select poh.vendor_id into l_vendor_id
1568: from po_headers_all poh,
1569: po_lines_all pol,
1570: po_line_locations_all pll
1571: where poh.po_header_id = pol.po_header_id
1572: and pll.po_header_id = pol.po_header_id

Line 1579: from po_headers_all poh,

1575: and pll.line_location_id = p_reference_id ;
1576:
1577: elsif (p_reference = 'PO_DISTRIBUTION_ID' ) then
1578: select poh.vendor_id into l_vendor_id
1579: from po_headers_all poh,
1580: po_lines_all pol,
1581: po_distributions_all pod,
1582: po_line_locations_all pll
1583: where poh.po_header_id = pol.po_header_id

Line 1593: from po_headers_all poh,

1589: and pll.shipment_type = 'STANDARD'
1590: and pod.po_distribution_id = p_reference_id;
1591: Else
1592: select poh.vendor_id into l_vendor_id
1593: from po_headers_all poh,
1594: po_lines_all pol,
1595: rcv_transactions rct,
1596: po_line_locations_all pll
1597: where poh.po_header_id = pol.po_header_id