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 321: * 1) YES - case a. whether it is a REPRINT and REPUBLISH - check for output details in fnd_conc_req_outputs

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

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

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

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

323: * Check whether the parent program supports republish
324: * 1) YES - Check for output details in fnd_conc_req_outputs which request id as parent request id.
325: * 2) NO - Check for output details in fnd_concurrent_requests with REPRINT request id.
326: * 2) NO (NOT FNDREPRINT)
327: * case a. If the program is layout enabled - check for output details in fnd_conc_req_outputs
328: * case b. Check for the output details in fnd_concurrent_requests as already done in the above sql.
329: */
330:
331: /* Check whether the program is a FNDREPRINT program */

Line 341: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt

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

Line 374: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt

370: if (fnd_conc_sswa.layout_enabled(appl_name, prog_name)) then
371: begin
372: select file_type,file_name,file_node_name,file_size, fmt.mime_type
373: into ffcode, fname, node, fsize, mtype
374: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt
375: where concurrent_request_id = (select to_number(argument1) from fnd_concurrent_requests where request_id=id)
376: and RO.file_type = fmt.file_format_code
377: and rownum = 1;
378: exception

Line 404: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt

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