APPS.MSC_DRP_HORI_PLAN dependencies on MSC_SYSTEM_ITEMS

Line 244: msc_system_items msi,

240: nvl(msi.unit_volume,0)) volume,
241: sum(NVL(ms.old_order_quantity,0)*nvl(msi.unit_weight,0)) quantity2,
242: sum(NVL(ms.old_order_quantity,0)*nvl(msi.unit_volume,0)) quantity3
243: FROM msc_form_query mfq,
244: msc_system_items msi,
245: msc_supplies ms
246: WHERE ms.plan_id = msi.plan_id
247: AND ms.inventory_item_id = msi.inventory_item_id
248: AND ms.organization_id = msi.organization_id

Line 375: msc_system_items msi,

371: nvl(md.unmet_quantity,0)),
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

Line 465: FROM msc_system_items msi,

461: sum(nvl(ms.firm_quantity,ms.new_order_quantity) *
462: nvl(msi.unit_volume,0)) volume,
463: 0 quantity2,
464: 0 quantity3
465: FROM msc_system_items msi,
466: msc_supplies ms,
467: msc_form_query mfq
468: WHERE msi.plan_id = ms.plan_id
469: AND msi.inventory_item_id = ms.inventory_item_id

Line 513: msc_system_items msi,

509: nvl(msi.unit_volume,0)) volume,
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

Line 552: msc_system_items msi,

548: sum(safety.safety_stock_quantity * nvl(msi.unit_volume,0)) volume,
549: 0 quantity2,
550: 0 quantity3
551: FROM msc_safety_stocks safety,
552: msc_system_items msi,
553: msc_form_query mfq
554: WHERE trunc(safety.period_start_date) <= last_date
555: AND safety.organization_id = mfq.number2
556: AND safety.sr_instance_id = mfq.number3

Line 586: msc_system_items msi,

582: sum(nvl(mil.max_quantity,0) * nvl(msi.unit_volume,0)) volume,
583: sum(nvl(mil.target_quantity,0) * nvl(msi.unit_weight,0)) quantity2,
584: sum(nvl(mil.target_quantity,0) * nvl(msi.unit_volume,0)) quantity3
585: FROM msc_inventory_levels mil,
586: msc_system_items msi,
587: msc_form_query mfq
588: WHERE trunc(mil.inventory_date) <= last_date
589: AND mil.organization_id = mfq.number2
590: AND mil.sr_instance_id = mfq.number3

Line 873: FROM msc_system_items msi,

869: committed_demand number;
870:
871: cursor check_atp is
872: SELECT msi.calculate_atp
873: FROM msc_system_items msi,
874: msc_form_query mfq
875: WHERE msi.inventory_item_id = mfq.number1
876: AND msi.organization_id = mfq.number2
877: AND msi.plan_id = arg_plan_id