VIEW: APPS.PAY_FLOW_PARAMETERS_V

Source

View Text - Preformatted

SELECT flow_set_info.Flow_Name1 Flow_Name, flow_set_info.flow_name2 flow_name_tl, flow_set_info.process_flow_id1 process_flow_id, ppd_out.parameter_name Parameter_Name, ppdt_out.name Parameter_Name_TL, ppsv.parameter_id Parameter_Id, ppsv.set_variable_id Set_Variable_Id, ppsv.set_var_sequence Set_Variable_Sequence, ppsv.display_flag display_flag, ppsv.default_type from pay_para_set_variables ppsv, pay_parameter_definitions ppd_out, pay_parameters pp_out, pay_parameter_definitions_tl ppdt_out, ( select ppd_in.parameter_name Flow_Name1, ppdt_in.name flow_name2, ppf.process_flow_id process_flow_id1, ppf.set_id Set_Id from pay_parameter_definitions ppd_in, pay_parameter_definitions_tl ppdt_in, pay_parameters pp_in, pay_parameter_sets pps, pay_process_flows ppf where pps.set_id = ppf.set_id and pp_in.parameter_id = pps.set_name_id and ppd_in.parameter_def_id = pp_in.parameter_def_id and ppdt_in.parameter_def_id = pp_in.parameter_def_id and ppdt_in.language = userenv('LANG') ) flow_set_info where flow_set_info.Set_Id = ppsv.set_id and ppsv.parameter_id = pp_out.parameter_id and pp_out.parameter_def_id = ppdt_out.parameter_def_id and ppd_out.parameter_Def_id = ppdt_out.parameter_def_id order by flow_name, Set_Variable_Sequence

View Text - HTML Formatted

SELECT FLOW_SET_INFO.FLOW_NAME1 FLOW_NAME
, FLOW_SET_INFO.FLOW_NAME2 FLOW_NAME_TL
, FLOW_SET_INFO.PROCESS_FLOW_ID1 PROCESS_FLOW_ID
, PPD_OUT.PARAMETER_NAME PARAMETER_NAME
, PPDT_OUT.NAME PARAMETER_NAME_TL
, PPSV.PARAMETER_ID PARAMETER_ID
, PPSV.SET_VARIABLE_ID SET_VARIABLE_ID
, PPSV.SET_VAR_SEQUENCE SET_VARIABLE_SEQUENCE
, PPSV.DISPLAY_FLAG DISPLAY_FLAG
, PPSV.DEFAULT_TYPE
FROM PAY_PARA_SET_VARIABLES PPSV
, PAY_PARAMETER_DEFINITIONS PPD_OUT
, PAY_PARAMETERS PP_OUT
, PAY_PARAMETER_DEFINITIONS_TL PPDT_OUT
, ( SELECT PPD_IN.PARAMETER_NAME FLOW_NAME1
, PPDT_IN.NAME FLOW_NAME2
, PPF.PROCESS_FLOW_ID PROCESS_FLOW_ID1
, PPF.SET_ID SET_ID
FROM PAY_PARAMETER_DEFINITIONS PPD_IN
, PAY_PARAMETER_DEFINITIONS_TL PPDT_IN
, PAY_PARAMETERS PP_IN
, PAY_PARAMETER_SETS PPS
, PAY_PROCESS_FLOWS PPF
WHERE PPS.SET_ID = PPF.SET_ID
AND PP_IN.PARAMETER_ID = PPS.SET_NAME_ID
AND PPD_IN.PARAMETER_DEF_ID = PP_IN.PARAMETER_DEF_ID
AND PPDT_IN.PARAMETER_DEF_ID = PP_IN.PARAMETER_DEF_ID
AND PPDT_IN.LANGUAGE = USERENV('LANG') ) FLOW_SET_INFO
WHERE FLOW_SET_INFO.SET_ID = PPSV.SET_ID
AND PPSV.PARAMETER_ID = PP_OUT.PARAMETER_ID
AND PP_OUT.PARAMETER_DEF_ID = PPDT_OUT.PARAMETER_DEF_ID
AND PPD_OUT.PARAMETER_DEF_ID = PPDT_OUT.PARAMETER_DEF_ID ORDER BY FLOW_NAME
, SET_VARIABLE_SEQUENCE