APPS.MSC_HORIZONTAL_PLAN_SC dependencies on MSC_SYSTEM_ITEMS

Line 369: msc_system_items msi,

365: sum(0) dos,
366: 0 cost
367: FROM msc_form_query list,
368: msc_trading_partners param,
369: msc_system_items msi,
370: msc_supplies rec,
371: msc_calendar_dates dates
372: WHERE (arg_res_level = 1
373: OR (arg_res_level = 2

Line 735: msc_system_items item

731: sum(safety.achieved_days_of_supply) dos,
732: sum(safety.safety_stock_quantity * item.standard_cost) cost
733: FROM msc_safety_stocks safety,
734: msc_form_query list ,
735: msc_system_items item
736: WHERE safety.period_start_date <= last_date
737: AND safety.organization_id = list.number2
738: AND safety.sr_instance_id = list.number3
739: AND safety.plan_id = list.number4

Line 773: msc_system_items item

769: sum(safety.target_days_of_supply) dos,
770: sum(safety.TARGET_SAFETY_STOCK * item.standard_cost) cost
771: FROM msc_safety_stocks safety,
772: msc_form_query list ,
773: msc_system_items item
774: WHERE safety.period_start_date <= last_date
775: AND safety.organization_id = list.number2
776: AND safety.sr_instance_id = list.number3
777: AND safety.plan_id = list.number4

Line 810: msc_system_items item

806: sum(safety.user_defined_dos) dos,
807: sum(safety.USER_DEFINED_SAFETY_STOCKS * item.standard_cost) cost
808: FROM msc_safety_stocks safety,
809: msc_form_query list,
810: msc_system_items item
811: WHERE safety.period_start_date <= last_date
812: AND safety.organization_id = list.number2
813: AND safety.sr_instance_id = list.number3
814: AND safety.plan_id = list.number4

Line 847: msc_system_items item

843: sum(safety.TRANSIT_LTVAR_SS_PERCENT) dos,
844: sum(safety.DEMAND_VAR_SS_PERCENT) cost
845: FROM msc_safety_stocks safety,
846: msc_form_query list,
847: msc_system_items item
848: WHERE safety.period_start_date <= last_date
849: AND safety.organization_id = list.number2
850: AND safety.sr_instance_id = list.number3
851: AND safety.plan_id = list.number4

Line 1015: from msc_system_items

1011: p_sr_instance_id number,
1012: p_organization_id number,
1013: p_plan_id number) is
1014: select nvl(standard_cost,0)
1015: from msc_system_items
1016: where inventory_item_id=p_inventory_item_id
1017: and organization_id =p_organization_id
1018: and sr_instance_id =p_sr_instance_id
1019: and plan_id =p_plan_id;

Line 1226: FROM msc_system_items msi,

1222: l_atp_qty_net MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1223:
1224: cursor check_atp is
1225: SELECT msi.calculate_atp
1226: FROM msc_system_items msi,
1227: msc_form_query mfq
1228: WHERE msi.inventory_item_id = mfq.number1
1229: AND msi.organization_id = mfq.number2
1230: AND msi.plan_id = arg_plan_id

Line 2613: from msc_system_items

2609:
2610: v_isProductFamily number :=0;
2611: cursor isProductFamily is
2612: select 1
2613: from msc_system_items
2614: where plan_id = p_plan_id
2615: and organization_id = v_org_id
2616: and sr_instance_id = v_inst_id
2617: and inventory_item_id = v_item_id

Line 2622: from msc_system_items

2618: and bom_item_type in (2,5);
2619:
2620: cursor isProductFamily_no_org is
2621: select 1
2622: from msc_system_items
2623: where plan_id = p_plan_id
2624: and inventory_item_id = v_item_id
2625: and bom_item_type in (2,5);
2626:

Line 2630: msc_system_items msi

2626:
2627: cursor org_list_c IS
2628: select mpt.object_type, mpt.source_type, mpt.sequence_id
2629: from msc_pq_types mpt,
2630: msc_system_items msi
2631: where mpt.query_id = p_pf
2632: and mpt.object_type = msi.organization_id
2633: and mpt.source_type = msi.sr_instance_id
2634: and msi.plan_id = p_plan_id

Line 2873: ' FROM msc_system_items msi, msc_item_categories mic' ||

2869: ' :NODE_REGULAR_ITEM, ' ||
2870: ' :org_seq, '||
2871: ' :p_all_org_string,'||
2872: 'msi.item_name '||
2873: ' FROM msc_system_items msi, msc_item_categories mic' ||
2874: ' WHERE mic.organization_id = msi.organization_id ' ||
2875: 'AND mic.sr_instance_id = msi.sr_instance_id ' ||
2876: 'AND mic.inventory_item_id = msi.inventory_item_id ' ||
2877: 'AND mic.category_set_id = :p_category_set '||

Line 2894: ' FROM msc_system_items msi ' ||

2890: ' :NODE_REGULAR_ITEM, ' ||
2891: ' :org_seq, '||
2892: ' :p_all_org_string,'||
2893: ' msi.item_name '||
2894: ' FROM msc_system_items msi ' ||
2895: ' where msi.inventory_item_id = :p_item_list ' ||
2896: ' AND msi.organization_id <> -1 '||
2897: ' AND msi.plan_id = :p_plan_id ';
2898:

Line 2911: ' FROM msc_system_items msi ' ||

2907: ':NODE_REGULAR_ITEM, ' ||
2908: ' :org_seq, '||
2909: 'msc_get_name.org_code(msi.organization_id,msi.sr_instance_id), '||
2910: 'msi.item_name '||
2911: ' FROM msc_system_items msi ' ||
2912: ' where msi.sr_instance_id = :p_inst_id '||
2913: 'and msi.organization_id = :p_org_list ' ||
2914: 'AND msi.inventory_item_id = :p_item_list ' ||
2915: 'AND msi.plan_id = :p_plan_id ';

Line 2935: ' FROM msc_system_items msi ' ||

2931: ':NODE_REGULAR_ITEM, ' ||
2932: ' :org_seq, '||
2933: ':p_all_org_string, '||
2934: 'msi.item_name '||
2935: ' FROM msc_system_items msi ' ||
2936: ' where msi.sr_instance_id = :p_inst_id '||
2937: 'and msi.organization_id = :p_org_list ' ||
2938: 'AND msi.inventory_item_id = :p_item_list ' ||
2939: 'AND msi.plan_id = :p_plan_id ';

Line 2959: ' FROM msc_system_items msi, msc_item_categories mic' ||

2955: ' :NODE_REGULAR_ITEM, ' ||
2956: ' :org_seq, '||
2957: 'msc_get_name.org_code(msi.organization_id,msi.sr_instance_id),'||
2958: 'msi.item_name '||
2959: ' FROM msc_system_items msi, msc_item_categories mic' ||
2960: ' WHERE mic.organization_id = msi.organization_id ' ||
2961: 'AND mic.sr_instance_id = msi.sr_instance_id ' ||
2962: 'AND mic.inventory_item_id = msi.inventory_item_id ' ||
2963: 'AND mic.category_set_id = :p_category_set '||

Line 2979: ' FROM msc_system_items msi ' ||

2975: ' :NODE_REGULAR_ITEM, ' ||
2976: ' :org_seq, '||
2977: ' msc_get_name.org_code(msi.organization_id,msi.sr_instance_id),'||
2978: ' msi.item_name '||
2979: ' FROM msc_system_items msi ' ||
2980: ' where msi.inventory_item_id = :p_item_list ' ||
2981: ' AND msi.organization_id <> -1 '||
2982: ' AND msi.plan_id = :p_plan_id ';
2983: