APPS.MSC_ITEM_PKG dependencies on DUAL

Line 106: select msc_hub_query_s.nextval into l_qid_vmi_item from dual;

102: -- l_qid_vim_item result will be used later to populate vmi_flag
103: ---------------------------------------------------------------
104:
105: l_stmt_id :=10;
106: select msc_hub_query_s.nextval into l_qid_vmi_item from dual;
107:
108: insert into msc_hub_query(
109: query_id,
110: last_update_date,

Line 150: select msc_hub_query_s.nextval into l_qid_bucket from dual;

146: -- in bucket's last working day
147: -- about 200 rows
148: ----------------------------------------------------------------------------
149: l_stmt_id:=20;
150: select msc_hub_query_s.nextval into l_qid_bucket from dual;
151: insert into msc_hub_query(
152: query_id,
153: last_update_date,
154: last_updated_by,

Line 216: select msc_hub_query_s.nextval into l_qid_hub_week from dual;

212: --- get week end date/week start date from msc_phub_mfg_cal_weeks_mv
213: --- so that we can merge msc_item_kpi_f with msc_item_inventory_f
214: -------------------------------------------------------------------
215: l_stmt_id:=25;
216: select msc_hub_query_s.nextval into l_qid_hub_week from dual;
217: insert into msc_hub_query (
218: query_id,
219: last_update_date,
220: last_updated_by,

Line 247: select msc_hub_query_s.nextval into l_qid_bis_week from dual;

243:
244:
245:
246: l_stmt_id:=26;
247: select msc_hub_query_s.nextval into l_qid_bis_week from dual;
248: insert into msc_hub_query (
249: query_id,
250: last_update_date,
251: last_updated_by,

Line 275: select msc_hub_query_s.nextval into l_qid_week_map from dual;

271: --- find the mapping between bis week and mfg week
272: ----------------------------------------------------------------------------
273:
274: l_stmt_id:=27;
275: select msc_hub_query_s.nextval into l_qid_week_map from dual;
276: insert into msc_hub_query (
277: query_id,
278: last_update_date,
279: last_updated_by,

Line 315: select msc_hub_query_s.nextval into l_qid_last_date1 from dual;

311: -- about 100 rows max
312: --------------------------------------------------------------------
313:
314: l_stmt_id :=30;
315: select msc_hub_query_s.nextval into l_qid_last_date1 from dual;
316:
317: insert into msc_hub_query (
318: query_id,
319: last_update_date,

Line 339: from dual

335: from msc_phub_fiscal_periods_mv bp
336: where bp.end_date between l_first_bkt_start_date and l_last_bkt_end_date
337: union
338: select l_qid_last_date1, l_sysdate, 1, l_sysdate, 1, 1, trunc(l_last_bkt_end_date)
339: from dual
340: order by 1;
341:
342: --dbms_output.put_line(l_stmt_id||', l_qid_last_Date1='||l_qid_last_Date1||', count='||sql%rowcount);
343: commit;

Line 357: select msc_hub_query_s.nextval into l_qid_last_date from dual;

353: -----------------------------------------------------------------
354:
355:
356: l_stmt_id :=35;
357: select msc_hub_query_s.nextval into l_qid_last_date from dual;
358:
359:
360: insert into msc_hub_query (
361: query_id,

Line 395: select msc_hub_query_s.nextval into l_qid_mil_item from dual;

391: -- is included
392: -----------------------------------------------------------
393:
394: l_stmt_id :=40;
395: select msc_hub_query_s.nextval into l_qid_mil_item from dual;
396:
397: for c in c_plan_orgs
398: loop
399: insert into msc_hub_query (

Line 484: select msc_hub_query_s.nextval into l_qid_sd_item from dual;

480: -- is included
481: -----------------------------------------------------------
482:
483: l_stmt_id :=50;
484: select msc_hub_query_s.nextval into l_qid_sd_item from dual;
485:
486:
487: insert into msc_hub_query
488: (query_id,

Line 562: select msc_hub_query_s.nextval into l_qid_pab_item from dual;

558:
559:
560: -----------------------------------------------------------------------------
561: l_stmt_id :=55;
562: select msc_hub_query_s.nextval into l_qid_pab_item from dual;
563:
564: insert into msc_hub_query
565: (query_id,
566: last_update_date,

Line 645: select msc_hub_query_s.nextval into l_qid_pab from dual;

641: --------------------------------------------------------------------
642:
643:
644: l_stmt_id :=60;
645: select msc_hub_query_s.nextval into l_qid_pab from dual;
646:
647:
648: insert into msc_hub_query (
649: query_id,

Line 904: select msc_hub_query_s.nextval into l_qid_ss_item from dual;

900: --
901: ------------------------------------------------------------
902:
903: l_stmt_id :=70;
904: select msc_hub_query_s.nextval into l_qid_ss_item from dual;
905:
906: insert into msc_hub_query
907: (query_id,
908: last_update_date,

Line 975: select msc_hub_query_s.nextval into l_qid_ss from dual;

971: --------------------------------------------------------------------
972:
973:
974: l_stmt_id :=80;
975: select msc_hub_query_s.nextval into l_qid_ss from dual;
976:
977:
978: insert into msc_hub_query (
979: query_id,

Line 1033: select msc_hub_query_s.nextval into l_qid_others from dual;

1029: ---------------------------------------------------------------------------
1030: --- calculate daily demand
1031: ---------------------------------------------------------------------------
1032: l_stmt_id :=90;
1033: select msc_hub_query_s.nextval into l_qid_others from dual;
1034:
1035:
1036: insert into msc_hub_query (
1037: query_id,