ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9879D2E0530100007F1FF2 FND Application Name Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name US 8E2FF36EDE9D79D2E0530100007F1FF2 FND Concurrent Program Name Y select fcpt.user_concurrent_program_name value, fav.application_name||nvl2(fcpt.description,': ',null)||fcpt.description description from fnd_application_vl fav, fnd_concurrent_programs_tl fcpt where fcpt.language=userenv('lang') and fcpt.application_id=fav.application_id order by fcpt.user_concurrent_program_name AR اسم البرنامج المتزامن FND D FND gleichzeitiger Programmname E Nombre del programa concurrente FND F Nom du programme concurrent du FND I Nome del programma concorrente FND JA FND 同時進行プログラム名 KO FND 동시 작업 프로그램 이름 PTB FND nome do programa concorrente RU одновременное имя программы FND S FND-samtidiga programnamn TR FND eşzamanlı program adı US FND concurrent program name ZHS FND并发程序名称 8E2FF36EDE8F79D2E0530100007F1FF2 FND Request Group Y select frg.request_group_name value, frg.description from fnd_request_groups frg where (:$flex$.fnd_application_name is null or frg.application_id in (select fav.application_id from fnd_application_vl fav where fav.application_name=:$flex$.fnd_application_name)) order by frg.request_group_name US FCE81EEF3A37290CE0530100007F6A26 select frg.request_group_name request_group, fav.application_name application, frg.request_group_code, frg.description, decode(frgu.request_unit_type,'P','Program','A','Application','S','Set',frgu.request_unit_type) assignment_type, decode(frgu.request_unit_type, 'P',fcpv.user_concurrent_program_name, 'A',fav2.application_name, 'S',frsv.user_request_set_name ) assignment_name, fav2.application_name assignment_application, xxen_util.user_name(frg.created_by) group_created_by, xxen_util.client_time(frg.creation_date) group_creation_date, xxen_util.user_name(frg.last_updated_by) group_last_updated_by, xxen_util.client_time(frg.last_update_date) group_last_update_date, xxen_util.user_name(frgu.created_by) assignment_created_by, xxen_util.client_time(frgu.creation_date) assignment_creation_date, xxen_util.user_name(frgu.last_updated_by) assignment_last_updated_by, xxen_util.client_time(frgu.last_update_date) assignment_last_update_date, frg.application_id, frg.request_group_id from fnd_request_groups frg, fnd_application_vl fav, fnd_request_group_units frgu, fnd_concurrent_programs_vl fcpv, fnd_application_vl fav2, fnd_request_sets_vl frsv where 1=1 and frg.application_id=fav.application_id and frg.application_id=frgu.application_id and frg.request_group_id=frgu.request_group_id and frgu.unit_application_id=fav2.application_id and decode(frgu.request_unit_type,'P',frgu.unit_application_id)=fcpv.application_id(+) and decode(frgu.request_unit_type,'P',frgu.request_unit_id)=fcpv.concurrent_program_id(+) and decode(frgu.request_unit_type,'S',frgu.unit_application_id)=frsv.application_id(+) and decode(frgu.request_unit_type,'S',frgu.request_unit_id)=frsv.request_set_id(+) order by frg.request_group_name, fav.application_name, frgu.request_unit_type, assignment_name Y US FND Request Groups FND request groups and their assigned units, such as concurrent programs, request sets or applications Enginatics 1=1 1 10 1=1 frg.request_group_name=:request_group LOV FND Request Group 8E2FF36EDE8F79D2E0530100007F1FF2 Y select frg.request_group_name value, frg.description from fnd_request_groups frg where (:$flex$.fnd_application_name is null or frg.application_id in (select fav.application_id from fnd_application_vl fav where fav.application_name=:$flex$.fnd_application_name)) order by frg.request_group_name US Request Group 2 20 1=1 fav.application_name=:application_name LOV FND Application Name 8E2FF36EDE9879D2E0530100007F1FF2 Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name US Group Application 3 30 1=1 frgu.request_unit_type='P' and fcpv.user_concurrent_program_name=:user_concurrent_program_name LOV FND Concurrent Program Name 8E2FF36EDE9D79D2E0530100007F1FF2 Y select fcpt.user_concurrent_program_name value, fav.application_name||nvl2(fcpt.description,': ',null)||fcpt.description description from fnd_application_vl fav, fnd_concurrent_programs_tl fcpt where fcpt.language=userenv('lang') and fcpt.application_id=fav.application_id order by fcpt.user_concurrent_program_name US Concurrent Program Name :$flex$.fnd_application_name Group Application Request Group