[Home] [Help]
| Product: | AST - TeleSales |
|---|---|
| Description: | AST_SUSPENSION_ACTIVITY_V retrieves suspension activity for a customer account. |
| Implementation/DBA Data: |
APPS.AST_SUSPENSION_ACTIVITY_V
|
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