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.FND_WEBFILE dependencies on FND_CONC_REQ_OUTPUTS

Line 315: * 1) YES - case a. whether it is a REPRINT and REPUBLISH - check for output details in fnd_conc_req_outputs

311: and rownum = 1;
312:
313: /* Bug 6040814. Supporting output file display for FNDREPRINT (REPRINT and REPULISH) programs.
314: * First check whether the program is a FNDREPRINT program.
315: * 1) YES - case a. whether it is a REPRINT and REPUBLISH - check for output details in fnd_conc_req_outputs
316: * case b. Only REPRINT
317: * Check whether the parent program supports republish
318: * 1) YES - Check for output details in fnd_conc_req_outputs which request id as parent request id.
319: * 2) NO - Check for output details in fnd_concurrent_requests with REPRINT request id.

Line 318: * 1) YES - Check for output details in fnd_conc_req_outputs which request id as parent request id.

314: * First check whether the program is a FNDREPRINT program.
315: * 1) YES - case a. whether it is a REPRINT and REPUBLISH - check for output details in fnd_conc_req_outputs
316: * case b. Only REPRINT
317: * Check whether the parent program supports republish
318: * 1) YES - Check for output details in fnd_conc_req_outputs which request id as parent request id.
319: * 2) NO - Check for output details in fnd_concurrent_requests with REPRINT request id.
320: * 2) NO (NOT FNDREPRINT)
321: * case a. If the program is layout enabled - check for output details in fnd_conc_req_outputs
322: * case b. Check for the output details in fnd_concurrent_requests as already done in the above sql.

Line 321: * case a. If the program is layout enabled - check for output details in fnd_conc_req_outputs

317: * Check whether the parent program supports republish
318: * 1) YES - Check for output details in fnd_conc_req_outputs which request id as parent request id.
319: * 2) NO - Check for output details in fnd_concurrent_requests with REPRINT request id.
320: * 2) NO (NOT FNDREPRINT)
321: * case a. If the program is layout enabled - check for output details in fnd_conc_req_outputs
322: * case b. Check for the output details in fnd_concurrent_requests as already done in the above sql.
323: */
324:
325: /* Check whether the program is a FNDREPRINT program */

Line 335: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt

331: if(action_publish_count=1) then /* Check if it is a REPRINT and REPUBLISH request */
332: begin
333: select file_type,file_name,file_node_name,file_size, fmt.mime_type
334: into ffcode, fname, node, fsize, mtype
335: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt
336: where concurrent_request_id = id
337: and RO.file_type = fmt.file_format_code
338: and rownum = 1;
339: exception

Line 368: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt

364: if (fnd_conc_sswa.layout_enabled(appl_name, prog_name)) then
365: begin
366: select file_type,file_name,file_node_name,file_size, fmt.mime_type
367: into ffcode, fname, node, fsize, mtype
368: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt
369: where concurrent_request_id = (select to_number(argument1) from fnd_concurrent_requests where request_id=id)
370: and RO.file_type = fmt.file_format_code
371: and rownum = 1;
372: exception

Line 398: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt

394: elsif(fnd_conc_sswa.layout_enabled(appl_name, prog_name) and file_type=request_out) then /* Not a FNDREPRINT request */
395: begin
396: select file_type,file_name,file_node_name,file_size, fmt.mime_type
397: into ffcode, fname, node, fsize, mtype
398: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt
399: where concurrent_request_id = id
400: and RO.file_type = fmt.file_format_code
401: and rownum = 1;
402: exception