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.HRFV_ORG_CLASSIFICATIONS

Object Details

Object Name:	HRFV_ORG_CLASSIFICATIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HRFV_ORG_CLASSIFICATIONS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view shows all organizations defined for the enterprise, together with their classifications. Organizations may have multiple classifications, e.g. a Business Group and a GRE.

[View Source]

Columns

Name	Datatype	Length	Mandatory
BUSINESS_GROUP_NAME	VARCHAR2	(240)	Yes
ORGANIZATION_NAME	VARCHAR2	(240)	Yes
DATE_FROM	DATE		Yes
DATE_TO	DATE
CLASSIFICATION	VARCHAR2	(4000)
ENABLED	VARCHAR2	(4000)
_DF	CHAR	(32)
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
ORGANIZATION_ID	NUMBER	(15)	Yes

Query Text

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


SELECT BUSINESS_GROUP_NAME
,      ORGANIZATION_NAME
,      DATE_FROM
,      DATE_TO
,      CLASSIFICATION
,      ENABLED
,      _DF
,      BUSINESS_GROUP_ID
,      ORGANIZATION_ID
FROM APPS.HRFV_ORG_CLASSIFICATIONS;

Dependencies

[top of page]

APPS.HRFV_ORG_CLASSIFICATIONS references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; HR_ALL_ORGANIZATION_UNITS_TL; HR_BIS - show dependent code; HR_ORGANIZATION_INFORMATION

APPS.HRFV_ORG_CLASSIFICATIONS is referenced by following:

PUBLIC: HRFV_ORG_CLASSIFICATIONS