Thursday, November 25, 2021

PO_LINE_LOCATIONS_ALL.MATCH_OPTION in Oracle APPS

SELECT lookup_type, lookup_code, meaning
  FROM fnd_lookup_values
 WHERE     1 = 1
       AND lookup_type = 'POS_INVOICE_MATCH_OPTION'
       AND enabled_flag = 'Y'
       AND SYSDATE BETWEEN NVL (start_date_active, SYSDATE)
                       AND NVL (end_date_active, SYSDATE)

No comments:

Post a Comment

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...