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 1132: from fnd_attached_docs_form_vl

1128: cursor update_att_cursor (x_attached_document_id varchar2,
1129: x_function_name varchar2) is
1130: select row_id, document_id, media_id, start_date_active,
1131: end_date_active, datatype_id
1132: from fnd_attached_docs_form_vl
1133: where attached_document_id = to_number(x_attached_document_id)
1134: and function_name= x_function_name
1135: and function_type = 'F';
1136:

Line 1401: from FND_ATTACHED_DOCS_FORM_VL

1397: USAGE_TYPE,
1398: USER_ENTITY_NAME,
1399: MEDIA_ID,
1400: ATTACHED_DOCUMENT_ID
1401: from FND_ATTACHED_DOCS_FORM_VL
1402: where FUNCTION_NAME =printsummary.function_name
1403: and FUNCTION_TYPE ='F'
1404: and (SECURITY_TYPE = 4 OR PUBLISH_FLAG = 'Y')
1405: and (ENTITY_NAME= printsummary.entity_name and

Line 1840: from fnd_attached_docs_form_vl fdfv, fnd_documents_long_text fdlt

1836: if (l_datatype_id = 2) then
1837: select fdfv.seq_num, fdfv.category_description,
1838: fdfv.document_description, fdlt.long_text
1839: into l_seq_num,l_category_description,l_document_description,l_text
1840: from fnd_attached_docs_form_vl fdfv, fnd_documents_long_text fdlt
1841: where fdfv.media_id = fdlt.media_id
1842: and fdfv.attached_document_id = to_number(l_attached_document_id)
1843: and fdfv.function_name = l_function_name
1844: and fdfv.function_type = 'F';

Line 1849: from fnd_attached_docs_form_vl fdfv, fnd_documents_short_text fdst

1845: else
1846: select fdfv.seq_num, fdfv.category_description,
1847: fdfv.document_description, fdst.short_text
1848: into l_seq_num,l_category_description,l_document_description,l_text
1849: from fnd_attached_docs_form_vl fdfv, fnd_documents_short_text fdst
1850: where fdfv.media_id = fdst.media_id
1851: and fdfv.attached_document_id = to_number(l_attached_document_id)
1852: and fdfv.function_name = l_function_name
1853: and fdfv.function_type = 'F';

Line 1927: from fnd_attached_docs_form_vl

1923: document_description,
1924: datatype_id,
1925: media_id,
1926: file_name
1927: from fnd_attached_docs_form_vl
1928: where attached_document_id = PrintUpdateAttachment.attached_document_id;
1929:
1930: cursor doc_cat_cursor is
1931: select user_name,category_id,default_datatype_name,default_datatype_id