Create Package XX_ALLROWS
Create public Procedure P1
***** YOUR QUERY****
fnd_file.put_line (fnd_file.output, &OUTPUT1, &OUTPUT2);
(Create private Procedure P2
---Write the email package using the UTL_SMTP approch. Using this approch you can send the procedure P1 output file as an attachment to the desiginated receiptents.
(Create public Procedure P3
---call the procedure P1 using the "g_request_id = fnd_request.submit_request"
---Wait for the above procedure to complete using "l_conc_status := fnd_concurrent.wait_for_request" procedure.
---call the procedure P2. (When called you must provide the correct to, from address)
Register the Package ALL_ROWS as a concurrent program and schedule when submit it from the request.
sharing is Caring
I already used Type as 'Summary', but still getting 14 emails