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

VIEW: APPS.EDW_PVT_MAP_FUNC_MD_V

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

View Type

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


EDW_PVT_MAP_FUNC_MD_V


[View Source]

Columns
Name Datatype Length Mandatory Comments
FUNC_NAME VARCHAR2 (255)
comment
CATEGORY_NAME VARCHAR2 (255)
comment
COLUMN_NAME VARCHAR2 (255)
comment
COLUMN_ID NUMBER (9)
comment
COLUMN_USAGE_ID NUMBER (9)
comment
AGGREGATION VARCHAR2 (4000)
comment
IS_DISTINCT VARCHAR2 (10)
comment
RELATION_ID NUMBER (9)
comment
RELATION_NAME VARCHAR2 (255)
comment
RELATION_USAGE_ID NUMBER (9)
comment
RELATION_TYPE VARCHAR2 (4000)
comment
FUNC_USAGE_ID NUMBER (9)
comment
ATTRIBUTE_POSITION NUMBER (9)
comment
FUNC_DEFAULT_VALUE VARCHAR2 (4000)
comment
MAPPING_ID NUMBER (9)
comment
Query Text

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


SELECT FUNC_NAME
,      CATEGORY_NAME
,      COLUMN_NAME
,      COLUMN_ID
,      COLUMN_USAGE_ID
,      AGGREGATION
,      IS_DISTINCT
,      RELATION_ID
,      RELATION_NAME
,      RELATION_USAGE_ID
,      RELATION_TYPE
,      FUNC_USAGE_ID
,      ATTRIBUTE_POSITION
,      FUNC_DEFAULT_VALUE
,      MAPPING_ID
FROM APPS.EDW_PVT_MAP_FUNC_MD_V;

Dependencies

[top of page]

APPS.EDW_PVT_MAP_FUNC_MD_V references the following:

SchemaAPPS
SynonymEDW_PVT_MAP_FUNC_MD

APPS.EDW_PVT_MAP_FUNC_MD_V is not referenced by any database object