APPS.MSC_DRP_HORI_PLAN dependencies on MSC_FORM_QUERY

Line 243: FROM msc_form_query mfq,

239: nvl(ms.firm_quantity,ms.new_order_quantity)) *
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

Line 374: FROM msc_form_query mfq,

370: nvl(old_using_requirement_quantity,0),
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

Line 467: msc_form_query mfq

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
470: AND msi.organization_id = ms.source_organization_id
471: AND msi.sr_instance_id = ms.sr_instance_id

Line 512: FROM msc_form_query mfq,

508: sum(nvl(md.firm_quantity,nvl(md.old_using_requirement_quantity,md.using_requirement_quantity)) *
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

Line 553: msc_form_query mfq

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
557: AND safety.plan_id = mfq.number4

Line 587: msc_form_query mfq

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
591: AND mil.plan_id = mfq.number4

Line 620: FROM msc_form_query mfq

616: 0 weight,
617: 0 volume,
618: 0 quantity2,
619: 0 quantity3
620: FROM msc_form_query mfq
621: WHERE mfq.query_id = arg_query_id
622: AND mfq.number7 <> NODE_GL_FORECAST_ITEM
623: ORDER BY
624: 1, 2, 3,7,8,4,5,6;

Line 874: msc_form_query mfq

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
878: AND msi.sr_instance_id = mfq.number3

Line 1596: from msc_form_query

1592: p_delimeter varchar2(1) := '|';
1593:
1594: CURSOR name_c IS
1595: select char1, char2
1596: from msc_form_query
1597: where query_id = p_query_id
1598: and number5 = p_item_id
1599: and number6 = p_org_id
1600: and number3 = p_inst_id;

Line 1605: msc_form_query mfq_item,

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
1609: and md.organization_id = mfq_item.number2

Line 1628: msc_form_query mfq_item,

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
1632: and md.organization_id = mfq_item.number2