Queries for Value Sets

Value Sets based on table:

This Query gives details of value sets that are based on a oracle application tables.

select ffvs.flex_value_set_id,

       ffvs.flex_value_set_name,

       ffvs.description set_description,

       ffvs.validation_type,

       ffvt.value_column_name,

       ffvt.meaning_column_name,

       ffvt.id_column_name,

       ffvt.application_table_name,

       ffvt.additional_where_clause

  FROM fnd_flex_value_sets ffvs, fnd_flex_validation_tables ffvt

 WHERE ffvs.flex_value_set_id = ffvt.flex_value_set_id

   AND ffvs.flex_value_set_name = 'XXX_COUNTRY_VS'

Independent Value set Details:

This query gives details of independent FND Value sets i.e. Values are static and these are not derived from any application table.

SELECT ffvs.flex_value_set_id,

       ffvs.flex_value_set_name,

       ffvs.description         set_description,

       ffvs.validation_type,

       ffv.flex_value_id,

       ffv.flex_value,

       ffvt.flex_value_meaning,

       ffvt.description         value_description

  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 ffvs.flex_value_set_name = 'XXX_COUNTRY_VS'

WebADI Upload Download Command

WebADI LDT Command :-

1. Download è FNDLOAD apps/<password> 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneintegrator.lct XX_TST_1_XINTG.ldt BNE_INTEGRATORS INTEGRATOR_ASN=XXINV INTEGRATOR_CODE=XX_TST_1_XINTG

2. Upload è FNDLOAD apps/<password> 0 Y UPLOAD $BNE_TOP/patch/115/import/bneintegrator.lct XX_TST_1_XINTG.ldt

Form Function LDT Command :-

1. Download è FNDLOAD apps/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXINV_SSM_ITEM_UPL_WADI.ldt FUNCTION FUNCTION_NAME="XXINV_SSM_ITEM_UPL_WADI"

2. Upload è FNDLOAD apps/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XXINV_SSM_ITEM_UPL_WADI.ldt