View: CS_CP_AUDIT_MAINT_V

Product:	CS - Service
Description:	Audit information for customer products
Implementation/DBA Data:	APPS.CS_CP_AUDIT_MAINT_V

View Text

SELECT CPA.ROWID ROW_ID
, CPA.CUSTOMER_PRODUCT_ID
, CPA.LAST_UPDATE_DATE
, CPA.LAST_UPDATED_BY
, CPA.CREATION_DATE
, CPA.CREATED_BY
, CPA.LAST_UPDATE_LOGIN
, CPA.OLD_CUSTOMER_ID
, CPA.CURRENT_CUSTOMER_ID
, CPA.OLD_SYSTEM_ID
, CPA.CURRENT_SYSTEM_ID
, CPA.OLD_PRODUCT_AGREEMENT_ID
, CPA.CURRENT_PRODUCT_AGREEMENT_ID
, CPA.OLD_PLATFORM_VERSION_ID
, CPA.CURRENT_PLATFORM_VERSION_ID
, CPA.ATTRIBUTE1
, CPA.ATTRIBUTE2
, CPA.ATTRIBUTE3
, CPA.ATTRIBUTE4
, CPA.ATTRIBUTE5
, CPA.ATTRIBUTE6
, CPA.ATTRIBUTE7
, CPA.ATTRIBUTE8
, CPA.ATTRIBUTE9
, CPA.ATTRIBUTE10
, CPA.CONTEXT
, CPA.ATTRIBUTE11
, CPA.ATTRIBUTE12
, CPA.ATTRIBUTE13
, CPA.ATTRIBUTE14
, CPA.ATTRIBUTE15
, CPA.COMMENTS
, CPA.OLD_CP_STATUS_ID
, CPA.CURRENT_CP_STATUS_ID
, CPA.OLD_TYPE_CODE
, CPA.CURRENT_TYPE_CODE
, FND.USER_NAME UPDATED_BY
, HZP1.PARTY_NAME OLD_CUSTOMER
, HZP2.PARTY_NAME NEW_CUSTOMER
, CS1.NAME OLD_SYSTEM
, CS2.NAME NEW_SYSTEM
, PAG1.NAME OLD_PRODUCT_AGREEMENT
, PAG2.NAME NEW_PRODUCT_AGREEMENT
, NULL OLD_PLATFORM_NAME
, NULL NEW_PLATFORM_NAME
, CPS1.NAME OLD_CP_STATUS
, CPS2.NAME NEW_CP_STATUS
, LU1.MEANING OLD_TYPE
, LU2.MEANING NEW_TYPE
, CPA.SPLIT_CP_ID
, CCP.REFERENCE_NUMBER SPLIT_CP_REFERENCE_NUMBER
, CPA.OLD_CP_QUANTITY
, CPA.CURRENT_CP_QUANTITY
, CPA.CP_SPLIT_REASON_CODE
, LU.MEANING CP_SPLIT_REASON
FROM CS_CP_AUDIT CPA
, HZ_CUST_ACCOUNTS CUST1
, HZ_CUST_ACCOUNTS CUST2
, HZ_PARTIES HZP1
, HZ_PARTIES HZP2
, CS_SYSTEMS CS1
, CS_SYSTEMS CS2
, OE_AGREEMENTS PAG1
, OE_AGREEMENTS PAG2
, FND_USER FND
, CS_CUSTOMER_PRODUCT_STATUSES CPS1
, CS_CUSTOMER_PRODUCT_STATUSES CPS2
, CS_CUSTOMER_PRODUCTS_ALL CCP
, CS_LOOKUPS LU1
, CS_LOOKUPS LU2
, CS_LOOKUPS LU
WHERE FND.USER_ID = CPA.CREATED_BY
AND CPA.OLD_CUSTOMER_ID = CUST1.CUST_ACCOUNT_ID(+)
AND CUST1.PARTY_ID = HZP1.PARTY_ID
AND CPA.CURRENT_CUSTOMER_ID = CUST2.CUST_ACCOUNT_ID(+)
AND CUST2.PARTY_ID = HZP2.PARTY_ID
AND CPA.OLD_SYSTEM_ID = CS1.SYSTEM_ID(+)
AND CPA.CURRENT_SYSTEM_ID = CS2.SYSTEM_ID(+)
AND CPA.OLD_PRODUCT_AGREEMENT_ID = PAG1.AGREEMENT_ID(+)
AND CPA.CURRENT_PRODUCT_AGREEMENT_ID = PAG2.AGREEMENT_ID(+)
AND CPA.OLD_CP_STATUS_ID = CPS1.CUSTOMER_PRODUCT_STATUS_ID(+)
AND CPA.CURRENT_CP_STATUS_ID = CPS2.CUSTOMER_PRODUCT_STATUS_ID(+)
AND CPA.SPLIT_CP_ID = CCP.CUSTOMER_PRODUCT_ID(+)
AND CPA.OLD_TYPE_CODE = LU1.LOOKUP_CODE(+)
AND LU1.LOOKUP_TYPE(+) = 'CUSTOMER_PRODUCT_TYPE'
AND CPA.CURRENT_TYPE_CODE = LU2.LOOKUP_CODE(+)
AND LU2.LOOKUP_TYPE(+) = 'CUSTOMER_PRODUCT_TYPE'
AND CPA.CP_SPLIT_REASON_CODE = LU.LOOKUP_CODE(+)
AND LU.LOOKUP_TYPE(+) = 'CS_SPLIT_CP_REASON'

Columns