VIEW: APPS.PO_AP_RETROACTIVE_DIST_V

Source

View Text - Preformatted

SELECT pod.po_header_id, pod.po_line_id, pod.line_location_id, pod.po_distribution_id, poh.vendor_id, poh.vendor_site_id, poh.org_id, pod.invoice_adjustment_flag, pol.unit_price, pr.po_release_id, poll.price_override, poll.retroactive_date FROM po_headers_all poh, po_lines_all pol, po_releases_all pr, po_line_locations_all poll, po_distributions_all pod WHERE poh.po_header_id = pol.po_header_id AND pr.po_release_id(+) = poll.po_release_id AND pol.po_line_id = poll.po_line_id AND poll.line_location_id = pod.line_location_id AND pod.invoice_adjustment_flag in ('R', 'E')

View Text - HTML Formatted

SELECT POD.PO_HEADER_ID
, POD.PO_LINE_ID
, POD.LINE_LOCATION_ID
, POD.PO_DISTRIBUTION_ID
, POH.VENDOR_ID
, POH.VENDOR_SITE_ID
, POH.ORG_ID
, POD.INVOICE_ADJUSTMENT_FLAG
, POL.UNIT_PRICE
, PR.PO_RELEASE_ID
, POLL.PRICE_OVERRIDE
, POLL.RETROACTIVE_DATE
FROM PO_HEADERS_ALL POH
, PO_LINES_ALL POL
, PO_RELEASES_ALL PR
, PO_LINE_LOCATIONS_ALL POLL
, PO_DISTRIBUTIONS_ALL POD
WHERE POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND PR.PO_RELEASE_ID(+) = POLL.PO_RELEASE_ID
AND POL.PO_LINE_ID = POLL.PO_LINE_ID
AND POLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID
AND POD.INVOICE_ADJUSTMENT_FLAG IN ('R'
, 'E')