VIEW: APPS.CSL_CSI_ITEM_INSTANCES_V

Source

View Text - Preformatted

SELECT CLA.ACCESS_ID , CII.INSTANCE_ID , CII.INSTANCE_NUMBER , 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.INSTANCE_STATUS_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.INSTALL_DATE , CII.RETURN_BY_DATE , CII.ACTUAL_RETURN_DATE , CII.CREATION_COMPLETE_FLAG , CII.COMPLETENESS_FLAG , CII.INSTALL_LOCATION_TYPE_CODE , CII.INSTALL_LOCATION_ID , CII.INSTANCE_USAGE_CODE , CII.OWNER_PARTY_SOURCE_TABLE , CII.OWNER_PARTY_ID , CII.OWNER_PARTY_ACCOUNT_ID , CIR.OBJECT_ID AS PARENT_INSTANCE_ID , 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.CONTEXT , CII.EXTERNAL_REFERENCE , CIR.ACTIVE_END_DATE AS REL_ACTIVE_END_DATE FROM CSI_ITEM_INSTANCES CII , CSI_II_RELATIONSHIPS CIR , CSL_CSI_ITEM_INSTANCES_ACC CLA WHERE CII.INSTANCE_ID = CIR.SUBJECT_ID(+) AND CIR.RELATIONSHIP_TYPE_CODE(+) = 'COMPONENT-OF' AND CII.INSTANCE_ID = CLA.INSTANCE_ID AND CLA.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID

View Text - HTML Formatted

SELECT CLA.ACCESS_ID
, CII.INSTANCE_ID
, CII.INSTANCE_NUMBER
, 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.INSTANCE_STATUS_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.INSTALL_DATE
, CII.RETURN_BY_DATE
, CII.ACTUAL_RETURN_DATE
, CII.CREATION_COMPLETE_FLAG
, CII.COMPLETENESS_FLAG
, CII.INSTALL_LOCATION_TYPE_CODE
, CII.INSTALL_LOCATION_ID
, CII.INSTANCE_USAGE_CODE
, CII.OWNER_PARTY_SOURCE_TABLE
, CII.OWNER_PARTY_ID
, CII.OWNER_PARTY_ACCOUNT_ID
, CIR.OBJECT_ID AS PARENT_INSTANCE_ID
, 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.CONTEXT
, CII.EXTERNAL_REFERENCE
, CIR.ACTIVE_END_DATE AS REL_ACTIVE_END_DATE
FROM CSI_ITEM_INSTANCES CII
, CSI_II_RELATIONSHIPS CIR
, CSL_CSI_ITEM_INSTANCES_ACC CLA
WHERE CII.INSTANCE_ID = CIR.SUBJECT_ID(+)
AND CIR.RELATIONSHIP_TYPE_CODE(+) = 'COMPONENT-OF'
AND CII.INSTANCE_ID = CLA.INSTANCE_ID
AND CLA.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID