APPS.DPP_PURCHASEPRICE_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 103: LEFT OUTER JOIN po_line_locations_all pll

99: AND poh.authorization_status IN ('APPROVED','REQUIRES REAPPROVAL')
100: and pol.item_id = p_inventory_item_id
101: AND ((nvl(pol.ALLOW_PRICE_OVERRIDE_FLAG,'N') = 'Y' AND poh.type_lookup_code = 'BLANKET')
102: OR (poh.type_lookup_code = 'STANDARD'))
103: LEFT OUTER JOIN po_line_locations_all pll
104: ON pol.po_line_id = pll.po_line_id
105: AND nvl(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED')
106: AND pll.quantity_received = 0
107: AND nvl(pll.cancel_flag,'N') = 'N'

Line 842: po_line_locations_all pll

838: pol.item_id = p_inventory_item_id AND
839: poh.vendor_id = p_vendor_id AND
840: poh.enabled_flag = 'Y'
841: INNER JOIN
842: po_line_locations_all pll
843: ON
844: pol.po_line_id = pll.po_line_id AND
845: (pll.quantity_received > 0 OR (nvl(pol.ALLOW_PRICE_OVERRIDE_FLAG,'N') = 'N' AND poh.type_lookup_code = 'BLANKET')) AND
846: nvl(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND

Line 902: po_line_locations_all pll,

898: flv.meaning authorization_status
899: FROM
900: po_headers_all poh,
901: po_lines_all pol,
902: po_line_locations_all pll,
903: po_releases_all por,
904: fnd_lookup_values flv
905: WHERE
906: poh.po_header_id = pol.po_header_id AND

Line 1007: po_line_locations_all pll

1003: pol.item_id = p_inventory_item_id AND
1004: poh.vendor_id = p_vendor_id AND
1005: poh.enabled_flag = 'Y'
1006: INNER JOIN
1007: po_line_locations_all pll
1008: ON
1009: pol.po_line_id = pll.po_line_id AND
1010: pol.org_id = pll.org_id AND
1011: nvl(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND