APPS.CSI_INSTANCE_DETAILS_V
[Home] [Help]
| Product: | CSI - Install Base |
|---|---|
| Description: | Instance Details. |
| Implementation/DBA Data: |
APPS.CSI_INSTANCE_DETAILS_V
|
SELECT CII.INSTANCE_ID INSTANCE_ID
, CII.INSTANCE_NUMBER INSTANCE_NUMBER
, CII.EXTERNAL_REFERENCE EXTERNAL_REFERENCE
, CII.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CII.INVENTORY_REVISION INVENTORY_REVISION
, CII.INV_MASTER_ORGANIZATION_ID INV_MASTER_ORGANIZATION_ID
, CII.SERIAL_NUMBER SERIAL_NUMBER
, CII.MFG_SERIAL_NUMBER_FLAG MFG_SERIAL_NUMBER_FLAG
, CII.LOT_NUMBER LOT_NUMBER
, CII.QUANTITY QUANTITY
, CII.UNIT_OF_MEASURE UNIT_OF_MEASURE
, CII.ACCOUNTING_CLASS_CODE ACCOUNTING_CLASS_CODE
, CII.INSTANCE_CONDITION_ID INSTANCE_CONDITION_ID
, CII.INSTANCE_STATUS_ID INSTANCE_STATUS_ID
, CII.CUSTOMER_VIEW_FLAG CUSTOMER_VIEW_FLAG
, CII.MERCHANT_VIEW_FLAG MERCHANT_VIEW_FLAG
, CII.SELLABLE_FLAG SELLABLE_FLAG
, CII.SYSTEM_ID SYSTEM_ID
, CII.INSTANCE_TYPE_CODE INSTANCE_TYPE_CODE
, CII.ACTIVE_START_DATE ACTIVE_START_DATE
, CII.ACTIVE_END_DATE ACTIVE_END_DATE
, CII.LOCATION_TYPE_CODE LOCATION_TYPE_CODE
, CII.LOCATION_ID LOCATION_ID
, CII.INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, CII.INV_SUBINVENTORY_NAME INV_SUBINVENTORY_NAME
, CII.INV_LOCATOR_ID INV_LOCATOR_ID
, CII.PA_PROJECT_ID PA_PROJECT_ID
, CII.PA_PROJECT_TASK_ID PA_PROJECT_TASK_ID
, CII.IN_TRANSIT_ORDER_LINE_ID IN_TRANSIT_ORDER_LINE_ID
, CII.WIP_JOB_ID WIP_JOB_ID
, CII.PO_ORDER_LINE_ID PO_ORDER_LINE_ID
, CII.LAST_OE_ORDER_LINE_ID LAST_OE_ORDER_LINE_ID
, CII.LAST_OE_RMA_LINE_ID LAST_OE_RMA_LINE_ID
, CII.LAST_PO_PO_LINE_ID LAST_PO_PO_LINE_ID
, CII.LAST_OE_PO_NUMBER LAST_OE_PO_NUMBER
, CII.LAST_WIP_JOB_ID LAST_WIP_JOB_ID
, CII.LAST_PA_PROJECT_ID LAST_PA_PROJECT_ID
, CII.LAST_PA_TASK_ID LAST_PA_TASK_ID
, CII.LAST_OE_AGREEMENT_ID LAST_OE_AGREEMENT_ID
, CII.INSTALL_DATE INSTALL_DATE
, CII.MANUALLY_CREATED_FLAG MANUALLY_CREATED_FLAG
, CII.RETURN_BY_DATE RETURN_BY_DATE
, CII.ACTUAL_RETURN_DATE ACTUAL_RETURN_DATE
, CII.CREATION_COMPLETE_FLAG CREATION_COMPLETE_FLAG
, CII.COMPLETENESS_FLAG COMPLETENESS_FLAG
, CII.CONTEXT CONTEXT
, CII.ATTRIBUTE1 ATTRIBUTE1
, CII.ATTRIBUTE2 ATTRIBUTE2
, CII.ATTRIBUTE3 ATTRIBUTE3
, CII.ATTRIBUTE4 ATTRIBUTE4
, CII.ATTRIBUTE5 ATTRIBUTE5
, CII.ATTRIBUTE6 ATTRIBUTE6
, CII.ATTRIBUTE7 ATTRIBUTE7
, CII.ATTRIBUTE8 ATTRIBUTE8
, CII.ATTRIBUTE9 ATTRIBUTE9
, CII.ATTRIBUTE10 ATTRIBUTE10
, CII.ATTRIBUTE11 ATTRIBUTE11
, CII.ATTRIBUTE12 ATTRIBUTE12
, CII.ATTRIBUTE13 ATTRIBUTE13
, CII.ATTRIBUTE14 ATTRIBUTE14
, CII.ATTRIBUTE15 ATTRIBUTE15
, CII.CREATED_BY CREATED_BY
, CII.CREATION_DATE CREATION_DATE
, CII.LAST_UPDATED_BY LAST_UPDATED_BY
, CII.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CII.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CII.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CII.LAST_TXN_LINE_DETAIL_ID LAST_TXN_LINE_DETAIL_ID
, CII.INSTALL_LOCATION_TYPE_CODE INSTALL_LOCATION_TYPE_CODE
, CII.INSTALL_LOCATION_ID INSTALL_LOCATION_ID
, CII.INSTANCE_USAGE_CODE INSTANCE_USAGE_CODE
, CII.CONFIG_INST_HDR_ID CONFIG_INST_HDR_ID
, CII.CONFIG_INST_REV_NUM CONFIG_INST_REV_NUM
, CII.CONFIG_INST_ITEM_ID CONFIG_INST_ITEM_ID
, CII.CONFIG_VALID_STATUS CONFIG_VALID_STATUS
, CII.INSTANCE_DESCRIPTION INSTANCE_DESCRIPTION
, MSIKFV.DESCRIPTION DESCRIPTION
, MSI.ITEM_TYPE ITEM_TYPE
, MSI.SERIAL_NUMBER_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE
, MSI.LOT_CONTROL_CODE LOT_CONTROL_CODE
, MSIKFV.CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS
, MSIKFV.PADDED_CONCATENATED_SEGMENTS PADDED_CONCATENATED_SEGMENTS
, UOM.UNIT_OF_MEASURE UNIT_OF_MEASURE_NAME
, HOU.NAME NAME
, MMS.STATUS_CODE STATUS_CODE
, MMS.DESCRIPTION CONDITION_DESCRIPTION
, CIS.NAME STATUS_NAME
, CIS.DESCRIPTION STATUS_DESCRIPTION
, PP.NAME PROJECT_NAME
, PP.PROJECT_TYPE PROJECT_TYPE
, PP.PROJECT_STATUS_CODE PROJECT_STATUS_CODE
, PP.DESCRIPTION PROJECT_DESCRIPTION
, PT.TASK_NUMBER TASK_NUMBER
, PT.TASK_NAME TASK_NAME
, PT.PARENT_TASK_ID PARENT_TASK_ID
, PT.DESCRIPTION TASK_DESCRIPTION
, OEL.LINE_TYPE_ID LINE_TYPE_ID
, OEL.LINE_NUMBER LINE_NUMBER
, OEL.CUST_PO_NUMBER CUST_PO_NUMBER
, OOL.ORDER_NUMBER ORDER_NUMBER
, OOL.VERSION_NUMBER ORDER_LINE_VERSION
, OOL.ORDER_SOURCE_ID ORDER_SOURCE_ID
, OOL.ORDERED_DATE ORDERED_DATE
, WE.WIP_ENTITY_NAME WIP_ENTITY_NAME
, WE.ENTITY_TYPE WIP_ENTITY_TYPE
, WE.DESCRIPTION WIP_ENTITY_DESCRIPTION
, PL.PO_HEADER_ID PO_HEADER_ID
, PL.LINE_TYPE_ID PO_LINE_TYPE_ID
, PL.LINE_NUM PO_LINE_NUMBER
, PL.ITEM_DESCRIPTION ITEM_DESCRIPTION
, CS.NAME SYSTEM_NAME
, LOOH.HEADER_ID LAST_HEADER_ID
, LOOH.ORDER_NUMBER LAST_ORDER_NUMBER
, LOOH.ORDERED_DATE LAST_ORDERED_DATE
, LOOL.LINE_ID LAST_LINE_ID
, LOOL.LINE_NUMBER LAST_LINE_NUMBER
, LOOL.CUST_PO_NUMBER LAST_CUST_PO_NUMBER
, NVL(LOOL.ACTUAL_SHIPMENT_DATE
, LOOL.FULFILLMENT_DATE) SHIPPED_DATE
, CL1.MEANING INSTANCE_USAGE_MEANING
, OAT.NAME AGREEMENT_NAME
, CII.LAST_VLD_ORGANIZATION_ID LAST_VLD_ORGANIZATION_ID
, MSI.BOM_ENABLED_FLAG BOM_ENABLED_FLAG
, MSI.COMMS_NL_TRACKABLE_FLAG COMMS_NL_TRACKABLE_FLAG
, MSI.INVENTORY_ITEM_FLAG INVENTORY_ITEM_FLAG
, MSI.SHIPPABLE_ITEM_FLAG SHIPPABLE_ITEM_FLAG
FROM CSI_ITEM_INSTANCES CII
, MTL_SYSTEM_ITEMS_VL MSIKFV
, MTL_SYSTEM_ITEMS MSI
, HR_ALL_ORGANIZATION_UNITS HOU
, MTL_UNITS_OF_MEASURE_VL UOM
, MTL_MATERIAL_STATUSES MMS
, CSI_INSTANCE_STATUSES CIS
, PA_PROJECTS_ALL PP
, PA_TASKS PT
, OE_ORDER_LINES_ALL OEL
, OE_ORDER_HEADERS_ALL OOL
, OE_AGREEMENTS_TL OAT
, WIP_ENTITIES WE
, PO_LINES_ALL PL
, CSI_SYSTEMS_VL CS
, OE_ORDER_LINES_ALL LOOL
, OE_ORDER_HEADERS_ALL LOOH
, CSI_LOOKUPS CL1
WHERE CII.LAST_VLD_ORGANIZATION_ID = MSI.ORGANIZATION_ID AND CII.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND CII.LAST_VLD_ORGANIZATION_ID = MSIKFV.ORGANIZATION_ID AND CII.INVENTORY_ITEM_ID = MSIKFV.INVENTORY_ITEM_ID AND CII.SYSTEM_ID = CS.SYSTEM_ID (+) AND HOU.ORGANIZATION_ID(+) = CII.LAST_VLD_ORGANIZATION_ID AND CII.UNIT_OF_MEASURE = UOM.UOM_CODE(+) AND CII.INSTANCE_CONDITION_ID = MMS.STATUS_ID (+) AND CII.INSTANCE_STATUS_ID = CIS.INSTANCE_STATUS_ID AND CII.PA_PROJECT_ID = PP.PROJECT_ID (+) AND CII.PA_PROJECT_TASK_ID = PT.TASK_ID (+) AND CII.IN_TRANSIT_ORDER_LINE_ID = OEL.LINE_ID (+) AND OEL.HEADER_ID = OOL.HEADER_ID (+) AND CII.WIP_JOB_ID = WE.WIP_ENTITY_ID(+) AND CII.PO_ORDER_LINE_ID = PL.PO_LINE_ID(+) AND CII.LAST_OE_ORDER_LINE_ID = LOOL.LINE_ID (+) AND LOOL.HEADER_ID = LOOH.HEADER_ID (+) AND CII.INSTANCE_USAGE_CODE = CL1.LOOKUP_CODE (+) AND CL1.LOOKUP_TYPE (+) = 'CSI_INSTANCE_USAGE_CODE' AND OAT.AGREEMENT_ID (+) = CII.LAST_OE_AGREEMENT_ID AND OAT.LANGUAGE (+) = USERENV('LANG')