VIEW: APPS.RLM_CUST_ITEM_CUM_KEYS_V

Source

View Text - Preformatted

SELECT ckeys.rowid row_id, ckeys.CUM_KEY_ID, ckeys.CUSTOMER_ITEM_ID, ckeys.SHIP_FROM_ORG_ID, ckeys.CUM_START_DATE, ckeys.CUST_RECORD_YEAR, ckeys.cust_uom_code, ckeys.CUM_QTY, ckeys.CUM_QTY_TO_BE_ACCUMULATED, ckeys.CUM_QTY_AFTER_CUTOFF, ckeys.LAST_CUM_QTY_UPDATE_DATE, ckeys.PURCHASE_ORDER_NUMBER, ckeys.SHIP_TO_ADDRESS_ID, ckeys.BILL_TO_ADDRESS_ID, ckeys.INTRMD_SHIP_TO_ID, ckeys.LAST_UPDATE_DATE, ckeys.LAST_UPDATED_BY, ckeys.CREATION_DATE, ckeys.CREATED_BY, ckeys.ATTRIBUTE_CATEGORY, ckeys.ATTRIBUTE1, ckeys.ATTRIBUTE2, ckeys.ATTRIBUTE3, ckeys.ATTRIBUTE4, ckeys.ATTRIBUTE5, ckeys.ATTRIBUTE6, ckeys.ATTRIBUTE7, ckeys.ATTRIBUTE8, ckeys.ATTRIBUTE9, ckeys.ATTRIBUTE10, ckeys.ATTRIBUTE11, ckeys.ATTRIBUTE12, ckeys.ATTRIBUTE13, ckeys.ATTRIBUTE14, ckeys.ATTRIBUTE15, ckeys.TP_ATTRIBUTE_CATEGORY, ckeys.TP_ATTRIBUTE1, ckeys.TP_ATTRIBUTE2, ckeys.TP_ATTRIBUTE3, ckeys.TP_ATTRIBUTE4, ckeys.TP_ATTRIBUTE5, ckeys.TP_ATTRIBUTE6, ckeys.TP_ATTRIBUTE7, ckeys.TP_ATTRIBUTE8, ckeys.TP_ATTRIBUTE9, ckeys.TP_ATTRIBUTE10, ckeys.TP_ATTRIBUTE11, ckeys.TP_ATTRIBUTE12, ckeys.TP_ATTRIBUTE13, ckeys.TP_ATTRIBUTE14, ckeys.TP_ATTRIBUTE15, ckeys.LAST_UPDATE_LOGIN, ckeys.REQUEST_ID, ckeys.PROGRAM_APPLICATION_ID, ckeys.PROGRAM_ID, ckeys.PROGRAM_UPDATE_DATE, ckeys.INACTIVE_FLAG, ckeys.CUM_NOTE_TEXT, ckeys.ORG_ID FROM rlm_cust_item_cum_keys ckeys

View Text - HTML Formatted

SELECT CKEYS.ROWID ROW_ID
, CKEYS.CUM_KEY_ID
, CKEYS.CUSTOMER_ITEM_ID
, CKEYS.SHIP_FROM_ORG_ID
, CKEYS.CUM_START_DATE
, CKEYS.CUST_RECORD_YEAR
, CKEYS.CUST_UOM_CODE
, CKEYS.CUM_QTY
, CKEYS.CUM_QTY_TO_BE_ACCUMULATED
, CKEYS.CUM_QTY_AFTER_CUTOFF
, CKEYS.LAST_CUM_QTY_UPDATE_DATE
, CKEYS.PURCHASE_ORDER_NUMBER
, CKEYS.SHIP_TO_ADDRESS_ID
, CKEYS.BILL_TO_ADDRESS_ID
, CKEYS.INTRMD_SHIP_TO_ID
, CKEYS.LAST_UPDATE_DATE
, CKEYS.LAST_UPDATED_BY
, CKEYS.CREATION_DATE
, CKEYS.CREATED_BY
, CKEYS.ATTRIBUTE_CATEGORY
, CKEYS.ATTRIBUTE1
, CKEYS.ATTRIBUTE2
, CKEYS.ATTRIBUTE3
, CKEYS.ATTRIBUTE4
, CKEYS.ATTRIBUTE5
, CKEYS.ATTRIBUTE6
, CKEYS.ATTRIBUTE7
, CKEYS.ATTRIBUTE8
, CKEYS.ATTRIBUTE9
, CKEYS.ATTRIBUTE10
, CKEYS.ATTRIBUTE11
, CKEYS.ATTRIBUTE12
, CKEYS.ATTRIBUTE13
, CKEYS.ATTRIBUTE14
, CKEYS.ATTRIBUTE15
, CKEYS.TP_ATTRIBUTE_CATEGORY
, CKEYS.TP_ATTRIBUTE1
, CKEYS.TP_ATTRIBUTE2
, CKEYS.TP_ATTRIBUTE3
, CKEYS.TP_ATTRIBUTE4
, CKEYS.TP_ATTRIBUTE5
, CKEYS.TP_ATTRIBUTE6
, CKEYS.TP_ATTRIBUTE7
, CKEYS.TP_ATTRIBUTE8
, CKEYS.TP_ATTRIBUTE9
, CKEYS.TP_ATTRIBUTE10
, CKEYS.TP_ATTRIBUTE11
, CKEYS.TP_ATTRIBUTE12
, CKEYS.TP_ATTRIBUTE13
, CKEYS.TP_ATTRIBUTE14
, CKEYS.TP_ATTRIBUTE15
, CKEYS.LAST_UPDATE_LOGIN
, CKEYS.REQUEST_ID
, CKEYS.PROGRAM_APPLICATION_ID
, CKEYS.PROGRAM_ID
, CKEYS.PROGRAM_UPDATE_DATE
, CKEYS.INACTIVE_FLAG
, CKEYS.CUM_NOTE_TEXT
, CKEYS.ORG_ID
FROM RLM_CUST_ITEM_CUM_KEYS CKEYS