View: CSI_IPAH_DETAILS_V

Product:	CSI - Install Base
Description:	Instance Party Accounts History details.
Implementation/DBA Data:	APPS.CSI_IPAH_DETAILS_V

View Text

SELECT IPAH.IP_ACCOUNT_HISTORY_ID
, IPAH.IP_ACCOUNT_ID
, IPAH.TRANSACTION_ID
, CIP.INSTANCE_ID
, IPAH.OLD_PARTY_ACCOUNT_ID
, IPAH.NEW_PARTY_ACCOUNT_ID
, IPAH.OLD_RELATIONSHIP_TYPE_CODE
, IPAH.NEW_RELATIONSHIP_TYPE_CODE
, IPAH.OLD_ACTIVE_START_DATE
, IPAH.NEW_ACTIVE_START_DATE
, IPAH.OLD_ACTIVE_END_DATE
, IPAH.NEW_ACTIVE_END_DATE
, IPAH.OLD_CONTEXT
, IPAH.NEW_CONTEXT
, IPAH.OLD_ATTRIBUTE1
, IPAH.NEW_ATTRIBUTE1
, IPAH.OLD_ATTRIBUTE2
, IPAH.NEW_ATTRIBUTE2
, IPAH.OLD_ATTRIBUTE3
, IPAH.NEW_ATTRIBUTE3
, IPAH.OLD_ATTRIBUTE4
, IPAH.NEW_ATTRIBUTE4
, IPAH.OLD_ATTRIBUTE5
, IPAH.NEW_ATTRIBUTE5
, IPAH.OLD_ATTRIBUTE6
, IPAH.NEW_ATTRIBUTE6
, IPAH.OLD_ATTRIBUTE7
, IPAH.NEW_ATTRIBUTE7
, IPAH.OLD_ATTRIBUTE8
, IPAH.NEW_ATTRIBUTE8
, IPAH.OLD_ATTRIBUTE9
, IPAH.NEW_ATTRIBUTE9
, IPAH.OLD_ATTRIBUTE10
, IPAH.NEW_ATTRIBUTE10
, IPAH.OLD_ATTRIBUTE11
, IPAH.NEW_ATTRIBUTE11
, IPAH.OLD_ATTRIBUTE12
, IPAH.NEW_ATTRIBUTE12
, IPAH.OLD_ATTRIBUTE13
, IPAH.NEW_ATTRIBUTE13
, IPAH.OLD_ATTRIBUTE14
, IPAH.NEW_ATTRIBUTE14
, IPAH.OLD_ATTRIBUTE15
, IPAH.NEW_ATTRIBUTE15
, IPAH.FULL_DUMP_FLAG
, IPAH.CREATED_BY
, IPAH.CREATION_DATE
, IPAH.LAST_UPDATED_BY
, IPAH.LAST_UPDATE_DATE
, IPAH.LAST_UPDATE_LOGIN
, IPAH.OBJECT_VERSION_NUMBER
, IPAH.OLD_BILL_TO_ADDRESS
, IPAH.NEW_BILL_TO_ADDRESS
, IPAH.OLD_SHIP_TO_ADDRESS
, IPAH.NEW_SHIP_TO_ADDRESS
, OHCA.ACCOUNT_NUMBER OLD_ACCOUNT_NUMBER
, OHCA.ACCOUNT_NAME OLD_ACCOUNT_NAME
, OHP.PARTY_NAME OLD_PARTY_NAME
, OCIR.NAME OLD_RELATIONSHIP_NAME
, OCIR.DESCRIPTION OLD_RELATIONSHIP_DESCR
, NHCA.ACCOUNT_NUMBER NEW_ACCOUNT_NUMBER
, NHCA.ACCOUNT_NAME NEW_ACCOUNT_NAME
, NHP.PARTY_NAME NEW_PARTY_NAME
, NCIR.NAME NEW_RELATIONSHIP_NAME
, NCIR.DESCRIPTION NEW_RELATIONSHIP_DESCR
FROM CSI_IP_ACCOUNTS_H IPAH
, HZ_CUST_ACCOUNTS OHCA
, HZ_PARTIES OHP
, CSI_IPA_RELATION_TYPES OCIR
, HZ_CUST_ACCOUNTS NHCA
, HZ_PARTIES NHP
, CSI_IPA_RELATION_TYPES NCIR
, CSI_IP_ACCOUNTS IPA
, CSI_I_PARTIES CIP
WHERE IPAH.OLD_PARTY_ACCOUNT_ID = OHCA.CUST_ACCOUNT_ID (+) AND OHCA.PARTY_ID = OHP.PARTY_ID (+) AND IPAH.OLD_RELATIONSHIP_TYPE_CODE = OCIR.IPA_RELATION_TYPE_CODE (+)
AND IPAH.NEW_PARTY_ACCOUNT_ID = NHCA.CUST_ACCOUNT_ID (+) AND NHCA.PARTY_ID = NHP.PARTY_ID (+) AND IPAH.NEW_RELATIONSHIP_TYPE_CODE = NCIR.IPA_RELATION_TYPE_CODE (+)
AND IPAH.IP_ACCOUNT_ID = IPA.IP_ACCOUNT_ID (+) AND IPA.INSTANCE_PARTY_ID = CIP.INSTANCE_PARTY_ID (+)

Columns