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

VIEW: APPS.EDW_ORGA_OPER_UNIT_LCV

Object Details
Object Name: EDW_ORGA_OPER_UNIT_LCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewHRI.EDW_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

Internal

[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)
LAST_UPDATE_DATE DATE

CREATION_DATE DATE

USER_ATTRIBUTE1 VARCHAR2 (0)
USER_ATTRIBUTE2 VARCHAR2 (0)
USER_ATTRIBUTE3 VARCHAR2 (0)
USER_ATTRIBUTE4 VARCHAR2 (0)
USER_ATTRIBUTE5 VARCHAR2 (0)
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
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM APPS.EDW_ORGA_OPER_UNIT_LCV;

Dependencies

[top of page]

APPS.EDW_ORGA_OPER_UNIT_LCV references the following:

SchemaAPPS
ViewEDWBV_ORGA_OPER_UNIT_LCV
PL/SQL PackageHR_GENERAL - show dependent code
APPS.EDW_ORGA_OPER_UNIT_LCV is referenced by following:

SchemaAPPS
ViewEDW_MTL_ILDM_OU_LCV
Package BodyEDW_MTL_INVENTORY_LOC_M_SZ - show dependent code