[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JTF_SUSPENSION_ACTIVITY_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  JTF.JTF_SUSPENSION_ACTIVITY_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
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.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row Id | |
| SUSPENSION_ACTIVITY_ID | NUMBER | (15) | Yes | Unique identifier of the suspension of service activity |
| ACTION_EFFECTIVE_ON_DATE | DATE | The date that the suspension activity is instigated (i.e. the date that it is said that service will be suspended). | ||
| ACTION_REASON | VARCHAR2 | (2000) | A textual description of the reason for suspension of an account. | |
| ACTION_TYPE | VARCHAR2 | (30) | A classification of suspension. Examples include, temporary, warning. | |
| SITE_USE_ID | NUMBER | (15) | FK to HZ_CUST_SITE_USES_ALL | |
| CUST_ACCOUNT_ID | NUMBER | (15) | Yes | Customer Account identifier. FK to HZ_CUST_ACCOUNTS_ALL |
| NOTICE_METHOD | VARCHAR2 | (60) | Describes the method by which an account holder was notified. For example, U.S. Mail, Registered Letter, Telephone etc. | |
| NOTICE_RECEIVED_CONFIRMATION | VARCHAR2 | (1) | Indicates whether a notice was received. The default value is No, the confirmation was not received. | |
| NOTICE_SENT_DATE | DATE | The date and time on which a notice was sent to the account holder. | ||
| NOTICE_TYPE | VARCHAR2 | (60) | Classifies notices in terms of how soon the suspension will take effect. | |
| BEGIN_DATE | DATE | The actual date (can be in the future) that suspension is to be activated. | ||
| END_DATE | DATE | The date on which suspension was lifted. | ||
| CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
| PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| WH_UPDATE_DATE | DATE | Warehouse update date when record was recorded or changed |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.JTF_SUSPENSION_ACTIVITY_V;
APPS
HZ_SUSPENSION_ACTIVITY
APPS.JTF_SUSPENSION_ACTIVITY_V is not referenced by any database object
|
|
|
|