593: f1.po_cancel_count,
594: f1.buy_order_value,
595: f1.buy_order_value2,
596: f1.buy_order_count,
597: fnd_global.user_id,
598: sysdate,
599: sysdate,
600: fnd_global.user_id,
601: fnd_global.login_id,
596: f1.buy_order_count,
597: fnd_global.user_id,
598: sysdate,
599: sysdate,
600: fnd_global.user_id,
601: fnd_global.login_id,
602: fnd_global.conc_program_id,
603: fnd_global.conc_login_id,
604: fnd_global.prog_appl_id,
597: fnd_global.user_id,
598: sysdate,
599: sysdate,
600: fnd_global.user_id,
601: fnd_global.login_id,
602: fnd_global.conc_program_id,
603: fnd_global.conc_login_id,
604: fnd_global.prog_appl_id,
605: fnd_global.conc_request_id
598: sysdate,
599: sysdate,
600: fnd_global.user_id,
601: fnd_global.login_id,
602: fnd_global.conc_program_id,
603: fnd_global.conc_login_id,
604: fnd_global.prog_appl_id,
605: fnd_global.conc_request_id
606: from
599: sysdate,
600: fnd_global.user_id,
601: fnd_global.login_id,
602: fnd_global.conc_program_id,
603: fnd_global.conc_login_id,
604: fnd_global.prog_appl_id,
605: fnd_global.conc_request_id
606: from
607: (select
600: fnd_global.user_id,
601: fnd_global.login_id,
602: fnd_global.conc_program_id,
603: fnd_global.conc_login_id,
604: fnd_global.prog_appl_id,
605: fnd_global.conc_request_id
606: from
607: (select
608: number3 sr_instance_id,
601: fnd_global.login_id,
602: fnd_global.conc_program_id,
603: fnd_global.conc_login_id,
604: fnd_global.prog_appl_id,
605: fnd_global.conc_request_id
606: from
607: (select
608: number3 sr_instance_id,
609: number4 organization_id,
711: sum(f.po_cancel_count),
712: sum(f.buy_order_value),
713: sum(f.buy_order_value2),
714: sum(f.buy_order_count),
715: fnd_global.user_id, sysdate,
716: sysdate, fnd_global.user_id, fnd_global.login_id,
717: fnd_global.conc_program_id, fnd_global.conc_login_id,
718: fnd_global.prog_appl_id, fnd_global.conc_request_id
719: from
712: sum(f.buy_order_value),
713: sum(f.buy_order_value2),
714: sum(f.buy_order_count),
715: fnd_global.user_id, sysdate,
716: sysdate, fnd_global.user_id, fnd_global.login_id,
717: fnd_global.conc_program_id, fnd_global.conc_login_id,
718: fnd_global.prog_appl_id, fnd_global.conc_request_id
719: from
720: msc_suppliers_f f,
713: sum(f.buy_order_value2),
714: sum(f.buy_order_count),
715: fnd_global.user_id, sysdate,
716: sysdate, fnd_global.user_id, fnd_global.login_id,
717: fnd_global.conc_program_id, fnd_global.conc_login_id,
718: fnd_global.prog_appl_id, fnd_global.conc_request_id
719: from
720: msc_suppliers_f f,
721: msc_phub_item_categories_mv q
714: sum(f.buy_order_count),
715: fnd_global.user_id, sysdate,
716: sysdate, fnd_global.user_id, fnd_global.login_id,
717: fnd_global.conc_program_id, fnd_global.conc_login_id,
718: fnd_global.prog_appl_id, fnd_global.conc_request_id
719: from
720: msc_suppliers_f f,
721: msc_phub_item_categories_mv q
722: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
780: t.po_cancel_count,
781: t.buy_order_value,
782: t.buy_order_value2,
783: t.buy_order_count,
784: fnd_global.user_id, sysdate,
785: sysdate, fnd_global.user_id, fnd_global.login_id,
786: fnd_global.conc_program_id, fnd_global.conc_login_id,
787: fnd_global.prog_appl_id, fnd_global.conc_request_id
788: from
781: t.buy_order_value,
782: t.buy_order_value2,
783: t.buy_order_count,
784: fnd_global.user_id, sysdate,
785: sysdate, fnd_global.user_id, fnd_global.login_id,
786: fnd_global.conc_program_id, fnd_global.conc_login_id,
787: fnd_global.prog_appl_id, fnd_global.conc_request_id
788: from
789: (select
782: t.buy_order_value2,
783: t.buy_order_count,
784: fnd_global.user_id, sysdate,
785: sysdate, fnd_global.user_id, fnd_global.login_id,
786: fnd_global.conc_program_id, fnd_global.conc_login_id,
787: fnd_global.prog_appl_id, fnd_global.conc_request_id
788: from
789: (select
790: f.plan_id, f.plan_run_id,
783: t.buy_order_count,
784: fnd_global.user_id, sysdate,
785: sysdate, fnd_global.user_id, fnd_global.login_id,
786: fnd_global.conc_program_id, fnd_global.conc_login_id,
787: fnd_global.prog_appl_id, fnd_global.conc_request_id
788: from
789: (select
790: f.plan_id, f.plan_run_id,
791: f.sr_instance_id, f.organization_id,