APPS.DPP_PURCHASEPRICE_PVT dependencies on PO_LINES_ALL

Line 87: JOIN po_lines_all pol

83: por.release_num,
84: pll.shipment_num,
85: nvl(pll.price_override,pol.unit_price) unit_price
86: FROM po_headers_all poh
87: JOIN po_lines_all pol
88: ON poh.po_header_id = pol.po_header_id
89: AND nvl(pol.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED')
90: AND nvl(poh.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED')
91: AND nvl(pol.cancel_flag,'N') = 'N'

Line 838: po_lines_all pol

834: flv.meaning authorization_status
835: FROM
836: po_headers_all poh
837: JOIN
838: po_lines_all pol
839: ON
840: poh.po_header_id = pol.po_header_id AND
841: nvl(pol.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
842: nvl(poh.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND

Line 881: po_lines_all pol

877: flv.meaning authorization_status
878: FROM
879: po_headers_all poh
880: JOIN
881: po_lines_all pol
882: ON
883: poh.po_header_id = pol.po_header_id AND
884: nvl(pol.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
885: nvl(poh.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND

Line 910: po_lines_all pol,

906: pol.line_num line_num,
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

Line 945: po_lines_all pol

941: flv.meaning authorization_status
942: FROM
943: po_headers_all poh
944: JOIN
945: po_lines_all pol
946: ON
947: poh.po_header_id = pol.po_header_id AND
948: nvl(pol.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
949: nvl(poh.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND

Line 974: po_lines_all pol

970: flv.meaning authorization_status
971: FROM
972: po_headers_all poh
973: JOIN
974: po_lines_all pol
975: ON
976: poh.po_header_id = pol.po_header_id AND
977: nvl(pol.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
978: nvl(poh.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND

Line 1003: po_lines_all pol

999: flv.meaning authorization_status
1000: FROM
1001: po_headers_all poh
1002: JOIN
1003: po_lines_all pol
1004: ON
1005: poh.po_header_id = pol.po_header_id AND
1006: nvl(pol.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
1007: nvl(poh.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND