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.
