IBY_XML_BEP_ACCT_OPTIONS_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name
ACCOUNT_OPTIONS BEP_ACCOUNT_ID

Query

SQL_Statement
SELECT XMLAGG ( XMLELEMENT ( "AccountOption", XMLELEMENT ( "Name", VALS.ACCOUNT_OPTION_CODE ), XMLELEMENT ( "Value", NVL2( VALS.VAL_SEC_SEGMENT_ID, IBY_SECURITY_PKG.DECRYPT_FIELD_VALS( VALS.VAL_SEC_SEGMENT_ID, IBY_UTILITY_PVT.GET_VIEW_PARAM('SYS_KEY')), VALS.ACCOUNT_OPTION_VALUE)))), VALS.BEP_ACCOUNT_ID FROM IBY_BEP_ACCT_OPT_VALS VALS GROUP BY VALS.BEP_ACCOUNT_ID