DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CSI_INST_CHILD_DETAILS_V

Object Details
Object Name: CSI_INST_CHILD_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSI.CSI_INST_CHILD_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
Name Datatype Length Mandatory Comments
CHILD_ID NUMBER

PARENT_ID NUMBER
Yes
RELATIONSHIP_ID NUMBER
Yes
RELATIONSHIP_TYPE_CODE VARCHAR2 (30) Yes
POSITION_REFERENCE VARCHAR2 (30)
REL_ACTIVE_START_DATE DATE

REL_ACTIVE_END_DATE DATE

DISPLAY_ORDER NUMBER

MANDATORY_FLAG VARCHAR2 (1)
REL_CONTEXT VARCHAR2 (30)
REL_ATTRIBUTE1 VARCHAR2 (150)
REL_ATTRIBUTE2 VARCHAR2 (150)
REL_ATTRIBUTE3 VARCHAR2 (150)
REL_ATTRIBUTE4 VARCHAR2 (150)
REL_ATTRIBUTE5 VARCHAR2 (150)
REL_ATTRIBUTE6 VARCHAR2 (150)
REL_ATTRIBUTE7 VARCHAR2 (150)
REL_ATTRIBUTE8 VARCHAR2 (150)
REL_ATTRIBUTE9 VARCHAR2 (150)
REL_ATTRIBUTE10 VARCHAR2 (150)
REL_ATTRIBUTE11 VARCHAR2 (150)
REL_ATTRIBUTE12 VARCHAR2 (150)
REL_ATTRIBUTE13 VARCHAR2 (150)
REL_ATTRIBUTE14 VARCHAR2 (150)
REL_ATTRIBUTE15 VARCHAR2 (150)
REL_CREATED_BY NUMBER (15) Yes
REL_CREATION_DATE DATE
Yes
REL_LAST_UPDATED_BY NUMBER (15) Yes
REL_LAST_UPDATE_DATE DATE
Yes
REL_LAST_UPDATE_LOGIN NUMBER (15)
REL_OBJECT_VERSION_NUMBER NUMBER
Yes
INSTANCE_NUMBER VARCHAR2 (30) Yes
EXTERNAL_REFERENCE VARCHAR2 (30)
INVENTORY_ITEM_ID NUMBER
Yes
INVENTORY_REVISION VARCHAR2 (3)
INV_MASTER_ORGANIZATION_ID NUMBER
Yes
SERIAL_NUMBER VARCHAR2 (30)
MFG_SERIAL_NUMBER_FLAG VARCHAR2 (1)
LOT_NUMBER VARCHAR2 (80)
QUANTITY NUMBER
Yes
UNIT_OF_MEASURE VARCHAR2 (3) Yes
ACCOUNTING_CLASS_CODE VARCHAR2 (10)
INSTANCE_CONDITION_ID NUMBER

INSTANCE_STATUS_ID NUMBER
Yes
CUSTOMER_VIEW_FLAG VARCHAR2 (1) Yes
MERCHANT_VIEW_FLAG VARCHAR2 (1) Yes
SELLABLE_FLAG VARCHAR2 (1)
SYSTEM_ID NUMBER

INSTANCE_TYPE_CODE VARCHAR2 (30)
ACTIVE_START_DATE DATE

ACTIVE_END_DATE DATE

LOCATION_TYPE_CODE VARCHAR2 (30)
LOCATION_ID NUMBER

INV_ORGANIZATION_ID NUMBER

INV_SUBINVENTORY_NAME VARCHAR2 (10)
INV_LOCATOR_ID NUMBER

PA_PROJECT_ID NUMBER

PA_PROJECT_TASK_ID NUMBER

IN_TRANSIT_ORDER_LINE_ID NUMBER

WIP_JOB_ID NUMBER

PO_ORDER_LINE_ID NUMBER

LAST_OE_ORDER_LINE_ID NUMBER

LAST_OE_RMA_LINE_ID NUMBER

LAST_PO_PO_LINE_ID NUMBER

LAST_OE_PO_NUMBER VARCHAR2 (50)
LAST_WIP_JOB_ID NUMBER

LAST_PA_PROJECT_ID NUMBER

LAST_PA_TASK_ID NUMBER

LAST_OE_AGREEMENT_ID NUMBER

INSTALL_DATE DATE

MANUALLY_CREATED_FLAG VARCHAR2 (1)
RETURN_BY_DATE DATE

ACTUAL_RETURN_DATE DATE

CREATION_COMPLETE_FLAG VARCHAR2 (1)
COMPLETENESS_FLAG VARCHAR2 (1)
CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
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
LAST_TXN_LINE_DETAIL_ID NUMBER

INSTALL_LOCATION_TYPE_CODE VARCHAR2 (30)
INSTALL_LOCATION_ID NUMBER

INSTANCE_USAGE_CODE VARCHAR2 (30)
Query Text

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


SELECT CHILD_ID
,      PARENT_ID
,      RELATIONSHIP_ID
,      RELATIONSHIP_TYPE_CODE
,      POSITION_REFERENCE
,      REL_ACTIVE_START_DATE
,      REL_ACTIVE_END_DATE
,      DISPLAY_ORDER
,      MANDATORY_FLAG
,      REL_CONTEXT
,      REL_ATTRIBUTE1
,      REL_ATTRIBUTE2
,      REL_ATTRIBUTE3
,      REL_ATTRIBUTE4
,      REL_ATTRIBUTE5
,      REL_ATTRIBUTE6
,      REL_ATTRIBUTE7
,      REL_ATTRIBUTE8
,      REL_ATTRIBUTE9
,      REL_ATTRIBUTE10
,      REL_ATTRIBUTE11
,      REL_ATTRIBUTE12
,      REL_ATTRIBUTE13
,      REL_ATTRIBUTE14
,      REL_ATTRIBUTE15
,      REL_CREATED_BY
,      REL_CREATION_DATE
,      REL_LAST_UPDATED_BY
,      REL_LAST_UPDATE_DATE
,      REL_LAST_UPDATE_LOGIN
,      REL_OBJECT_VERSION_NUMBER
,      INSTANCE_NUMBER
,      EXTERNAL_REFERENCE
,      INVENTORY_ITEM_ID
,      INVENTORY_REVISION
,      INV_MASTER_ORGANIZATION_ID
,      SERIAL_NUMBER
,      MFG_SERIAL_NUMBER_FLAG
,      LOT_NUMBER
,      QUANTITY
,      UNIT_OF_MEASURE
,      ACCOUNTING_CLASS_CODE
,      INSTANCE_CONDITION_ID
,      INSTANCE_STATUS_ID
,      CUSTOMER_VIEW_FLAG
,      MERCHANT_VIEW_FLAG
,      SELLABLE_FLAG
,      SYSTEM_ID
,      INSTANCE_TYPE_CODE
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      LOCATION_TYPE_CODE
,      LOCATION_ID
,      INV_ORGANIZATION_ID
,      INV_SUBINVENTORY_NAME
,      INV_LOCATOR_ID
,      PA_PROJECT_ID
,      PA_PROJECT_TASK_ID
,      IN_TRANSIT_ORDER_LINE_ID
,      WIP_JOB_ID
,      PO_ORDER_LINE_ID
,      LAST_OE_ORDER_LINE_ID
,      LAST_OE_RMA_LINE_ID
,      LAST_PO_PO_LINE_ID
,      LAST_OE_PO_NUMBER
,      LAST_WIP_JOB_ID
,      LAST_PA_PROJECT_ID
,      LAST_PA_TASK_ID
,      LAST_OE_AGREEMENT_ID
,      INSTALL_DATE
,      MANUALLY_CREATED_FLAG
,      RETURN_BY_DATE
,      ACTUAL_RETURN_DATE
,      CREATION_COMPLETE_FLAG
,      COMPLETENESS_FLAG
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      LAST_TXN_LINE_DETAIL_ID
,      INSTALL_LOCATION_TYPE_CODE
,      INSTALL_LOCATION_ID
,      INSTANCE_USAGE_CODE
FROM APPS.CSI_INST_CHILD_DETAILS_V;

Dependencies

[top of page]

APPS.CSI_INST_CHILD_DETAILS_V references the following:

SchemaAPPS
SynonymCSI_II_RELATIONSHIPS
SynonymCSI_ITEM_INSTANCES

APPS.CSI_INST_CHILD_DETAILS_V is not referenced by any database object