[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:	CSI.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

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_II_RELATIONSHIPS

CSI_ITEM_INSTANCES

APPS.CSI_INST_CHILD_DETAILS_V is not referenced by any database object