[Home] [Help] [Dependency Information]
Object Name: | HZ_SUSPENSION_ACTIVITY |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_SUSPENSION_ACTIVITY |
Subobject Name: | |
Status: | VALID |
The HZ_SUSPENSION_ACTIVITY table stores information about discontinuing sales or service to a customer. For example, this table could be used to store the information that on February 8, 2001, a letter was sent via registered US mail to a customer account site that stated that service to that site would be discontinued on April 1, 2001 due to delayed payments.
.
The primary key for this table is SUSPENSION_ACTIVITY_ID.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_SUSPENSION_ACTIVITY_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SUSPENSION_ACTIVITY_ID |
HZ_SUSPENSION_ACTIVITY_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SITE_USE_ID |
HZ_SUSPENSION_ACTIVITY_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CUST_ACCOUNT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUSPENSION_ACTIVITY_ID | NUMBER | (15) | Yes | Unique identifier of the suspension of service activity |
ACTION_EFFECTIVE_ON_DATE | DATE | The date that the suspension of activity takes effect. For example, the date that service to a customer 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) | Foreign key to the HZ_CUST_SITE_USES_ALL table | |
CUST_ACCOUNT_ID | NUMBER | (15) | Yes | Identifier for customer accounts. Foreign key to the HZ_CUST_ACCOUNTS table |
NOTICE_METHOD | VARCHAR2 | (60) | Describes the method by which an account holder was notified. For example, regular postal mail, registered letter, telephone, and so on. | |
NOTICE_RECEIVED_CONFIRMATION | VARCHAR2 | (1) | Indicates if a notice was received. Y for a received notice, N for a notice that receipt has not been | |
NOTICE_SENT_DATE | DATE | The date and time that 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 date that suspension was or will be activated | ||
END_DATE | DATE | The date that the suspension of activity was or will be 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 | Date when the record was entered or changed in a data warehouse |
Cut, paste (and edit) the following text to query this object:
SELECT 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 AR.HZ_SUSPENSION_ACTIVITY;
AR.HZ_SUSPENSION_ACTIVITY does not reference any database object
AR.HZ_SUSPENSION_ACTIVITY is referenced by following:
|
|
|