FND Attachment Functions

Description

Categories: Enginatics
Repository: Github

FND attachment functions, their category assignments, forms blocks and block entities

FND Attachment Functions and other Oracle EBS reports with Blitz Report™ on our demo environment

Copy

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

Parameter Name

SQL text

Validation

Name

faf.function_name=:name

LOV

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'
)
)