Product: | BIS - Applications BIS |
---|---|
Description: | EDW_PVT_MAP_FUNC_MD_V |
Implementation/DBA Data: | APPS.EDW_PVT_MAP_FUNC_MD_V |
SELECT FUNC.NAME FUNC_NAME
, FUNC_CATEGORY.NAME CATEGORY_NAME
, ITEM.NAME COLUMN_NAME
, ITEM.ELEMENTID COLUMN_ID
, ITEM_USAGE.ELEMENTID COLUMN_USAGE_ID
, ITEM_USAGE.AGGREGATEFUNCTION AGGREGATION
, ITEM_USAGE.ISDISTINCT IS_DISTINCT
, RELATION.ELEMENTID RELATION_ID
, RELATION.NAME RELATION_NAME
, RELATION_USAGE.ELEMENTID RELATION_USAGE_ID
, RELATION.CLASSNAME RELATION_TYPE
, FUNC_USAGE.ELEMENTID FUNC_USAGE_ID
, ATTRIBUTE.POSITION ATTRIBUTE_POSITION
, FUNC_ARG.DEFAULTVALUE FUNC_DEFAULT_VALUE
, MAP.ELEMENTID MAPPING_ID
FROM CMPRELATIONMAPPING_V MAP
, CMPWBFUNCTIONUSAGE_V FUNC_USAGE
, CMPFUNCTION_V FUNC
, CMPFUNCTIONCATEGORY_V FUNC_CATEGORY
, CMPWBACTUALPARAMETER_V ACTUAL_PARAM
, CMPWBITEMUSAGE_V ITEM_USAGE
, CMPITEM_V ITEM
, CMPWBRELATIONUSAGE_V RELATION_USAGE
, CMPRELATION_V RELATION
, CMPFUNCTIONARGUMENT_V FUNC_ARG
, CMPATTRIBUTE_V ATTRIBUTE
WHERE FUNC_USAGE.CMPRELATION=MAP.ELEMENTID
AND FUNC.ELEMENTID=FUNC_USAGE.CMPFUNCTION
AND FUNC_CATEGORY.ELEMENTID=FUNC.FUNCTIONCATEGORY
AND ACTUAL_PARAM.CMPWBFUNCTIONUSAGE=FUNC_USAGE.ELEMENTID
AND ACTUAL_PARAM.CMPWBITEMUSAGE=ITEM_USAGE.ELEMENTID
AND ITEM_USAGE.CMPITEM=ITEM.ELEMENTID
AND RELATION_USAGE.ELEMENTID=ITEM_USAGE.CMPWBRELATIONUSAGE
AND RELATION.ELEMENTID=RELATION_USAGE.CMPRELATION
AND FUNC_ARG.ELEMENTID(+)=ITEM.ELEMENTID
AND ATTRIBUTE.ELEMENTID=ACTUAL_PARAM.FUNCTIONARGUMENT