[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 |