VIEW: APPS.CSI_INST_PARENT_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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