Wednesday 1 December 2021

Query to get cash receipts information in oracle fusion

 /* Formatted on 12/2/2021 11:37:58 AM (QP5 v5.294) */

SELECT *

  FROM ar_cash_receipts_all

 WHERE     receipt_number = '1'

       AND NVL (TRUNC (RECEIPT_DATE), SYSDATE) =

              TO_DATE ('28-11-21', 'DD-MM-YY')

No comments:

Post a Comment

Query to get Business unit (ORGANIZATION_ID) Detail in oracle Fusion

  SELECT HAO.ORGANIZATION_ID AS BUSINESS_UNIT_ID,         HAOT.NAME,         HAO.BUSINESS_GROUP_ID,         HAO.EFFECTIVE_START_DATE,       ...