[Home] [Help]
1506: and ms.transaction_id = p_supply_id;
1507:
1508: CURSOR type_of_plan(p_plan_id number) IS
1509: select plan_type
1510: from msc_plans
1511: where plan_id = p_plan_id;
1512:
1513:
1514: cursor transfer_order_ok_to_release is
1574:
1575: CURSOR bkt_c(p_date date) IS
1576: select bucket_index
1577: from msc_plan_buckets mpb,
1578: msc_plans mp
1579: where mp.plan_id = arg_plan_id
1580: and mp.plan_id = mpb.plan_id
1581: and mp.organization_id = mpb.organization_id
1582: and mp.sr_instance_id = mpb.sr_instance_id
2400: FUNCTION plan_name(p_plan_id number) return varchar2 IS
2401:
2402: CURSOR plan_name_cur IS
2403: SELECT compile_designator
2404: FROM msc_plans
2405: WHERE plan_id = p_plan_id;
2406: l_plan_name varchar2(30);
2407:
2408: BEGIN
2752:
2753: CURSOR forward_backward_days_c2 IS
2754: SELECT curr_FORWARD_days,
2755: curr_BACKWARD_days
2756: FROM msc_plans
2757: WHERE plan_id = p_plan_id;
2758:
2759: l_forward_days number;
2760: l_backward_days number;
5871: md.source_org_instance_id <> md.sr_instance_id));
5872:
5873: CURSOR type_of_plan(p_plan_id number) IS
5874: select plan_type
5875: from msc_plans
5876: where plan_id = p_plan_id;
5877:
5878:
5879: l_action Number;
5886:
5887: CURSOR bkt_c(p_date date) IS
5888: select bucket_index
5889: from msc_plan_buckets mpb,
5890: msc_plans mp
5891: where mp.plan_id = arg_plan_id
5892: and mp.plan_id = mpb.plan_id
5893: and mp.organization_id = mpb.organization_id
5894: and mp.sr_instance_id = mpb.sr_instance_id
6262: MSC_SUPPLIES SUPPLIES,
6263: MSC_FULL_PEGGING PEGGING,
6264: MSC_DEMANDS DEMANDS,
6265: MSC_BOM_COMPONENTS COMPONENTS,
6266: MSC_PLANS PLANS
6267: WHERE
6268: supplies.transaction_id=pegging.transaction_id and
6269: SUPPLIES.SR_INSTANCE_ID = pegging.sr_instance_id and
6270: supplies.organization_id=pegging.organization_id and