APPS.DPP_PURCHASEPRICE_PVT dependencies on PO_HEADERS_ALL

Line 86: FROM po_headers_all poh

82: nvl(por.revision_num ,poh.revision_num ) revision_num,
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')

Line 836: po_headers_all poh

832: poh.type_lookup_code,
833: pol.line_num line_num,
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

Line 879: po_headers_all poh

875: poh.type_lookup_code,
876: pol.line_num line_num,
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

Line 909: po_headers_all poh,

905: poh.type_lookup_code,
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

Line 943: po_headers_all poh

939: poh.type_lookup_code,
940: pol.line_num line_num,
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

Line 972: po_headers_all poh

968: poh.type_lookup_code,
969: pol.line_num line_num,
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

Line 1001: po_headers_all poh

997: poh.type_lookup_code,
998: pol.line_num line_num,
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