Product: | CSI - Install Base |
---|---|
Description: | Instance Party Account Details |
Implementation/DBA Data: | APPS.CSI_PARTY_ACCT_DETAILS_V |
SELECT CIA.IP_ACCOUNT_ID IP_ACCOUNT_ID
, CIA.INSTANCE_PARTY_ID INSTANCE_PARTY_ID
, CIA.PARTY_ACCOUNT_ID PARTY_ACCOUNT_ID
, CIA.RELATIONSHIP_TYPE_CODE RELATIONSHIP_TYPE_CODE
, CIA.ACTIVE_START_DATE ACTIVE_START_DATE
, CIA.ACTIVE_END_DATE ACTIVE_END_DATE
, CIA.BILL_TO_ADDRESS BILL_TO_ADDRESS
, CIA.SHIP_TO_ADDRESS SHIP_TO_ADDRESS
, CIA.CONTEXT CONTEXT
, CIA.ATTRIBUTE1 ATTRIBUTE1
, CIA.ATTRIBUTE2 ATTRIBUTE2
, CIA.ATTRIBUTE3 ATTRIBUTE3
, CIA.ATTRIBUTE4 ATTRIBUTE4
, CIA.ATTRIBUTE5 ATTRIBUTE5
, CIA.ATTRIBUTE6 ATTRIBUTE6
, CIA.ATTRIBUTE7 ATTRIBUTE7
, CIA.ATTRIBUTE8 ATTRIBUTE8
, CIA.ATTRIBUTE9 ATTRIBUTE9
, CIA.ATTRIBUTE10 ATTRIBUTE10
, CIA.ATTRIBUTE11 ATTRIBUTE11
, CIA.ATTRIBUTE12 ATTRIBUTE12
, CIA.ATTRIBUTE13 ATTRIBUTE13
, CIA.ATTRIBUTE14 ATTRIBUTE14
, CIA.ATTRIBUTE15 ATTRIBUTE15
, CIA.CREATED_BY CREATED_BY
, CIA.CREATION_DATE CREATION_DATE
, CIA.LAST_UPDATED_BY LAST_UPDATED_BY
, CIA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CIA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CIA.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, HCA.ACCOUNT_NUMBER ACCOUNT_NUMBER
, HCA.ACCOUNT_NAME ACCOUNT_NAME
, HP.PARTY_NAME PARTY_NAME
, CIR.NAME RELATIONSHIP_NAME
, CIR.DESCRIPTION RELATIONSHIP_DESCR
FROM CSI_IP_ACCOUNTS CIA
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HP
, CSI_IPA_RELATION_TYPES CIR
WHERE CIA.PARTY_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID AND HCA.PARTY_ID = HP.PARTY_ID AND CIA.RELATIONSHIP_TYPE_CODE = CIR.IPA_RELATION_TYPE_CODE AND CIR.ACCOUNT_USE_FLAG = 'Y'