SELECT FCPL.USER_CONCURRENT_PROGRAM_NAME USER_CONCURRENT_PROGRAM_NAME,
FDFCUV.COLUMN_SEQ_NUM COLUMN_SEQ_NUM,
FDFCUV.END_USER_COLUMN_NAME PARAMETER_NAME,
FDFCUV.FORM_LEFT_PROMPT PROMPT, FDFCUV.ENABLED_FLAG ENABLED_FLAG,
FDFCUV.REQUIRED_FLAG REQUIRED_FLAG,
FDFCUV.DISPLAY_FLAG DISPLAY_FLAG,
FFVS.FLEX_VALUE_SET_NAME FLEX_VALUE_SET_NAME
FROM fnd_concurrent_programs fcp,
fnd_concurrent_programs_tl fcpl,
fnd_descr_flex_col_usage_vl fdfcuv,
fnd_flex_value_sets ffvs,
fnd_lookup_values flv
WHERE 1 = 1
AND fcp.concurrent_program_id = fcpl.concurrent_program_id
AND fdfcuv.descriptive_flexfield_name =
'$SRS$.' || fcp.concurrent_program_name
AND ffvs.flex_value_set_id = fdfcuv.flex_value_set_id
AND flv.lookup_code(+) = fdfcuv.default_type
AND flv.lookup_type(+) = 'FLEX_DEFAULT_TYPE'
AND fcpl.LANGUAGE = USERENV ('LANG')
AND flv.LANGUAGE(+) =
USERENV
('LANG')
--AND fcpl.user_concurrent_program_name LIKE 'XXENEUR%'
AND ffvs.flex_value_set_name NOT LIKE 'XX%'
And fcp.CONCURRENT_PROGRAM_NAME in(
'APXAAREP',
'APXCRRCR'
))
FDFCUV.COLUMN_SEQ_NUM COLUMN_SEQ_NUM,
FDFCUV.END_USER_COLUMN_NAME PARAMETER_NAME,
FDFCUV.FORM_LEFT_PROMPT PROMPT, FDFCUV.ENABLED_FLAG ENABLED_FLAG,
FDFCUV.REQUIRED_FLAG REQUIRED_FLAG,
FDFCUV.DISPLAY_FLAG DISPLAY_FLAG,
FFVS.FLEX_VALUE_SET_NAME FLEX_VALUE_SET_NAME
FROM fnd_concurrent_programs fcp,
fnd_concurrent_programs_tl fcpl,
fnd_descr_flex_col_usage_vl fdfcuv,
fnd_flex_value_sets ffvs,
fnd_lookup_values flv
WHERE 1 = 1
AND fcp.concurrent_program_id = fcpl.concurrent_program_id
AND fdfcuv.descriptive_flexfield_name =
'$SRS$.' || fcp.concurrent_program_name
AND ffvs.flex_value_set_id = fdfcuv.flex_value_set_id
AND flv.lookup_code(+) = fdfcuv.default_type
AND flv.lookup_type(+) = 'FLEX_DEFAULT_TYPE'
AND fcpl.LANGUAGE = USERENV ('LANG')
AND flv.LANGUAGE(+) =
USERENV
('LANG')
--AND fcpl.user_concurrent_program_name LIKE 'XXENEUR%'
AND ffvs.flex_value_set_name NOT LIKE 'XX%'
And fcp.CONCURRENT_PROGRAM_NAME in(
'APXAAREP',
'APXCRRCR'
))
No comments:
Post a Comment