[Home] [Help]
View: CS_CP_AUDIT_V
| Product: | CS - Service |
|---|
| Description: | Audit table view for transferred products |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT AD.ROWID ROW_ID
, AD.CUSTOMER_PRODUCT_ID
, AD.LAST_UPDATE_DATE
, AD.LAST_UPDATED_BY
, AD.CREATION_DATE
, AD.CREATED_BY
, AD.LAST_UPDATE_LOGIN
, AD.COMMENTS
, CUST.CUSTOMER_NAME
, CUST.CUSTOMER_NUMBER
, FND.USER_NAME
FROM CS_CP_AUDIT AD
, CS_CUSTOMER_PRODUCTS CP
, RA_CUSTOMERS CUST
, FND_USER FND
WHERE ( AD.CUSTOMER_PRODUCT_ID = CP.CUSTOMER_PRODUCT_ID )
AND ( AD.CURRENT_CUSTOMER_ID = CUST.CUSTOMER_ID )
AND ( AD.CREATED_BY = FND.USER_ID )
Columns
| Name |
| ROW_ID |
| CUSTOMER_PRODUCT_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_LOGIN |
| COMMENTS |
| CUSTOMER_NAME |
| CUSTOMER_NUMBER |
| USER_NAME |