Query To Find Form Personalization In Oracle Apps
Query To Find Form Personalization In Oracle Apps. Query to get list of form personalization. Select distinct ffcr.form_name , ffcr.enabled, fft.user_form_name, fat.application_name , ffcr.description, ffcr.id rule_id.
This is the query you need, but in order to have forms personalization correctly interpret it there are 2 things you need to worry about. So for our example, a query that would achieve our goal would be: Select * from fnd_form_custom_rules where form_name='oexoeord';
This Can Be Done In Different Ways.
Home » sql query to get oracle form personalization details. Hence forms personalization must check conditions for below three fields. Add an action to navigate to the block “responsibility”.
This Query Can Be Anything (One Caveat Though… It Has To Return A Charvalue!).
Fill the context as you need. From fnd_form_custom_rules ffcr, fnd_form ff, fnd_form_tl fft, fnd_application_tl fat. Select distinct a.id, a.sequence, a.function_name, a.form_name, a.enabled, c.user_form_name, d.application_name, a.description, a.trigger_event, a.trigger_object, a.condition, ca.*.
Select Ffcr.form_Name, Ffft.user_Function_Name “User Form Name”, Ffcr.sequence, Ffcr.description, Ffcr.rule_Type, Ffcr.enabled, Ffcr.trigger_Event, Ffcr.trigger_Object, Ffcr.condition, Ffcr.fire_In_Enter_Query, (Select User_Name.
The tables that are filled when any forms personalization is done are listed below. User wants without close the form value should be default. Shailender thallam * *****/ select ffv.
Select Distinct Ffcr.form_Name , Ffcr.enabled, Fft.user_Form_Name, Fat.application_Name , Ffcr.description, Ffcr.id Rule_Id.
Query to get list of form personalization. Select po_lines.unit_price / po_lines.quantity from dual. Description personalization rule name from fnd_form_vl ffv, fnd_form_custom_rules ffcr where ffv.
Execute Pl/Sql Programs Through Form_Ddl Package;
Query to find the form personalization in oracle apps. When implementing this, you will have. To list all forms personalizations * *author:
Post a Comment for "Query To Find Form Personalization In Oracle Apps"