FND Design Data [Home] [Help]

View: JTF_SUSPENSION_ACTIVITY_V

Product: JTF - CRM Foundation
Description: JTF_SUSPENSION_ACTIVITY_V retreives information about the point in time that service is no longer provided to a customer account or customer account site.
Implementation/DBA Data: ViewAPPS.JTF_SUSPENSION_ACTIVITY_V
View Text

SELECT ROWID
, SUSPENSION_ACTIVITY_ID
, ACTION_EFFECTIVE_ON_DATE
, ACTION_REASON
, ACTION_TYPE
, SITE_USE_ID
, CUST_ACCOUNT_ID
, NOTICE_METHOD
, NOTICE_RECEIVED_CONFIRMATION
, NOTICE_SENT_DATE
, NOTICE_TYPE
, BEGIN_DATE
, END_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, WH_UPDATE_DATE
FROM HZ_SUSPENSION_ACTIVITY

Columns

Name
ROW_ID
SUSPENSION_ACTIVITY_ID
ACTION_EFFECTIVE_ON_DATE
ACTION_REASON
ACTION_TYPE
SITE_USE_ID
CUST_ACCOUNT_ID
NOTICE_METHOD
NOTICE_RECEIVED_CONFIRMATION
NOTICE_SENT_DATE
NOTICE_TYPE
BEGIN_DATE
END_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATE_LOGIN
LAST_UPDATE_DATE
LAST_UPDATED_BY
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
WH_UPDATE_DATE