Monday, October 23, 2017

Query to Get DFF Details in Oracle Apps

SELECT app.application_name,
         dff_name.descriptive_flexfield_name,
         dff_segments.end_user_column_name dff_column_name,
         dff_segments.application_column_name attribute_column,
         dff_segments.descriptive_flex_context_code   
    FROM fnd_descriptive_flexs_vl dff_name,
         fnd_descr_flex_col_usage_vl dff_segments,
         fnd_application_tl app
   WHERE 1=1
     --dff_name.application_id = 201
     AND dff_name.application_id = dff_segments.application_id
     AND dff_name.descriptive_flexfield_name =
                dff_segments.descriptive_flexfield_name
     AND dff_name.application_id = app.application_id
     AND dff_name.application_id = app.application_id
     AND dff_name.descriptive_flexfield_name NOT LIKE '$SRS$%'
--     AND dff_name.descriptive_flexfield_name LIKE 'PO%HEADE%'
ORDER BY dff_name.descriptive_flexfield_name,
         dff_segments.end_user_column_name,
         dff_segments.application_column_name

No comments:

Post a Comment

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)