VIEW: APPS.CSI_PARTY_ACCT_DETAILS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'