372: using_requirement_quantity) *
373: nvl(msi.unit_volume,0)) quantity3 -- unconstr volume
374: FROM msc_form_query mfq,
375: msc_system_items msi,
376: msc_demands md
377: WHERE md.plan_id = mfq.number4
378: AND md.inventory_item_id = mfq.number1
379: AND md.organization_id = mfq.number2
380: AND md.sr_instance_id = mfq.number3
489: PURCH_REQ,PLANNED_SHIPMENT_OFF,
490: INTRANSIT_SHIPMENT, OUTBOUND_OFF),
491: ms.organization_id,
492: ms.new_ship_date
493: UNION ALL -- for requested arrival. in msc_demands, for request shipment
494: SELECT mfq.number5 item_id, -- source_org_id actually store dest org id
495: mfq.number6 org_id, -- while org_id store source org id
496: mfq.number3 inst_id,
497: REQUEST_ARRIVAL_OFF offset,
510: 0 quantity2,
511: 0 quantity3
512: FROM msc_form_query mfq,
513: msc_system_items msi,
514: msc_demands md
515: WHERE md.plan_id = mfq.number4
516: AND md.inventory_item_id = mfq.number1
517: AND md.source_organization_id = mfq.number2
518: AND md.sr_instance_id = mfq.number3
1600: and number3 = p_inst_id;
1601:
1602: CURSOR priority_c(p_start_date date, p_end_date date) IS
1603: select distinct md.demand_priority
1604: from msc_demands md,
1605: msc_form_query mfq_item,
1606: msc_plans mp
1607: where md.plan_id = p_plan_id
1608: and md.inventory_item_id = mfq_item.number1
1623:
1624: CURSOR demand_c(p_start_date date, p_end_date date) IS
1625: select md.demand_priority,
1626: sum(nvl(md.firm_quantity,md.using_requirement_quantity))
1627: from msc_demands md,
1628: msc_form_query mfq_item,
1629: msc_plans mp
1630: where md.plan_id = p_plan_id
1631: and md.inventory_item_id = mfq_item.number1