VIEW: APPS.PSB_FLEX_MAPPING_SET_VALUES_V

Source

View Text - Preformatted

SELECT val.rowid, flex_mapping_set_id, flex_mapping_value_id, val.budget_year_type_id, application_column_name, val.flex_value_set_id, vset.flex_value, val.from_flex_value_id, val.flex_value_id, fset.flex_value, type.name, type.sequence_number, val.last_updated_by ,val.last_update_login , val.last_update_date , val.created_by , val.creation_date from psb_budget_year_types_vl type, psb_flex_mapping_set_values val, fnd_flex_values_vl vset , fnd_flex_values_vl fset where application_column_name = PSB_Flex_Mapping_PVT.Get_Application_Column_Name and flex_mapping_set_id = PSB_Flex_Mapping_PVT.Get_Flex_Set_ID and type.budget_year_type_id = val.budget_year_type_id and val.flex_value_id = vset.flex_value_id(+) and val.from_flex_value_id = fset.flex_value_id

View Text - HTML Formatted

SELECT VAL.ROWID
, FLEX_MAPPING_SET_ID
, FLEX_MAPPING_VALUE_ID
, VAL.BUDGET_YEAR_TYPE_ID
, APPLICATION_COLUMN_NAME
, VAL.FLEX_VALUE_SET_ID
, VSET.FLEX_VALUE
, VAL.FROM_FLEX_VALUE_ID
, VAL.FLEX_VALUE_ID
, FSET.FLEX_VALUE
, TYPE.NAME
, TYPE.SEQUENCE_NUMBER
, VAL.LAST_UPDATED_BY
, VAL.LAST_UPDATE_LOGIN
, VAL.LAST_UPDATE_DATE
, VAL.CREATED_BY
, VAL.CREATION_DATE
FROM PSB_BUDGET_YEAR_TYPES_VL TYPE
, PSB_FLEX_MAPPING_SET_VALUES VAL
, FND_FLEX_VALUES_VL VSET
, FND_FLEX_VALUES_VL FSET
WHERE APPLICATION_COLUMN_NAME = PSB_FLEX_MAPPING_PVT.GET_APPLICATION_COLUMN_NAME
AND FLEX_MAPPING_SET_ID = PSB_FLEX_MAPPING_PVT.GET_FLEX_SET_ID
AND TYPE.BUDGET_YEAR_TYPE_ID = VAL.BUDGET_YEAR_TYPE_ID
AND VAL.FLEX_VALUE_ID = VSET.FLEX_VALUE_ID(+)
AND VAL.FROM_FLEX_VALUE_ID = FSET.FLEX_VALUE_ID