eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ITEM_PKG dependencies on MSC_HUB_QUERY_S

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 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,

Line 1282: from msc_hub_query ss,

1278: to_number(null) tp_cost,
1279: to_number(null) carrying_cost,
1280: to_number(null) total_cost,
1281: to_number(null) inv_build_target
1282: from msc_hub_query ss,
1283: msc_hub_query ss_last,
1284: msc_trading_partners ss_mtp
1285: where ss.query_id = l_qid_ss
1286: and ss_last.query_id =l_qid_last_date

Line 1283: msc_hub_query ss_last,

1279: to_number(null) carrying_cost,
1280: to_number(null) total_cost,
1281: to_number(null) inv_build_target
1282: from msc_hub_query ss,
1283: msc_hub_query ss_last,
1284: msc_trading_partners ss_mtp
1285: where ss.query_id = l_qid_ss
1286: and ss_last.query_id =l_qid_last_date
1287: and ss_last.date2 = ss.date1 -- for each last day,pick out its bkt_start_date

Line 1747: from msc_hub_query sd,

1743: --------------------------------------------------------------
1744: to_number(null) no_activity_item_count,
1745: to_number(null) stock_outs_count
1746:
1747: from msc_hub_query sd,
1748: msc_hub_query sd_item,
1749: msc_hub_query others
1750: where sd.query_id =l_qid_pab
1751: and sd_item.query_id =l_qid_sd_item

Line 1748: msc_hub_query sd_item,

1744: to_number(null) no_activity_item_count,
1745: to_number(null) stock_outs_count
1746:
1747: from msc_hub_query sd,
1748: msc_hub_query sd_item,
1749: msc_hub_query others
1750: where sd.query_id =l_qid_pab
1751: and sd_item.query_id =l_qid_sd_item
1752: and sd.number1 = sd_item.number1