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 | Child Alias 1
 
Child Alias 1
This child alias issues a stored procedure to gather phone number information for each customer. The stored procedure's input value is ID, and its output value is PHONE.
Field
Value
Alias Name
PHONENUMBER
SQL
APPS.YYY.GETCUSTOMERPHONE
Relation
CUSTOMER.ID