VIEW: APPS.EGO_MAPPINGS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'