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

Object Details

Object Name:	HRBV_ORGANIZATION_UNIT
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Organization Units (from HR_ORGANIZATION_UNITS and HR_ALL_ORGANIZATION_UNITS_TL tables)

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Translated name of the organization
DATE_FROM	DATE		Yes	Start date of the organization.
DATE_TO	DATE			End date of the organization.
INTERNAL_ADDRESS	VARCHAR2	(80)		Internal address line.
COMMENTS	LONG	(0)		Comments.
INTERNAL_EXTERNAL_FLAG	VARCHAR2	(4000)		Identifies whether the organization is treated as an employment unit within the business group.
ORGANIZATION_TYPE	VARCHAR2	(4000)		User-defined organization types, for example Region, Division, Department.
_DF:AOU	CHAR	(32)		Descriptive Flex placeholder
INTERNAL_EXTERNAL_FLAG_CODE	VARCHAR2	(30)		Code of INTERNAL_EXTERNAL_FLAG
TYPE_CODE	VARCHAR2	(30)		Code of ORGANIZATION_TYPE
LEGISLATION_CODE	VARCHAR2	(4000)		Identifies the legislation of the Business group where the Organization is created.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign key to HR_ORGANIZATION_UNITS.
COST_ALLOCATION_KEYFLEX_ID	NUMBER	(9)		Foreign key to PAY_COST_ALLOCATION_KEYFLEX.
LOCATION_ID	NUMBER	(15)		Foreign key to HR_LOCATIONS. Default work site location for all assignments to this organization.
ORGANIZATION_ID	NUMBER	(15)	Yes	System-generated primary key column.
SOFT_CODING_KEYFLEX_ID	NUMBER	(15)		Foreign key to HR_SOFT_CODING_KEYFLEX
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATED_BY	NUMBER	(15)		Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
CREATED_BY	NUMBER	(15)		Standard who column
CREATION_DATE	DATE			Standard who column
BG_SECURITY_FLAG_CODE	CHAR	(1)		Business group security flag code

Query Text

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


SELECT ORGANIZATION_NAME
,      DATE_FROM
,      DATE_TO
,      INTERNAL_ADDRESS
,      COMMENTS
,      INTERNAL_EXTERNAL_FLAG
,      ORGANIZATION_TYPE
,      _DF:AOU
,      INTERNAL_EXTERNAL_FLAG_CODE
,      TYPE_CODE
,      LEGISLATION_CODE
,      BUSINESS_GROUP_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      SOFT_CODING_KEYFLEX_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_ORGANIZATION_UNIT;

Dependencies

[top of page]

APPS.HRBV_ORGANIZATION_UNIT references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; HR_API - show dependent code; HR_BIS - show dependent code; HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code

APPS.HRBV_ORGANIZATION_UNIT is referenced by following:

PUBLIC: HRBV_ORGANIZATION_UNIT