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

Line 90: select msc_hub_query_s.nextval into l_qid_req from dual;

86: l_plan_type := msc_phub_util.get_plan_type(p_plan_id);
87: --dbms_output.put_line('populate_details '||p_plan_id||', '||p_plan_run_id||', '||l_plan_type);
88:
89: l_stmt_id:=10;
90: select msc_hub_query_s.nextval into l_qid_req from dual;
91: insert into msc_hub_query(
92: query_id,
93: last_update_date,
94: last_updated_by,

Line 91: insert into msc_hub_query(

87: --dbms_output.put_line('populate_details '||p_plan_id||', '||p_plan_run_id||', '||l_plan_type);
88:
89: l_stmt_id:=10;
90: select msc_hub_query_s.nextval into l_qid_req from dual;
91: insert into msc_hub_query(
92: query_id,
93: last_update_date,
94: last_updated_by,
95: creation_date,

Line 283: select msc_hub_query_s.nextval into l_qid_avail_org from dual;

279: commit;
280:
281:
282: l_stmt_id:=20;
283: select msc_hub_query_s.nextval into l_qid_avail_org from dual;
284: insert into msc_hub_query(
285: query_id,
286: last_update_date,
287: last_updated_by,

Line 284: insert into msc_hub_query(

280:
281:
282: l_stmt_id:=20;
283: select msc_hub_query_s.nextval into l_qid_avail_org from dual;
284: insert into msc_hub_query(
285: query_id,
286: last_update_date,
287: last_updated_by,
288: creation_date,

Line 394: select msc_hub_query_s.nextval into l_qid_avail_req from dual;

390: --dbms_output.put_line('l_stmt_id='|| l_stmt_id||' count=' || SQL%ROWCOUNT || ' l_qid_avail_org=' || l_qid_avail_org);
391: commit;
392:
393: l_stmt_id:=30;
394: select msc_hub_query_s.nextval into l_qid_avail_req from dual;
395: insert into msc_hub_query(
396: query_id,
397: last_update_date,
398: last_updated_by,

Line 395: insert into msc_hub_query(

391: commit;
392:
393: l_stmt_id:=30;
394: select msc_hub_query_s.nextval into l_qid_avail_req from dual;
395: insert into msc_hub_query(
396: query_id,
397: last_update_date,
398: last_updated_by,
399: creation_date,

Line 438: from msc_hub_query

434: number8 inventory_item_id,
435: date1 analysis_date,
436: sum(number10) required_qty,
437: to_number(null) avail_qty
438: from msc_hub_query
439: where query_id=l_qid_req
440: group by number3, number5, number6, number7, number8, date1
441:
442: union all

Line 452: from msc_hub_query

448: number8 inventory_item_id,
449: date1 analysis_date,
450: to_number(null) required_qty,
451: number20 avail_qty
452: from msc_hub_query
453: where query_id=l_qid_avail_org) t
454:
455: group by
456: t.sr_instance_id,

Line 467: select msc_hub_query_s.nextval into l_qid_avail_cum from dual;

463: --dbms_output.put_line('l_stmt_id='|| l_stmt_id||' count=' || SQL%ROWCOUNT || ' l_qid_avail_req=' || l_qid_avail_req);
464: commit;
465:
466: l_stmt_id:=40;
467: select msc_hub_query_s.nextval into l_qid_avail_cum from dual;
468: insert into msc_hub_query(
469: query_id,
470: last_update_date,
471: last_updated_by,

Line 468: insert into msc_hub_query(

464: commit;
465:
466: l_stmt_id:=40;
467: select msc_hub_query_s.nextval into l_qid_avail_cum from dual;
468: insert into msc_hub_query(
469: query_id,
470: last_update_date,
471: last_updated_by,
472: creation_date,

Line 514: from msc_hub_query where query_id=l_qid_avail_req),

510: number8 inventory_item_id,
511: date1 analysis_date
512: from
513: (select distinct number3, number5, number6, number7, number8
514: from msc_hub_query where query_id=l_qid_avail_req),
515:
516: (select distinct date1 from msc_hub_query where query_id=l_qid_avail_req)
517: ) k,
518:

Line 516: (select distinct date1 from msc_hub_query where query_id=l_qid_avail_req)

512: from
513: (select distinct number3, number5, number6, number7, number8
514: from msc_hub_query where query_id=l_qid_avail_req),
515:
516: (select distinct date1 from msc_hub_query where query_id=l_qid_avail_req)
517: ) k,
518:
519: (select
520: number3 sr_instance_id,

Line 529: from msc_hub_query

525: date1 analysis_date,
526: number10 required_qty,
527: number20 avail_qty,
528: number21 net_avail_qty
529: from msc_hub_query
530: where query_id=l_qid_avail_req) f2
531:
532: where k.sr_instance_id = f2.sr_instance_id(+)
533: and k.supplier_id = f2.supplier_id(+)

Line 622: from msc_hub_query

618: number13 po_cancel_count,
619: number14 buy_order_value,
620: number15 buy_order_value2,
621: number16 buy_order_count
622: from msc_hub_query
623: where query_id=l_qid_req) f1,
624:
625: (select
626: number3 sr_instance_id,

Line 638: from msc_hub_query where query_id=l_qid_avail_cum),

634: number21 net_avail_qty,
635: number22 net_avail_qty_cum
636: from
637: (select distinct number3, number5, number6, number7, number8, date1, number20, number21, number22
638: from msc_hub_query where query_id=l_qid_avail_cum),
639:
640: (select distinct number4 from msc_hub_query where query_id in (l_qid_req, l_qid_avail_org))
641: ) f2
642:

Line 640: (select distinct number4 from msc_hub_query where query_id in (l_qid_req, l_qid_avail_org))

636: from
637: (select distinct number3, number5, number6, number7, number8, date1, number20, number21, number22
638: from msc_hub_query where query_id=l_qid_avail_cum),
639:
640: (select distinct number4 from msc_hub_query where query_id in (l_qid_req, l_qid_avail_org))
641: ) f2
642:
643: where f2.sr_instance_id = f1.sr_instance_id(+)
644: and f2.organization_id = f1.organization_id(+)