View: CSI_INSTANCE_PARTY_V

Product:	CSI - Install Base
Description:	Instance Party Associations view.
Implementation/DBA Data:	APPS.CSI_INSTANCE_PARTY_V

View Text

SELECT CII.INSTANCE_ID INSTANCE_ID
, CII.INSTANCE_NUMBER INSTANCE_NUMBER
, CII.EXTERNAL_REFERENCE EXTERNAL_REFERENCE
, CII.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CII.INVENTORY_REVISION INVENTORY_REVISION
, CII.INV_MASTER_ORGANIZATION_ID INV_MASTER_ORGANIZATION_ID
, CII.SERIAL_NUMBER SERIAL_NUMBER
, CII.MFG_SERIAL_NUMBER_FLAG MFG_SERIAL_NUMBER_FLAG
, CII.LOT_NUMBER LOT_NUMBER
, CII.QUANTITY QUANTITY
, CII.UNIT_OF_MEASURE UNIT_OF_MEASURE
, CII.ACCOUNTING_CLASS_CODE ACCOUNTING_CLASS_CODE
, CII.INSTANCE_CONDITION_ID INSTANCE_CONDITION_ID
, CII.INSTANCE_STATUS_ID INSTANCE_STATUS_ID
, CII.CUSTOMER_VIEW_FLAG CUSTOMER_VIEW_FLAG
, CII.MERCHANT_VIEW_FLAG MERCHANT_VIEW_FLAG
, CII.SELLABLE_FLAG SELLABLE_FLAG
, CII.SYSTEM_ID SYSTEM_ID
, CII.INSTANCE_TYPE_CODE INSTANCE_TYPE_CODE
, CII.ACTIVE_START_DATE ACTIVE_START_DATE
, CII.ACTIVE_END_DATE ACTIVE_END_DATE
, CII.LOCATION_TYPE_CODE LOCATION_TYPE_CODE
, CII.LOCATION_ID LOCATION_ID
, CII.INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, CII.INV_SUBINVENTORY_NAME INV_SUBINVENTORY_NAME
, CII.INV_LOCATOR_ID INV_LOCATOR_ID
, CII.PA_PROJECT_ID PA_PROJECT_ID
, CII.PA_PROJECT_TASK_ID PA_PROJECT_TASK_ID
, CII.IN_TRANSIT_ORDER_LINE_ID IN_TRANSIT_ORDER_LINE_ID
, CII.WIP_JOB_ID WIP_JOB_ID
, CII.PO_ORDER_LINE_ID PO_ORDER_LINE_ID
, CII.LAST_OE_ORDER_LINE_ID LAST_OE_ORDER_LINE_ID
, CII.LAST_OE_RMA_LINE_ID LAST_OE_RMA_LINE_ID
, CII.LAST_PO_PO_LINE_ID LAST_PO_PO_LINE_ID
, CII.LAST_OE_PO_NUMBER LAST_OE_PO_NUMBER
, CII.LAST_WIP_JOB_ID LAST_WIP_JOB_ID
, CII.LAST_PA_PROJECT_ID LAST_PA_PROJECT_ID
, CII.LAST_PA_TASK_ID LAST_PA_TASK_ID
, CII.LAST_OE_AGREEMENT_ID LAST_OE_AGREEMENT_ID
, CII.INSTALL_DATE INSTALL_DATE
, CII.MANUALLY_CREATED_FLAG MANUALLY_CREATED_FLAG
, CII.RETURN_BY_DATE RETURN_BY_DATE
, CII.ACTUAL_RETURN_DATE ACTUAL_RETURN_DATE
, CII.CREATION_COMPLETE_FLAG CREATION_COMPLETE_FLAG
, CII.COMPLETENESS_FLAG COMPLETENESS_FLAG
, CII.CONTEXT CONTEXT
, CII.ATTRIBUTE1 ATTRIBUTE1
, CII.ATTRIBUTE2 ATTRIBUTE2
, CII.ATTRIBUTE3 ATTRIBUTE3
, CII.ATTRIBUTE4 ATTRIBUTE4
, CII.ATTRIBUTE5 ATTRIBUTE5
, CII.ATTRIBUTE6 ATTRIBUTE6
, CII.ATTRIBUTE7 ATTRIBUTE7
, CII.ATTRIBUTE8 ATTRIBUTE8
, CII.ATTRIBUTE9 ATTRIBUTE9
, CII.ATTRIBUTE10 ATTRIBUTE10
, CII.ATTRIBUTE11 ATTRIBUTE11
, CII.ATTRIBUTE12 ATTRIBUTE12
, CII.ATTRIBUTE13 ATTRIBUTE13
, CII.ATTRIBUTE14 ATTRIBUTE14
, CII.ATTRIBUTE15 ATTRIBUTE15
, CII.CREATED_BY CREATED_BY
, CII.CREATION_DATE CREATION_DATE
, CII.LAST_UPDATED_BY LAST_UPDATED_BY
, CII.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CII.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CII.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CII.LAST_TXN_LINE_DETAIL_ID LAST_TXN_LINE_DETAIL_ID
, CII.INSTALL_LOCATION_TYPE_CODE INSTALL_LOCATION_TYPE_CODE
, CII.INSTALL_LOCATION_ID INSTALL_LOCATION_ID
, CII.INSTANCE_USAGE_CODE INSTANCE_USAGE_CODE
, CIP.INSTANCE_PARTY_ID INSTANCE_PARTY_ID
, CIP.PARTY_SOURCE_TABLE PARTY_SOURCE_TABLE
, CIP.PARTY_ID PARTY_ID
, CIP.RELATIONSHIP_TYPE_CODE IP_RELATIONSHIP_TYPE_CODE
, CIP.PREFERRED_FLAG PREFERRED_FLAG
, CIP.PRIMARY_FLAG PRIMARY_FLAG
, CIP.CONTACT_FLAG CONTACT_FLAG
, CIP.CONTACT_IP_ID CONTACT_IP_ID
, CIP.CONTEXT IP_CONTEXT
, CIP.ATTRIBUTE1 IP_ATTRIBUTE1
, CIP.ATTRIBUTE2 IP_ATTRIBUTE2
, CIP.ATTRIBUTE3 IP_ATTRIBUTE3
, CIP.ATTRIBUTE4 IP_ATTRIBUTE4
, CIP.ATTRIBUTE5 IP_ATTRIBUTE5
, CIP.ATTRIBUTE6 IP_ATTRIBUTE6
, CIP.ATTRIBUTE7 IP_ATTRIBUTE7
, CIP.ATTRIBUTE8 IP_ATTRIBUTE8
, CIP.ATTRIBUTE9 IP_ATTRIBUTE9
, CIP.ATTRIBUTE10 IP_ATTRIBUTE10
, CIP.ATTRIBUTE11 IP_ATTRIBUTE11
, CIP.ATTRIBUTE12 IP_ATTRIBUTE12
, CIP.ATTRIBUTE13 IP_ATTRIBUTE13
, CIP.ATTRIBUTE14 IP_ATTRIBUTE14
, CIP.ATTRIBUTE15 IP_ATTRIBUTE15
, CIP.ACTIVE_START_DATE IP_ACTIVE_START_DATE
, CIP.ACTIVE_END_DATE IP_ACTIVE_END_DATE
, CIA.PARTY_ACCOUNT_ID PARTY_ACCOUNT_ID
, CIA.RELATIONSHIP_TYPE_CODE IPA_RELATIONSHIP_TYPE_CODE
, CIA.ACTIVE_START_DATE IPA_ACTIVE_START_DATE
, CIA.ACTIVE_END_DATE IPA_ACTIVE_END_DATE
, CIA.BILL_TO_ADDRESS BILL_TO_ADDRESS
, CIA.SHIP_TO_ADDRESS SHIP_TO_ADDRESS
FROM CSI_ITEM_INSTANCES CII
, CSI_I_PARTIES CIP
, CSI_IP_ACCOUNTS CIA
WHERE CII.INSTANCE_ID = CIP.INSTANCE_ID AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND CIP.RELATIONSHIP_TYPE_CODE = 'OWNER' AND CIP.INSTANCE_PARTY_ID = CIA.INSTANCE_PARTY_ID (+) AND CIA.RELATIONSHIP_TYPE_CODE(+) = 'OWNER' AND CIP.PARTY_ID <> ( SELECT INTERNAL_PARTY_ID FROM CSI_INSTALL_PARAMETERS )

Columns