Friday, July 1, 2022

AP_SUPPLIER_SITES_ALL.PAY_GROUP_LOOKUP_CODE or PO_VENDOR_SITES_ALL.PAY_GROUP_LOOKUP_CODE in Oracle APPS

SELECT *
  FROM apps.fnd_lookup_values flv
 WHERE     flv.lookup_type = 'PAY GROUP'
       AND flv.LANGUAGE = USERENV ('LANG')
       AND flv.enabled_flag = 'Y'
       AND SYSDATE BETWEEN NVL (flv.START_DATE_ACTIVE, SYSDATE)
                       AND NVL (flv.END_DATE_ACTIVE, SYSDATE)

LOOKUP_CODE will be AP_SUPPLIER_SITES_ALL.PAY_GROUP_LOOKUP_CODE or PO_VENDOR_SITES_ALL.PAY_GROUP_LOOKUP_CODE

No comments:

Post a Comment

currentAppUi built in variable in VBCS

$global.currentAppUi.id :- The id of the App UI $global.currentAppUi.urlId :-The id of the App UI as shown in the URL $global.currentAppUi.d...