View: OKX_ITEM_INSTS_LINES_V

Product:	OKX - Contracts Integration
Description:	View on Installed base item instance line of Oracle Lease management lease contract. This line points to an item instance (instance_id ) in IB
Implementation/DBA Data:	APPS.OKX_ITEM_INSTS_LINES_V

View Text

SELECT CLE.ID ID1
, '#' ID2
, NVL(TL.NAME
, CSI.NAME) NAME
, CLE.LINE_NUMBER DESCRIPTION
, TL.ITEM_DESCRIPTION ITEM_DESCRIPTION
, TL.COMMENTS COMMENTS
, CLE.CHR_ID CHR_ID
, CLE.DNZ_CHR_ID DNZ_CHR_ID
, LS.LTY_CODE LTY_CODE
, LS.LSE_TYPE LSE_TYPE
, LS.LSE_PARENT_ID LSE_PARENT_ID
, CLE.LINE_NUMBER LINE_NUMBER
, CLE.DATE_TERMINATED DATE_TERMINATED
, CLE.START_DATE START_DATE_ACTIVE
, CLE.END_DATE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(CLE.START_DATE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(CLE.END_DATE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, CIM.OBJECT1_ID1 CUSTOMER_PRODUCT_ID
, CIM.OBJECT1_ID2 REFERENCE_NUMBER
, CIM.NUMBER_OF_ITEMS QUANTITY
, CIM.UOM_CODE PRIMARY_UOM_CODE
, CSI.INSTANCE_ID INSTANCE_ID
, CSI.INSTANCE_NUMBER INSTANCE_NUMBER
, CSI.EXTERNAL_REFERENCE EXTERNAL_REFERENCE
, CSI.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CSI.INVENTORY_REVISION INVENTORY_REVISION
, CSI.INV_MASTER_ORGANIZATION_ID INV_MASTER_ORGANIZATION_ID
, CSI.SERIAL_NUMBER SERIAL_NUMBER
, CSI.MFG_SERIAL_NUMBER_FLAG MFG_SERIAL_NUMBER_FLAG
, CSI.LOT_NUMBER LOT_NUMBER
, CSI.QUANTITY QUANTITY
, CSI.UNIT_OF_MEASURE UNIT_OF_MEASURE
, CSI.ACCOUNTING_CLASS_CODE ACCOUNTING_CLASS_CODE
, CSI.INSTANCE_CONDITION_ID INSTANCE_CONDITION_ID
, CSI.INSTANCE_STATUS_ID INSTANCE_STATUS_ID
, CSI.CUSTOMER_VIEW_FLAG CUSTOMER_VIEW_FLAG
, CSI.MERCHANT_VIEW_FLAG MERCHANT_VIEW_FLAG
, CSI.SELLABLE_FLAG SELLABLE_FLAG
, CSI.SYSTEM_ID SYSTEM_ID
, CSI.INSTANCE_TYPE_CODE INSTANCE_TYPE_CODE
, CSI.START_DATE_ACTIVE INSTANCE_ACTIVE_START_DATE
, CSI.END_DATE_ACTIVE INSTANCE_ACTIVE_END_DATE
, CSI.LOCATION_TYPE_CODE LOCATION_TYPE_CODE
, CSI.LOCATION_ID LOCATION_ID
, CSI.INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, CSI.INV_SUBINVENTORY_NAME INV_SUBINVENTORY_NAME
, CSI.INV_LOCATOR_ID INV_LOCATOR_ID
, CSI.PA_PROJECT_ID PA_PROJECT_ID
, CSI.PA_PROJECT_TASK_ID PA_PROJECT_TASK_ID
, CSI.IN_TRANSIT_ORDER_LINE_ID IN_TRANSIT_ORDER_LINE_ID
, CSI.WIP_JOB_ID WIP_JOB_ID
, CSI.PO_ORDER_LINE_ID PO_ORDER_LINE_ID
, CSI.LAST_OE_ORDER_LINE_ID LAST_OE_ORDER_LINE_ID
, CSI.LAST_OE_RMA_LINE_ID LAST_OE_RMA_LINE_ID
, CSI.LAST_PO_PO_LINE_ID LAST_PO_PO_LINE_ID
, CSI.LAST_OE_PO_NUMBER LAST_OE_PO_NUMBER
, CSI.LAST_WIP_JOB_ID LAST_WIP_JOB_ID
, CSI.LAST_PA_PROJECT_ID LAST_PA_PROJECT_ID
, CSI.LAST_PA_TASK_ID LAST_PA_TASK_ID
, CSI.LAST_OE_AGREEMENT_ID LAST_OE_AGREEMENT_ID
, CSI.INSTALL_DATE INSTALL_DATE
, CSI.MANUALLY_CREATED_FLAG MANUALLY_CREATED_FLAG
, CSI.RETURN_BY_DATE RETURN_BY_DATE
, CSI.ACTUAL_RETURN_DATE ACTUAL_RETURN_DATE
, CSI.CREATION_COMPLETE_FLAG CREATION_COMPLETE_FLAG
, CSI.COMPLETENESS_FLAG COMPLETENESS_FLAG
, CSI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CSI.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CSI.SECURITY_GROUP_ID SECURITY_GROUP_ID
, CSI.LAST_TXN_LINE_DETAIL_ID LAST_TXN_LINE_DETAIL_ID
, CSI.INSTALL_LOCATION_TYPE_CODE INSTALL_LOCATION_TYPE_CODE
, CSI.INSTALL_LOCATION_ID INSTALL_LOCATION_ID
, CSI.INSTANCE_USAGE_CODE INSTANCE_USAGE_CODE
, CSI.OWNER_PARTY_SOURCE_TABLE OWNER_PARTY_SOURCE_TABLE
, CSI.OWNER_PARTY_ID OWNER_PARTY_ID
, CSI.OWNER_PARTY_ACCOUNT_ID OWNER_PARTY_ACCOUNT_ID
, CSI.LAST_VLD_ORGANIZATION_ID LAST_VLD_ORGANIZATION_ID
, CSI.MIGRATED_FLAG MIGRATED_FLAG
FROM OKX_INSTALL_ITEMS_V CSI
, OKC_K_LINES_B CLE
, OKC_K_LINES_TL TL
, OKC_LINE_STYLES_B LS
, OKC_K_ITEMS CIM
WHERE TL.ID = CLE.ID
AND TL.LANGUAGE = USERENV('LANG')
AND LS.ID = CLE.LSE_ID
AND CIM.CLE_ID = CLE.ID
AND CIM.JTOT_OBJECT1_CODE = 'OKX_IB_ITEM'
AND CSI.ID1 = CIM.OBJECT1_ID1
AND CSI.ID2 = CIM.OBJECT1_ID2

Columns