[Home] [Help]
View: IBY_XML_BEP_ACCT_OPTIONS_V
View Text
SELECT XMLAGG( XMLELEMENT("ACCOUNTOPTION"
, XMLELEMENT("NAME"
, VALS.ACCOUNT_OPTION_CODE)
, XMLELEMENT("VALUE"
, VALS.ACCOUNT_OPTION_VALUE) ) )
, VALS.BEP_ACCOUNT_ID
FROM IBY_BEP_ACCT_OPT_VALS VALS GROUP BY VALS.BEP_ACCOUNT_ID
Columns
Name |
ACCOUNT_OPTIONS |
BEP_ACCOUNT_ID |