View: PO_ITEM_HISTORY_V

Product:	PO - Purchasing
Description:	Replaces PO_ITEM_HISTORY table
Implementation/DBA Data:	APPS.PO_ITEM_HISTORY_V

View Text

SELECT POL.ITEM_ID ITEM_ID
, POV.VENDOR_ID VENDOR_ID
, DECODE(POLL.PO_LINE_ID
, NULL
, POL.QUANTITY
, POLL.QUANTITY) QUANTITY
, POLL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, POLL.LAST_UPDATED_BY LAST_UPDATED_BY
, POLL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, POLL.CREATION_DATE CREATION_DATE
, POLL.CREATED_BY CREATED_BY
, POL.ITEM_REVISION ITEM_REVISION
, POL.UNIT_MEAS_LOOKUP_CODE UNIT_MEAS_LOOKUP_CODE
, DECODE(POLL.PO_LINE_ID
, NULL
, POL.UNIT_PRICE
, POLL.PRICE_OVERRIDE) PRICE
, POLL.CREATION_DATE LATEST_DATE
, POH.PO_HEADER_ID PO_HEADER_ID
, POLL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, POLL.PROGRAM_ID PROGRAM_ID
, POLL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, POLL.REQUEST_ID REQUEST_ID
, POL.ORG_ID
FROM PO_HEADERS_ARCHIVE_ALL POH
, PO_VENDORS POV
, PO_LINE_LOCATIONS_ARCHIVE_ALL POLL
, PO_LINES_ARCHIVE POL
WHERE POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND POH.TYPE_LOOKUP_CODE IN ('STANDARD'
, 'PLANNED'
, 'BLANKET')
AND POV.VENDOR_ID = POH.VENDOR_ID
AND POLL.SHIPMENT_TYPE != 'PRICE BREAK'
AND POLL.PO_LINE_ID = POL.PO_LINE_ID
AND NVL(POH.LATEST_EXTERNAL_FLAG
, 'N') = 'Y'
AND NVL(POL.LATEST_EXTERNAL_FLAG
, 'N') = 'Y'
AND NVL(POLL.LATEST_EXTERNAL_FLAG
, 'N') = 'Y'
AND POH.PO_HEADER_ID = POLL.PO_HEADER_ID

Columns