APPS.DPP_PURCHASEPRICE_PVT dependencies on PO_HEADERS_ALL

Line 87: FROM po_headers_all poh

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

Line 827: po_headers_all poh

823: poh.type_lookup_code,
824: pol.line_num line_num,
825: flv.meaning authorization_status
826: FROM
827: po_headers_all poh
828: JOIN
829: po_lines_all pol
830: ON
831: poh.po_header_id = pol.po_header_id AND

Line 870: po_headers_all poh

866: poh.type_lookup_code,
867: pol.line_num line_num,
868: flv.meaning authorization_status
869: FROM
870: po_headers_all poh
871: JOIN
872: po_lines_all pol
873: ON
874: poh.po_header_id = pol.po_header_id AND

Line 900: po_headers_all poh,

896: poh.type_lookup_code,
897: pol.line_num line_num,
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

Line 934: po_headers_all poh

930: poh.type_lookup_code,
931: pol.line_num line_num,
932: flv.meaning authorization_status
933: FROM
934: po_headers_all poh
935: JOIN
936: po_lines_all pol
937: ON
938: poh.po_header_id = pol.po_header_id AND

Line 963: po_headers_all poh

959: poh.type_lookup_code,
960: pol.line_num line_num,
961: flv.meaning authorization_status
962: FROM
963: po_headers_all poh
964: JOIN
965: po_lines_all pol
966: ON
967: poh.po_header_id = pol.po_header_id AND

Line 992: po_headers_all poh

988: poh.type_lookup_code,
989: pol.line_num line_num,
990: flv.meaning authorization_status
991: FROM
992: po_headers_all poh
993: JOIN
994: po_lines_all pol
995: ON
996: poh.po_header_id = pol.po_header_id AND