Product: | OKL - Lease and Finance Management |
---|---|
Description: | A contract line level transaction table to record various Install Base Module location attributes of an asset needed by Install Base Module before activating the contract. |
Implementation/DBA Data: | APPS.OKL_TXL_ITM_INSTS_V |
SELECT ITIB.ROWID ROW_ID
, ITIB.ID ID
, ITIB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ITIB.TAS_ID TAS_ID
, ITIB.TAL_ID TAL_ID
, ITIB.KLE_ID KLE_ID
, ITIB.TAL_TYPE TAL_TYPE
, ITIB.LINE_NUMBER LINE_NUMBER
, ITIB.INSTANCE_NUMBER_IB INSTANCE_NUMBER_IB
, ITIB.OBJECT_ID1_NEW OBJECT_ID1_NEW
, ITIB.OBJECT_ID2_NEW OBJECT_ID2_NEW
, ITIB.JTOT_OBJECT_CODE_NEW JTOT_OBJECT_CODE_NEW
, ITIB.OBJECT_ID1_OLD OBJECT_ID1_OLD
, ITIB.OBJECT_ID2_OLD OBJECT_ID2_OLD
, ITIB.JTOT_OBJECT_CODE_OLD JTOT_OBJECT_CODE_OLD
, ITIB.INVENTORY_ORG_ID INVENTORY_ORG_ID
, ITIB.SERIAL_NUMBER SERIAL_NUMBER
, ITIB.MFG_SERIAL_NUMBER_YN MFG_SERIAL_NUMBER_YN
, ITIB.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITIB.INV_MASTER_ORG_ID INV_MASTER_ORG_ID
, ITIB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ITIB.ATTRIBUTE1 ATTRIBUTE1
, ITIB.ATTRIBUTE2 ATTRIBUTE2
, ITIB.ATTRIBUTE3 ATTRIBUTE3
, ITIB.ATTRIBUTE4 ATTRIBUTE4
, ITIB.ATTRIBUTE5 ATTRIBUTE5
, ITIB.ATTRIBUTE6 ATTRIBUTE6
, ITIB.ATTRIBUTE7 ATTRIBUTE7
, ITIB.ATTRIBUTE8 ATTRIBUTE8
, ITIB.ATTRIBUTE9 ATTRIBUTE9
, ITIB.ATTRIBUTE10 ATTRIBUTE10
, ITIB.ATTRIBUTE11 ATTRIBUTE11
, ITIB.ATTRIBUTE12 ATTRIBUTE12
, ITIB.ATTRIBUTE13 ATTRIBUTE13
, ITIB.ATTRIBUTE14 ATTRIBUTE14
, ITIB.ATTRIBUTE15 ATTRIBUTE15
, ITIB.CREATED_BY CREATED_BY
, ITIB.CREATION_DATE CREATION_DATE
, ITIB.LAST_UPDATED_BY LAST_UPDATED_BY
, ITIB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ITIB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ITIB.DNZ_CLE_ID DNZ_CLE_ID
, ITIB.INSTANCE_ID INSTANCE_ID
, ITIB.SELECTED_FOR_SPLIT_FLAG SELECTED_FOR_SPLIT_FLAG
, ITIB.ASD_ID ASD_ID
FROM OKL_TXL_ITM_INSTS ITIB