[Home] [Help]
| 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
|
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