VIEW: APPS.RLM_CUST_ITEM_CUM_ADJ_V

Source

View Text - Preformatted

SELECT adj.rowid row_id, adj.cum_adj_id, adj.cum_key_id, adj.transaction_date_time, adj.transaction_qty, adj.adjustment_reference, adj.adjustment_reason, ckeys.cust_uom_code, 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.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_adj_all adj, rlm_cust_item_cum_keys ckeys WHERE adj.cum_key_id = ckeys.cum_key_id AND adj.ORG_ID = ckeys.ORG_ID

View Text - HTML Formatted

SELECT ADJ.ROWID ROW_ID
, ADJ.CUM_ADJ_ID
, ADJ.CUM_KEY_ID
, ADJ.TRANSACTION_DATE_TIME
, ADJ.TRANSACTION_QTY
, ADJ.ADJUSTMENT_REFERENCE
, ADJ.ADJUSTMENT_REASON
, CKEYS.CUST_UOM_CODE
, 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.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_ADJ_ALL ADJ
, RLM_CUST_ITEM_CUM_KEYS CKEYS
WHERE ADJ.CUM_KEY_ID = CKEYS.CUM_KEY_ID
AND ADJ.ORG_ID = CKEYS.ORG_ID