FND Design Data [Home] [Help]

View: RLM_CUM_ADJ_DETAILS_V

Product: RLM - Release Management
Description:
Implementation/DBA Data: ViewAPPS.RLM_CUM_ADJ_DETAILS_V
View Text

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

Columns

Name
CUM_KEY_ID
TXN_DATE
TXN_QUANTITY
QUANTITY_UOM
SHIPMENT_NUMBER
LAST_ADJUSTED_BY
ADJUSTMENT_REASON
ADJUSTMENT_REFERENCE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
TP_ATTRIBUTE_CATEGORY
TP_ATTRIBUTE1
TP_ATTRIBUTE2
TP_ATTRIBUTE3
TP_ATTRIBUTE4
TP_ATTRIBUTE5
TP_ATTRIBUTE6
TP_ATTRIBUTE7
TP_ATTRIBUTE8
TP_ATTRIBUTE9
TP_ATTRIBUTE10
TP_ATTRIBUTE11
TP_ATTRIBUTE12
TP_ATTRIBUTE13
TP_ATTRIBUTE14
TP_ATTRIBUTE15
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE