[Home] [Help]
View: AST_SUSPENSION_ACTIVITY_V
Product: | AST - TeleSales |
Description: | AST_SUSPENSION_ACTIVITY_V retrieves suspension activity for a customer account. |
Implementation/DBA Data: |
APPS.AST_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 |