Page 1 of 1
TO SEE THE ORIGNAL PO
Posted: Wed Nov 01, 2006 2:03 am
by sajid
I REVISED A PO TWICE, HOW CAN I SEE THE ORIGNAL PO?
PLZ REPLY ME AS SOON AS POSSIBLE.
Posted: Thu Nov 09, 2006 7:31 am
by hottowild
check po change history.
Posted: Sat Nov 11, 2006 2:41 am
by ahmadbilal
This Will Help You (Just Hint)
<b>PO_ACTION_HISTORY Table </b>
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
FROM PO_HEADERS_ARCHIVE POH
, PO_VENDORS POV
, PO_LINE_LOCATIONS_ARCHIVE 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