Stored procedure data.

[Vaibhav Bhanot <Va...@db.com>]

Vaibhav,

The name of the stored procedure for Consolidated Account Summary is view_asset_acct_summary which is created in INS_D database.

This is how you will be calling the stored procedure:
exec view_asset_acct_summary
 @user_id              = 'ONLINE_INC',
 @user_type            = 'C',
 @acct_info            = null,
 @search_type          = 'C',   -- A = account number,  L = account List, null = not known
 @gcis_no              = null,
 @source_system_cd     = null,
 @bank_no              = null,
 @screen_id            = null,
 @show_excluded_accts  = null,
 @cust_id              = null,
 @input_date           = '9/28/01',
 @ccy_id               = 'USD',
 @grouping_by          = 'P',
 @category_id          = null,
 @category_indicator   = null,
 @report_id            = 2, -- 1 =Asset Account Summary - Financials, 2 = Consolidated Account Summary - Report
 @debug                = null
go

The resultant columns are:
product_desc,
account_no,
account_title,
market_value,
accrued_income,
date_value

If you have any questions or comments let me know.

Thanks

Sridhar Saraf



--

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.