Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSB_FLEX_MAPPING_SET_VALUES_V |
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