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

VIEW: APPS.EDW_FOREIGN_KEY_COLUMNS_MD_V

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

View Type

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


EDW_FOREIGN_KEY_COLUMNS_MD_V


[View Source]

Columns
Name Datatype Length Mandatory Comments
ENTITY_ID NUMBER (9)
comment
ENTITY_TYPE VARCHAR2 (4000)
comment
ENTITY_NAME VARCHAR2 (255)
comment
FK_NAME VARCHAR2 (255)
comment
FK_ID NUMBER (9)
comment
FK_LOGICAL_NAME VARCHAR2 (4000)
comment
FK_DESCRIPTION VARCHAR2 (4000)
comment
PK_ID NUMBER (9)
comment
PK_NAME VARCHAR2 (255)
comment
FK_COLUMN_ID NUMBER (9)
comment
FK_COLUMN_NAME VARCHAR2 (255)
comment
FK_POSITION NUMBER (9)
comment
Query Text

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


SELECT ENTITY_ID
,      ENTITY_TYPE
,      ENTITY_NAME
,      FK_NAME
,      FK_ID
,      FK_LOGICAL_NAME
,      FK_DESCRIPTION
,      PK_ID
,      PK_NAME
,      FK_COLUMN_ID
,      FK_COLUMN_NAME
,      FK_POSITION
FROM APPS.EDW_FOREIGN_KEY_COLUMNS_MD_V;

Dependencies

[top of page]

APPS.EDW_FOREIGN_KEY_COLUMNS_MD_V references the following:

SchemaAPPS
SynonymEDW_FOREIGN_KEY_COLUMNS_MD

APPS.EDW_FOREIGN_KEY_COLUMNS_MD_V is not referenced by any database object