Oracle Apps Adapter uses SQL trees to build and run Oracle Applications -to-Integration Server transaction definitions. SQL trees are hierarchical SQL statements that the adapter executes at run time to retrieve data from an Oracle Applications system and to store the data in a hierarchical format that is easily accessible in integration flows.

SQL trees enable the adapter to collect data from separate tables and to place (join) the results in a hierarchical structure rather than in a standard result set. You must understand how Oracle Apps Adapter uses SQL trees to define Oracle Applications -to-Integration Server transaction definitions before you create or edit the transaction definitions.

SQL trees are made up of a series of SQL query calls called aliases. You can specify an alias's SQL query either as a SQL SELECT statement or as a stored procedure. Each SQL tree contains one top-level SQL statement and one or more child SQL statements. Child level SQL statements retrieve data from Oracle Applications using results from the top-level SQL statement as the query input parameters in their own SQL calls.