APPS.WMS_RULES_WORKBENCH_PVT dependencies on PO_LINES_ALL

Line 1801: po_lines_all pol,

1797: -- existing where clauses sufficient to stripe by OU
1798:
1799: select poh.vendor_id into l_vendor_id
1800: from po_headers_all poh,
1801: po_lines_all pol,
1802: po_line_locations_all pll
1803: where poh.po_header_id = pol.po_header_id
1804: and pll.po_header_id = pol.po_header_id
1805: and pll.po_line_id = pol.po_line_id

Line 1812: po_lines_all pol,

1808:
1809: elsif (p_reference = 'PO_DISTRIBUTION_ID' ) then
1810: select poh.vendor_id into l_vendor_id
1811: from po_headers_all poh,
1812: po_lines_all pol,
1813: po_distributions_all pod,
1814: po_line_locations_all pll
1815: where poh.po_header_id = pol.po_header_id
1816: and pll.po_header_id = pol.po_header_id

Line 1826: po_lines_all pol,

1822: and pod.po_distribution_id = p_reference_id;
1823: Else
1824: select poh.vendor_id into l_vendor_id
1825: from po_headers_all poh,
1826: po_lines_all pol,
1827: rcv_transactions rct,
1828: po_line_locations_all pll
1829: where poh.po_header_id = pol.po_header_id
1830: and pll.po_header_id = pol.po_header_id