[Home] [Help] [Dependency Information]
Object Name: | HZ_CLASS_CODE_RELATIONS |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_CLASS_CODE_RELATIONS |
Subobject Name: | |
Status: | VALID |
The HZ_CLASS_CODE_RELATIONS table stores information about the relationships between parent and child classification codes and the categories in the HZ_CLASS_CATEGORIES table. For example, within the North America Industry Classification System (NAICS) Manufacturing
category (code 33), the classification code for Radio and Television manufacturers (code 33422) is the child in relation to the classification code for Communications Equipment manufacturers (code 3342).
.
The primary keys for this table are CLASS_CATEGORY, CLASS_CODE, SUB_CLASS_CODE, and START_DATE_ACTIVE.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_CLASS_CODE_RELATIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CLASS_CATEGORY
CLASS_CODE SUB_CLASS_CODE START_DATE_ACTIVE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLASS_CATEGORY | VARCHAR2 | (30) | Yes | Classification category name |
CLASS_CODE | VARCHAR2 | (30) | Yes | Parent classification code |
SUB_CLASS_CODE | VARCHAR2 | (30) | Yes | Child classification code |
START_DATE_ACTIVE | DATE | Yes | The date when the class code relationship becomes effective | |
END_DATE_ACTIVE | DATE | The date when the class code relationship is no longer applied. | ||
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). |
OBJECT_VERSION_NUMBER | NUMBER | This column is used for locking purposes | ||
CREATED_BY_MODULE | VARCHAR2 | (150) | TCA Who column | |
APPLICATION_ID | NUMBER | TCA Who column |
Cut, paste (and edit) the following text to query this object:
SELECT CLASS_CATEGORY
, CLASS_CODE
, SUB_CLASS_CODE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, OBJECT_VERSION_NUMBER
, CREATED_BY_MODULE
, APPLICATION_ID
FROM AR.HZ_CLASS_CODE_RELATIONS;
AR.HZ_CLASS_CODE_RELATIONS does not reference any database object
AR.HZ_CLASS_CODE_RELATIONS is referenced by following:
|
|
|