VIEW: APPS.RLM_CUM_ADJ_DETAILS_V

Source

View Text - Preformatted

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, ckeys.ORG_ID FROM rlm_cust_item_cum_keys ckeys, rlm_cust_item_cum_adj_all adj, fnd_user fuser WHERE ckeys.CUM_KEY_ID = adj.CUM_KEY_ID AND fuser.user_id = adj.last_updated_by AND ckeys.ORG_ID = adj.ORG_ID

View Text - HTML Formatted

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
, CKEYS.ORG_ID
FROM RLM_CUST_ITEM_CUM_KEYS CKEYS
, RLM_CUST_ITEM_CUM_ADJ_ALL ADJ
, FND_USER FUSER
WHERE CKEYS.CUM_KEY_ID = ADJ.CUM_KEY_ID
AND FUSER.USER_ID = ADJ.LAST_UPDATED_BY
AND CKEYS.ORG_ID = ADJ.ORG_ID