eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_FND_ATTACHMENTS_PVT dependencies on FND_DOCUMENTS

Line 316: ' , fnd_documents d'||l_newline||

312:
313: l_rule_sql := 'select distinct r.document_id'||l_newline||
314: 'from oe_attachment_rules r'||l_newline||
315: ' , oe_attachment_rule_elements e1'||l_newline||
316: ' , fnd_documents d'||l_newline||
317: 'where r.database_object_name = :p_database_object_name'||l_newline||
318: ' and e1.rule_id = r.rule_id'||l_newline||
319: ' and r.document_id = d.document_id'||l_newline||
320: ' AND sysdate between NVL(d.start_date_active, sysdate)'||l_newline||

Line 720: FROM FND_DOCUMENTS

716:
717: CURSOR C_DOC
718: IS
719: SELECT 'Y'
720: FROM FND_DOCUMENTS
721: WHERE document_id = p_document_id;
722:
723: l_user_id number:=fnd_global.USER_ID;
724: l_login_id number:=fnd_global.LOGIN_ID;

Line 732: l_usage_type fnd_documents.usage_type%TYPE := null;

728: l_media_id NUMBER;
729: l_document_id NUMBER := p_document_id;
730: l_rowid VARCHAR2(60);
731: --included to fix bug 1903257 Begin
732: l_usage_type fnd_documents.usage_type%TYPE := null;
733: l_datatype_id fnd_documents.datatype_id%TYPE := null;
734: l_category_id fnd_documents.category_id%TYPE := null;
735: l_security_type fnd_documents.security_type%TYPE := null;
736: l_publish_flag fnd_documents.publish_flag%TYPE := null;

Line 733: l_datatype_id fnd_documents.datatype_id%TYPE := null;

729: l_document_id NUMBER := p_document_id;
730: l_rowid VARCHAR2(60);
731: --included to fix bug 1903257 Begin
732: l_usage_type fnd_documents.usage_type%TYPE := null;
733: l_datatype_id fnd_documents.datatype_id%TYPE := null;
734: l_category_id fnd_documents.category_id%TYPE := null;
735: l_security_type fnd_documents.security_type%TYPE := null;
736: l_publish_flag fnd_documents.publish_flag%TYPE := null;
737: l_description fnd_documents_vl.description%TYPE := null;

Line 734: l_category_id fnd_documents.category_id%TYPE := null;

730: l_rowid VARCHAR2(60);
731: --included to fix bug 1903257 Begin
732: l_usage_type fnd_documents.usage_type%TYPE := null;
733: l_datatype_id fnd_documents.datatype_id%TYPE := null;
734: l_category_id fnd_documents.category_id%TYPE := null;
735: l_security_type fnd_documents.security_type%TYPE := null;
736: l_publish_flag fnd_documents.publish_flag%TYPE := null;
737: l_description fnd_documents_vl.description%TYPE := null;
738: l_file_name fnd_documents_vl.file_name%TYPE := null;

Line 735: l_security_type fnd_documents.security_type%TYPE := null;

731: --included to fix bug 1903257 Begin
732: l_usage_type fnd_documents.usage_type%TYPE := null;
733: l_datatype_id fnd_documents.datatype_id%TYPE := null;
734: l_category_id fnd_documents.category_id%TYPE := null;
735: l_security_type fnd_documents.security_type%TYPE := null;
736: l_publish_flag fnd_documents.publish_flag%TYPE := null;
737: l_description fnd_documents_vl.description%TYPE := null;
738: l_file_name fnd_documents_vl.file_name%TYPE := null;
739: l_create_doc varchar2(1):= null;

Line 736: l_publish_flag fnd_documents.publish_flag%TYPE := null;

732: l_usage_type fnd_documents.usage_type%TYPE := null;
733: l_datatype_id fnd_documents.datatype_id%TYPE := null;
734: l_category_id fnd_documents.category_id%TYPE := null;
735: l_security_type fnd_documents.security_type%TYPE := null;
736: l_publish_flag fnd_documents.publish_flag%TYPE := null;
737: l_description fnd_documents_vl.description%TYPE := null;
738: l_file_name fnd_documents_vl.file_name%TYPE := null;
739: l_create_doc varchar2(1):= null;
740: --included to fix bug 1903257 End

Line 737: l_description fnd_documents_vl.description%TYPE := null;

733: l_datatype_id fnd_documents.datatype_id%TYPE := null;
734: l_category_id fnd_documents.category_id%TYPE := null;
735: l_security_type fnd_documents.security_type%TYPE := null;
736: l_publish_flag fnd_documents.publish_flag%TYPE := null;
737: l_description fnd_documents_vl.description%TYPE := null;
738: l_file_name fnd_documents_vl.file_name%TYPE := null;
739: l_create_doc varchar2(1):= null;
740: --included to fix bug 1903257 End
741:

Line 738: l_file_name fnd_documents_vl.file_name%TYPE := null;

734: l_category_id fnd_documents.category_id%TYPE := null;
735: l_security_type fnd_documents.security_type%TYPE := null;
736: l_publish_flag fnd_documents.publish_flag%TYPE := null;
737: l_description fnd_documents_vl.description%TYPE := null;
738: l_file_name fnd_documents_vl.file_name%TYPE := null;
739: l_create_doc varchar2(1):= null;
740: --included to fix bug 1903257 End
741:
742: --

Line 810: from fnd_documents

806: --Code changes made to fix bug 1903257 Begin
807: begin
808: select usage_type
809: into l_usage_type
810: from fnd_documents
811: where document_id = p_document_id ;
812: if l_usage_type = 'S' then
813: l_create_doc := null;
814: elsif l_usage_type in ('T','O') then

Line 820: from fnd_documents_vl where document_id = p_document_id;

816: select datatype_id,category_id,security_type,
817: publish_flag,media_id,file_name,description
818: into l_datatype_id,l_category_id,l_security_type,
819: l_publish_flag,l_media_id,l_file_name,l_description
820: from fnd_documents_vl where document_id = p_document_id;
821: l_create_doc := 'Y';
822: l_document_id := null;
823: exception
824: when others then