Tuesday, October 24, 2017

SYSTEM.CURSOR_RECORD in Oracle Forms

SYSTEM.CURSOR_RECORD:-
  • Represents the number of the record where the cursor is located. 
  • This number represents the record's current physical order in the block's list of records. 
  • The value is always a character string.

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