Product: | RLM - Release Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.RLM_CUM_ADJ_DETAILS_V |
SELECT ADJ.CUM_KEY_ID
, ADJ.TRANSACTION_DATE_TIME TXN_DATE
, ADJ.TRANSACTION_QTY TXN_QUANTITY
, CKEYS.CUST_UOM_CODE QUANTITY_UOM
, TO_NUMBER(NULL) SHIPMENT_NUMBER
, FUSER.USER_NAME LAST_ADJUSTED_BY
, ADJ.ADJUSTMENT_REASON
, ADJ.ADJUSTMENT_REFERENCE
, ADJ.LAST_UPDATE_DATE
, ADJ.LAST_UPDATED_BY
, ADJ.CREATION_DATE
, ADJ.CREATED_BY
, ADJ.ATTRIBUTE_CATEGORY
, ADJ.ATTRIBUTE1
, ADJ.ATTRIBUTE2
, ADJ.ATTRIBUTE3
, ADJ.ATTRIBUTE4
, ADJ.ATTRIBUTE5
, ADJ.ATTRIBUTE6
, ADJ.ATTRIBUTE7
, ADJ.ATTRIBUTE8
, ADJ.ATTRIBUTE9
, ADJ.ATTRIBUTE10
, ADJ.ATTRIBUTE11
, ADJ.ATTRIBUTE12
, ADJ.ATTRIBUTE13
, ADJ.ATTRIBUTE14
, ADJ.ATTRIBUTE15
, ADJ.TP_ATTRIBUTE_CATEGORY
, ADJ.TP_ATTRIBUTE1
, ADJ.TP_ATTRIBUTE2
, ADJ.TP_ATTRIBUTE3
, ADJ.TP_ATTRIBUTE4
, ADJ.TP_ATTRIBUTE5
, ADJ.TP_ATTRIBUTE6
, ADJ.TP_ATTRIBUTE7
, ADJ.TP_ATTRIBUTE8
, ADJ.TP_ATTRIBUTE9
, ADJ.TP_ATTRIBUTE10
, ADJ.TP_ATTRIBUTE11
, ADJ.TP_ATTRIBUTE12
, ADJ.TP_ATTRIBUTE13
, ADJ.TP_ATTRIBUTE14
, ADJ.TP_ATTRIBUTE15
, ADJ.LAST_UPDATE_LOGIN
, ADJ.REQUEST_ID
, ADJ.PROGRAM_APPLICATION_ID
, ADJ.PROGRAM_ID
, ADJ.PROGRAM_UPDATE_DATE
FROM RLM_CUST_ITEM_CUM_KEYS CKEYS
, RLM_CUST_ITEM_CUM_ADJ ADJ
, FND_USER FUSER
WHERE CKEYS.CUM_KEY_ID = ADJ.CUM_KEY_ID
AND FUSER.USER_ID = ADJ.LAST_UPDATED_BY