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: HR.PAY_ELE_TMPLT_CLASS_USAGES

Object Details

Object Name:	PAY_ELE_TMPLT_CLASS_USAGES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_ELE_TMPLT_CLASS_USAGES
Subobject Name:
Status:	VALID

Intermediate Table of pay_element_templates and pay_element_classifications, which is used for Element Template Wizard.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_ELE_TMPLT_CLASS_USAGES_PK

ELE_TEMPLATE_CLASSIFICATION_ID
ZD_EDITION_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_ELE_TMPLT_CLASS_USAGES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ELE_TEMPLATE_CLASSIFICATION_ID ZD_EDITION_NAME
PAY_ELE_TMPLT_CLASS_USAGES_UK2	NORMAL	UNIQUE	APPS_TS_TX_IDX	CLASSIFICATION_ID TEMPLATE_ID ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
ELE_TEMPLATE_CLASSIFICATION_ID	NUMBER	(9)	Yes	Element Template Classification ID
CLASSIFICATION_ID	NUMBER	(9)	Yes	Element Classification ID
TEMPLATE_ID	NUMBER	(9)	Yes	Element Template ID
DISPLAY_PROCESS_MODE	VARCHAR2	(30)		Display Process Mode
DISPLAY_ARREARAGE	VARCHAR2	(30)		Display Arrearage
ELE_TMPLT_CLASS_INFO_CATEGORY	VARCHAR2	(30)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO1	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO2	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO3	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO4	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO5	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO6	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO7	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO8	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO9	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO10	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO11	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO12	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO13	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO14	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO15	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO16	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO17	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO18	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO19	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO20	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO21	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO22	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO23	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO24	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO25	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO26	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO27	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO28	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO29	VARCHAR2	(150)		Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO30	VARCHAR2	(150)		Developer descriptive flexfield column.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT ELE_TEMPLATE_CLASSIFICATION_ID
,      CLASSIFICATION_ID
,      TEMPLATE_ID
,      DISPLAY_PROCESS_MODE
,      DISPLAY_ARREARAGE
,      ELE_TMPLT_CLASS_INFO_CATEGORY
,      ELE_TMPLT_CLASS_INFO1
,      ELE_TMPLT_CLASS_INFO2
,      ELE_TMPLT_CLASS_INFO3
,      ELE_TMPLT_CLASS_INFO4
,      ELE_TMPLT_CLASS_INFO5
,      ELE_TMPLT_CLASS_INFO6
,      ELE_TMPLT_CLASS_INFO7
,      ELE_TMPLT_CLASS_INFO8
,      ELE_TMPLT_CLASS_INFO9
,      ELE_TMPLT_CLASS_INFO10
,      ELE_TMPLT_CLASS_INFO11
,      ELE_TMPLT_CLASS_INFO12
,      ELE_TMPLT_CLASS_INFO13
,      ELE_TMPLT_CLASS_INFO14
,      ELE_TMPLT_CLASS_INFO15
,      ELE_TMPLT_CLASS_INFO16
,      ELE_TMPLT_CLASS_INFO17
,      ELE_TMPLT_CLASS_INFO18
,      ELE_TMPLT_CLASS_INFO19
,      ELE_TMPLT_CLASS_INFO20
,      ELE_TMPLT_CLASS_INFO21
,      ELE_TMPLT_CLASS_INFO22
,      ELE_TMPLT_CLASS_INFO23
,      ELE_TMPLT_CLASS_INFO24
,      ELE_TMPLT_CLASS_INFO25
,      ELE_TMPLT_CLASS_INFO26
,      ELE_TMPLT_CLASS_INFO27
,      ELE_TMPLT_CLASS_INFO28
,      ELE_TMPLT_CLASS_INFO29
,      ELE_TMPLT_CLASS_INFO30
,      ZD_EDITION_NAME
FROM HR.PAY_ELE_TMPLT_CLASS_USAGES;

Dependencies

[top of page]

HR.PAY_ELE_TMPLT_CLASS_USAGES does not reference any database object

HR.PAY_ELE_TMPLT_CLASS_USAGES is referenced by following:

HR: PAY_ELE_TMPLT_CLASS_USAGES#