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


VIEW: APPS.EDWBV_ORGA_OPER_UNIT_LCV

Object Details
Object Name: EDWBV_ORGA_OPER_UNIT_LCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewHRI.EDWBV_ORGA_OPER_UNIT_LCV
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view


This view contains . It is the base view for the collection view.


[View Source]

Columns
Name Datatype Length Mandatory Comments
OPERATING_UNIT_PK VARCHAR2 (71)
LEGAL_ENTITY_FK VARCHAR2 (71)
NAME VARCHAR2 (483)
OPERATING_UNIT_DP VARCHAR2 (483)
BUSINESS_GROUP VARCHAR2 (240) Yes
DATE_FROM DATE
Yes
DATE_TO DATE

INT_EXT_FLAG VARCHAR2 (4000)
ORG_TYPE VARCHAR2 (4000)
ORG_CODE VARCHAR2 (3)
PRIMARY_CST_MTHD NUMBER

INSTANCE VARCHAR2 (30)
OPERATING_UNIT_ID NUMBER (15) Yes
LEVEL_NAME CHAR (2)
_DF:POU:_EDW CHAR (33)
_DF:HOI:_EDW CHAR (39)
_DF:ODD:_EDW CHAR (28)
LAST_UPDATE_DATE DATE

CREATION_DATE DATE

Query Text

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


SELECT OPERATING_UNIT_PK
,      LEGAL_ENTITY_FK
,      NAME
,      OPERATING_UNIT_DP
,      BUSINESS_GROUP
,      DATE_FROM
,      DATE_TO
,      INT_EXT_FLAG
,      ORG_TYPE
,      ORG_CODE
,      PRIMARY_CST_MTHD
,      INSTANCE
,      OPERATING_UNIT_ID
,      LEVEL_NAME
,      _DF:POU:_EDW
,      _DF:HOI:_EDW
,      _DF:ODD:_EDW
,      LAST_UPDATE_DATE
,      CREATION_DATE
FROM APPS.EDWBV_ORGA_OPER_UNIT_LCV;

Dependencies

[top of page]

APPS.EDWBV_ORGA_OPER_UNIT_LCV references the following:

SchemaAPPS
SynonymEDW_LOCAL_INSTANCE
SynonymHR_ALL_ORGANIZATION_UNITS
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_ORGANIZATION_INFORMATION
SynonymMTL_PARAMETERS
APPS.EDWBV_ORGA_OPER_UNIT_LCV is referenced by following:

SchemaAPPS
ViewEDW_ORGA_OPER_UNIT_LCV