DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.HRFV_OPERATING_UNITS

Object Details
Object Name: HRFV_OPERATING_UNITS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HRFV_OPERATING_UNITS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This view shows the operating units that have been defined for your enterprise.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240) Yes
OPERATING_UNIT_NAME VARCHAR2 (240) Yes
DATE_FROM DATE
Yes
DATE_TO DATE


ORGANIZATION_TYPE VARCHAR2 (4000)
INTERNAL_ADDRESS VARCHAR2 (80)
COMMENTS CLOB (4000)
LEGAL_ENTITY_NAME CHAR (0)
LOCATION_NAME VARCHAR2 (60)
_DF CHAR (34)
BUSINESS_GROUP_ID NUMBER (15) Yes
LEGAL_ENTITY_ID CHAR (0)

LOCATION_ID NUMBER (15)

OPERATING_UNITS_ID NUMBER (15) Yes
SHORT_CODE VARCHAR2 (150)
USABLE_FLAG VARCHAR2 (150)
Query Text

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


SELECT BUSINESS_GROUP_NAME
,      OPERATING_UNIT_NAME
,      DATE_FROM
,      DATE_TO
,      ORGANIZATION_TYPE
,      INTERNAL_ADDRESS
,      COMMENTS
,      LEGAL_ENTITY_NAME
,      LOCATION_NAME
,      _DF
,      BUSINESS_GROUP_ID
,      LEGAL_ENTITY_ID
,      LOCATION_ID
,      OPERATING_UNITS_ID
,      SHORT_CODE
,      USABLE_FLAG
FROM APPS.HRFV_OPERATING_UNITS;

Dependencies

[top of page]

APPS.HRFV_OPERATING_UNITS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_BIS - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL_TL
SynonymHR_ORGANIZATION_INFORMATION
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code

APPS.HRFV_OPERATING_UNITS is not referenced by any database object