FND Design Data [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: ViewAPPS.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