VIEW: APPS.CSI_IPAH_DETAILS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)