Printer Generic Queries:
SELECT NUMBER_OF_COPIES
, NLS_LANGUAGE
, NLS_TERRITORY
, PRINTER
, PRINT_STYLE
, COMPLETION_TEXT
, OUTPUT_FILE_TYPE
, NLS_CODESET
, OUTFILE_NODE_NAME
, OUTFILE_NAME
FROM APPS.FND_CONCURRENT_REQUESTS
WHERE REQUEST_ID = ;
SELECT PRINTER_STYLE_NAME
, SRW_DRIVER
, WIDTH
, LENGTH
, ORIENTATION
FROM apps.FND_PRINTER_STYLES
WHERE PRINTER_STYLE_NAME =
( SELECT PRINT_STYLE
FROM apps.FND_CONCURRENT_REQUESTS
WHERE REQUEST_ID =
);
SELECT PRINTER_DRIVER_NAME
, USER_PRINTER_DRIVER_NAME
, PRINTER_DRIVER_METHOD_CODE
, SPOOL_FLAG
, SRW_DRIVER
, COMMAND_NAME
, ARGUMENTS
, INITIALIZATION
, RESET
FROM apps.FND_PRINTER_DRIVERS
WHERE PRINTER_DRIVER_NAME =
( SELECT PRINTER_DRIVER
FROM apps.FND_PRINTER_INFORMATION
WHERE PRINTER_STYLE =
( SELECT PRINT_STYLE
FROM apps.FND_CONCURRENT_REQUESTS
WHERE REQUEST_ID=
AND PRINTER_TYPE = (
SELECT PRINTER_TYPE
FROM apps.FND_PRINTER
WHERE PRINTER_NAME = (
SELECT PRINTER
FROM apps.FND_CONCURRENT_REQUESTS
WHERE REQUEST_ID =
)
)
)
);
SELECT r.request_id, C.application_name,
t.user_concurrent_program_name, a.basepath,
e.execution_file_name, p.concurrent_program_name,
p.execution_method_code, p.execution_options,
p.output_file_type, p.save_output_flag, p.print_flag,
p.minimum_width, p.minimum_length,
p.output_print_style, p.required_style, p.printer_name,
TO_CHAR(r.actual_completion_date, 'DD-MON-RR HH24:MI:SS'),
r.logfile_node_name, r.logfile_name, r.outfile_name,
r.ofile_size, r.nls_language, r.nls_territory,
r.nls_codeset, r.is_sub_request, r.phase_code,
r.status_code, r.completion_text, r.output_file_type,
r.number_of_copies, r.printer, r.print_style,
s.width, s.length, s.srw_driver, n.printer_type,
i.printer_style, i.printer_driver,
d.srw_driver,printer_driver_method_code,
spool_flag, stdin_flag, d.command_name, d.arguments,
d.initialization, b.responsibility_name, r.argument_text,u.user_name
FROM apps.fnd_concurrent_programs_tl t,
apps.fnd_concurrent_programs p, apps.fnd_executables e,
apps.fnd_application a, apps.fnd_application_tl c,
apps.fnd_concurrent_requests r, apps.fnd_printer n,
apps.fnd_printer_information i, apps.fnd_printer_drivers d,
apps.fnd_languages l, apps.fnd_responsibility_tl b, apps.fnd_user u,
apps.fnd_printer_styles s
WHERE c.application_id = t.application_id
and c.application_id = a.application_id
and r.concurrent_program_id = t.concurrent_program_id
and t.concurrent_program_id = p.concurrent_program_id
and p.executable_id = e.executable_id
and n.printer_name = r.printer
and (n.printer_type = i.printer_type)
and (i.printer_driver = d.printer_driver_name)
and d.platform_code is NULL
and i.printer_style = r.print_style
and r.responsibility_id = b.responsibility_id
and b.language = l.language_code
and r.requested_by = u.user_id
and r.nls_language = l.nls_language
and i.printer_style = s.printer_style_name
and l.language_code = t.language
and l.language_code = c.language
and r.request_id = ;
