Tuesday, October 24, 2017

ExpertMode View Objects in OAF

Use ExpertMode custom SQL manually  mapped to EOs for
  • Unions,
  • Complex SQL &
  • SQL is encapsulated within an Inner view to support additional View Link Bindings.i.e. SELECT * FROM (<SQL Statement>).

No comments:

Post a Comment

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...