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.

[Home] [Help]

View: PER_GEN_HIER_NODE_TYPES_V

Product:	PER - Human Resources
Description:	Supports UI for HRMS Calendar node types only
Implementation/DBA Data:	APPS.PER_GEN_HIER_NODE_TYPES_V

View Text

SELECT PGT.HIER_NODE_TYPE_ID
, PGT.HIERARCHY_TYPE
, HRL2.MEANING
, PGT.PARENT_NODE_TYPE
, PGT.CHILD_NODE_TYPE
, HRL1.MEANING
, PGT.CHILD_VALUE_SET
, HRL1.DESCRIPTION
, PGT.LAST_UPDATE_DATE
, PGT.LAST_UPDATED_BY
, PGT.LAST_UPDATE_LOGIN
, PGT.CREATED_BY
, PGT.CREATION_DATE
, PGT.OBJECT_VERSION_NUMBER
FROM PER_GEN_HIER_NODE_TYPES PGT
, HR_LOOKUPS HRL1
, HR_LOOKUPS HRL2
WHERE PGT.CHILD_NODE_TYPE = HRL1.LOOKUP_CODE
AND HRL1.LOOKUP_TYPE = 'HIERARCHY_NODE_TYPE'
AND PGT.HIERARCHY_TYPE = HRL2.LOOKUP_CODE
AND PGT.HIERARCHY_TYPE LIKE 'PER_CAL%'
AND HRL2.LOOKUP_TYPE = 'HIERARCHY_TYPE'

Columns

Name
HIER_NODE_TYPE_ID
HIERARCHY_TYPE
HIERARCHY_TYPE_NAME
PARENT_NODE_TYPE
CHILD_NODE_TYPE
CHILD_NODE_NAME
CHILD_VALUE_SET
DESCRIPTION
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER