Reports2017-11-18T12:27:27+00:00

FND Attachment Functions

Description
Categories: Application, Enginatics
FND attachment functions, their category assignments, forms blocks and block entities

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,
faf.creation_date function_creation_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 '&enable_fdcu'='Y') fdcu,
fnd_document_categories_vl fdcv,
(select fab.* from fnd_attachment_blocks fab where '&enable_fab'='Y') fab,
(select fabev.* from fnd_attachment_blk_entities_vl fabev where '&enable_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

Parameter Name SQL text Validation
Form Name
(
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
Level
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,
Level
Y
Level
Y
Level
fdcv.user_name category,
xxen_util.meaning(fdcu.enabled_flag,'YES_NO',0) category_usage_enabled,
Level
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,
Level
Y
LOV
Name
faf.function_name=:name
LOV