[Home] [Help]
View: XNC_SUSPENSION_ACTIVITY_V
Product: | XNC - Sales for Communications (Obsolete) |
Description: | XNC_SUSPENSION_ACTIVITY_V retrieves suspension activity for a customer account. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ROWID
, CUST_ACCOUNT_ID
, SUSPENSION_ACTIVITY_ID
, SITE_USE_ID
, LAST_UPDATE_DATE
, ACTION_TYPE
, ACTION_REASON
, ACTION_EFFECTIVE_ON_DATE
, BEGIN_DATE
, END_DATE
, NOTICE_TYPE
, NOTICE_METHOD
, NOTICE_SENT_DATE
, NOTICE_RECEIVED_CONFIRMATION
FROM JTF_SUSPENSION_ACTIVITY_V
Columns
Name |
ROW_ID |
CUST_ACCOUNT_ID |
SUSPENSION_ACTIVITY_ID |
SITE_USE_ID |
LAST_UPDATE_DATE |
ACTION_TYPE |
ACTION_REASON |
ACTION_EFFECTIVE_ON_DATE |
BEGIN_DATE |
END_DATE |
NOTICE_TYPE |
NOTICE_METHOD |
NOTICE_SENT_DATE |
NOTICE_RECEIVED_CONFIRMATION |