[Home] [Help]
410: sum(0) dos,
411: 0 cost
412: FROM msc_form_query list,
413: msc_trading_partners param,
414: msc_system_items msi,
415: msc_supplies rec,
416: msc_calendar_dates dates
417: WHERE (arg_res_level = 1
418: OR (arg_res_level = 2
809: sum(safety.achieved_days_of_supply) dos,
810: sum(safety.safety_stock_quantity * item.standard_cost) cost
811: FROM msc_safety_stocks safety,
812: msc_form_query list ,
813: msc_system_items item
814: WHERE safety.period_start_date <= last_date
815: AND safety.organization_id = list.number2
816: AND safety.sr_instance_id = list.number3
817: AND safety.plan_id = list.number4
847: sum(safety.target_days_of_supply) dos,
848: sum(safety.TARGET_SAFETY_STOCK * item.standard_cost) cost
849: FROM msc_safety_stocks safety,
850: msc_form_query list ,
851: msc_system_items item
852: WHERE safety.period_start_date <= last_date
853: AND safety.organization_id = list.number2
854: AND safety.sr_instance_id = list.number3
855: AND safety.plan_id = list.number4
884: sum(safety.user_defined_dos) dos,
885: sum(safety.USER_DEFINED_SAFETY_STOCKS * item.standard_cost) cost
886: FROM msc_safety_stocks safety,
887: msc_form_query list,
888: msc_system_items item
889: WHERE safety.period_start_date <= last_date
890: AND safety.organization_id = list.number2
891: AND safety.sr_instance_id = list.number3
892: AND safety.plan_id = list.number4
921: sum(safety.TRANSIT_LTVAR_SS_PERCENT) dos,
922: sum(safety.DEMAND_VAR_SS_PERCENT) cost
923: FROM msc_safety_stocks safety,
924: msc_form_query list,
925: msc_system_items item
926: WHERE safety.period_start_date <= last_date
927: AND safety.organization_id = list.number2
928: AND safety.sr_instance_id = list.number3
929: AND safety.plan_id = list.number4
1089: p_sr_instance_id number,
1090: p_organization_id number,
1091: p_plan_id number) is
1092: select nvl(standard_cost,0)
1093: from msc_system_items
1094: where inventory_item_id=p_inventory_item_id
1095: and organization_id =p_organization_id
1096: and sr_instance_id =p_sr_instance_id
1097: and plan_id =p_plan_id;
1301: l_atp_qty_net MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
1302:
1303: cursor check_atp is
1304: SELECT msi.calculate_atp
1305: FROM msc_system_items msi,
1306: msc_form_query mfq
1307: WHERE msi.inventory_item_id = mfq.number1
1308: AND msi.organization_id = mfq.number2
1309: AND msi.plan_id = arg_plan_id
2789:
2790: v_isProductFamily number :=0;
2791: cursor isProductFamily is
2792: select 1
2793: from msc_system_items
2794: where plan_id = p_plan_id
2795: and organization_id = v_org_id
2796: and sr_instance_id = v_inst_id
2797: and inventory_item_id = v_item_id
2798: and bom_item_type in (2,5);
2799:
2800: cursor isProductFamily_no_org is
2801: select 1
2802: from msc_system_items
2803: where plan_id = p_plan_id
2804: and inventory_item_id = v_item_id
2805: and bom_item_type in (2,5);
2806:
2806:
2807: cursor org_list_c IS
2808: select mpt.object_type, mpt.source_type, mpt.sequence_id
2809: from msc_pq_types mpt,
2810: msc_system_items msi
2811: where mpt.query_id = p_pf
2812: and mpt.object_type = msi.organization_id
2813: and mpt.source_type = msi.sr_instance_id
2814: and msi.plan_id = p_plan_id
3049: ' :NODE_REGULAR_ITEM, ' ||
3050: ' :org_seq, '||
3051: ' :p_all_org_string'||'|'||'|'||''''||'-'||''''||'|'||'|'||'substr(msi.organization_code, 1, instr(msi.organization_code,'||''''||':'||''''||',1)-1),'||
3052: 'msi.item_name '||
3053: ' FROM msc_system_items msi, msc_item_categories mic' ||
3054: ' WHERE mic.organization_id = msi.organization_id ' ||
3055: 'AND mic.sr_instance_id = msi.sr_instance_id ' ||
3056: 'AND mic.inventory_item_id = msi.inventory_item_id ' ||
3057: 'AND mic.category_set_id = :p_category_set '||
3070: ' :NODE_REGULAR_ITEM, ' ||
3071: ' :org_seq, '||
3072: ' :p_all_org_string'||'|'||'|'||''''||'-'||''''||'|'||'|'||'substr(msi.organization_code, 1, instr(msi.organization_code,'||''''||':'||''''||',1)-1),'||
3073: ' msi.item_name '||
3074: ' FROM msc_system_items msi ' ||
3075: ' where msi.inventory_item_id = :p_item_list ' ||
3076: ' AND msi.organization_id <> -1 '||
3077: ' AND msi.plan_id = :p_plan_id ';
3078:
3087: ':NODE_REGULAR_ITEM, ' ||
3088: ' :org_seq, '||
3089: 'msc_get_name.org_code(msi.organization_id,msi.sr_instance_id), '||
3090: 'msi.item_name '||
3091: ' FROM msc_system_items msi ' ||
3092: ' where msi.sr_instance_id = :p_inst_id '||
3093: 'and msi.organization_id = :p_org_list ' ||
3094: 'AND msi.inventory_item_id = :p_item_list ' ||
3095: 'AND msi.plan_id = :p_plan_id ';
3111: ':NODE_REGULAR_ITEM, ' ||
3112: ' :org_seq, '||
3113: ':p_all_org_string, '||
3114: 'msi.item_name '||
3115: ' FROM msc_system_items msi ' ||
3116: ' where msi.sr_instance_id = :p_inst_id '||
3117: 'and msi.organization_id = :p_org_list ' ||
3118: 'AND msi.inventory_item_id = :p_item_list ' ||
3119: 'AND msi.plan_id = :p_plan_id ';
3135: ' :NODE_REGULAR_ITEM, ' ||
3136: ' :org_seq, '||
3137: 'msc_get_name.org_code(msi.organization_id,msi.sr_instance_id),'||
3138: 'msi.item_name '||
3139: ' FROM msc_system_items msi, msc_item_categories mic' ||
3140: ' WHERE mic.organization_id = msi.organization_id ' ||
3141: 'AND mic.sr_instance_id = msi.sr_instance_id ' ||
3142: 'AND mic.inventory_item_id = msi.inventory_item_id ' ||
3143: 'AND mic.category_set_id = :p_category_set '||
3155: ' :NODE_REGULAR_ITEM, ' ||
3156: ' :org_seq, '||
3157: ' msc_get_name.org_code(msi.organization_id,msi.sr_instance_id),'||
3158: ' msi.item_name '||
3159: ' FROM msc_system_items msi ' ||
3160: ' where msi.inventory_item_id = :p_item_list ' ||
3161: ' AND msi.organization_id <> -1 '||
3162: ' AND msi.plan_id = :p_plan_id ';
3163: