Product: | EGO - Advanced Product Catalog |
---|---|
Description: | View contains the mapping data for attribute to parameter mapping of a function |
Implementation/DBA Data: | APPS.EGO_MAPPINGS_V |
SELECT M.FUNCTION_ID FUNCTION_ID
, M.MAPPED_OBJ_TYPE MAPPED_OBJ_TYPE
, M.MAPPED_OBJ_PK1_VAL MAPPED_OBJ_PK1_VAL
, M.FUNC_PARAM_ID FUNC_PARAM_ID
, M.MAPPED_TO_GROUP_TYPE MAPPED_TO_GROUP_TYPE
, M.MAPPED_TO_GROUP_PK1 MAPPED_TO_GROUP_PK1
, M.MAPPED_TO_GROUP_PK2 MAPPED_TO_GROUP_PK2
, M.MAPPED_TO_GROUP_PK3 MAPPED_TO_GROUP_PK3
, M.MAPPED_ATTRIBUTE MAPPED_ATTRIBUTE
, L1.MEANING MAPPED_TO_GROUP_MEANING
, M.MAPPED_UOM_PARAMETER MAPPED_UOM_PARAMETER
, M.VALUE_UOM_SOURCE VALUE_UOM_SOURCE
, L2.MEANING VALUE_UOM_SOURCE_MEANING
, M.FIXED_UOM FIXED_UOM
FROM EGO_MAPPINGS_B M
, FND_LOOKUP_VALUES L1
, FND_LOOKUP_VALUES L2
WHERE L1.VIEW_APPLICATION_ID = 0
AND L1.LANGUAGE = USERENV('LANG')
AND L1.LOOKUP_CODE = M.MAPPED_TO_GROUP_TYPE
AND L1.LOOKUP_TYPE = 'EGO_EF_MAPPED_TO_GROUP_TYPE'
AND L2.LANGUAGE(+) = USERENV('LANG')
AND L2.LOOKUP_CODE(+) = M.VALUE_UOM_SOURCE
AND L2.LOOKUP_TYPE(+) = 'EGO_PARAM_MAP_UOM_SOURCE'