VIEW: APPS.IGI_DOS_DEFAULT_VALUES

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)