Tuesday, November 21, 2017

Query to get Value Set Values in Oracle Apps

SELECT ffvs.flex_value_set_id,
         ffvs.flex_value_set_name,
         ffvs.description set_description,
         ffvs.validation_type,
         ffv.flex_value,
         ffvt.description value_description,
         ffv.enabled_flag,
         ffv.last_update_date,
         ffv.last_updated_by
    FROM fnd_flex_value_sets ffvs, fnd_flex_values ffv, fnd_flex_values_tl ffvt
   WHERE     ffvs.flex_value_set_id = ffv.flex_value_set_id
         AND ffv.flex_value_id = ffvt.flex_value_id
         AND ffvt.language = USERENV ('LANG')
         AND flex_value_set_name = 'XX_VALUE_SET_NAME'
ORDER BY flex_value ASC

1 comment:

  1. Optumflex Solutions for your ERP business needs. Visit Optumflex.com for more information.

    ReplyDelete

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)