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


VIEW: APPS.HR_LEGAL_ENTITIES

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


HR_LEGAL_ENTITIES is a view based on HR_ORGANIZATION_UNITS and
HR_ORGANIZATION_INFORMATION that returns generic information about a
GRE/Legal entity. Legislation specific information is not returned by
this view. HR_TAX_UNITS_V returns US specific information about a
GRE/legal entity.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_ID NUMBER (15) Yes Refer to base table.
ORGANIZATION_ID NUMBER (15) Yes Refer to base table.
NAME VARCHAR2 (240) Yes Refer to base table.
DATE_FROM DATE
Yes Refer to base table.
DATE_TO DATE

Refer to base table.
Query Text

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


SELECT BUSINESS_GROUP_ID
,      ORGANIZATION_ID
,      NAME
,      DATE_FROM
,      DATE_TO
FROM APPS.HR_LEGAL_ENTITIES;

Dependencies

[top of page]

APPS.HR_LEGAL_ENTITIES references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_ORGANIZATION_INFORMATION
ViewHR_ORG_UNITS_NO_JOIN
PL/SQL PackageHR_SECURITY - show dependent code
APPS.HR_LEGAL_ENTITIES is referenced by following:

SchemaAPPS
Package BodyBOM_CSTRPWDD_XMLP_PKG - show dependent code
Package BodyCST_PERITEMCOSTCHANGERPT_PVT - show dependent code
ViewECE_MVSTO_HEADERS_V
Package BodyHRSPINE - show dependent code
ViewHR_ADP_GRE_LIST_V
ViewINVFV_MOVEMENT_PARAMETERS
Package BodyJAI_AP_TDS_ETDS_PKG - show dependent code
Package BodyJA_CN_CFS_GENERATE_PKG - show dependent code
ViewMTL_MOVEMENT_PARAMETERS_V
Package BodyPAY_US_SQWL_ARCHIVE - show dependent code
Package BodyPA_CC_TP_UTILS - show dependent code
PL/SQL PackagePN_MO_CACHE_UTILS - show dependent code
Package BodyPN_MO_CACHE_UTILS - show dependent code
ViewPON_SYSTEM_FIELDS_VALUES_V
Package BodyPO_SIGNATURE_PVT - show dependent code
Package BodyXLE_BUSINESSINFO_GRP - show dependent code