DBA Data[Home] [Help] [Dependency Information]


TABLE: AR.HZ_SUSPENSION_ACTIVITY

Object Details
Object Name: HZ_SUSPENSION_ACTIVITY
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HZ_SUSPENSION_ACTIVITY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUSPENSION_ACTIVITY_ID
HZ_SUSPENSION_ACTIVITY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSITE_USE_ID
HZ_SUSPENSION_ACTIVITY_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_ACCOUNT_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

AR.HZ_SUSPENSION_ACTIVITY does not reference any database object

AR.HZ_SUSPENSION_ACTIVITY is referenced by following:

SchemaAPPS
SynonymHZ_SUSPENSION_ACTIVITY