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.PAY_AE_SI_REPORTS dependencies on FND_LOBS

Line 5364: From fnd_lobs

5360: BEGIN
5361: IF (p_report='FORM1') THEN
5362: Select file_data
5363: Into p_pdf_blob
5364: From fnd_lobs
5365: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_F1_ar_AE.pdf');
5366: ELSIF (p_report = 'FORM2') THEN
5367: Select file_data
5368: Into p_pdf_blob

Line 5365: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_F1_ar_AE.pdf');

5361: IF (p_report='FORM1') THEN
5362: Select file_data
5363: Into p_pdf_blob
5364: From fnd_lobs
5365: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_F1_ar_AE.pdf');
5366: ELSIF (p_report = 'FORM2') THEN
5367: Select file_data
5368: Into p_pdf_blob
5369: From fnd_lobs

Line 5369: From fnd_lobs

5365: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_F1_ar_AE.pdf');
5366: ELSIF (p_report = 'FORM2') THEN
5367: Select file_data
5368: Into p_pdf_blob
5369: From fnd_lobs
5370: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_F2_ar_AE.pdf');
5371: ELSIF (p_report ='FORM6') THEN
5372: Select file_data
5373: Into p_pdf_blob

Line 5370: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_F2_ar_AE.pdf');

5366: ELSIF (p_report = 'FORM2') THEN
5367: Select file_data
5368: Into p_pdf_blob
5369: From fnd_lobs
5370: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_F2_ar_AE.pdf');
5371: ELSIF (p_report ='FORM6') THEN
5372: Select file_data
5373: Into p_pdf_blob
5374: From fnd_lobs

Line 5374: From fnd_lobs

5370: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_F2_ar_AE.pdf');
5371: ELSIF (p_report ='FORM6') THEN
5372: Select file_data
5373: Into p_pdf_blob
5374: From fnd_lobs
5375: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_F6_ar_AE.rtf');
5376: ELSIF (p_report ='MCP') THEN
5377: Select file_data
5378: Into p_pdf_blob

Line 5375: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_F6_ar_AE.rtf');

5371: ELSIF (p_report ='FORM6') THEN
5372: Select file_data
5373: Into p_pdf_blob
5374: From fnd_lobs
5375: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_F6_ar_AE.rtf');
5376: ELSIF (p_report ='MCP') THEN
5377: Select file_data
5378: Into p_pdf_blob
5379: From fnd_lobs

Line 5379: From fnd_lobs

5375: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_F6_ar_AE.rtf');
5376: ELSIF (p_report ='MCP') THEN
5377: Select file_data
5378: Into p_pdf_blob
5379: From fnd_lobs
5380: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_MCP_ar_AE.rtf');
5381: ELSIF (p_report ='MCF') THEN
5382: Select file_data
5383: Into p_pdf_blob

Line 5380: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_MCP_ar_AE.rtf');

5376: ELSIF (p_report ='MCP') THEN
5377: Select file_data
5378: Into p_pdf_blob
5379: From fnd_lobs
5380: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_MCP_ar_AE.rtf');
5381: ELSIF (p_report ='MCF') THEN
5382: Select file_data
5383: Into p_pdf_blob
5384: From fnd_lobs

Line 5384: From fnd_lobs

5380: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_MCP_ar_AE.rtf');
5381: ELSIF (p_report ='MCF') THEN
5382: Select file_data
5383: Into p_pdf_blob
5384: From fnd_lobs
5385: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_MCF_ar_AE.rtf');
5386: ELSIF (p_report ='FORM7') THEN
5387: Select file_data
5388: Into p_pdf_blob

Line 5385: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_MCF_ar_AE.rtf');

5381: ELSIF (p_report ='MCF') THEN
5382: Select file_data
5383: Into p_pdf_blob
5384: From fnd_lobs
5385: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_MCF_ar_AE.rtf');
5386: ELSIF (p_report ='FORM7') THEN
5387: Select file_data
5388: Into p_pdf_blob
5389: From fnd_lobs

Line 5389: From fnd_lobs

5385: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_MCF_ar_AE.rtf');
5386: ELSIF (p_report ='FORM7') THEN
5387: Select file_data
5388: Into p_pdf_blob
5389: From fnd_lobs
5390: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_F7_ar_AE.rtf');
5391: END IF;
5392: EXCEPTION
5393: when no_data_found then

Line 5390: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_F7_ar_AE.rtf');

5386: ELSIF (p_report ='FORM7') THEN
5387: Select file_data
5388: Into p_pdf_blob
5389: From fnd_lobs
5390: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_F7_ar_AE.rtf');
5391: END IF;
5392: EXCEPTION
5393: when no_data_found then
5394: null;