Tuesday, October 25, 2022

AR Receipt Reversal Categories(REVERSAL_CATEGORY_TYPE) in Oracle APPS

SELECT lookup_code
      ,meaning
      ,description
  FROM fnd_lookup_values 
WHERE lookup_type = 'REVERSAL_CATEGORY_TYPE'
    AND LANGUAGE = USERENV('LANG')
    AND lookup_code = 'REV'

No comments:

Post a Comment

Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...