APPS.FND_WEBATTCH dependencies on FND_ATTACHED_DOCS_FORM_VL

Line 465: from fnd_attached_docs_form_vl

461: )
462: as
463: cursor delatt_cursor (x_attached_document_id varchar2) is
464: select datatype_id,file_name,media_id
465: from fnd_attached_docs_form_vl
466: where attached_document_id = to_number(x_attached_document_id);
467:
468: deldatarec delatt_cursor%ROWTYPE;
469:

Line 1064: from fnd_attached_docs_form_vl

1060: cursor update_att_cursor (x_attached_document_id varchar2,
1061: x_function_name varchar2) is
1062: select row_id, document_id, media_id, start_date_active,
1063: end_date_active, datatype_id
1064: from fnd_attached_docs_form_vl
1065: where attached_document_id = to_number(x_attached_document_id)
1066: and function_name= x_function_name
1067: and function_type = 'F';
1068:

Line 1326: from FND_ATTACHED_DOCS_FORM_VL

1322: USAGE_TYPE,
1323: USER_ENTITY_NAME,
1324: MEDIA_ID,
1325: ATTACHED_DOCUMENT_ID
1326: from FND_ATTACHED_DOCS_FORM_VL
1327: where FUNCTION_NAME =printsummary.function_name
1328: and FUNCTION_TYPE ='F'
1329: and (SECURITY_TYPE = 4 OR PUBLISH_FLAG = 'Y')
1330: and (ENTITY_NAME= printsummary.entity_name and

Line 1765: from fnd_attached_docs_form_vl fdfv, fnd_documents_long_text fdlt

1761: if (l_datatype_id = 2) then
1762: select fdfv.seq_num, fdfv.category_description,
1763: fdfv.document_description, fdlt.long_text
1764: into l_seq_num,l_category_description,l_document_description,l_text
1765: from fnd_attached_docs_form_vl fdfv, fnd_documents_long_text fdlt
1766: where fdfv.media_id = fdlt.media_id
1767: and fdfv.attached_document_id = to_number(l_attached_document_id)
1768: and fdfv.function_name = l_function_name
1769: and fdfv.function_type = 'F';

Line 1774: from fnd_attached_docs_form_vl fdfv, fnd_documents_short_text fdst

1770: else
1771: select fdfv.seq_num, fdfv.category_description,
1772: fdfv.document_description, fdst.short_text
1773: into l_seq_num,l_category_description,l_document_description,l_text
1774: from fnd_attached_docs_form_vl fdfv, fnd_documents_short_text fdst
1775: where fdfv.media_id = fdst.media_id
1776: and fdfv.attached_document_id = to_number(l_attached_document_id)
1777: and fdfv.function_name = l_function_name
1778: and fdfv.function_type = 'F';

Line 1852: from fnd_attached_docs_form_vl

1848: document_description,
1849: datatype_id,
1850: media_id,
1851: file_name
1852: from fnd_attached_docs_form_vl
1853: where attached_document_id = PrintUpdateAttachment.attached_document_id;
1854:
1855: cursor doc_cat_cursor is
1856: select user_name,category_id,default_datatype_name,default_datatype_id