[Home] [Help]
View: CSC_SUSPENSION_ACTIVITY_V
| Product: | CSC - Customer Care |
| Description: | AST_SUSPENSION_ACTIVITY_V retrieves suspension activity for a customer account. |
| Implementation/DBA Data: |
APPS.CSC_SUSPENSION_ACTIVITY_V
|
View Text
SELECT ROWID
, CUST_ACCOUNT_ID
, SUSPENSION_ACTIVITY_ID
, SITE_USE_ID
, ACTION_TYPE
, ACTION_REASON
, ACTION_EFFECTIVE_ON_DATE
, BEGIN_DATE
, END_DATE
, NOTICE_TYPE
, NOTICE_METHOD
, NOTICE_SENT_DATE
, NOTICE_RECEIVED_CONFIRMATION
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM HZ_SUSPENSION_ACTIVITY
Columns
| Name |
| ROW_ID |
| CUST_ACCOUNT_ID |
| SUSPENSION_ACTIVITY_ID |
| SITE_USE_ID |
| ACTION_TYPE |
| ACTION_REASON |
| ACTION_EFFECTIVE_ON_DATE |
| BEGIN_DATE |
| END_DATE |
| NOTICE_TYPE |
| NOTICE_METHOD |
| NOTICE_SENT_DATE |
| NOTICE_RECEIVED_CONFIRMATION |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_LOGIN |