VIEW: APPS.PO_ITEM_HISTORY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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