Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter Installation and User’s Documentation | Transaction Definitions | Working with SQL Trees in Oracle Applications -to-Integration Server Transactions | SQL Tree Example | Parent Level Alias
 
Parent Level Alias
This alias retrieves the customer's ID and name based on the customer's status. You will use the ID field from this alias to query the database in the two child aliases.
Field
Value
Alias Name
CUSTOMERS
SQL
SELECT NAME, ID FROM TABLE1 WHERE STATUS = ‘N' ORDER BY NAME