DBA Data[Home] [Help]

APPS.DPP_PURCHASEPRICE_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 102: LEFT OUTER JOIN po_line_locations_all pll

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

Line 851: po_line_locations_all pll

847: pol.item_id = p_inventory_item_id AND
848: poh.vendor_id = p_vendor_id AND
849: poh.enabled_flag = 'Y'
850: INNER JOIN
851: po_line_locations_all pll
852: ON
853: pol.po_line_id = pll.po_line_id AND
854: (pll.quantity_received > 0 OR (nvl(pol.ALLOW_PRICE_OVERRIDE_FLAG,'N') = 'N' AND poh.type_lookup_code = 'BLANKET')) AND
855: nvl(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND

Line 911: po_line_locations_all pll,

907: flv.meaning authorization_status
908: FROM
909: po_headers_all poh,
910: po_lines_all pol,
911: po_line_locations_all pll,
912: po_releases_all por,
913: fnd_lookup_values flv
914: WHERE
915: poh.po_header_id = pol.po_header_id AND

Line 1016: po_line_locations_all pll

1012: pol.item_id = p_inventory_item_id AND
1013: poh.vendor_id = p_vendor_id AND
1014: poh.enabled_flag = 'Y'
1015: INNER JOIN
1016: po_line_locations_all pll
1017: ON
1018: pol.po_line_id = pll.po_line_id AND
1019: pol.org_id = pll.org_id AND
1020: nvl(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND