[Home] [Help]
[Dependency Information]
| Object Name: | EDWBV_ORGA_LEG_ENTITY_LCV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | HRI.EDWBV_ORGA_LEG_ENTITY_LCV
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A Business Intelligence System view
This view contains
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LEGAL_ENTITY_PK | VARCHAR2 | (71) | ||
| BUSINESS_GROUP_FK | VARCHAR2 | (71) | ||
| NAME | VARCHAR2 | (483) | ||
| LEGAL_ENTITY_DP | VARCHAR2 | (483) | ||
| SET_OF_BOOKS | VARCHAR2 | (30) | ||
| DATE_FROM | DATE | Yes | ||
| DATE_TO | DATE | |||
| INT_EXT_FLAG | VARCHAR2 | (4000) | ||
| ORG_CODE | VARCHAR2 | (3) | ||
| ORG_TYPE | VARCHAR2 | (4000) | ||
| PRIMARY_CST_MTHD | NUMBER | |||
| INSTANCE | VARCHAR2 | (30) | ||
| LEGAL_ENTITY_ID | NUMBER | (15) | Yes | |
| LEVEL_NAME | CHAR | (2) | ||
| _DF:POU:_EDW | CHAR | (33) | ||
| _DF:HOI:_EDW | CHAR | (39) | ||
| _DF:ODD:_EDW | CHAR | (28) | ||
| _DF:JGB:_EDW | CHAR | (30) | ||
| _DF:GSB:_EDW | CHAR | (30) | ||
| LAST_UPDATE_DATE | DATE | |||
| CREATION_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT LEGAL_ENTITY_PK
, BUSINESS_GROUP_FK
, NAME
, LEGAL_ENTITY_DP
, SET_OF_BOOKS
, DATE_FROM
, DATE_TO
, INT_EXT_FLAG
, ORG_CODE
, ORG_TYPE
, PRIMARY_CST_MTHD
, INSTANCE
, LEGAL_ENTITY_ID
, LEVEL_NAME
, _DF:POU:_EDW
, _DF:HOI:_EDW
, _DF:ODD:_EDW
, _DF:JGB:_EDW
, _DF:GSB:_EDW
, LAST_UPDATE_DATE
, CREATION_DATE
FROM APPS.EDWBV_ORGA_LEG_ENTITY_LCV;
APPS
EDW_LOCAL_INSTANCE
GL_SETS_OF_BOOKS
HR_ALL_ORGANIZATION_UNITS
HR_GENERAL
- show dependent code
HR_ORGANIZATION_INFORMATION
MTL_PARAMETERS
APPS
EDW_ORGA_LEG_ENTITY_LCV
|
|
|
|