[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CSI_IIH_DETAILS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  CSI.CSI_IIH_DETAILS_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INSTANCE_HISTORY_ID | NUMBER | Yes | ||
| INSTANCE_ID | NUMBER | Yes | ||
| TRANSACTION_ID | NUMBER | Yes | ||
| OLD_INSTANCE_NUMBER | VARCHAR2 | (30) | ||
| NEW_INSTANCE_NUMBER | VARCHAR2 | (30) | ||
| OLD_EXTERNAL_REFERENCE | VARCHAR2 | (30) | ||
| NEW_EXTERNAL_REFERENCE | VARCHAR2 | (30) | ||
| OLD_INVENTORY_ITEM_ID | NUMBER | |||
| NEW_INVENTORY_ITEM_ID | NUMBER | |||
| OLD_INVENTORY_REVISION | VARCHAR2 | (3) | ||
| NEW_INVENTORY_REVISION | VARCHAR2 | (3) | ||
| OLD_INV_MASTER_ORGANIZATION_ID | NUMBER | |||
| NEW_INV_MASTER_ORGANIZATION_ID | NUMBER | |||
| OLD_SERIAL_NUMBER | VARCHAR2 | (30) | ||
| NEW_SERIAL_NUMBER | VARCHAR2 | (30) | ||
| OLD_MFG_SERIAL_NUMBER_FLAG | VARCHAR2 | (1) | ||
| NEW_MFG_SERIAL_NUMBER_FLAG | VARCHAR2 | (1) | ||
| OLD_LOT_NUMBER | VARCHAR2 | (80) | ||
| NEW_LOT_NUMBER | VARCHAR2 | (80) | ||
| OLD_QUANTITY | NUMBER | |||
| NEW_QUANTITY | NUMBER | |||
| OLD_UNIT_OF_MEASURE | VARCHAR2 | (3) | ||
| NEW_UNIT_OF_MEASURE | VARCHAR2 | (3) | ||
| OLD_ACCOUNTING_CLASS_CODE | VARCHAR2 | (10) | ||
| NEW_ACCOUNTING_CLASS_CODE | VARCHAR2 | (10) | ||
| OLD_INSTANCE_CONDITION_ID | NUMBER | |||
| NEW_INSTANCE_CONDITION_ID | NUMBER | |||
| OLD_INSTANCE_STATUS_ID | NUMBER | |||
| NEW_INSTANCE_STATUS_ID | NUMBER | |||
| OLD_CUSTOMER_VIEW_FLAG | VARCHAR2 | (1) | ||
| NEW_CUSTOMER_VIEW_FLAG | VARCHAR2 | (1) | ||
| OLD_MERCHANT_VIEW_FLAG | VARCHAR2 | (1) | ||
| NEW_MERCHANT_VIEW_FLAG | VARCHAR2 | (1) | ||
| OLD_SELLABLE_FLAG | VARCHAR2 | (1) | ||
| NEW_SELLABLE_FLAG | VARCHAR2 | (1) | ||
| OLD_SYSTEM_ID | NUMBER | |||
| NEW_SYSTEM_ID | NUMBER | |||
| OLD_INSTANCE_TYPE_CODE | VARCHAR2 | (30) | ||
| NEW_INSTANCE_TYPE_CODE | VARCHAR2 | (30) | ||
| OLD_ACTIVE_START_DATE | DATE | |||
| NEW_ACTIVE_START_DATE | DATE | |||
| OLD_ACTIVE_END_DATE | DATE | |||
| NEW_ACTIVE_END_DATE | DATE | |||
| OLD_LOCATION_TYPE_CODE | VARCHAR2 | (30) | ||
| NEW_LOCATION_TYPE_CODE | VARCHAR2 | (30) | ||
| OLD_LOCATION_ID | NUMBER | |||
| NEW_LOCATION_ID | NUMBER | |||
| OLD_INV_ORGANIZATION_ID | NUMBER | |||
| NEW_INV_ORGANIZATION_ID | NUMBER | |||
| OLD_INV_SUBINVENTORY_NAME | VARCHAR2 | (10) | ||
| NEW_INV_SUBINVENTORY_NAME | VARCHAR2 | (10) | ||
| OLD_INV_LOCATOR_ID | NUMBER | |||
| NEW_INV_LOCATOR_ID | NUMBER | |||
| OLD_PA_PROJECT_ID | NUMBER | |||
| NEW_PA_PROJECT_ID | NUMBER | |||
| OLD_PA_PROJECT_TASK_ID | NUMBER | |||
| NEW_PA_PROJECT_TASK_ID | NUMBER | |||
| OLD_IN_TRANSIT_ORDER_LINE_ID | NUMBER | |||
| NEW_IN_TRANSIT_ORDER_LINE_ID | NUMBER | |||
| OLD_WIP_JOB_ID | NUMBER | |||
| NEW_WIP_JOB_ID | NUMBER | |||
| OLD_PO_ORDER_LINE_ID | NUMBER | |||
| NEW_PO_ORDER_LINE_ID | NUMBER | |||
| OLD_COMPLETENESS_FLAG | VARCHAR2 | (1) | ||
| NEW_COMPLETENESS_FLAG | VARCHAR2 | (1) | ||
| OLD_INST_LOC_TYPE_CODE | VARCHAR2 | (30) | ||
| NEW_INST_LOC_TYPE_CODE | VARCHAR2 | (30) | ||
| OLD_INST_LOC_ID | NUMBER | |||
| NEW_INST_LOC_ID | NUMBER | |||
| OLD_INST_USAGE_CODE | VARCHAR2 | (30) | ||
| NEW_INST_USAGE_CODE | VARCHAR2 | (30) | ||
| OLD_CONTEXT | VARCHAR2 | (30) | ||
| NEW_CONTEXT | VARCHAR2 | (30) | ||
| OLD_ATTRIBUTE1 | VARCHAR2 | (240) | ||
| NEW_ATTRIBUTE1 | VARCHAR2 | (240) | ||
| OLD_ATTRIBUTE2 | VARCHAR2 | (240) | ||
| NEW_ATTRIBUTE2 | VARCHAR2 | (240) | ||
| OLD_ATTRIBUTE3 | VARCHAR2 | (240) | ||
| NEW_ATTRIBUTE3 | VARCHAR2 | (240) | ||
| OLD_ATTRIBUTE4 | VARCHAR2 | (240) | ||
| NEW_ATTRIBUTE4 | VARCHAR2 | (240) | ||
| OLD_ATTRIBUTE5 | VARCHAR2 | (240) | ||
| NEW_ATTRIBUTE5 | VARCHAR2 | (240) | ||
| OLD_ATTRIBUTE6 | VARCHAR2 | (240) | ||
| NEW_ATTRIBUTE6 | VARCHAR2 | (240) | ||
| OLD_ATTRIBUTE7 | VARCHAR2 | (240) | ||
| NEW_ATTRIBUTE7 | VARCHAR2 | (240) | ||
| OLD_ATTRIBUTE8 | VARCHAR2 | (240) | ||
| NEW_ATTRIBUTE8 | VARCHAR2 | (240) | ||
| OLD_ATTRIBUTE9 | VARCHAR2 | (240) | ||
| NEW_ATTRIBUTE9 | VARCHAR2 | (240) | ||
| OLD_ATTRIBUTE10 | VARCHAR2 | (240) | ||
| NEW_ATTRIBUTE10 | VARCHAR2 | (240) | ||
| OLD_ATTRIBUTE11 | VARCHAR2 | (240) | ||
| NEW_ATTRIBUTE11 | VARCHAR2 | (240) | ||
| OLD_ATTRIBUTE12 | VARCHAR2 | (240) | ||
| NEW_ATTRIBUTE12 | VARCHAR2 | (240) | ||
| OLD_ATTRIBUTE13 | VARCHAR2 | (240) | ||
| NEW_ATTRIBUTE13 | VARCHAR2 | (240) | ||
| OLD_ATTRIBUTE14 | VARCHAR2 | (240) | ||
| NEW_ATTRIBUTE14 | VARCHAR2 | (240) | ||
| OLD_ATTRIBUTE15 | VARCHAR2 | (240) | ||
| NEW_ATTRIBUTE15 | VARCHAR2 | (240) | ||
| FULL_DUMP_FLAG | VARCHAR2 | (1) | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
| OLD_OE_AGREEMENT_ID | NUMBER | |||
| NEW_OE_AGREEMENT_ID | NUMBER | |||
| OLD_LAST_VLD_ORGANIZATION_ID | NUMBER | |||
| NEW_LAST_VLD_ORGANIZATION_ID | NUMBER | |||
| OLD_CONFIG_INST_REV_NUM | NUMBER | |||
| NEW_CONFIG_INST_REV_NUM | NUMBER | |||
| OLD_CONFIG_VALID_STATUS | VARCHAR2 | (30) | ||
| NEW_CONFIG_VALID_STATUS | VARCHAR2 | (30) | ||
| OLD_INSTANCE_DESCRIPTION | VARCHAR2 | (240) | ||
| NEW_INSTANCE_DESCRIPTION | VARCHAR2 | (240) | ||
| OLD_INSTALL_DATE | DATE | |||
| NEW_INSTALL_DATE | DATE | |||
| OLD_RETURN_BY_DATE | DATE | |||
| NEW_RETURN_BY_DATE | DATE | |||
| OLD_ACTUAL_RETURN_DATE | DATE | |||
| NEW_ACTUAL_RETURN_DATE | DATE | |||
| OLD_DESCRIPTION | VARCHAR2 | (240) | ||
| OLD_SRL_NUM_CONTROL_CODE | NUMBER | |||
| OLD_CONCATENATED_SEGMENTS | VARCHAR2 | (40) | ||
| OLD_PADDED_SEGMENTS | VARCHAR2 | (40) | ||
| OLD_UNIT_OF_MEASURE_NAME | VARCHAR2 | (25) | ||
| OLD_NAME | VARCHAR2 | (240) | ||
| OLD_STATUS_CODE | VARCHAR2 | (80) | ||
| OLD_CONDITION_DESCRIPTION | VARCHAR2 | (240) | ||
| OLD_STATUS_NAME | VARCHAR2 | (50) | ||
| OLD_STATUS_DESCRIPTION | VARCHAR2 | (240) | ||
| OLD_PROJECT_NAME | VARCHAR2 | (30) | ||
| OLD_PROJECT_TYPE | VARCHAR2 | (20) | ||
| OLD_PROJECT_STATUS_CODE | VARCHAR2 | (30) | ||
| OLD_PROJECT_DESCRIPTION | VARCHAR2 | (250) | ||
| OLD_TASK_NUMBER | VARCHAR2 | (25) | ||
| OLD_TASK_NAME | VARCHAR2 | (20) | ||
| OLD_PARENT_TASK_ID | NUMBER | (15) | ||
| OLD_TASK_DESCRIPTION | VARCHAR2 | (250) | ||
| OLD_LINE_TYPE_ID | NUMBER | |||
| OLD_LINE_NUMBER | NUMBER | |||
| OLD_CUST_PO_NUMBER | VARCHAR2 | (50) | ||
| OLD_ORDER_NUMBER | NUMBER | |||
| OLD_ORDER_LINE_VERSION | NUMBER | |||
| OLD_ORDER_SOURCE_ID | NUMBER | |||
| OLD_ORDERED_DATE | DATE | |||
| OLD_WIP_ENTITY_NAME | VARCHAR2 | (240) | ||
| OLD_WIP_ENTITY_TYPE | NUMBER | |||
| OLD_WIP_ENTITY_DESCRIPTION | VARCHAR2 | (240) | ||
| OLD_PO_HEADER_ID | NUMBER | |||
| OLD_PO_LINE_TYPE_ID | NUMBER | |||
| OLD_PO_LINE_NUMBER | NUMBER | |||
| OLD_ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
| OLD_SYSTEM_NAME | VARCHAR2 | (50) | ||
| NEW_DESCRIPTION | VARCHAR2 | (240) | ||
| NEW_SRL_NUM_CONTROL_CODE | NUMBER | |||
| NEW_CONCATENATED_SEGMENTS | VARCHAR2 | (40) | ||
| NEW_PADDED_SEGMENTS | VARCHAR2 | (40) | ||
| NEW_UNIT_OF_MEASURE_NAME | VARCHAR2 | (25) | ||
| NEW_NAME | VARCHAR2 | (240) | ||
| NEW_STATUS_CODE | VARCHAR2 | (80) | ||
| NEW_CONDITION_DESCRIPTION | VARCHAR2 | (240) | ||
| NEW_STATUS_NAME | VARCHAR2 | (50) | ||
| NEW_STATUS_DESCRIPTION | VARCHAR2 | (240) | ||
| NEW_PROJECT_NAME | VARCHAR2 | (30) | ||
| NEW_PROJECT_TYPE | VARCHAR2 | (20) | ||
| NEW_PROJECT_STATUS_CODE | VARCHAR2 | (30) | ||
| NEW_PROJECT_DESCRIPTION | VARCHAR2 | (250) | ||
| NEW_TASK_NUMBER | VARCHAR2 | (25) | ||
| NEW_TASK_NAME | VARCHAR2 | (20) | ||
| NEW_PARENT_TASK_ID | NUMBER | (15) | ||
| NEW_TASK_DESCRIPTION | VARCHAR2 | (250) | ||
| NEW_LINE_TYPE_ID | NUMBER | |||
| NEW_LINE_NUMBER | NUMBER | |||
| NEW_CUST_PO_NUMBER | VARCHAR2 | (50) | ||
| NEW_ORDER_NUMBER | NUMBER | |||
| NEW_ORDER_LINE_VERSION | NUMBER | |||
| NEW_ORDER_SOURCE_ID | NUMBER | |||
| NEW_ORDERED_DATE | DATE | |||
| NEW_WIP_ENTITY_NAME | VARCHAR2 | (240) | ||
| NEW_WIP_ENTITY_TYPE | NUMBER | |||
| NEW_WIP_ENTITY_DESCRIPTION | VARCHAR2 | (240) | ||
| NEW_PO_HEADER_ID | NUMBER | |||
| NEW_PO_LINE_TYPE_ID | NUMBER | |||
| NEW_PO_LINE_NUMBER | NUMBER | |||
| NEW_ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
| NEW_SYSTEM_NAME | VARCHAR2 | (50) |
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;
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
|
|
|
|