APPS.MSC_DEMAND_PKG dependencies on MSC_DEMANDS_CUM_F

Line 6: create table msc.msc_demands_cum_f (

2: /* $Header: MSCHBDEB.pls 120.40.12010000.5 2008/09/03 14:38:50 wexia ship $ */
3:
4:
5: /*
6: create table msc.msc_demands_cum_f (
7: PLAN_ID number NOT NULL,
8: PLAN_RUN_ID number NOT NULL,
9: SR_INSTANCE_ID number NOT NULL,
10: ORGANIZATION_ID number NOT NULL,

Line 22: create unique index msc.msc_demands_cum_f_n1 on msc.msc_demands_cum_f(

18: cum_sales_order_qty number,
19: cum_forecast_qty number);
20:
21:
22: create unique index msc.msc_demands_cum_f_n1 on msc.msc_demands_cum_f(
23: plan_id,plan_run_id,sr_instance_id,organization_id,inventory_item_id,
24: customer_id,customer_site_id,demand_class,order_date);
25:
26:

Line 1127: insert into msc_demands_cum_f (

1123: commit;
1124:
1125:
1126: l_stmt_id :=60;
1127: insert into msc_demands_cum_f (
1128: CREATED_BY,
1129: CREATION_DATE,
1130: LAST_UPDATED_BY,
1131: LAST_UPDATE_DATE,

Line 1510: insert into msc_demands_cum_f (

1506:
1507: commit;
1508:
1509: -- level 1
1510: insert into msc_demands_cum_f (
1511: plan_id, plan_run_id,
1512: io_plan_flag,
1513: sr_instance_id, organization_id, inventory_item_id,
1514: vmi_flag,

Line 1555: msc_demands_cum_f f,

1551: sysdate, fnd_global.user_id, fnd_global.login_id,
1552: fnd_global.conc_program_id, fnd_global.conc_login_id,
1553: fnd_global.prog_appl_id, fnd_global.conc_request_id
1554: from
1555: msc_demands_cum_f f,
1556: msc_phub_item_categories_mv q
1557: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
1558: and f.aggr_type=0
1559: and f.owning_inst_id=q.sr_instance_id(+)