- View Objects represent a query Result.
- View Objects are used for joining, filtering, projecting, and sorting business data.
- View Objects are created based on any number of Entity Objects.
- View Objects can also be constructed from a SQL Statement.
- The View Objects represents both the data i.e. SELECT statement & the operations or methods that can be performed on the data(get/set/validations).
- Most of the View Objects are defined decoratively, but there are even methods to programmatically create and Alter VOs at RUN time.
- View Objects are designed to manage collection of data i.e. main collection interface into the DataBase.
- View Objects provide view-like shaping of the data. It leverages SQL to join tables and corresponding Entity Objects.
- The View Object allows us to do the action most often performed, query without the overhead of a full Entity Object which indirectly increase the performance of Oracle Application Framework pages.
- View Objects ensures better usability of business logic (as it delegates to other objects such as Entity Object or PL/SQL for Business Logic).
- View Object contains only the attributes required for a specific purpose. So do not select more attributes i.e. columns than required for a Page.
- View Objects are considered for a specific page and are not expected to be reused.
- Never include business logic in View Object.
Tuesday, October 24, 2017
View Objects in Oracle OAF
Subscribe to:
Post Comments (Atom)
Query to get Parent and Child Accounts in Oracle APPS R12
SELECT ffv1.flex_value parent_account ,ffvt1.description parent_account_desc ,ffv2.flex_value child_account ,ffvt2.description...
-
The XDOLoader utility is a Java-based command line program to load template (RTF, PDF, and XSL-FO), XML, and XSD files to the XML Publis...
-
Serial_number_control_code column contains values as 1,2,5 &6 in mtl_system_items_b table. Inorder to find meaning for this values r...
-
SELECT HAOU.NAME "Operating Unit", OTTT_H.NAME "Transaction Type", OTTT_H.DESCRIPTION "Descripti...
No comments:
Post a Comment