[Home] [Help] [Dependency Information]

VIEW: APPS.CSI_IIH_DETAILS_V

Object Details

Object Name:	CSI_IIH_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSI.CSI_IIH_DETAILS_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT INSTANCE_HISTORY_ID
,      INSTANCE_ID
,      TRANSACTION_ID
,      OLD_INSTANCE_NUMBER
,      NEW_INSTANCE_NUMBER
,      OLD_EXTERNAL_REFERENCE
,      NEW_EXTERNAL_REFERENCE
,      OLD_INVENTORY_ITEM_ID
,      NEW_INVENTORY_ITEM_ID
,      OLD_INVENTORY_REVISION
,      NEW_INVENTORY_REVISION
,      OLD_INV_MASTER_ORGANIZATION_ID
,      NEW_INV_MASTER_ORGANIZATION_ID
,      OLD_SERIAL_NUMBER
,      NEW_SERIAL_NUMBER
,      OLD_MFG_SERIAL_NUMBER_FLAG
,      NEW_MFG_SERIAL_NUMBER_FLAG
,      OLD_LOT_NUMBER
,      NEW_LOT_NUMBER
,      OLD_QUANTITY
,      NEW_QUANTITY
,      OLD_UNIT_OF_MEASURE
,      NEW_UNIT_OF_MEASURE
,      OLD_ACCOUNTING_CLASS_CODE
,      NEW_ACCOUNTING_CLASS_CODE
,      OLD_INSTANCE_CONDITION_ID
,      NEW_INSTANCE_CONDITION_ID
,      OLD_INSTANCE_STATUS_ID
,      NEW_INSTANCE_STATUS_ID
,      OLD_CUSTOMER_VIEW_FLAG
,      NEW_CUSTOMER_VIEW_FLAG
,      OLD_MERCHANT_VIEW_FLAG
,      NEW_MERCHANT_VIEW_FLAG
,      OLD_SELLABLE_FLAG
,      NEW_SELLABLE_FLAG
,      OLD_SYSTEM_ID
,      NEW_SYSTEM_ID
,      OLD_INSTANCE_TYPE_CODE
,      NEW_INSTANCE_TYPE_CODE
,      OLD_ACTIVE_START_DATE
,      NEW_ACTIVE_START_DATE
,      OLD_ACTIVE_END_DATE
,      NEW_ACTIVE_END_DATE
,      OLD_LOCATION_TYPE_CODE
,      NEW_LOCATION_TYPE_CODE
,      OLD_LOCATION_ID
,      NEW_LOCATION_ID
,      OLD_INV_ORGANIZATION_ID
,      NEW_INV_ORGANIZATION_ID
,      OLD_INV_SUBINVENTORY_NAME
,      NEW_INV_SUBINVENTORY_NAME
,      OLD_INV_LOCATOR_ID
,      NEW_INV_LOCATOR_ID
,      OLD_PA_PROJECT_ID
,      NEW_PA_PROJECT_ID
,      OLD_PA_PROJECT_TASK_ID
,      NEW_PA_PROJECT_TASK_ID
,      OLD_IN_TRANSIT_ORDER_LINE_ID
,      NEW_IN_TRANSIT_ORDER_LINE_ID
,      OLD_WIP_JOB_ID
,      NEW_WIP_JOB_ID
,      OLD_PO_ORDER_LINE_ID
,      NEW_PO_ORDER_LINE_ID
,      OLD_COMPLETENESS_FLAG
,      NEW_COMPLETENESS_FLAG
,      OLD_INST_LOC_TYPE_CODE
,      NEW_INST_LOC_TYPE_CODE
,      OLD_INST_LOC_ID
,      NEW_INST_LOC_ID
,      OLD_INST_USAGE_CODE
,      NEW_INST_USAGE_CODE
,      OLD_CONTEXT
,      NEW_CONTEXT
,      OLD_ATTRIBUTE1
,      NEW_ATTRIBUTE1
,      OLD_ATTRIBUTE2
,      NEW_ATTRIBUTE2
,      OLD_ATTRIBUTE3
,      NEW_ATTRIBUTE3
,      OLD_ATTRIBUTE4
,      NEW_ATTRIBUTE4
,      OLD_ATTRIBUTE5
,      NEW_ATTRIBUTE5
,      OLD_ATTRIBUTE6
,      NEW_ATTRIBUTE6
,      OLD_ATTRIBUTE7
,      NEW_ATTRIBUTE7
,      OLD_ATTRIBUTE8
,      NEW_ATTRIBUTE8
,      OLD_ATTRIBUTE9
,      NEW_ATTRIBUTE9
,      OLD_ATTRIBUTE10
,      NEW_ATTRIBUTE10
,      OLD_ATTRIBUTE11
,      NEW_ATTRIBUTE11
,      OLD_ATTRIBUTE12
,      NEW_ATTRIBUTE12
,      OLD_ATTRIBUTE13
,      NEW_ATTRIBUTE13
,      OLD_ATTRIBUTE14
,      NEW_ATTRIBUTE14
,      OLD_ATTRIBUTE15
,      NEW_ATTRIBUTE15
,      FULL_DUMP_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      OLD_OE_AGREEMENT_ID
,      NEW_OE_AGREEMENT_ID
,      OLD_LAST_VLD_ORGANIZATION_ID
,      NEW_LAST_VLD_ORGANIZATION_ID
,      OLD_CONFIG_INST_REV_NUM
,      NEW_CONFIG_INST_REV_NUM
,      OLD_CONFIG_VALID_STATUS
,      NEW_CONFIG_VALID_STATUS
,      OLD_INSTANCE_DESCRIPTION
,      NEW_INSTANCE_DESCRIPTION
,      OLD_INSTALL_DATE
,      NEW_INSTALL_DATE
,      OLD_RETURN_BY_DATE
,      NEW_RETURN_BY_DATE
,      OLD_ACTUAL_RETURN_DATE
,      NEW_ACTUAL_RETURN_DATE
,      OLD_DESCRIPTION
,      OLD_SRL_NUM_CONTROL_CODE
,      OLD_CONCATENATED_SEGMENTS
,      OLD_PADDED_SEGMENTS
,      OLD_UNIT_OF_MEASURE_NAME
,      OLD_NAME
,      OLD_STATUS_CODE
,      OLD_CONDITION_DESCRIPTION
,      OLD_STATUS_NAME
,      OLD_STATUS_DESCRIPTION
,      OLD_PROJECT_NAME
,      OLD_PROJECT_TYPE
,      OLD_PROJECT_STATUS_CODE
,      OLD_PROJECT_DESCRIPTION
,      OLD_TASK_NUMBER
,      OLD_TASK_NAME
,      OLD_PARENT_TASK_ID
,      OLD_TASK_DESCRIPTION
,      OLD_LINE_TYPE_ID
,      OLD_LINE_NUMBER
,      OLD_CUST_PO_NUMBER
,      OLD_ORDER_NUMBER
,      OLD_ORDER_LINE_VERSION
,      OLD_ORDER_SOURCE_ID
,      OLD_ORDERED_DATE
,      OLD_WIP_ENTITY_NAME
,      OLD_WIP_ENTITY_TYPE
,      OLD_WIP_ENTITY_DESCRIPTION
,      OLD_PO_HEADER_ID
,      OLD_PO_LINE_TYPE_ID
,      OLD_PO_LINE_NUMBER
,      OLD_ITEM_DESCRIPTION
,      OLD_SYSTEM_NAME
,      NEW_DESCRIPTION
,      NEW_SRL_NUM_CONTROL_CODE
,      NEW_CONCATENATED_SEGMENTS
,      NEW_PADDED_SEGMENTS
,      NEW_UNIT_OF_MEASURE_NAME
,      NEW_NAME
,      NEW_STATUS_CODE
,      NEW_CONDITION_DESCRIPTION
,      NEW_STATUS_NAME
,      NEW_STATUS_DESCRIPTION
,      NEW_PROJECT_NAME
,      NEW_PROJECT_TYPE
,      NEW_PROJECT_STATUS_CODE
,      NEW_PROJECT_DESCRIPTION
,      NEW_TASK_NUMBER
,      NEW_TASK_NAME
,      NEW_PARENT_TASK_ID
,      NEW_TASK_DESCRIPTION
,      NEW_LINE_TYPE_ID
,      NEW_LINE_NUMBER
,      NEW_CUST_PO_NUMBER
,      NEW_ORDER_NUMBER
,      NEW_ORDER_LINE_VERSION
,      NEW_ORDER_SOURCE_ID
,      NEW_ORDERED_DATE
,      NEW_WIP_ENTITY_NAME
,      NEW_WIP_ENTITY_TYPE
,      NEW_WIP_ENTITY_DESCRIPTION
,      NEW_PO_HEADER_ID
,      NEW_PO_LINE_TYPE_ID
,      NEW_PO_LINE_NUMBER
,      NEW_ITEM_DESCRIPTION
,      NEW_SYSTEM_NAME
FROM APPS.CSI_IIH_DETAILS_V;

Dependencies

[top of page]

APPS

CSI_INSTANCE_STATUSES

CSI_ITEM_INSTANCES_H

CSI_SYSTEMS_VL

HR_GENERAL - show dependent code

HR_ORGANIZATION_UNITS

HR_SECURITY - show dependent code

MTL_MATERIAL_STATUSES

MTL_SYSTEM_ITEMS

MTL_SYSTEM_ITEMS_KFV

MTL_UNITS_OF_MEASURE_VL

OE_ORDER_HEADERS_ALL

OE_ORDER_LINES_ALL

PA_PROJECTS_ALL

PA_TASKS

PO_LINES_ALL

WIP_ENTITIES

APPS.CSI_IIH_DETAILS_V is not referenced by any database object