Introduction: This query is used to fetch the printer name .In this we will be passing concurrent program id and level value id(user id) as the parameter so that printer attached to that specific user gets displayed.
SQL Query:
SELECT printer_name
FROM
wsh_report_printers
WHERE
level_value_id =:p_level_value_id
AND concurrent_program_id =:p_concurrent_program_id
AND enabled_flag = ‘Y’
AND default_printer_flag = ‘Y’;
Parameter: Concurrent Program Id and Level Value Id
Query to get the Printer Style
Introduction: This query is used to fetch the printer style .In this we will be passing concurrent program request id as the parameter so that printer style attached to that request gets displayed.
SQL Query:
SELECT
print_style,
number_of_copies,
requested_by
FROM
fnd_concurrent_requests
WHERE
request_id = :p_request_id;
Parameter: Request Id
