Thursday 17 July 2014

Concurrent Program Definition Query

/* Formatted on 7/17/2014 1:08:51 PM (QP5 v5.115.810.9015) */
SELECT fcp.concurrent_program_name,
       fcpt.user_concurrent_program_name,
       fe.executable_name,
       fet.user_executable_name,
       flv.meaning,
       fe.execution_file_name,
       fdfcu.column_seq_num,
       fdfcu.application_column_name,
       fdfcu.end_user_column_name,
       fdfcut.description,
       ffvs.flex_value_set_name,
       fdfcut.form_left_prompt,
       fdfcu.enabled_flag,
       fdfcu.required_flag,
       fdfcu.DEFAULT_VALUE
FROM fnd_concurrent_programs fcp,
     fnd_concurrent_programs_tl fcpt,
     fnd_executables fe,
     fnd_executables_tl fet,
     fnd_lookup_values flv,
     fnd_descr_flex_column_usages fdfcu,
     fnd_descr_flex_col_usage_tl fdfcut,
     fnd_flex_value_sets ffvs
WHERE     fcp.application_id = fcpt.application_id
      AND fcp.concurrent_program_id = fcpt.concurrent_program_id
      AND fcpt.language = USERENV ('LANG')
      AND fcp.executable_application_id = fe.application_id
      AND fcp.executable_id = fe.executable_id
      AND fe.application_id = fet.application_id
      AND fe.executable_id = fet.executable_id
      AND fet.language = USERENV ('LANG')
      AND fe.execution_method_code = flv.lookup_code
      AND flv.lookup_type = 'CP_EXECUTION_METHOD_CODE'
      AND fdfcu.descriptive_flexfield_name =
            '$SRS$.' || fcp.concurrent_program_name
      AND fdfcu.application_id = fdfcut.application_id
      AND fdfcu.descriptive_flexfield_name = fdfcut.descriptive_flexfield_name
      AND fdfcu.descriptive_flex_context_code =
            fdfcut.descriptive_flex_context_code
      AND fdfcu.application_column_name = fdfcut.application_column_name
      AND fdfcut.language = USERENV ('LANG')
      AND fdfcu.flex_value_set_id = ffvs.flex_value_set_id
       AND fcp.concurrent_program_name = 'OEXAUGEN'
ORDER BY fcp.concurrent_program_name, fdfcu.column_seq_num

No comments:

Post a Comment