26: where plan_id=p_plan_id
27: and plan_run_id=p_plan_run_id;
28:
29: -- msc_st_costs_f:regular_costs
30: msc_phub_util.gather_table_stats(msc_phub_util.stats_pds, 'MSC_BIS_INV_DETAIL');
31: insert /*+ append nologging */ into msc_st_costs_f (
32: st_transaction_id,
33: error_code,
34: owning_inst_id,
96: fnd_global.user_id, sysdate,
97: sysdate, fnd_global.user_id, fnd_global.login_id,
98: fnd_global.conc_program_id, fnd_global.conc_login_id,
99: fnd_global.prog_appl_id, fnd_global.conc_request_id
100: from msc_bis_inv_detail mbid, msc_phub_dates_mv d
101: where mbid.plan_id=p_plan_id
102: and l_plan_type not in (101,102,103,105)
103: and (mbid.detail_level=1 or l_plan_type=6)
104: and mbid.period_type=1