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

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...