APPS.MSC_DRP_HORI_PLAN dependencies on MSC_PLANS

Line 159: FROM msc_plans

155: -- -------------------------------------------------
156: CURSOR plan_buckets IS
157: SELECT DECODE(arg_plan_id, -1, sysdate, trunc(plan_start_date)),
158: DECODE(arg_plan_id, -1, sysdate+365, trunc(curr_cutoff_date))
159: FROM msc_plans
160: WHERE plan_id = arg_plan_id;
161:
162: -- -------------------------------------------------
163: -- This cursor selects the dates for the buckets.

Line 1606: msc_plans mp

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
1610: and md.sr_instance_id = mfq_item.number3

Line 1629: msc_plans mp

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
1633: and md.sr_instance_id = mfq_item.number3