Wednesday, July 25, 2018

Query to get Form and Form Personalization Details in Oracle APPS

Form Details:-

SELECT  DISTINCT application_short_name, forms.form_name,
         formstl.user_form_name,
         func.function_name,
         func.user_function_name,
         fm.menu_name,
         menu.prompt menu_prompt,
         menu.description,
         restl.responsibility_name     
  FROM   fnd_form forms,
         fnd_form_tl formstl,
         fnd_form_functions_vl func,
         fnd_menu_entries_vl menu,
         fnd_menus fm,
         fnd_responsibility res,
         fnd_responsibility_tl restl,
         fnd_application fat
 WHERE     1=1
         AND forms.form_id = formstl.form_id
         AND func.form_id = forms.form_id
         AND menu.function_id = func.function_id
         AND menu.menu_id=fm.menu_id
         AND res.menu_id = menu.menu_id
         AND res.responsibility_id = restl.responsibility_id
         AND fat.application_id=forms.application_id
         AND UPPER (forms.form_name) LIKE 'XX%'
ORDER BY 1,2
     


Form Personalization:

SELECT DISTINCT ffv.form_name, fa.application_name,ffv.form_id,  ffv.user_form_name,
                ffv.description form_description, ffcr.sequence,
                ffcr.description personalization_rule_name
           FROM fnd_form_vl ffv, fnd_form_custom_rules ffcr, fnd_application_tl fa
          WHERE ffv.form_name = ffcr.form_name
          AND fa.application_id=ffv.application_id
       ORDER BY 2, 1;

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)