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

VIEW: APPS.EDW_FACT_DIM_RELATIONS_MD_V

Object Details
Object Name: EDW_FACT_DIM_RELATIONS_MD_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIS.EDW_FACT_DIM_RELATIONS_MD_V
Subobject Name:
Status: VALID

View Type

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


EDW_FACT_DIM_RELATIONS_MD_V


[View Source]

Columns
Name Datatype Length Mandatory Comments
FACT_ID NUMBER (9)
comment
FACT_NAME VARCHAR2 (255)
comment
FACT_FK_ID NUMBER (9)
comment
FACT_FK_NAME VARCHAR2 (255)
comment
FACT_FK_COL_ID NUMBER (9)
comment
FACT_FK_COL_NAME VARCHAR2 (255)
comment
DIM_UK_COL_ID NUMBER (9)
comment
DIM_UK_COL_NAME VARCHAR2 (255)
comment
DIM_UK_ID NUMBER (9)
comment
DIM_UK_NAME VARCHAR2 (255)
comment
DIM_UK_LONG_NAME VARCHAR2 (4000)
comment
DIM_ID NUMBER (9)
comment
DIM_NAME VARCHAR2 (255)
comment
FACT_LONG_NAME VARCHAR2 (4000)
comment
Query Text

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


SELECT FACT_ID
,      FACT_NAME
,      FACT_FK_ID
,      FACT_FK_NAME
,      FACT_FK_COL_ID
,      FACT_FK_COL_NAME
,      DIM_UK_COL_ID
,      DIM_UK_COL_NAME
,      DIM_UK_ID
,      DIM_UK_NAME
,      DIM_UK_LONG_NAME
,      DIM_ID
,      DIM_NAME
,      FACT_LONG_NAME
FROM APPS.EDW_FACT_DIM_RELATIONS_MD_V;

Dependencies

[top of page]

APPS.EDW_FACT_DIM_RELATIONS_MD_V references the following:

SchemaAPPS
SynonymEDW_FACT_DIM_RELATIONS_MD
APPS.EDW_FACT_DIM_RELATIONS_MD_V is referenced by following:

SchemaAPPS
Package BodyEDW_BSC_BRIDGE - show dependent code
ViewEDW_SEC_FACT_INFO_V