APPS.WMS_RULES_WORKBENCH_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 1802: po_line_locations_all pll

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
1806: and pll.shipment_type = 'STANDARD'

Line 1814: po_line_locations_all pll

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
1817: and pll.po_line_id = pol.po_line_id
1818: and pod.po_header_id = pll.po_header_id

Line 1828: po_line_locations_all pll

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
1831: and pll.po_line_id = pol.po_line_id
1832: and rct.po_header_id = pll.po_header_id