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]

VIEW: APPS.HRIFV_US_FEDREP_GEN_HRCHY

Object Details

Object Name:	HRIFV_US_FEDREP_GEN_HRCHY
Object Type:	VIEW
Owner:	APPS
FND Design Data:	HRI.HRIFV_US_FEDREP_GEN_HRCHY
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

[View Source]

Columns

Name	Datatype	Length
HIERARCHY_NAME	VARCHAR2	(80)
HIERARCHY_TYPE	VARCHAR2	(4000)
HIERARCHY_TYPE_CODE	VARCHAR2	(30)
HIERARCHY_VERSION_NUMBER	NUMBER	(9)
HIERARCHY_VERSION_DATE_FROM	DATE
HIERARCHY_VERSION_DATE_TO	DATE
HIER_VERSION_DATE_TO_NN	DATE
HIER_VERSION_STATUS_CODE	VARCHAR2	(30)
HIER_VERSION_STATUS	VARCHAR2	(4000)
ENTITY_LEVEL	NUMBER	(4)
NODE_TYPE_CODE	VARCHAR2	(30)
NODE_TYPE	VARCHAR2	(4000)
NODE_NAME	VARCHAR2	(240)
NODE_LONG_NAME	VARCHAR2	(760)
SUB_ENTITY_LEVEL	NUMBER	(4)
SUB_NODE_TYPE_CODE	VARCHAR2	(30)
SUB_NODE_TYPE	VARCHAR2	(4000)
SUB_NODE_NAME	VARCHAR2	(60)
SUB_NODE_LONG_NAME	VARCHAR2	(760)
_DF:HRCY	CHAR	(29)
_DF:HRCYVER	CHAR	(38)
_DF:PAR	CHAR	(35)
_DF:LOC	CHAR	(22)
HIERARCHY_ID	NUMBER	(15)
HIERARCHY_VERSION_ID	NUMBER	(15)
BUSINESS_GROUP_ID	NUMBER	(9)
ENTITY_ID	VARCHAR2	(255)
HIERARCHY_NODE_ID	NUMBER	(15)
SUB_ENTITY_BG_ID	NUMBER	(9)
SUB_ENTITY_ID	VARCHAR2	(255)
SUB_HIERARCHY_NODE_ID	NUMBER	(15)

Query Text

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


SELECT HIERARCHY_NAME
,      HIERARCHY_TYPE
,      HIERARCHY_TYPE_CODE
,      HIERARCHY_VERSION_NUMBER
,      HIERARCHY_VERSION_DATE_FROM
,      HIERARCHY_VERSION_DATE_TO
,      HIER_VERSION_DATE_TO_NN
,      HIER_VERSION_STATUS_CODE
,      HIER_VERSION_STATUS
,      ENTITY_LEVEL
,      NODE_TYPE_CODE
,      NODE_TYPE
,      NODE_NAME
,      NODE_LONG_NAME
,      SUB_ENTITY_LEVEL
,      SUB_NODE_TYPE_CODE
,      SUB_NODE_TYPE
,      SUB_NODE_NAME
,      SUB_NODE_LONG_NAME
,      _DF:HRCY
,      _DF:HRCYVER
,      _DF:PAR
,      _DF:LOC
,      HIERARCHY_ID
,      HIERARCHY_VERSION_ID
,      BUSINESS_GROUP_ID
,      ENTITY_ID
,      HIERARCHY_NODE_ID
,      SUB_ENTITY_BG_ID
,      SUB_ENTITY_ID
,      SUB_HIERARCHY_NODE_ID
FROM APPS.HRIFV_US_FEDREP_GEN_HRCHY;

Dependencies

[top of page]

APPS.HRIFV_US_FEDREP_GEN_HRCHY references the following:

APPS: HRI_GEN_HRCHY_SUMMARY; HR_ALL_ORGANIZATION_UNITS_TL; HR_BIS - show dependent code; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL; HR_LOCATIONS_ALL_TL; HR_LOCATION_EXTRA_INFO; HR_ORGANIZATION_INFORMATION; PER_GEN_HIERARCHY; PER_GEN_HIERARCHY_NODES; PER_GEN_HIERARCHY_VERSIONS

APPS.HRIFV_US_FEDREP_GEN_HRCHY is not referenced by any database object