DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on PO_LINES_ALL

Line 1569: po_lines_all pol,

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

Line 1580: po_lines_all pol,

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

Line 1594: po_lines_all pol,

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