DBA Data[Home] [Help]

APPS.DPP_PURCHASEPRICE_PVT dependencies on PO_LINES_ALL

Line 88: JOIN po_lines_all pol

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')
92: AND nvl(pol.cancel_flag,'N') = 'N'

Line 829: po_lines_all pol

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
832: nvl(pol.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
833: nvl(poh.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND

Line 872: po_lines_all pol

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
875: nvl(pol.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
876: nvl(poh.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND

Line 901: po_lines_all pol,

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
905: WHERE

Line 936: po_lines_all pol

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
939: nvl(pol.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
940: nvl(poh.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND

Line 965: po_lines_all pol

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
968: nvl(pol.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
969: nvl(poh.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND

Line 994: po_lines_all pol

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
997: nvl(pol.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND
998: nvl(poh.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') AND