APPS.MSC_GET_NAME dependencies on MSC_SYSTEM_ITEMS

Line 719: FROM msc_system_items

715: arg_instance_id IN NUMBER) return varchar2 IS
716: item_description varchar2(240);
717: CURSOR item_desc IS
718: SELECT description
719: FROM msc_system_items
720: WHERE inventory_item_id = arg_item_id
721: AND plan_id = arg_plan_id
722: AND sr_instance_id = arg_instance_id
723: AND (new_plan_id = -1 OR new_plan_id IS NULL )

Line 736: from msc_system_items

732: end if;
733: if arg_org_id is not null and arg_org_id > 0 then
734: select description
735: into item_description
736: from msc_system_items
737: where inventory_item_id = arg_item_id
738: and plan_id = arg_plan_id
739: and organization_id = arg_org_id
740: and sr_instance_id = arg_instance_id

Line 1207: from msc_system_items

1203: end if;
1204:
1205: select item_name
1206: into v_item_name
1207: from msc_system_items
1208: where inventory_item_id = arg_item_id
1209: and plan_id = arg_plan_id
1210: and organization_id = arg_org_id
1211: and sr_instance_id = arg_instance_id

Line 1229: from MSC_SYSTEM_ITEMS

1225: --For SRP
1226: FUNCTION item_name(arg_item_id IN NUMBER) return varchar2 IS
1227: CURSOR ITEM_CUR(P_INV_ITEM_ID IN NUMBER) IS
1228: select ITEM_NAME
1229: from MSC_SYSTEM_ITEMS
1230: WHERE INVENTORY_ITEM_ID = P_INV_ITEM_ID
1231: AND PLAN_ID =-1;
1232:
1233: L_ITEM_NAME VARCHAR2(250);

Line 1257: from msc_system_items

1253: end if;
1254:
1255: select planner_code
1256: into v_planner_code
1257: from msc_system_items
1258: where inventory_item_id = arg_item_id
1259: and plan_id = arg_plan_id
1260: and organization_id = arg_org_id
1261: and sr_instance_id = arg_instance_id

Line 1468: msc_system_items msi

1464: ms.firm_quantity,ms.plan_id,
1465: msi.critical_component_flag, msi.mrp_planning_code,
1466: msi.lots_exist)
1467: from msc_supplies ms,
1468: msc_system_items msi
1469: where ms.plan_id = p_plan_id
1470: and ms.transaction_id = p_tran_id
1471: and ms.sr_instance_id = p_inst_id
1472: and ms.plan_id = msi.plan_id

Line 1518: msc_system_items msi,

1514: cursor transfer_order_ok_to_release is
1515: Select 1
1516: from
1517: msc_supplies ms,
1518: msc_system_items msi,
1519: msc_trading_partners mtp
1520: where
1521: ms.transaction_id = arg_trx_id
1522: and ms.plan_id =arg_plan_id

Line 2527: from msc_demands dem, msc_system_items msi

2523: dem.forecast_set_id ),
2524: msc_get_name.scenario_designator(dem.forecast_set_id, dem.plan_id, dem.organization_id, dem.sr_instance_id)
2525: || 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 )))),
2526: msc_get_name.designator(dem.schedule_designator_id))) order_number
2527: from msc_demands dem, msc_system_items msi
2528: where dem.plan_id = p_plan_id
2529: and dem.sr_instance_id = p_inst_id
2530: and dem.demand_id = p_demand_id
2531: AND dem.plan_id = msi.plan_id

Line 2675: from msc_system_items

2671: cursor l_ss_method is
2672: select decode(safety_stock_code,
2673: 1,'Non-MRP Planned Percent',
2674: 2,'MRP Planned Percent',null)
2675: from msc_system_items
2676: where plan_id = p_plan_id
2677: and sr_instancE_id = p_inst_id
2678: and organization_id = p_org_id
2679: and inventory_item_id = p_item_id;

Line 3506: msc_system_items mif

3502:
3503: select (mif.unit_weight * mr.new_order_quantity)
3504: into l_req_capacity
3505: from msc_supplies mr,
3506: msc_system_items mif
3507: where mr.plan_id = mif.plan_id
3508: and mr.sr_instance_id = mif.sr_instance_id
3509: and mr.organization_id = mif.organization_id
3510: and mr.inventory_item_id = mif.inventory_item_id

Line 3545: from msc_system_items

3541:
3542: function get_bom_item_type(p_item_id in number) return number is
3543: cursor bom_item_c is
3544: select bom_item_type
3545: from msc_system_items
3546: where inventory_item_id = p_item_id
3547: and rownum < 2;
3548: l_bom_item_type number;
3549: begin

Line 4947: from msc_system_items

4943: p_organization_id in number,
4944: p_inventory_item_id in number)
4945: is
4946: select full_lead_time
4947: from msc_system_items
4948: where plan_id = p_plan_id
4949: and sr_instance_id = p_sr_instance_id
4950: and organization_id = p_organization_id
4951: and inventory_item_id = p_inventory_item_id;

Line 5262: from msc_system_items

5258: end if;
5259:
5260: select description
5261: into v_item_desc
5262: from msc_system_items
5263: where inventory_item_id = arg_item_id
5264: and plan_id = arg_plan_id
5265: and organization_id = arg_org_id
5266: and sr_instance_id = arg_instance_id

Line 5847: msc_system_items msi

5843: ms.firm_quantity,ms.plan_id,
5844: msi.critical_component_flag, msi.mrp_planning_code,
5845: msi.lots_exist)
5846: from msc_supplies ms,
5847: msc_system_items msi
5848: where ms.plan_id = p_plan_id
5849: and ms.transaction_id = p_tran_id
5850: and ms.sr_instance_id = p_inst_id
5851: and ms.plan_id = msi.plan_id