APPS.MSC_ITEM_PKG dependencies on MSC_ITEM_ORDERS_F

Line 1615: --- insert supply, demand activity into msc_item_orders_f table

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
1616: -------------------------------------------------------------------------------
1617:
1618: l_stmt_id :=110;
1619:

Line 1620: insert into msc_item_orders_f (

1616: -------------------------------------------------------------------------------
1617:
1618: l_stmt_id :=110;
1619:
1620: insert into msc_item_orders_f (
1621: CREATED_BY,
1622: CREATION_DATE,
1623: LAST_UPDATED_BY,
1624: LAST_UPDATE_DATE,

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

1897: order_tbl.inventory_item_id,
1898: order_tbl.vmi_flag,
1899: order_tbl.order_date;
1900:
1901: --dbms_output.put_line('msc_item_orders_f, count='||sql%rowcount);
1902: commit;
1903:
1904: populate_summary(errbuf, retcode, p_plan_id, p_plan_run_id);
1905:

Line 2026: insert into msc_item_orders_f (

2022:
2023: commit;
2024:
2025: -- level 1
2026: insert into msc_item_orders_f (
2027: plan_id, plan_run_id, io_plan_flag,
2028: sr_instance_id, organization_id, owning_inst_id, owning_org_id,
2029: inventory_item_id,
2030: vmi_flag, order_date,

Line 2090: msc_item_orders_f f,

2086: sysdate, fnd_global.user_id, fnd_global.login_id,
2087: fnd_global.conc_program_id, fnd_global.conc_login_id,
2088: fnd_global.prog_appl_id, fnd_global.conc_request_id
2089: from
2090: msc_item_orders_f f,
2091: msc_phub_item_categories_mv q
2092: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
2093: and f.aggr_type=0
2094: and f.owning_inst_id=q.sr_instance_id(+)

Line 2171: delete /*+ PARALLEL(mos) */ from msc_item_orders_f

2167:
2168:
2169: while true loop
2170: l_stmt_id :=11;
2171: delete /*+ PARALLEL(mos) */ from msc_item_orders_f
2172: where rownum<=p_commit_size and plan_id=p_plan_id and plan_run_id=nvl(p_plan_run_id,plan_run_id);
2173: l_stmt_id:=12;
2174: commit;
2175: -- exit when there are no more rows to delete.

Line 2177: select count(1) into l_num from msc_item_orders_f

2173: l_stmt_id:=12;
2174: commit;
2175: -- exit when there are no more rows to delete.
2176: l_stmt_id:=13;
2177: select count(1) into l_num from msc_item_orders_f
2178: where plan_id=p_plan_id and plan_run_id=nvl(p_plan_run_id,plan_run_id);
2179: if (l_num=0) then
2180: commit;
2181: exit;