APPS.MSC_ITEM_PKG dependencies on MSC_ITEM_INVENTORY_F

Line 213: --- so that we can merge msc_item_kpi_f with msc_item_inventory_f

209:
210:
211: ------------------------------------------------------------------------
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 (

Line 1075: --- insert pab,ss,min/max inventory into msc_item_inventory_f table

1071: --dbms_output.put_line(l_stmt_id||', l_qid_others='||l_qid_others||', count='||sql%rowcount);
1072: commit;
1073:
1074: --------------------------------------------------------------------------------
1075: --- insert pab,ss,min/max inventory into msc_item_inventory_f table
1076: -------------------------------------------------------------------------------
1077:
1078: l_stmt_id :=100;
1079:

Line 1080: insert into msc_item_inventory_f (

1076: -------------------------------------------------------------------------------
1077:
1078: l_stmt_id :=100;
1079:
1080: insert into msc_item_inventory_f (
1081: CREATED_BY,
1082: CREATION_DATE,
1083: LAST_UPDATED_BY,
1084: LAST_UPDATE_DATE,

Line 1611: --dbms_output.put_line('msc_item_inventory_f, count='||sql%rowcount);

1607: pab_tbl.ship_method,
1608: pab_tbl.vmi_flag,
1609: pab_tbl.order_date;
1610:
1611: --dbms_output.put_line('msc_item_inventory_f, count='||sql%rowcount);
1612: commit;
1613:
1614: --------------------------------------------------------------------------------
1615: --- insert supply, demand activity into msc_item_orders_f table

Line 1941: insert into msc_item_inventory_f (

1937: is
1938: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
1939: begin
1940: -- level 1
1941: insert into msc_item_inventory_f (
1942: plan_id, plan_run_id, io_plan_flag,
1943: sr_instance_id, organization_id, owning_inst_id, owning_org_id,
1944: inventory_item_id,
1945: ship_method, vmi_flag, order_date,

Line 2009: msc_item_inventory_f f,

2005: sysdate, fnd_global.user_id, fnd_global.login_id,
2006: fnd_global.conc_program_id, fnd_global.conc_login_id,
2007: fnd_global.prog_appl_id, fnd_global.conc_request_id
2008: from
2009: msc_item_inventory_f f,
2010: msc_phub_item_categories_mv q
2011: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
2012: and f.aggr_type=0
2013: and f.owning_inst_id=q.sr_instance_id(+)

Line 2137: delete /*+ PARALLEL(mos) */ from msc_item_inventory_f

2133:
2134:
2135: while true loop
2136: l_stmt_id :=1;
2137: delete /*+ PARALLEL(mos) */ from msc_item_inventory_f
2138: where rownum<=p_commit_size and plan_id=p_plan_id and plan_run_id=nvl(p_plan_run_id,plan_run_id);
2139: l_stmt_id:=2;
2140: commit;
2141: -- exit when there are no more rows to delete.

Line 2143: select count(1) into l_num from msc_item_inventory_f

2139: l_stmt_id:=2;
2140: commit;
2141: -- exit when there are no more rows to delete.
2142: l_stmt_id:=3;
2143: select count(1) into l_num from msc_item_inventory_f
2144: where plan_id=p_plan_id and plan_run_id=nvl(p_plan_run_id,plan_run_id);
2145: if (l_num=0) then
2146: commit;
2147: exit;

Line 2154: delete /*+ PARALLEL(mos) */ from msc_item_inventory_f

2150:
2151:
2152: while true loop
2153: l_stmt_id :=1;
2154: delete /*+ PARALLEL(mos) */ from msc_item_inventory_f
2155: where rownum<=p_commit_size and plan_id=p_plan_id and plan_run_id=nvl(p_plan_run_id,plan_run_id);
2156: l_stmt_id:=2;
2157: commit;
2158: -- exit when there are no more rows to delete.

Line 2160: select count(1) into l_num from msc_item_inventory_f

2156: l_stmt_id:=2;
2157: commit;
2158: -- exit when there are no more rows to delete.
2159: l_stmt_id:=3;
2160: select count(1) into l_num from msc_item_inventory_f
2161: where plan_id=p_plan_id and plan_run_id=nvl(p_plan_run_id,plan_run_id);
2162: if (l_num=0) then
2163: commit;
2164: exit;