DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, January 18, 2017

             


                         Query to find the how many Receipt has been printer in a day.


Query
---------



 SELECT COUNT (*) "Receipts_So_Far"
  FROM FND_CONC_REQ_SUMMARY_V
 WHERE PHASE_CODE = 'C' AND (NVL (request_type, 'X') != 'S')
       AND ( (DESCRIPTION LIKE 'Receipt Print for Receipt%'
              OR (DESCRIPTION IS NULL
                  AND USER_CONCURRENT_PROGRAM_NAME LIKE
                         ' Print for Receipt%')))
       AND (TRUNC (request_date)) >= TRUNC (SYSDATE)

No comments: