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_DEMAND_PKG dependencies on MSC_HUB_QUERY

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

102: l_stmt_id :=10;
103: ----------------------------------------------------
104:
105:
106: select msc_hub_query_s.nextval into l_qid_vmi from dual;
107:
108: insert into msc_hub_query(
109:
110: query_id,

Line 108: insert into msc_hub_query(

104:
105:
106: select msc_hub_query_s.nextval into l_qid_vmi from dual;
107:
108: insert into msc_hub_query(
109:
110: query_id,
111: last_update_date,
112: last_updated_by,

Line 703: msc_hub_query f_1

699: msi_1.list_price,
700: msi_1.AVERAGE_DISCOUNT,
701: nvl(f_1.number10,0) vmi_flag
702: from msc_system_items msi_1,
703: msc_hub_query f_1
704: where f_1.query_id(+) = l_qid_vmi
705: and f_1.number1(+) = msi_1.plan_id
706: and f_1.number3(+) = msi_1.sr_instance_id
707: and f_1.number4(+) = msi_1.organization_id

Line 874: msc_hub_query f_2

870: msi_2.list_price,
871: msi_2.AVERAGE_DISCOUNT,
872: nvl(f_2.number10,0) vmi_flag
873: from msc_system_items msi_2,
874: msc_hub_query f_2
875: where f_2.query_id(+) = l_qid_vmi
876: and f_2.number1(+) = msi_2.plan_id
877: and f_2.number3(+) = msi_2.sr_instance_id
878: and f_2.number4(+) = msi_2.organization_id

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

983:
984:
985:
986: l_stmt_id :=30;
987: select msc_hub_query_s.nextval into l_qid_last_date from dual;
988:
989: insert into msc_hub_query (
990: query_id,
991: last_update_date,

Line 989: insert into msc_hub_query (

985:
986: l_stmt_id :=30;
987: select msc_hub_query_s.nextval into l_qid_last_date from dual;
988:
989: insert into msc_hub_query (
990: query_id,
991: last_update_date,
992: last_updated_by,
993: creation_date,

Line 1021: select msc_hub_query_s.nextval into l_qid_demand_date from dual;

1017:
1018:
1019:
1020: l_stmt_id :=40;
1021: select msc_hub_query_s.nextval into l_qid_demand_date from dual;
1022:
1023:
1024: insert into msc_hub_query (
1025: query_id,

Line 1024: insert into msc_hub_query (

1020: l_stmt_id :=40;
1021: select msc_hub_query_s.nextval into l_qid_demand_date from dual;
1022:
1023:
1024: insert into msc_hub_query (
1025: query_id,
1026: last_update_date,
1027: last_updated_by,
1028: creation_date,

Line 1047: select msc_hub_query_s.nextval into l_qid_demand_item from dual;

1043: commit;
1044:
1045:
1046: l_stmt_id :=45;
1047: select msc_hub_query_s.nextval into l_qid_demand_item from dual;
1048: insert into msc_hub_query (
1049: query_id,
1050: last_update_date,
1051: last_updated_by,

Line 1048: insert into msc_hub_query (

1044:
1045:
1046: l_stmt_id :=45;
1047: select msc_hub_query_s.nextval into l_qid_demand_item from dual;
1048: insert into msc_hub_query (
1049: query_id,
1050: last_update_date,
1051: last_updated_by,
1052: creation_date,

Line 1099: select msc_hub_query_s.nextval into l_qid_dl_relation from dual;

1095:
1096:
1097:
1098: l_stmt_id :=50;
1099: select msc_hub_query_s.nextval into l_qid_dl_relation from dual;
1100:
1101: insert into msc_hub_query (
1102: query_id,
1103: last_update_date,

Line 1101: insert into msc_hub_query (

1097:
1098: l_stmt_id :=50;
1099: select msc_hub_query_s.nextval into l_qid_dl_relation from dual;
1100:
1101: insert into msc_hub_query (
1102: query_id,
1103: last_update_date,
1104: last_updated_by,
1105: creation_date,

Line 1115: (select max(d.date1) from msc_hub_query d

1111: select
1112: unique l_qid_dl_relation,
1113: l_sysdate,1,l_sysdate,1,1,
1114: l.date1,
1115: (select max(d.date1) from msc_hub_query d
1116: where d.query_id=l_qid_demand_date
1117: and d.date1<=l.date1)
1118: from msc_hub_query l where l.query_id=l_qid_last_date;
1119:

Line 1118: from msc_hub_query l where l.query_id=l_qid_last_date;

1114: l.date1,
1115: (select max(d.date1) from msc_hub_query d
1116: where d.query_id=l_qid_demand_date
1117: and d.date1<=l.date1)
1118: from msc_hub_query l where l.query_id=l_qid_last_date;
1119:
1120:
1121:
1122: --dbms_output.put_line('l_stmt_id='|| l_stmt_id||' count=' || SQL%ROWCOUNT || ' dl=' || l_qid_dl_relation);

Line 1255: msc_hub_query last_date,

1251: cum.demand_class,cum.customer_id,cum.customer_site_id,cum.region_id
1252: order by last_date.date1) cum_constrained_fcst_value2
1253:
1254: from
1255: msc_hub_query last_date,
1256: (
1257: select
1258: demand_item.number1 plan_id,
1259: demand_item.number2 plan_run_id,

Line 1334: from msc_hub_query item,

1330: item.char1,
1331: demand_date.date1,
1332: item.number9,
1333: item.number10
1334: from msc_hub_query item,
1335: msc_hub_query demand_date
1336: where item.query_id=l_qid_Demand_item
1337: and demand_date.query_id = l_qid_demand_date) demand_item
1338: where demand_item.date1 = t1.order_date(+)

Line 1335: msc_hub_query demand_date

1331: demand_date.date1,
1332: item.number9,
1333: item.number10
1334: from msc_hub_query item,
1335: msc_hub_query demand_date
1336: where item.query_id=l_qid_Demand_item
1337: and demand_date.query_id = l_qid_demand_date) demand_item
1338: where demand_item.date1 = t1.order_date(+)
1339: and demand_item.number1 = t1.plan_id(+)