eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AR.HZ_CODE_ASSIGNMENTS

Object Details

Object Name:	HZ_CODE_ASSIGNMENTS
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_CODE_ASSIGNMENTS
Subobject Name:
Status:	VALID

The HZ_CODE_ASSIGNMENTS table is an intersection table that links the classification codes in the FND_LOOKUP_VALUES table to the names of parties or other entities stored in the table identified in the OWNER_TABLE_NAME column. For example, the classification code for databases can be linked to Oracle Corporation.
.
The primary key for this table is CODE_ASSIGNMENT_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_CODE_ASSIGNMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CODE_ASSIGNMENT_ID
HZ_CODE_ASSIGNMENTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	OWNER_TABLE_ID OWNER_TABLE_KEY_1 OWNER_TABLE_KEY_2 OWNER_TABLE_KEY_3 OWNER_TABLE_KEY_4 OWNER_TABLE_KEY_5 OWNER_TABLE_NAME ACTUAL_CONTENT_SOURCE CLASS_CATEGORY CLASS_CODE START_DATE_ACTIVE
HZ_CODE_ASSIGNMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLASS_CATEGORY CLASS_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
CODE_ASSIGNMENT_ID	NUMBER	(15)	Yes	Unique identifier of the assignment of an industrial classification code to an object
OWNER_TABLE_NAME	VARCHAR2	(30)	Yes	Table that stores the owner of the class code
OWNER_TABLE_ID	NUMBER	(15)		Identifies the owner of the class code
CLASS_CATEGORY	VARCHAR2	(30)	Yes	Classification category name
CLASS_CODE	VARCHAR2	(30)	Yes	Classification code
PRIMARY_FLAG	VARCHAR2	(1)	Yes	Indicates if this is the primary class code of a class category for the organization. Y for the primary class code, N for all others.
CONTENT_SOURCE_TYPE	VARCHAR2	(30)	Yes	Source of data content. The data may have originated from Dun & Bradstreet or be user entered.
IMPORTANCE_RANKING	VARCHAR2	(240)		No longer used
START_DATE_ACTIVE	DATE		Yes	The date that the class code applies to the organization.
END_DATE_ACTIVE	DATE			The date when the class code 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).
STATUS	VARCHAR2	(1)		Record status flag
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
RANK	NUMBER			Used to rank classes if multiple classes have been assigned to a party.
OWNER_TABLE_KEY_1	VARCHAR2	(255)		First column of alphanumeric or multi-part foreign key.
OWNER_TABLE_KEY_2	VARCHAR2	(255)		Second column of alphanumeric or multi-part foreign key.
OWNER_TABLE_KEY_3	VARCHAR2	(255)		Third column of alphanumeric or multi-part foreign key.
OWNER_TABLE_KEY_4	VARCHAR2	(255)		Fourth column of alphanumeric or multi-part foreign key.
OWNER_TABLE_KEY_5	VARCHAR2	(255)		Fifth column of alphanumeric or multi-part foreign key.
REQUEST_ID	NUMBER	(15)		Concurrent Program Who column. Request identifier 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 identifier of the program that last updated this row. Foreign key to FND_APPLICATION.APPLICATION_ID
PROGRAM_ID	NUMBER	(15)		Concurrent Program Who column. Program identifier 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
ACTUAL_CONTENT_SOURCE	VARCHAR2	(30)	Yes	Source system that users can overwrite data from.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CODE_ASSIGNMENT_ID
,      OWNER_TABLE_NAME
,      OWNER_TABLE_ID
,      CLASS_CATEGORY
,      CLASS_CODE
,      PRIMARY_FLAG
,      CONTENT_SOURCE_TYPE
,      IMPORTANCE_RANKING
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      STATUS
,      OBJECT_VERSION_NUMBER
,      CREATED_BY_MODULE
,      APPLICATION_ID
,      RANK
,      OWNER_TABLE_KEY_1
,      OWNER_TABLE_KEY_2
,      OWNER_TABLE_KEY_3
,      OWNER_TABLE_KEY_4
,      OWNER_TABLE_KEY_5
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ACTUAL_CONTENT_SOURCE
FROM AR.HZ_CODE_ASSIGNMENTS;

Dependencies

[top of page]

AR.HZ_CODE_ASSIGNMENTS does not reference any database object

AR.HZ_CODE_ASSIGNMENTS is referenced by following:

APPS: HZ_CODE_ASSIGNMENTS