[Home] [Help]
138: END IF;
139:
140: select md.using_assembly_demand_date
141: into var_date
142: from msc_demands md,
143: msc_full_pegging mfp
144: where mfp.pegging_id = arg_pegging_id
145: and mfp.plan_id=arg_plan_id
146: and md.demand_id = mfp.demand_id
422: select order_number
423: from msc_supplies
424: where disposition_id in
425: (select disposition_id
426: from msc_demands
427: where plan_id = arg_plan_id
428: and demand_id = arg_disp_id)
429: and sr_instance_id = arg_instance_id
430: and plan_id = arg_plan_id
435: select wip_entity_name
436: from msc_supplies
437: where disposition_id in
438: (select disposition_id
439: from msc_demands
440: where plan_id = arg_plan_id
441: and demand_id = arg_disp_id)
442: and sr_instance_id = arg_instance_id
443: and plan_id = arg_plan_id
446:
447: cursor designator_c is
448: select desig.designator
449: from msc_designators desig,
450: msc_demands mgr
451: where desig.designator_id = mgr.schedule_designator_id
452: and mgr.demand_id = arg_disp_id
453: and mgr.sr_instance_id = arg_instance_id
454: and mgr.plan_id = arg_plan_id
456:
457:
458: BEGIN
459: -- note : arg_disp_id contains the demand_id,
460: -- since plan_id, org, instance, disposition cannot be unique in msc_demands
461: --bug 2038727
462:
463: if ((arg_demand_type is NULL and arg_supply_type is NULL) or
464: arg_disp_id is null or
946: order_number varchar2(240);
947:
948: cursor C4 is
949: select sales_order_number
950: from msc_demands
951: where demand_id = arg_demand_id;
952: BEGIN
953: if arg_demand_id is null
954: then return null;
1272: CURSOR excp_exist(p_plan_id number,
1273: p_demand_id number) IS
1274: select 1
1275: from msc_exception_details med,
1276: msc_demands md
1277: where med.plan_id = md.plan_id
1278: and med.organization_id = md.organization_id
1279: and med.sr_instance_id = md.sr_instance_id
1280: and med.inventory_item_id = md.inventory_item_id
1457: -- Shikyu item
1458: RETURN l_action;
1459: END IF;
1460:
1461: if arg_source_table = 'MSC_DEMANDS' and
1462: arg_plan_id <> -1 and -- plan_id <> -1
1463: arg_order_type in (30,6) then -- sales order
1464: OPEN internal_sales(arg_plan_id, -- plan_id
1465: arg_base_item_id, -- disposition_id
1510: l_action := msc_get_name.lookup_meaning('MRP_ACTIONS',6);
1511: end if;
1512: end if; -- if arg_rescheduled_flag = 1
1513: end if; -- if v_temp = 2 then -- cancel
1514: end if; -- if arg_source_table = 'MSC_DEMANDS'
1515:
1516:
1517: END IF;
1518: return l_action;
1957: p_demand_id NUMBER) return number IS
1958:
1959: CURSOR dmd_cur IS
1960: SELECT order_priority
1961: FROM msc_demands
1962: WHERE plan_id = p_plan_id
1963: and demand_id = p_demand_id;
1964: l_priority number;
1965:
2073: l_group_id NUMBER;
2074:
2075: CURSOR grp_cur IS
2076: SELECT group_id
2077: FROM msc_demands
2078: WHERE plan_id = p_plan_id
2079: AND sr_instance_id = p_inst_id
2080: AND demand_id = p_demand_id;
2081:
2084: -- opening the expensive dmd_cur.
2085:
2086: CURSOR dmd_cur IS
2087: SELECT sum(using_requirement_quantity)
2088: FROM msc_demands
2089: WHERE plan_id = p_plan_id
2090: and sr_instance_id = p_inst_id
2091: and group_id = l_group_id;
2092:
2121: dem.forecast_set_id ),
2122: msc_get_name.scenario_designator(dem.forecast_set_id, dem.plan_id, dem.organization_id, dem.sr_instance_id)
2123: || decode(msc_get_name.designator(dem.schedule_designator_id,dem.forecast_set_id ), null, null, '/'||msc_get_name.designator(dem.schedule_designator_id,dem.forecast_set_id )))),
2124: msc_get_name.designator(dem.schedule_designator_id))) order_number
2125: from msc_demands dem, msc_system_items msi
2126: where dem.plan_id = p_plan_id
2127: and dem.sr_instance_id = p_inst_id
2128: and dem.demand_id = p_demand_id
2129: AND dem.plan_id = msi.plan_id
2297: forecast_set_id,plan_id,organization_id,sr_instance_id),
2298: msc_get_name.designator(schedule_designator_id)
2299: )
2300: )
2301: from msc_demands
2302: where plan_id = p_plan_id
2303: and demand_id = p_demand_id;
2304: BEGIN
2305: if p_plan_id is null or
3179:
3180: cursor c_dem (l_plan number, l_dem number) is
3181: select schedule_arrival_date, planned_arrival_date, promise_date, request_date
3182: ,using_assembly_demand_date, planned_ship_date, origination_type
3183: from msc_demands
3184: where plan_id = l_plan
3185: and demand_id = l_dem;
3186:
3187: l_sched_arrival date;
4528: END check_cfm;
4529:
4530: FUNCTION load_type ( p_plan_type IN NUMBER
4531: , p_plan_id IN NUMBER
4532: , p_source_table IN VARCHAR2 -- MSC_SUPPLIES or MSC_DEMANDS
4533: , p_transaction_id IN NUMBER -- or demand_id
4534: , p_organization_id IN NUMBER
4535: , p_sr_instance_id IN NUMBER -- not reqd, but can hit U1 index with this
4536: , p_order_type IN NUMBER
4547:
4548: -- IRproject
4549: cursor iso_exists IS
4550: select 1
4551: from msc_demands
4552: where disposition_id = p_transaction_id
4553: and plan_id = p_plan_id
4554: and organization_id = p_source_organization_id
4555: and sr_instance_id = p_sr_instance_id;
4560: where plan_id = p_plan_id
4561: and sr_instance_id = p_sr_instance_id
4562: and transaction_id in
4563: (select disposition_id
4564: from msc_demands
4565: where demand_id = p_transaction_id
4566: and plan_id = p_plan_id
4567: and organization_id = p_organization_id
4568: and sr_instance_id = p_sr_instance_id) ;
4688: END IF;
4689: END IF; -- IF p_plan_type in (8)
4690: --pabram.srp.release.changes.ends
4691:
4692: ELSE -- p_source_table = 'MSC_DEMANDS'
4693: IF p_order_type in (30) THEN
4694: -- v_load_type := 30;
4695: IF p_plan_type = 1 THEN -- ASCP
4696: open ir_exists;