APPS.WMS_RULES_WORKBENCH_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 1570: po_line_locations_all pll

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
1573: and pll.po_line_id = pol.po_line_id
1574: and pll.shipment_type = 'STANDARD'

Line 1582: po_line_locations_all pll

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
1584: and pll.po_header_id = pol.po_header_id
1585: and pll.po_line_id = pol.po_line_id
1586: and pod.po_header_id = pll.po_header_id

Line 1596: po_line_locations_all pll

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
1598: and pll.po_header_id = pol.po_header_id
1599: and pll.po_line_id = pol.po_line_id
1600: and rct.po_header_id = pll.po_header_id