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_BUSINESS_GROUPS

Object Details

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

View Type

A Business Intelligence System view

This view shows business groups within your enterprise. Each may have its own set of internal organizations, grades, jobs, positions, payrolls, employees, applicants etc.

[View Source]

Columns

Name	Datatype	Length	Mandatory
BUSINESS_GROUP_NAME	VARCHAR2	(240)	Yes
DATE_FROM	DATE		Yes
DATE_TO	DATE
INTERNAL_ADDRESS_LINE	VARCHAR2	(80)
COMMENTS	CLOB	(4000)
DEFAULT_START_TIME	VARCHAR2	(150)
DEFAULT_END_TIME	VARCHAR2	(150)
WORKING_HOURS_AMOUNT	VARCHAR2	(150)
WORKING_HOURS_FREQUENCY	VARCHAR2	(4000)
BUSINESS_GROUP_SHORT_NAME	VARCHAR2	(150)
EMP_NUMBER_GENERATION_METHOD	VARCHAR2	(4000)
APL_NUMBER_GENERATION_METHOD	VARCHAR2	(4000)
DEFAULT_CURRENCY_CODE	VARCHAR2	(150)
ENABLED_FLAG	VARCHAR2	(4000)
LEGISLATION_CODE	VARCHAR2	(150)
GRADE_STRUCTURE	VARCHAR2	(30)	Yes
PEOPLE_GROUP_STRUCTURE	VARCHAR2	(30)	Yes
JOB_STRUCTURE	VARCHAR2	(30)	Yes
COST_ALLOCATION_STRUCTURE	VARCHAR2	(30)	Yes
POSITION_STRUCTURE	VARCHAR2	(30)	Yes
COMPETENCE_STRUCTURE	VARCHAR2	(30)	Yes
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
COSTING_KF_STRUCTURE_ID	VARCHAR2	(150)
GRADE_KF_STRUCTURE_ID	VARCHAR2	(150)
JOB_KF_STRUCTURE_ID	VARCHAR2	(150)
LOCATION_ID	NUMBER	(15)
PEOPLE_GROUP_KF_STRUCTURE_ID	VARCHAR2	(150)
POSITION_KF_STRUCTURE_ID	VARCHAR2	(150)
COMPETENCE_KF_STRUCTURE_ID	VARCHAR2	(150)

Query Text

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


SELECT BUSINESS_GROUP_NAME
,      DATE_FROM
,      DATE_TO
,      INTERNAL_ADDRESS_LINE
,      COMMENTS
,      DEFAULT_START_TIME
,      DEFAULT_END_TIME
,      WORKING_HOURS_AMOUNT
,      WORKING_HOURS_FREQUENCY
,      BUSINESS_GROUP_SHORT_NAME
,      EMP_NUMBER_GENERATION_METHOD
,      APL_NUMBER_GENERATION_METHOD
,      DEFAULT_CURRENCY_CODE
,      ENABLED_FLAG
,      LEGISLATION_CODE
,      GRADE_STRUCTURE
,      PEOPLE_GROUP_STRUCTURE
,      JOB_STRUCTURE
,      COST_ALLOCATION_STRUCTURE
,      POSITION_STRUCTURE
,      COMPETENCE_STRUCTURE
,      BUSINESS_GROUP_ID
,      COSTING_KF_STRUCTURE_ID
,      GRADE_KF_STRUCTURE_ID
,      JOB_KF_STRUCTURE_ID
,      LOCATION_ID
,      PEOPLE_GROUP_KF_STRUCTURE_ID
,      POSITION_KF_STRUCTURE_ID
,      COMPETENCE_KF_STRUCTURE_ID
FROM APPS.HRFV_BUSINESS_GROUPS;

Dependencies

[top of page]

APPS.HRFV_BUSINESS_GROUPS references the following:

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

APPS.HRFV_BUSINESS_GROUPS is not referenced by any database object