View: PO_AP_RETROACTIVE_DIST_V

Product:	PO - Purchasing
Description:	PO_AP_RETROACTIVE_DIST_V view captures the distributions to be invoice adjusted..
Implementation/DBA Data:	APPS.PO_AP_RETROACTIVE_DIST_V

View Text

SELECT DECODE ( POLL.SHIPMENT_TYPE
, 'BLANKET'
, POD.PO_HEADER_ID
, NVL (POL.FROM_HEADER_ID
, POD.PO_HEADER_ID) ) PO_HEADER_ID
, POD.PO_LINE_ID
, POD.LINE_LOCATION_ID
, POD.PO_DISTRIBUTION_ID
, POH.VENDOR_ID
, POD.INVOICE_ADJUSTMENT_FLAG
, POL.UNIT_PRICE
, POLL.PRICE_OVERRIDE
, POLL.RETROACTIVE_DATE
, POD.ORG_ID
FROM PO_HEADERS_ALL POH
, PO_LINES_ALL POL
, PO_LINE_LOCATIONS_ALL POLL
, PO_DISTRIBUTIONS POD
WHERE POH.PO_HEADER_ID = POL.PO_HEADER_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')

Columns