eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
[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:
APPS.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
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
Name