[Home] [Help]
589: arg_instance_id IN NUMBER) return varchar2 IS
590: item_description varchar2(240);
591: CURSOR item_desc IS
592: SELECT description
593: FROM msc_system_items
594: WHERE inventory_item_id = arg_item_id
595: AND plan_id = arg_plan_id
596: AND sr_instance_id = arg_instance_id;
597:
604: end if;
605: if arg_org_id is not null and arg_org_id > 0 then
606: select description
607: into item_description
608: from msc_system_items
609: where inventory_item_id = arg_item_id
610: and plan_id = arg_plan_id
611: and organization_id = arg_org_id
612: and sr_instance_id = arg_instance_id;
1073: end if;
1074:
1075: select item_name
1076: into v_item_name
1077: from msc_system_items
1078: where inventory_item_id = arg_item_id
1079: and plan_id = arg_plan_id
1080: and organization_id = arg_org_id
1081: and sr_instance_id = arg_instance_id;
1093: --For SRP
1094: FUNCTION item_name(arg_item_id IN NUMBER) return varchar2 IS
1095: CURSOR ITEM_CUR(P_INV_ITEM_ID IN NUMBER) IS
1096: select ITEM_NAME
1097: from MSC_SYSTEM_ITEMS
1098: WHERE INVENTORY_ITEM_ID = P_INV_ITEM_ID
1099: AND PLAN_ID =-1;
1100:
1101: L_ITEM_NAME VARCHAR2(250);
1121: end if;
1122:
1123: select planner_code
1124: into v_planner_code
1125: from msc_system_items
1126: where inventory_item_id = arg_item_id
1127: and plan_id = arg_plan_id
1128: and organization_id = arg_org_id
1129: and sr_instance_id = arg_instance_id;
1259: ms.firm_quantity,ms.plan_id,
1260: msi.critical_component_flag, msi.mrp_planning_code,
1261: msi.lots_exist)
1262: from msc_supplies ms,
1263: msc_system_items msi
1264: where ms.plan_id = p_plan_id
1265: and ms.transaction_id = p_tran_id
1266: and ms.sr_instance_id = p_inst_id
1267: and ms.plan_id = msi.plan_id
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
2269: cursor l_ss_method is
2270: select decode(safety_stock_code,
2271: 1,'Non-MRP Planned Percent',
2272: 2,'MRP Planned Percent',null)
2273: from msc_system_items
2274: where plan_id = p_plan_id
2275: and sr_instancE_id = p_inst_id
2276: and organization_id = p_org_id
2277: and inventory_item_id = p_item_id;
3076:
3077: select (mif.unit_weight * mr.new_order_quantity)
3078: into l_req_capacity
3079: from msc_supplies mr,
3080: msc_system_items mif
3081: where mr.plan_id = mif.plan_id
3082: and mr.sr_instance_id = mif.sr_instance_id
3083: and mr.organization_id = mif.organization_id
3084: and mr.inventory_item_id = mif.inventory_item_id
3113:
3114: function get_bom_item_type(p_item_id in number) return number is
3115: cursor bom_item_c is
3116: select bom_item_type
3117: from msc_system_items
3118: where inventory_item_id = p_item_id
3119: and rownum < 2;
3120: l_bom_item_type number;
3121: begin
4450: p_organization_id in number,
4451: p_inventory_item_id in number)
4452: is
4453: select full_lead_time
4454: from msc_system_items
4455: where plan_id = p_plan_id
4456: and sr_instance_id = p_sr_instance_id
4457: and organization_id = p_organization_id
4458: and inventory_item_id = p_inventory_item_id;
4747: end if;
4748:
4749: select description
4750: into v_item_desc
4751: from msc_system_items
4752: where inventory_item_id = arg_item_id
4753: and plan_id = arg_plan_id
4754: and organization_id = arg_org_id
4755: and sr_instance_id = arg_instance_id;