VIEW: APPS.BEN_ICD_SS_CONFIG_V

Source

View Text - Preformatted

SELECT INPV.input_value_id, INPV.element_type_id, inpvtl.name input_value, fcol.column_seq_num, fcoltl.form_left_prompt selfservice_display_prompt, decode(fcol.display_flag,'Y','N','Y') hidden_in_selfservice, config.USER_ENTERABLE_FLAG, config.SHOW_ON_OVERVIEW_FLAG, fcol.descriptive_flex_context_code, inpv.effective_start_date, inpv.effective_end_date, fcoltl.language from BEN_ICD_SS_CONFIG config, fnd_descr_flex_column_usages fcol, fnd_descr_flex_col_usage_tl fcoltl, pay_input_values_f inpv, pay_input_values_f_tl inpvtl WHERE fcol.application_id = 805 and fcol.DESCRIPTIVE_FLEXFIELD_NAME = 'Ben ICD Developer DF' and fcol.END_USER_COLUMN_NAME ='ICD_'|| config.input_value_id_char and fcoltl.DESCRIPTIVE_FLEXFIELD_NAME = fcol.DESCRIPTIVE_FLEXFIELD_NAME and fcoltl.DESCRIPTIVE_FLEX_CONTEXT_CODE = fcol.DESCRIPTIVE_FLEX_CONTEXT_CODE and fcoltl.application_column_name = fcol.application_column_name and fcoltl.application_id = fcol.application_id and fcoltl.language = userenv('LANG') and inpv.input_value_id = config.input_value_id and inpvtl.input_value_id = inpv.input_value_id and inpvtl.language = userenv('LANG')

View Text - HTML Formatted

SELECT INPV.INPUT_VALUE_ID
, INPV.ELEMENT_TYPE_ID
, INPVTL.NAME INPUT_VALUE
, FCOL.COLUMN_SEQ_NUM
, FCOLTL.FORM_LEFT_PROMPT SELFSERVICE_DISPLAY_PROMPT
, DECODE(FCOL.DISPLAY_FLAG
, 'Y'
, 'N'
, 'Y') HIDDEN_IN_SELFSERVICE
, CONFIG.USER_ENTERABLE_FLAG
, CONFIG.SHOW_ON_OVERVIEW_FLAG
, FCOL.DESCRIPTIVE_FLEX_CONTEXT_CODE
, INPV.EFFECTIVE_START_DATE
, INPV.EFFECTIVE_END_DATE
, FCOLTL.LANGUAGE
FROM BEN_ICD_SS_CONFIG CONFIG
, FND_DESCR_FLEX_COLUMN_USAGES FCOL
, FND_DESCR_FLEX_COL_USAGE_TL FCOLTL
, PAY_INPUT_VALUES_F INPV
, PAY_INPUT_VALUES_F_TL INPVTL
WHERE FCOL.APPLICATION_ID = 805
AND FCOL.DESCRIPTIVE_FLEXFIELD_NAME = 'BEN ICD DEVELOPER DF'
AND FCOL.END_USER_COLUMN_NAME ='ICD_'|| CONFIG.INPUT_VALUE_ID_CHAR
AND FCOLTL.DESCRIPTIVE_FLEXFIELD_NAME = FCOL.DESCRIPTIVE_FLEXFIELD_NAME
AND FCOLTL.DESCRIPTIVE_FLEX_CONTEXT_CODE = FCOL.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FCOLTL.APPLICATION_COLUMN_NAME = FCOL.APPLICATION_COLUMN_NAME
AND FCOLTL.APPLICATION_ID = FCOL.APPLICATION_ID
AND FCOLTL.LANGUAGE = USERENV('LANG')
AND INPV.INPUT_VALUE_ID = CONFIG.INPUT_VALUE_ID
AND INPVTL.INPUT_VALUE_ID = INPV.INPUT_VALUE_ID
AND INPVTL.LANGUAGE = USERENV('LANG')