[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_IIH_DETAILS_V is not referenced by any database object
|
|
|