[Home] [Help]
166: from mfg_lookups
167: where lookup_type = 'MSC_NC_MISC_PROMPTS'
168: order by lookup_code;
169:
170: select msc_form_query_s.nextval
171: into g_options_query_id
172: from dual;
173:
174: option_query_id :=g_options_query_id;
366: if plan_a_rec(a) <> plan_b_rec(a) or
367: (plan_a_rec(a) is null and plan_b_rec(a) is not null) or
368: (plan_a_rec(a) is not null and plan_b_rec(a) is null) then
369: */
370: insert into msc_form_query
371: (QUERY_ID,
372: LAST_UPDATE_DATE,
373: LAST_UPDATED_BY,
374: CREATION_DATE,
471: plan_b_rec(7);
472: CLOSE option_c;
473:
474: for a in 1 .. plan_a_rec.count loop
475: insert into msc_form_query
476: (QUERY_ID,
477: LAST_UPDATE_DATE,
478: LAST_UPDATED_BY,
479: CREATION_DATE,
555: CLOSE option_c;
556:
557: for a in 1 .. plan_a_rec.count loop
558:
559: insert into msc_form_query
560: (QUERY_ID,
561: LAST_UPDATE_DATE,
562: LAST_UPDATED_BY,
563: CREATION_DATE,
676:
677: for a in 1 .. plan_a_rec.count loop
678:
679:
680: insert into msc_form_query
681: (QUERY_ID,
682: LAST_UPDATE_DATE,
683: LAST_UPDATED_BY,
684: CREATION_DATE,
741: CLOSE option_c;
742:
743: for a in 1 .. plan_a_rec.count loop
744:
745: insert into msc_form_query
746: (QUERY_ID,
747: LAST_UPDATE_DATE,
748: LAST_UPDATED_BY,
749: CREATION_DATE,
771:
772: Procedure compare_orgs IS
773:
774: Begin
775: insert into msc_form_query
776: (QUERY_ID,
777: LAST_UPDATE_DATE,
778: LAST_UPDATED_BY,
779: CREATION_DATE,
830: and nvl(MPO2.BILL_OF_RESOURCES,'0') = nvl(MPO.BILL_OF_RESOURCES,'0')
831: and nvl(MPO2.INCLUDE_SALESORDER,0) = nvl(MPO.INCLUDE_SALESORDER,0))
832: ;
833:
834: insert into msc_form_query
835: (QUERY_ID,
836: LAST_UPDATE_DATE,
837: LAST_UPDATED_BY,
838: CREATION_DATE,
889: and nvl(MPO2.BILL_OF_RESOURCES,'0') = nvl(MPO.BILL_OF_RESOURCES,'0')
890: and nvl(MPO2.INCLUDE_SALESORDER,0) = nvl(MPO.INCLUDE_SALESORDER,0))
891: ;
892:
893: insert into msc_form_query
894: (QUERY_ID,
895: LAST_UPDATE_DATE,
896: LAST_UPDATED_BY,
897: CREATION_DATE,
956: Procedure compare_schedules IS
957:
958: Begin
959:
960: insert into msc_form_query
961: (QUERY_ID,
962: LAST_UPDATE_DATE,
963: LAST_UPDATED_BY,
964: CREATION_DATE,
1016: and nvl(MPS2.PROBABILITY,0) = nvl(MPS.PROBABILITY,0)
1017: )
1018: ;
1019:
1020: insert into msc_form_query
1021: (QUERY_ID,
1022: LAST_UPDATE_DATE,
1023: LAST_UPDATED_BY,
1024: CREATION_DATE,
1076: and nvl(MPS2.PROBABILITY,0) = nvl(MPS.PROBABILITY,0)
1077: )
1078: ;
1079:
1080: insert into msc_form_query
1081: (QUERY_ID,
1082: LAST_UPDATE_DATE,
1083: LAST_UPDATED_BY,
1084: CREATION_DATE,
1182:
1183: checkPlanStatus(g_from_plan, g_to_plan,p_plan_status,p_report_id);
1184:
1185: if g_need_insert_temp then
1186: select msc_form_query_s.nextval
1187: into g_excp_query_id
1188: from dual;
1189: else
1190: g_excp_query_id := p_report_id;