View: IGI_DOS_DEFAULT_VALUES

Product:	IGI - Public Sector Financials International
Description:	Based on FND_ID_FLEX_SEGMENTS, FND_FLEX_VALUES, FND_FLEX_VALUE_SETS, IGI_DOSSIER_NUMBERING, IGI_DOS_SOURCE_USAGES_V
Implementation/DBA Data:	APPS.IGI_DOS_DEFAULT_VALUES

View Text

SELECT 'S'
, FFS.ID_FLEX_NUM
, FFS.SEGMENT_NAME
, FFV.FLEX_VALUE
FROM FND_FLEX_VALUES FFV
, FND_ID_FLEX_SEGMENTS FFS
, FND_FLEX_VALUE_SETS FFSV
, IGI_DOSSIER_NUMBERING NOS
, IGI_DOS_SOURCE_USAGES_V SOURCE
WHERE FFS.FLEX_VALUE_SET_ID = FFV.FLEX_VALUE_SET_ID UNION SELECT 'V'
, FFSV.FLEX_VALUE_SET_ID
, FFSV.FLEX_VALUE_SET_NAME
, FFSV.FLEX_VALUE_SET_NAME
FROM FND_FLEX_VALUE_SETS FFSV -- UNION -- SELECT 'P'
, -- PROFILE_OPTION_ID
, PROFILE_OPTION_NAME
, USER_PROFILE_OPTION_NAME --
FROM FND_PROFILE_OPTIONS_VL UNION SELECT 'N'
, NOS.COA_ID
, NOS.NUMBERING_SCHEME
, NOS.NUMBERING_SCHEME
FROM IGI_DOSSIER_NUMBERING NOS
WHERE NOS.NUMBERING_TYPE = 'SEG'
AND NOS.ENABLED_FLAG ='YES'
AND NOT EXISTS (SELECT 'X' FROM IGI_DOS_SOURCE_USAGES_V SOURCE WHERE SOURCE.DEFAULT_TYPE ='N' AND SOURCE.DEFAULT_VALUE =NOS.NUMBERING_SCHEME)

Columns