APPS.CSI_IIH_DETAILS_V
[Home] [Help]
| Product: | CSI - Install Base |
|---|---|
| Description: | Item Instance History details view. |
| Implementation/DBA Data: |
APPS.CSI_IIH_DETAILS_V
|
SELECT IH.INSTANCE_HISTORY_ID INSTANCE_HISTORY_ID
, IH.INSTANCE_ID INSTANCE_ID
, IH.TRANSACTION_ID TRANSACTION_ID
, IH.OLD_INSTANCE_NUMBER OLD_INSTANCE_NUMBER
, IH.NEW_INSTANCE_NUMBER NEW_INSTANCE_NUMBER
, IH.OLD_EXTERNAL_REFERENCE OLD_EXTERNAL_REFERENCE
, IH.NEW_EXTERNAL_REFERENCE NEW_EXTERNAL_REFERENCE
, IH.OLD_INVENTORY_ITEM_ID OLD_INVENTORY_ITEM_ID
, IH.NEW_INVENTORY_ITEM_ID NEW_INVENTORY_ITEM_ID
, IH.OLD_INVENTORY_REVISION OLD_INVENTORY_REVISION
, IH.NEW_INVENTORY_REVISION NEW_INVENTORY_REVISION
, IH.OLD_INV_MASTER_ORGANIZATION_ID OLD_INV_MASTER_ORGANIZATION_ID
, IH.NEW_INV_MASTER_ORGANIZATION_ID NEW_INV_MASTER_ORGANIZATION_ID
, IH.OLD_SERIAL_NUMBER OLD_SERIAL_NUMBER
, IH.NEW_SERIAL_NUMBER NEW_SERIAL_NUMBER
, IH.OLD_MFG_SERIAL_NUMBER_FLAG OLD_MFG_SERIAL_NUMBER_FLAG
, IH.NEW_MFG_SERIAL_NUMBER_FLAG NEW_MFG_SERIAL_NUMBER_FLAG
, IH.OLD_LOT_NUMBER OLD_LOT_NUMBER
, IH.NEW_LOT_NUMBER NEW_LOT_NUMBER
, IH.OLD_QUANTITY OLD_QUANTITY
, IH.NEW_QUANTITY NEW_QUANTITY
, IH.OLD_UNIT_OF_MEASURE OLD_UNIT_OF_MEASURE
, IH.NEW_UNIT_OF_MEASURE NEW_UNIT_OF_MEASURE
, IH.OLD_ACCOUNTING_CLASS_CODE OLD_ACCOUNTING_CLASS_CODE
, IH.NEW_ACCOUNTING_CLASS_CODE NEW_ACCOUNTING_CLASS_CODE
, IH.OLD_INSTANCE_CONDITION_ID OLD_INSTANCE_CONDITION_ID
, IH.NEW_INSTANCE_CONDITION_ID NEW_INSTANCE_CONDITION_ID
, IH.OLD_INSTANCE_STATUS_ID OLD_INSTANCE_STATUS_ID
, IH.NEW_INSTANCE_STATUS_ID NEW_INSTANCE_STATUS_ID
, IH.OLD_CUSTOMER_VIEW_FLAG OLD_CUSTOMER_VIEW_FLAG
, IH.NEW_CUSTOMER_VIEW_FLAG NEW_CUSTOMER_VIEW_FLAG
, IH.OLD_MERCHANT_VIEW_FLAG OLD_MERCHANT_VIEW_FLAG
, IH.NEW_MERCHANT_VIEW_FLAG NEW_MERCHANT_VIEW_FLAG
, IH.OLD_SELLABLE_FLAG OLD_SELLABLE_FLAG
, IH.NEW_SELLABLE_FLAG NEW_SELLABLE_FLAG
, IH.OLD_SYSTEM_ID OLD_SYSTEM_ID
, IH.NEW_SYSTEM_ID NEW_SYSTEM_ID
, IH.OLD_INSTANCE_TYPE_CODE OLD_INSTANCE_TYPE_CODE
, IH.NEW_INSTANCE_TYPE_CODE NEW_INSTANCE_TYPE_CODE
, IH.OLD_ACTIVE_START_DATE OLD_ACTIVE_START_DATE
, IH.NEW_ACTIVE_START_DATE NEW_ACTIVE_START_DATE
, IH.OLD_ACTIVE_END_DATE OLD_ACTIVE_END_DATE
, IH.NEW_ACTIVE_END_DATE NEW_ACTIVE_END_DATE
, IH.OLD_LOCATION_TYPE_CODE OLD_LOCATION_TYPE_CODE
, IH.NEW_LOCATION_TYPE_CODE NEW_LOCATION_TYPE_CODE
, IH.OLD_LOCATION_ID OLD_LOCATION_ID
, IH.NEW_LOCATION_ID NEW_LOCATION_ID
, IH.OLD_INV_ORGANIZATION_ID OLD_INV_ORGANIZATION_ID
, IH.NEW_INV_ORGANIZATION_ID NEW_INV_ORGANIZATION_ID
, IH.OLD_INV_SUBINVENTORY_NAME OLD_INV_SUBINVENTORY_NAME
, IH.NEW_INV_SUBINVENTORY_NAME NEW_INV_SUBINVENTORY_NAME
, IH.OLD_INV_LOCATOR_ID OLD_INV_LOCATOR_ID
, IH.NEW_INV_LOCATOR_ID NEW_INV_LOCATOR_ID
, IH.OLD_PA_PROJECT_ID OLD_PA_PROJECT_ID
, IH.NEW_PA_PROJECT_ID NEW_PA_PROJECT_ID
, IH.OLD_PA_PROJECT_TASK_ID OLD_PA_PROJECT_TASK_ID
, IH.NEW_PA_PROJECT_TASK_ID NEW_PA_PROJECT_TASK_ID
, IH.OLD_IN_TRANSIT_ORDER_LINE_ID OLD_IN_TRANSIT_ORDER_LINE_ID
, IH.NEW_IN_TRANSIT_ORDER_LINE_ID NEW_IN_TRANSIT_ORDER_LINE_ID
, IH.OLD_WIP_JOB_ID OLD_WIP_JOB_ID
, IH.NEW_WIP_JOB_ID NEW_WIP_JOB_ID
, IH.OLD_PO_ORDER_LINE_ID OLD_PO_ORDER_LINE_ID
, IH.NEW_PO_ORDER_LINE_ID NEW_PO_ORDER_LINE_ID
, IH.OLD_COMPLETENESS_FLAG OLD_COMPLETENESS_FLAG
, IH.NEW_COMPLETENESS_FLAG NEW_COMPLETENESS_FLAG
, IH.OLD_INST_LOC_TYPE_CODE OLD_INST_LOC_TYPE_CODE
, IH.NEW_INST_LOC_TYPE_CODE NEW_INST_LOC_TYPE_CODE
, IH.OLD_INST_LOC_ID OLD_INST_LOC_ID
, IH.NEW_INST_LOC_ID NEW_INST_LOC_ID
, IH.OLD_INST_USAGE_CODE OLD_INST_USAGE_CODE
, IH.NEW_INST_USAGE_CODE NEW_INST_USAGE_CODE
, IH.OLD_CONTEXT OLD_CONTEXT
, IH.NEW_CONTEXT NEW_CONTEXT
, IH.OLD_ATTRIBUTE1 OLD_ATTRIBUTE1
, IH.NEW_ATTRIBUTE1 NEW_ATTRIBUTE1
, IH.OLD_ATTRIBUTE2 OLD_ATTRIBUTE2
, IH.NEW_ATTRIBUTE2 NEW_ATTRIBUTE2
, IH.OLD_ATTRIBUTE3 OLD_ATTRIBUTE3
, IH.NEW_ATTRIBUTE3 NEW_ATTRIBUTE3
, IH.OLD_ATTRIBUTE4 OLD_ATTRIBUTE4
, IH.NEW_ATTRIBUTE4 NEW_ATTRIBUTE4
, IH.OLD_ATTRIBUTE5 OLD_ATTRIBUTE5
, IH.NEW_ATTRIBUTE5 NEW_ATTRIBUTE5
, IH.OLD_ATTRIBUTE6 OLD_ATTRIBUTE6
, IH.NEW_ATTRIBUTE6 NEW_ATTRIBUTE6
, IH.OLD_ATTRIBUTE7 OLD_ATTRIBUTE7
, IH.NEW_ATTRIBUTE7 NEW_ATTRIBUTE7
, IH.OLD_ATTRIBUTE8 OLD_ATTRIBUTE8
, IH.NEW_ATTRIBUTE8 NEW_ATTRIBUTE8
, IH.OLD_ATTRIBUTE9 OLD_ATTRIBUTE9
, IH.NEW_ATTRIBUTE9 NEW_ATTRIBUTE9
, IH.OLD_ATTRIBUTE10 OLD_ATTRIBUTE10
, IH.NEW_ATTRIBUTE10 NEW_ATTRIBUTE10
, IH.OLD_ATTRIBUTE11 OLD_ATTRIBUTE11
, IH.NEW_ATTRIBUTE11 NEW_ATTRIBUTE11
, IH.OLD_ATTRIBUTE12 OLD_ATTRIBUTE12
, IH.NEW_ATTRIBUTE12 NEW_ATTRIBUTE12
, IH.OLD_ATTRIBUTE13 OLD_ATTRIBUTE13
, IH.NEW_ATTRIBUTE13 NEW_ATTRIBUTE13
, IH.OLD_ATTRIBUTE14 OLD_ATTRIBUTE14
, IH.NEW_ATTRIBUTE14 NEW_ATTRIBUTE14
, IH.OLD_ATTRIBUTE15 OLD_ATTRIBUTE15
, IH.NEW_ATTRIBUTE15 NEW_ATTRIBUTE15
, IH.FULL_DUMP_FLAG FULL_DUMP_FLAG
, IH.CREATED_BY CREATED_BY
, IH.CREATION_DATE CREATION_DATE
, IH.LAST_UPDATED_BY LAST_UPDATED_BY
, IH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IH.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IH.OLD_OE_AGREEMENT_ID OLD_OE_AGREEMENT_ID
, IH.NEW_OE_AGREEMENT_ID NEW_OE_AGREEMENT_ID
, IH.OLD_LAST_VLD_ORGANIZATION_ID OLD_LAST_VLD_ORGANIZATION_ID
, IH.NEW_LAST_VLD_ORGANIZATION_ID NEW_LAST_VLD_ORGANIZATION_ID
, IH.OLD_CONFIG_INST_REV_NUM OLD_CONFIG_INST_REV_NUM
, IH.NEW_CONFIG_INST_REV_NUM NEW_CONFIG_INST_REV_NUM
, IH.OLD_CONFIG_VALID_STATUS OLD_CONFIG_VALID_STATUS
, IH.NEW_CONFIG_VALID_STATUS NEW_CONFIG_VALID_STATUS
, IH.OLD_INSTANCE_DESCRIPTION OLD_INSTANCE_DESCRIPTION
, IH.NEW_INSTANCE_DESCRIPTION NEW_INSTANCE_DESCRIPTION
, IH.OLD_INSTALL_DATE OLD_INSTALL_DATE
, IH.NEW_INSTALL_DATE NEW_INSTALL_DATE
, IH.OLD_RETURN_BY_DATE OLD_RETURN_BY_DATE
, IH.NEW_RETURN_BY_DATE NEW_RETURN_BY_DATE
, IH.OLD_ACTUAL_RETURN_DATE OLD_ACTUAL_RETURN_DATE
, IH.NEW_ACTUAL_RETURN_DATE NEW_ACTUAL_RETURN_DATE
, OMSI.DESCRIPTION OLD_DESCRIPTION
, OMSI.SERIAL_NUMBER_CONTROL_CODE OLD_SRL_NUM_CONTROL_CODE
, OMSIKFV.CONCATENATED_SEGMENTS OLD_CONCATENATED_SEGMENTS
, OMSIKFV.PADDED_CONCATENATED_SEGMENTS OLD_PADDED_SEGMENTS
, OUOM.UNIT_OF_MEASURE OLD_UNIT_OF_MEASURE_NAME
, OHOU.NAME OLD_NAME
, OMMS.STATUS_CODE OLD_STATUS_CODE
, OMMS.DESCRIPTION OLD_CONDITION_DESCRIPTION
, OCIS.NAME OLD_STATUS_NAME
, OCIS.DESCRIPTION OLD_STATUS_DESCRIPTION
, OPP.NAME OLD_PROJECT_NAME
, OPP.PROJECT_TYPE OLD_PROJECT_TYPE
, OPP.PROJECT_STATUS_CODE OLD_PROJECT_STATUS_CODE
, OPP.DESCRIPTION OLD_PROJECT_DESCRIPTION
, OPT.TASK_NUMBER OLD_TASK_NUMBER
, OPT.TASK_NAME OLD_TASK_NAME
, OPT.PARENT_TASK_ID OLD_PARENT_TASK_ID
, OPT.DESCRIPTION OLD_TASK_DESCRIPTION
, OOEL.LINE_TYPE_ID OLD_LINE_TYPE_ID
, OOEL.LINE_NUMBER OLD_LINE_NUMBER
, OOEL.CUST_PO_NUMBER OLD_CUST_PO_NUMBER
, OOOL.ORDER_NUMBER OLD_ORDER_NUMBER
, OOOL.VERSION_NUMBER OLD_ORDER_LINE_VERSION
, OOOL.ORDER_SOURCE_ID OLD_ORDER_SOURCE_ID
, OOOL.ORDERED_DATE OLD_ORDERED_DATE
, OWE.WIP_ENTITY_NAME OLD_WIP_ENTITY_NAME
, OWE.ENTITY_TYPE OLD_WIP_ENTITY_TYPE
, OWE.DESCRIPTION OLD_WIP_ENTITY_DESCRIPTION
, OPL.PO_HEADER_ID OLD_PO_HEADER_ID
, OPL.LINE_TYPE_ID OLD_PO_LINE_TYPE_ID
, OPL.LINE_NUM OLD_PO_LINE_NUMBER
, OPL.ITEM_DESCRIPTION OLD_ITEM_DESCRIPTION
, OCS.NAME OLD_SYSTEM_NAME
, NMSI.DESCRIPTION NEW_DESCRIPTION
, NMSI.SERIAL_NUMBER_CONTROL_CODE NEW_SRL_NUM_CONTROL_CODE
, NMSIKFV.CONCATENATED_SEGMENTS NEW_CONCATENATED_SEGMENTS
, NMSIKFV.PADDED_CONCATENATED_SEGMENTS NEW_PADDED_SEGMENTS
, NUOM.UNIT_OF_MEASURE NEW_UNIT_OF_MEASURE_NAME
, NHOU.NAME NEW_NAME
, NMMS.STATUS_CODE NEW_STATUS_CODE
, NMMS.DESCRIPTION NEW_CONDITION_DESCRIPTION
, NCIS.NAME NEW_STATUS_NAME
, NCIS.DESCRIPTION NEW_STATUS_DESCRIPTION
, NPP.NAME NEW_PROJECT_NAME
, NPP.PROJECT_TYPE NEW_PROJECT_TYPE
, NPP.PROJECT_STATUS_CODE NEW_PROJECT_STATUS_CODE
, NPP.DESCRIPTION NEW_PROJECT_DESCRIPTION
, NPT.TASK_NUMBER NEW_TASK_NUMBER
, NPT.TASK_NAME NEW_TASK_NAME
, NPT.PARENT_TASK_ID NEW_PARENT_TASK_ID
, NPT.DESCRIPTION NEW_TASK_DESCRIPTION
, NOEL.LINE_TYPE_ID NEW_LINE_TYPE_ID
, NOEL.LINE_NUMBER NEW_LINE_NUMBER
, NOEL.CUST_PO_NUMBER NEW_CUST_PO_NUMBER
, NOOL.ORDER_NUMBER NEW_ORDER_NUMBER
, NOOL.VERSION_NUMBER NEW_ORDER_LINE_VERSION
, NOOL.ORDER_SOURCE_ID NEW_ORDER_SOURCE_ID
, NOOL.ORDERED_DATE NEW_ORDERED_DATE
, NWE.WIP_ENTITY_NAME NEW_WIP_ENTITY_NAME
, NWE.ENTITY_TYPE NEW_WIP_ENTITY_TYPE
, NWE.DESCRIPTION NEW_WIP_ENTITY_DESCRIPTION
, NPL.PO_HEADER_ID NEW_PO_HEADER_ID
, NPL.LINE_TYPE_ID NEW_PO_LINE_TYPE_ID
, NPL.LINE_NUM NEW_PO_LINE_NUMBER
, NPL.ITEM_DESCRIPTION NEW_ITEM_DESCRIPTION
, NCS.NAME NEW_SYSTEM_NAME
FROM CSI_ITEM_INSTANCES_H IH
, MTL_SYSTEM_ITEMS_KFV OMSIKFV
, MTL_SYSTEM_ITEMS OMSI
, HR_ORGANIZATION_UNITS OHOU
, MTL_UNITS_OF_MEASURE_VL OUOM
, MTL_MATERIAL_STATUSES OMMS
, CSI_INSTANCE_STATUSES OCIS
, PA_PROJECTS_ALL OPP
, PA_TASKS OPT
, OE_ORDER_LINES_ALL OOEL
, OE_ORDER_HEADERS_ALL OOOL
, WIP_ENTITIES OWE
, PO_LINES_ALL OPL
, CSI_SYSTEMS_VL OCS
, MTL_SYSTEM_ITEMS_KFV NMSIKFV
, MTL_SYSTEM_ITEMS NMSI
, HR_ORGANIZATION_UNITS NHOU
, MTL_UNITS_OF_MEASURE_VL NUOM
, MTL_MATERIAL_STATUSES NMMS
, CSI_INSTANCE_STATUSES NCIS
, PA_PROJECTS_ALL NPP
, PA_TASKS NPT
, OE_ORDER_LINES_ALL NOEL
, OE_ORDER_HEADERS_ALL NOOL
, WIP_ENTITIES NWE
, PO_LINES_ALL NPL
, CSI_SYSTEMS_VL NCS
WHERE IH.OLD_INV_MASTER_ORGANIZATION_ID = OMSI.ORGANIZATION_ID (+) AND IH.OLD_INVENTORY_ITEM_ID = OMSI.INVENTORY_ITEM_ID (+) AND IH.OLD_INV_MASTER_ORGANIZATION_ID = OMSIKFV.ORGANIZATION_ID (+) AND IH.OLD_INVENTORY_ITEM_ID = OMSIKFV.INVENTORY_ITEM_ID (+) AND IH.OLD_SYSTEM_ID = OCS.SYSTEM_ID (+) AND OHOU.ORGANIZATION_ID (+) = IH.OLD_LAST_VLD_ORGANIZATION_ID AND IH.OLD_UNIT_OF_MEASURE = OUOM.UOM_CODE (+) AND IH.OLD_INSTANCE_CONDITION_ID = OMMS.STATUS_ID (+) AND IH.OLD_INSTANCE_STATUS_ID = OCIS.INSTANCE_STATUS_ID (+) AND IH.OLD_PA_PROJECT_ID = OPP.PROJECT_ID (+) AND IH.OLD_PA_PROJECT_TASK_ID = OPT.TASK_ID (+) AND IH.OLD_IN_TRANSIT_ORDER_LINE_ID = OOEL.LINE_ID (+) AND OOEL.HEADER_ID = OOOL.HEADER_ID (+) AND IH.OLD_WIP_JOB_ID = OWE.WIP_ENTITY_ID(+) AND IH.OLD_PO_ORDER_LINE_ID = OPL.PO_LINE_ID(+) AND IH.NEW_INV_MASTER_ORGANIZATION_ID = NMSI.ORGANIZATION_ID (+) AND IH.NEW_INVENTORY_ITEM_ID = NMSI.INVENTORY_ITEM_ID (+) AND IH.NEW_INV_MASTER_ORGANIZATION_ID = NMSIKFV.ORGANIZATION_ID (+) AND IH.NEW_INVENTORY_ITEM_ID = NMSIKFV.INVENTORY_ITEM_ID (+) AND IH.NEW_SYSTEM_ID = NCS.SYSTEM_ID (+) AND NHOU.ORGANIZATION_ID (+) = IH.NEW_LAST_VLD_ORGANIZATION_ID AND IH.NEW_UNIT_OF_MEASURE = NUOM.UOM_CODE (+) AND IH.NEW_INSTANCE_CONDITION_ID = NMMS.STATUS_ID (+) AND IH.NEW_INSTANCE_STATUS_ID = NCIS.INSTANCE_STATUS_ID (+) AND IH.NEW_PA_PROJECT_ID = NPP.PROJECT_ID (+) AND IH.NEW_PA_PROJECT_TASK_ID = NPT.TASK_ID (+) AND IH.NEW_IN_TRANSIT_ORDER_LINE_ID = NOEL.LINE_ID (+) AND NOEL.HEADER_ID = NOOL.HEADER_ID (+) AND IH.NEW_WIP_JOB_ID = NWE.WIP_ENTITY_ID(+) AND IH.NEW_PO_ORDER_LINE_ID = NPL.PO_LINE_ID(+)