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 the list of contexts for each formula type in Oracle Fusion HCM

select t.base_formula_type_name ,      ttl.formula_type_name ,      ttl.description ,      c.base_context_name from   ff_formula_types_b t ,...