ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 70A34819C5514FDFE0530100007FD76EY select decode(faf.function_type,'F','Function','O','Form','R','Report') type, faf.function_name name, decode(faf.function_type,'F',fffv.user_function_name,'O',ffv.user_form_name,'R',fcpv.user_concurrent_program_name) user_name, faf.session_context_field, xxen_util.meaning(faf.enabled_flag,'YES_NO',0) enabled, &category_columns &block_columns &entity_columns xxen_util.user_name(faf.created_by) function_created_by, xxen_util.client_time(faf.creation_date) function_creation_date, xxen_util.user_name(faf.last_updated_by) function_last_updated_by, xxen_util.client_time(faf.last_update_date) function_last_update_date from fnd_attachment_functions faf, fnd_form_functions_vl fffv, fnd_form_vl ffv, fnd_concurrent_programs_vl fcpv, (select fdcu.* from fnd_doc_category_usages fdcu where '&show_fdcu'='Y') fdcu, fnd_document_categories_vl fdcv, (select fab.* from fnd_attachment_blocks fab where '&show_fab'='Y') fab, (select fabev.* from fnd_attachment_blk_entities_vl fabev where '&show_fabev'='Y') fabev where 1=1 and decode(faf.function_type,'F',faf.function_name)=fffv.function_name(+) and decode(faf.function_type,'O',faf.function_name)=ffv.form_name(+) and decode(faf.function_type,'O',faf.application_id)=ffv.application_id(+) and decode(faf.function_type,'R',faf.function_name)=fcpv.concurrent_program_name (+) and decode(faf.function_type,'R',faf.application_id)=fcpv.application_id(+) and faf.attachment_function_id=fdcu.attachment_function_id(+) and fdcu.category_id=fdcv.category_id(+) and faf.attachment_function_id=fab.attachment_function_id(+) and fab.attachment_blk_id=fabev.attachment_blk_id(+) order by faf.function_name, fdcv.user_name Renamed &enable_ lexicals to &show_ AR FND Attachment Functions وظائف إرفاق FND ، وتخصيصات الفئات ، وكتل النماذج وكيانات الكتلة D FND Attachment Functions FND-Anhangsfunktionen, ihre Kategoriezuweisungen, Formularblöcke und Blockentitäten E FND Attachment Functions Funciones de fijación de FND, sus asignaciones de categoría, bloques de formularios y entidades de bloque F FND Attachment Functions Fonctions de rattachement des FND, leurs affectations de catégories, les blocs de formulaires et les entités de bloc I FND Attachment Functions Funzioni di attacco FND, le loro assegnazioni di categoria, blocchi di forme ed entità di blocco JA FND Attachment Functions FNDアタッチメント機能、そのカテゴリ割り当て、フォームブロック、ブロックエンティティ KO FND Attachment Functions FND 첨부 기능, 카테고리 지정, 양식 블록 및 블록 엔티티 PTB FND Attachment Functions Funções de anexo FND, suas atribuições de categoria, blocos de formulários e entidades de blocos RU FND Attachment Functions Функции прикрепления ФНД, их распределение по категориям, формирование блоков и блочных сущностей S FND Attachment Functions FND-bifogningsfunktioner, deras kategoritilldelningar, formulärblock och blockeringsenheter TR FND Attachment Functions FND ek işlevleri, kategori atamaları, form blokları ve blok varlıkları US FND Attachment Functions FND attachment functions, their category assignments, forms blocks and block entities ZHS FND Attachment Functions FND附件功能、其类别分配、表格块和块实体。 Enginatics &block_columns &category_columns &entity_columns &show_fab &show_fabev &show_fdcu 1=1 1 10 1=1 faf.function_name=:name LOV custom Y select fafv.function_name value, decode(fafv.function_type,'F','Function','O','Form','R','Report')||': '||fafv.user_function_name description from fnd_attachment_functions_vl fafv order by fafv.function_name F Nom US Name 2 20 1=1 ( faf.function_type='O' and faf.function_name=:form_name or faf.function_type='F' and faf.function_name in ( select fff.function_name from fnd_form ff, fnd_form_functions fff where ff.form_name=:form_name and ff.application_id=fff.application_id and ff.form_id=fff.form_id and fff.type='FORM' ) ) LOV FND Form Name 8E2FF36EDEA779D2E0530100007F1FF2 Y select ffv.form_name value, fav.application_name||': '||ffv.user_form_name||nvl2(ffv.description,': '||ffv.description,null) description from fnd_application_vl fav, fnd_form_vl ffv where fav.application_id=ffv.application_id order by ffv.form_name F Nom du formulaire US Form Name 3 100 &show_fdcu Y LOV custom Y select 'Function' value, 'Attachment functions only' description from dual union all select 'Category' value, 'Attachment functions and categories' description from dual union all select 'Block' value, 'Attachment functions and blocks' description from dual union all select 'Block Entities' value, 'Attachment functions, blocks and block entities' description from dual Category Category Y F Niveau US Level 4 &block_columns fab.block_name, decode(fab.query_flag,'N','Allow Change','Y','Query Only') method, decode(fab.security_type,1,'Organization',2,'Set of Books',3,'Business Unit',4,'None') security_type, fab.org_context_field organization, fab.set_of_books_context_field set_of_books, fab.business_unit_context_field business_unit, fab.context1_field context1, fab.context2_field context2, fab.context3_field context3, Block% F Niveau US Level 5 &category_columns fdcv.user_name category, xxen_util.meaning(fdcu.enabled_flag,'YES_NO',0) category_usage_enabled, Category F Niveau US Level 6 &entity_columns fabev.user_entity_name entity, decode(fabev.display_method,'M','Main Entity','R','Related Entity') display_method, xxen_util.meaning(fabev.include_in_indicator_flag,'YES_NO',0) include_in_indicator, xxen_util.meaning(fabev.indicator_in_view_flag,'YES_NO',0) indicator_in_view, decode(fabev.query_permission_type,'Y','Always','N','Never','T','When condition True','F','When condition False') query_permission, decode(fabev.insert_permission_type,'Y','Always','N','Never','T','When condition True','F','When condition False') insert_permission, decode(fabev.update_permission_type,'Y','Always','N','Never','T','When condition True','F','When condition False') update_permission, decode(fabev.delete_permission_type,'Y','Always','N','Never','T','When condition True','F','When condition False') delete_permission, fabev.condition_field, decode(fabev.condition_operator,1,'=',2,'<>',3,'>=',4,'<=',5,'>',6,'<',7,'NOT NULL',8,'NULL',9,'BETWEEN',10,'OUTSIDE') condition_operator, fabev.condition_value1, fabev.condition_value2, fabev.pk1_field key1, fabev.pk2_field key2, fabev.pk3_field key3, fabev.pk4_field key4, fabev.pk5_field key5, fabev.sql_statement, Block Entities F Niveau US Level 7 &show_fab Y Block% F Niveau US Level 8 &show_fabev Y Block Entities F Niveau US Level