94: exception_value2,
95: exception_tbl.exception_days,
96: exception_tbl.exception_quantity,
97: exception_tbl.exception_ratio,
98: fnd_global.user_id,
99: sysdate,
100: sysdate,
101: fnd_global.user_id,
102: fnd_global.login_id,
97: exception_tbl.exception_ratio,
98: fnd_global.user_id,
99: sysdate,
100: sysdate,
101: fnd_global.user_id,
102: fnd_global.login_id,
103: fnd_global.conc_program_id,
104: fnd_global.conc_login_id,
105: fnd_global.prog_appl_id,
98: fnd_global.user_id,
99: sysdate,
100: sysdate,
101: fnd_global.user_id,
102: fnd_global.login_id,
103: fnd_global.conc_program_id,
104: fnd_global.conc_login_id,
105: fnd_global.prog_appl_id,
106: fnd_global.conc_request_id
99: sysdate,
100: sysdate,
101: fnd_global.user_id,
102: fnd_global.login_id,
103: fnd_global.conc_program_id,
104: fnd_global.conc_login_id,
105: fnd_global.prog_appl_id,
106: fnd_global.conc_request_id
107: from (
100: sysdate,
101: fnd_global.user_id,
102: fnd_global.login_id,
103: fnd_global.conc_program_id,
104: fnd_global.conc_login_id,
105: fnd_global.prog_appl_id,
106: fnd_global.conc_request_id
107: from (
108: select
101: fnd_global.user_id,
102: fnd_global.login_id,
103: fnd_global.conc_program_id,
104: fnd_global.conc_login_id,
105: fnd_global.prog_appl_id,
106: fnd_global.conc_request_id
107: from (
108: select
109: med.plan_id,
102: fnd_global.login_id,
103: fnd_global.conc_program_id,
104: fnd_global.conc_login_id,
105: fnd_global.prog_appl_id,
106: fnd_global.conc_request_id
107: from (
108: select
109: med.plan_id,
110: nvl(med.organization_id, -23453) organization_id,
665: sum(f.exception_value2),
666: sum(f.exception_days),
667: sum(f.exception_quantity),
668: sum(f.exception_ratio),
669: fnd_global.user_id, sysdate,
670: sysdate, fnd_global.user_id, fnd_global.login_id,
671: fnd_global.conc_program_id, fnd_global.conc_login_id,
672: fnd_global.prog_appl_id, fnd_global.conc_request_id
673: from
666: sum(f.exception_days),
667: sum(f.exception_quantity),
668: sum(f.exception_ratio),
669: fnd_global.user_id, sysdate,
670: sysdate, fnd_global.user_id, fnd_global.login_id,
671: fnd_global.conc_program_id, fnd_global.conc_login_id,
672: fnd_global.prog_appl_id, fnd_global.conc_request_id
673: from
674: msc_exceptions_f f,
667: sum(f.exception_quantity),
668: sum(f.exception_ratio),
669: fnd_global.user_id, sysdate,
670: sysdate, fnd_global.user_id, fnd_global.login_id,
671: fnd_global.conc_program_id, fnd_global.conc_login_id,
672: fnd_global.prog_appl_id, fnd_global.conc_request_id
673: from
674: msc_exceptions_f f,
675: msc_phub_item_categories_mv q
668: sum(f.exception_ratio),
669: fnd_global.user_id, sysdate,
670: sysdate, fnd_global.user_id, fnd_global.login_id,
671: fnd_global.conc_program_id, fnd_global.conc_login_id,
672: fnd_global.prog_appl_id, fnd_global.conc_request_id
673: from
674: msc_exceptions_f f,
675: msc_phub_item_categories_mv q
676: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
736: sum(f.exception_value2),
737: sum(f.exception_days),
738: sum(f.exception_quantity),
739: sum(f.exception_ratio),
740: fnd_global.user_id, sysdate,
741: sysdate, fnd_global.user_id, fnd_global.login_id,
742: fnd_global.conc_program_id, fnd_global.conc_login_id,
743: fnd_global.prog_appl_id, fnd_global.conc_request_id
744: from
737: sum(f.exception_days),
738: sum(f.exception_quantity),
739: sum(f.exception_ratio),
740: fnd_global.user_id, sysdate,
741: sysdate, fnd_global.user_id, fnd_global.login_id,
742: fnd_global.conc_program_id, fnd_global.conc_login_id,
743: fnd_global.prog_appl_id, fnd_global.conc_request_id
744: from
745: msc_exceptions_f f,
738: sum(f.exception_quantity),
739: sum(f.exception_ratio),
740: fnd_global.user_id, sysdate,
741: sysdate, fnd_global.user_id, fnd_global.login_id,
742: fnd_global.conc_program_id, fnd_global.conc_login_id,
743: fnd_global.prog_appl_id, fnd_global.conc_request_id
744: from
745: msc_exceptions_f f,
746: msc_phub_mfg_cal_periods_mv mp
739: sum(f.exception_ratio),
740: fnd_global.user_id, sysdate,
741: sysdate, fnd_global.user_id, fnd_global.login_id,
742: fnd_global.conc_program_id, fnd_global.conc_login_id,
743: fnd_global.prog_appl_id, fnd_global.conc_request_id
744: from
745: msc_exceptions_f f,
746: msc_phub_mfg_cal_periods_mv mp
747: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id