[Home] [Help]
1: package body MSC_SDA_UTILS as
2: /* $Header: MSCSDAUB.pls 120.39.12010000.3 2008/08/26 19:40:31 pabram ship $ */
3:
4: procedure println(p_msg varchar2) is
5: begin
49: end escapeSplChars;
50:
51: procedure addRecordToOutStream(p_one_record varchar2,
52: p_out_data_index in out nocopy number,
53: p_out_data in out nocopy msc_sda_utils.maxchartbl) is
54: begin
55: if (nvl(length(p_out_data(1)),0) = 1) then -- {
56: p_out_data(1) := p_one_record;
57: elsif ( nvl(length(p_out_data(p_out_data_index)),0) + length(p_one_record) < 32000 ) then
64: end addRecordToOutStream;
65:
66: procedure addToOutStream(p_one_record varchar2,
67: p_out_data_index in out nocopy number,
68: p_out_data in out nocopy msc_sda_utils.maxchartbl,
69: p_debug_flag number default null) is
70: l_one_record varchar2(32000);
71: begin
72: --println(' addToOutStream in/out');
133: number5, number6, number7, date1, date2)
134: select l_query_id,sysdate, -1, -1, sysdate,
135: lower_item_id, higher_item_id, highest_item_id, level,
136: reciprocal_flag,
137: msc_sda_utils.getRepairItem(plan_id, lower_item_id, highest_item_id) repair_item_id,
138: prime_item_id,
139: effective_date, disable_date
140: from msc_item_substitutes
141: where plan_id = p_plan
322: select distinct
323: to_number(null) region_list_id,
324: to_char(null) region_list,
325: p_region_list region_id,
326: msc_sda_utils.getRegionName(p_region_list) region_code,
327: p_region_list sort_column
328: from dual
329: where p_region_type = c_reg_view
330: and p_view_type = 1
332: select distinct
333: mpq.query_id region_list_id,
334: mpq.query_name region_list,
335: mpt.object_type region_id,
336: msc_sda_utils.getRegionName(mpt.object_type) region_code,
337: mpt.sequence_id sort_column
338: from msc_pq_types mpt,
339: msc_personal_queries mpq
340: where mpq.query_id = p_region_list
426:
427: if ( p_region_list is not null) then
428: ll_view_type := 1;
429: elsif (p_org_list is not null) then
430: msc_sda_utils.getOrgListValues(p_org_list, p_org_type, ll_org_list_id, ll_org_list, ll_inst_id, ll_org_id, ll_org_code);
431: ll_view_type := 2;
432: end if;
433:
434: for c_regions in c_regions_cur(ll_view_type)
678: end loop;
679: return l_query_id;
680: end createHistCalInMfq;
681:
682: procedure spreadTableMessages(p_out_data in out nocopy msc_sda_utils.maxCharTbl) is
683: cursor c_item_prompts_cur (p_folder_object varchar2) is
684: select field_type,
685: field_name,
686: field_prompt,
706: l_row_count := l_row_count + 1;
707: if (l_row_count = 1) then
708: l_one_record := c_sdview_items_messages || c_bang_separator || c_record_seperator || l_one_record;
709: end if;
710: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
711: end loop;
712:
713: l_row_count := 0;
714:
722: l_row_count := l_row_count + 1;
723: if (l_row_count = 1) then
724: l_one_record := c_sdview_comments_messages || c_bang_separator || c_record_seperator || l_one_record;
725: end if;
726: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
727: end loop;
728:
729: l_row_count := 0;
730:
738: l_row_count := l_row_count + 1;
739: if (l_row_count = 1) then
740: l_one_record := c_sdview_excp_messages || c_bang_separator || c_record_seperator || l_one_record;
741: end if;
742: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
743: end loop;
744: end spreadTableMessages;
745:
746: procedure getCommentsData(p_plan_id number, p_chain_query_id number,
743: end loop;
744: end spreadTableMessages;
745:
746: procedure getCommentsData(p_plan_id number, p_chain_query_id number,
747: p_out_data in out nocopy msc_sda_utils.maxCharTbl, p_stream_label varchar2) is
748:
749: cursor c_comments_cur is
750: select distinct mun.note_id,
751: nvl(mun.last_update_date, mun.creation_date) comment_date,
769: loop
770: l_row_count := l_row_count + 1;
771: l_one_record := to_char(c_comments.note_id)
772: || c_field_seperator || to_char(c_comments.comment_date, c_date_format)
773: || c_field_seperator || msc_sda_utils.escapeSplChars(c_comments.comment_text)
774: || c_field_seperator || msc_sda_utils.escapeSplChars(c_comments.item_name);
775: if (l_row_count = 1) then
776: l_one_record := p_stream_label || c_bang_separator || c_record_seperator || l_one_record;
777: end if;
770: l_row_count := l_row_count + 1;
771: l_one_record := to_char(c_comments.note_id)
772: || c_field_seperator || to_char(c_comments.comment_date, c_date_format)
773: || c_field_seperator || msc_sda_utils.escapeSplChars(c_comments.comment_text)
774: || c_field_seperator || msc_sda_utils.escapeSplChars(c_comments.item_name);
775: if (l_row_count = 1) then
776: l_one_record := p_stream_label || c_bang_separator || c_record_seperator || l_one_record;
777: end if;
778: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
774: || c_field_seperator || msc_sda_utils.escapeSplChars(c_comments.item_name);
775: if (l_row_count = 1) then
776: l_one_record := p_stream_label || c_bang_separator || c_record_seperator || l_one_record;
777: end if;
778: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
779: end loop;
780: println('getCommentsData out');
781: end getCommentsData;
782:
868:
869: for c_item in c_item_cur loop
870:
871: l_one_record := c_item.node_id || c_field_seperator ||
872: msc_sda_utils.escapeSplChars(c_item.item_segments) || c_field_seperator ||
873: msc_sda_utils.escapeSplChars(c_item.organization_code) || c_field_seperator ||
874: msc_sda_utils.escapeSplChars(c_item.description) || c_field_seperator ||
875: msc_sda_utils.escapeSplChars(c_item.planner_code) || c_field_seperator ||
876: msc_sda_utils.escapeSplChars(c_item.nettable_inventory_quantity) || c_field_seperator ||
869: for c_item in c_item_cur loop
870:
871: l_one_record := c_item.node_id || c_field_seperator ||
872: msc_sda_utils.escapeSplChars(c_item.item_segments) || c_field_seperator ||
873: msc_sda_utils.escapeSplChars(c_item.organization_code) || c_field_seperator ||
874: msc_sda_utils.escapeSplChars(c_item.description) || c_field_seperator ||
875: msc_sda_utils.escapeSplChars(c_item.planner_code) || c_field_seperator ||
876: msc_sda_utils.escapeSplChars(c_item.nettable_inventory_quantity) || c_field_seperator ||
877: msc_sda_utils.escapeSplChars(c_item.nonnettable_inventory_quantity) || c_field_seperator ||
870:
871: l_one_record := c_item.node_id || c_field_seperator ||
872: msc_sda_utils.escapeSplChars(c_item.item_segments) || c_field_seperator ||
873: msc_sda_utils.escapeSplChars(c_item.organization_code) || c_field_seperator ||
874: msc_sda_utils.escapeSplChars(c_item.description) || c_field_seperator ||
875: msc_sda_utils.escapeSplChars(c_item.planner_code) || c_field_seperator ||
876: msc_sda_utils.escapeSplChars(c_item.nettable_inventory_quantity) || c_field_seperator ||
877: msc_sda_utils.escapeSplChars(c_item.nonnettable_inventory_quantity) || c_field_seperator ||
878: msc_sda_utils.escapeSplChars(c_item.buyer_name) || c_field_seperator ||
871: l_one_record := c_item.node_id || c_field_seperator ||
872: msc_sda_utils.escapeSplChars(c_item.item_segments) || c_field_seperator ||
873: msc_sda_utils.escapeSplChars(c_item.organization_code) || c_field_seperator ||
874: msc_sda_utils.escapeSplChars(c_item.description) || c_field_seperator ||
875: msc_sda_utils.escapeSplChars(c_item.planner_code) || c_field_seperator ||
876: msc_sda_utils.escapeSplChars(c_item.nettable_inventory_quantity) || c_field_seperator ||
877: msc_sda_utils.escapeSplChars(c_item.nonnettable_inventory_quantity) || c_field_seperator ||
878: msc_sda_utils.escapeSplChars(c_item.buyer_name) || c_field_seperator ||
879: msc_sda_utils.escapeSplChars(c_item.mrp_planning_code_text) || c_field_seperator ||
872: msc_sda_utils.escapeSplChars(c_item.item_segments) || c_field_seperator ||
873: msc_sda_utils.escapeSplChars(c_item.organization_code) || c_field_seperator ||
874: msc_sda_utils.escapeSplChars(c_item.description) || c_field_seperator ||
875: msc_sda_utils.escapeSplChars(c_item.planner_code) || c_field_seperator ||
876: msc_sda_utils.escapeSplChars(c_item.nettable_inventory_quantity) || c_field_seperator ||
877: msc_sda_utils.escapeSplChars(c_item.nonnettable_inventory_quantity) || c_field_seperator ||
878: msc_sda_utils.escapeSplChars(c_item.buyer_name) || c_field_seperator ||
879: msc_sda_utils.escapeSplChars(c_item.mrp_planning_code_text) || c_field_seperator ||
880: msc_sda_utils.escapeSplChars(c_item.critical_component_flag) || c_field_seperator ||
873: msc_sda_utils.escapeSplChars(c_item.organization_code) || c_field_seperator ||
874: msc_sda_utils.escapeSplChars(c_item.description) || c_field_seperator ||
875: msc_sda_utils.escapeSplChars(c_item.planner_code) || c_field_seperator ||
876: msc_sda_utils.escapeSplChars(c_item.nettable_inventory_quantity) || c_field_seperator ||
877: msc_sda_utils.escapeSplChars(c_item.nonnettable_inventory_quantity) || c_field_seperator ||
878: msc_sda_utils.escapeSplChars(c_item.buyer_name) || c_field_seperator ||
879: msc_sda_utils.escapeSplChars(c_item.mrp_planning_code_text) || c_field_seperator ||
880: msc_sda_utils.escapeSplChars(c_item.critical_component_flag) || c_field_seperator ||
881: msc_sda_utils.escapeSplChars(c_item.wip_supply_type_text) || c_field_seperator ||
874: msc_sda_utils.escapeSplChars(c_item.description) || c_field_seperator ||
875: msc_sda_utils.escapeSplChars(c_item.planner_code) || c_field_seperator ||
876: msc_sda_utils.escapeSplChars(c_item.nettable_inventory_quantity) || c_field_seperator ||
877: msc_sda_utils.escapeSplChars(c_item.nonnettable_inventory_quantity) || c_field_seperator ||
878: msc_sda_utils.escapeSplChars(c_item.buyer_name) || c_field_seperator ||
879: msc_sda_utils.escapeSplChars(c_item.mrp_planning_code_text) || c_field_seperator ||
880: msc_sda_utils.escapeSplChars(c_item.critical_component_flag) || c_field_seperator ||
881: msc_sda_utils.escapeSplChars(c_item.wip_supply_type_text) || c_field_seperator ||
882: msc_sda_utils.escapeSplChars(c_item.bom_item_type_text) || c_field_seperator ||
875: msc_sda_utils.escapeSplChars(c_item.planner_code) || c_field_seperator ||
876: msc_sda_utils.escapeSplChars(c_item.nettable_inventory_quantity) || c_field_seperator ||
877: msc_sda_utils.escapeSplChars(c_item.nonnettable_inventory_quantity) || c_field_seperator ||
878: msc_sda_utils.escapeSplChars(c_item.buyer_name) || c_field_seperator ||
879: msc_sda_utils.escapeSplChars(c_item.mrp_planning_code_text) || c_field_seperator ||
880: msc_sda_utils.escapeSplChars(c_item.critical_component_flag) || c_field_seperator ||
881: msc_sda_utils.escapeSplChars(c_item.wip_supply_type_text) || c_field_seperator ||
882: msc_sda_utils.escapeSplChars(c_item.bom_item_type_text) || c_field_seperator ||
883: msc_sda_utils.escapeSplChars(c_item.end_assembly_pegging_text) || c_field_seperator ||
876: msc_sda_utils.escapeSplChars(c_item.nettable_inventory_quantity) || c_field_seperator ||
877: msc_sda_utils.escapeSplChars(c_item.nonnettable_inventory_quantity) || c_field_seperator ||
878: msc_sda_utils.escapeSplChars(c_item.buyer_name) || c_field_seperator ||
879: msc_sda_utils.escapeSplChars(c_item.mrp_planning_code_text) || c_field_seperator ||
880: msc_sda_utils.escapeSplChars(c_item.critical_component_flag) || c_field_seperator ||
881: msc_sda_utils.escapeSplChars(c_item.wip_supply_type_text) || c_field_seperator ||
882: msc_sda_utils.escapeSplChars(c_item.bom_item_type_text) || c_field_seperator ||
883: msc_sda_utils.escapeSplChars(c_item.end_assembly_pegging_text) || c_field_seperator ||
884: msc_sda_utils.escapeSplChars(c_item.base_model) || c_field_seperator ||
877: msc_sda_utils.escapeSplChars(c_item.nonnettable_inventory_quantity) || c_field_seperator ||
878: msc_sda_utils.escapeSplChars(c_item.buyer_name) || c_field_seperator ||
879: msc_sda_utils.escapeSplChars(c_item.mrp_planning_code_text) || c_field_seperator ||
880: msc_sda_utils.escapeSplChars(c_item.critical_component_flag) || c_field_seperator ||
881: msc_sda_utils.escapeSplChars(c_item.wip_supply_type_text) || c_field_seperator ||
882: msc_sda_utils.escapeSplChars(c_item.bom_item_type_text) || c_field_seperator ||
883: msc_sda_utils.escapeSplChars(c_item.end_assembly_pegging_text) || c_field_seperator ||
884: msc_sda_utils.escapeSplChars(c_item.base_model) || c_field_seperator ||
885: msc_sda_utils.escapeSplChars(c_item.category) || c_field_seperator ||
878: msc_sda_utils.escapeSplChars(c_item.buyer_name) || c_field_seperator ||
879: msc_sda_utils.escapeSplChars(c_item.mrp_planning_code_text) || c_field_seperator ||
880: msc_sda_utils.escapeSplChars(c_item.critical_component_flag) || c_field_seperator ||
881: msc_sda_utils.escapeSplChars(c_item.wip_supply_type_text) || c_field_seperator ||
882: msc_sda_utils.escapeSplChars(c_item.bom_item_type_text) || c_field_seperator ||
883: msc_sda_utils.escapeSplChars(c_item.end_assembly_pegging_text) || c_field_seperator ||
884: msc_sda_utils.escapeSplChars(c_item.base_model) || c_field_seperator ||
885: msc_sda_utils.escapeSplChars(c_item.category) || c_field_seperator ||
886: msc_sda_utils.escapeSplChars(c_item.category_desc) || c_field_seperator ||
879: msc_sda_utils.escapeSplChars(c_item.mrp_planning_code_text) || c_field_seperator ||
880: msc_sda_utils.escapeSplChars(c_item.critical_component_flag) || c_field_seperator ||
881: msc_sda_utils.escapeSplChars(c_item.wip_supply_type_text) || c_field_seperator ||
882: msc_sda_utils.escapeSplChars(c_item.bom_item_type_text) || c_field_seperator ||
883: msc_sda_utils.escapeSplChars(c_item.end_assembly_pegging_text) || c_field_seperator ||
884: msc_sda_utils.escapeSplChars(c_item.base_model) || c_field_seperator ||
885: msc_sda_utils.escapeSplChars(c_item.category) || c_field_seperator ||
886: msc_sda_utils.escapeSplChars(c_item.category_desc) || c_field_seperator ||
887: msc_sda_utils.escapeSplChars(c_item.product_family_item) || c_field_seperator ||
880: msc_sda_utils.escapeSplChars(c_item.critical_component_flag) || c_field_seperator ||
881: msc_sda_utils.escapeSplChars(c_item.wip_supply_type_text) || c_field_seperator ||
882: msc_sda_utils.escapeSplChars(c_item.bom_item_type_text) || c_field_seperator ||
883: msc_sda_utils.escapeSplChars(c_item.end_assembly_pegging_text) || c_field_seperator ||
884: msc_sda_utils.escapeSplChars(c_item.base_model) || c_field_seperator ||
885: msc_sda_utils.escapeSplChars(c_item.category) || c_field_seperator ||
886: msc_sda_utils.escapeSplChars(c_item.category_desc) || c_field_seperator ||
887: msc_sda_utils.escapeSplChars(c_item.product_family_item) || c_field_seperator ||
888: msc_sda_utils.escapeSplChars(c_item.product_family_item_desc) || c_field_seperator ||
881: msc_sda_utils.escapeSplChars(c_item.wip_supply_type_text) || c_field_seperator ||
882: msc_sda_utils.escapeSplChars(c_item.bom_item_type_text) || c_field_seperator ||
883: msc_sda_utils.escapeSplChars(c_item.end_assembly_pegging_text) || c_field_seperator ||
884: msc_sda_utils.escapeSplChars(c_item.base_model) || c_field_seperator ||
885: msc_sda_utils.escapeSplChars(c_item.category) || c_field_seperator ||
886: msc_sda_utils.escapeSplChars(c_item.category_desc) || c_field_seperator ||
887: msc_sda_utils.escapeSplChars(c_item.product_family_item) || c_field_seperator ||
888: msc_sda_utils.escapeSplChars(c_item.product_family_item_desc) || c_field_seperator ||
889: msc_sda_utils.escapeSplChars(c_item.planning_exception_set) || c_field_seperator ||
882: msc_sda_utils.escapeSplChars(c_item.bom_item_type_text) || c_field_seperator ||
883: msc_sda_utils.escapeSplChars(c_item.end_assembly_pegging_text) || c_field_seperator ||
884: msc_sda_utils.escapeSplChars(c_item.base_model) || c_field_seperator ||
885: msc_sda_utils.escapeSplChars(c_item.category) || c_field_seperator ||
886: msc_sda_utils.escapeSplChars(c_item.category_desc) || c_field_seperator ||
887: msc_sda_utils.escapeSplChars(c_item.product_family_item) || c_field_seperator ||
888: msc_sda_utils.escapeSplChars(c_item.product_family_item_desc) || c_field_seperator ||
889: msc_sda_utils.escapeSplChars(c_item.planning_exception_set) || c_field_seperator ||
890: msc_sda_utils.escapeSplChars(c_item.repetitive_type) || c_field_seperator ||
883: msc_sda_utils.escapeSplChars(c_item.end_assembly_pegging_text) || c_field_seperator ||
884: msc_sda_utils.escapeSplChars(c_item.base_model) || c_field_seperator ||
885: msc_sda_utils.escapeSplChars(c_item.category) || c_field_seperator ||
886: msc_sda_utils.escapeSplChars(c_item.category_desc) || c_field_seperator ||
887: msc_sda_utils.escapeSplChars(c_item.product_family_item) || c_field_seperator ||
888: msc_sda_utils.escapeSplChars(c_item.product_family_item_desc) || c_field_seperator ||
889: msc_sda_utils.escapeSplChars(c_item.planning_exception_set) || c_field_seperator ||
890: msc_sda_utils.escapeSplChars(c_item.repetitive_type) || c_field_seperator ||
891: msc_sda_utils.escapeSplChars(c_item.standard_cost) || c_field_seperator ||
884: msc_sda_utils.escapeSplChars(c_item.base_model) || c_field_seperator ||
885: msc_sda_utils.escapeSplChars(c_item.category) || c_field_seperator ||
886: msc_sda_utils.escapeSplChars(c_item.category_desc) || c_field_seperator ||
887: msc_sda_utils.escapeSplChars(c_item.product_family_item) || c_field_seperator ||
888: msc_sda_utils.escapeSplChars(c_item.product_family_item_desc) || c_field_seperator ||
889: msc_sda_utils.escapeSplChars(c_item.planning_exception_set) || c_field_seperator ||
890: msc_sda_utils.escapeSplChars(c_item.repetitive_type) || c_field_seperator ||
891: msc_sda_utils.escapeSplChars(c_item.standard_cost) || c_field_seperator ||
892: msc_sda_utils.escapeSplChars(c_item.carrying_cost) || c_field_seperator ||
885: msc_sda_utils.escapeSplChars(c_item.category) || c_field_seperator ||
886: msc_sda_utils.escapeSplChars(c_item.category_desc) || c_field_seperator ||
887: msc_sda_utils.escapeSplChars(c_item.product_family_item) || c_field_seperator ||
888: msc_sda_utils.escapeSplChars(c_item.product_family_item_desc) || c_field_seperator ||
889: msc_sda_utils.escapeSplChars(c_item.planning_exception_set) || c_field_seperator ||
890: msc_sda_utils.escapeSplChars(c_item.repetitive_type) || c_field_seperator ||
891: msc_sda_utils.escapeSplChars(c_item.standard_cost) || c_field_seperator ||
892: msc_sda_utils.escapeSplChars(c_item.carrying_cost) || c_field_seperator ||
893: msc_sda_utils.escapeSplChars(c_item.uom_code) || c_field_seperator ||
886: msc_sda_utils.escapeSplChars(c_item.category_desc) || c_field_seperator ||
887: msc_sda_utils.escapeSplChars(c_item.product_family_item) || c_field_seperator ||
888: msc_sda_utils.escapeSplChars(c_item.product_family_item_desc) || c_field_seperator ||
889: msc_sda_utils.escapeSplChars(c_item.planning_exception_set) || c_field_seperator ||
890: msc_sda_utils.escapeSplChars(c_item.repetitive_type) || c_field_seperator ||
891: msc_sda_utils.escapeSplChars(c_item.standard_cost) || c_field_seperator ||
892: msc_sda_utils.escapeSplChars(c_item.carrying_cost) || c_field_seperator ||
893: msc_sda_utils.escapeSplChars(c_item.uom_code) || c_field_seperator ||
894: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_date) || c_field_seperator ||
887: msc_sda_utils.escapeSplChars(c_item.product_family_item) || c_field_seperator ||
888: msc_sda_utils.escapeSplChars(c_item.product_family_item_desc) || c_field_seperator ||
889: msc_sda_utils.escapeSplChars(c_item.planning_exception_set) || c_field_seperator ||
890: msc_sda_utils.escapeSplChars(c_item.repetitive_type) || c_field_seperator ||
891: msc_sda_utils.escapeSplChars(c_item.standard_cost) || c_field_seperator ||
892: msc_sda_utils.escapeSplChars(c_item.carrying_cost) || c_field_seperator ||
893: msc_sda_utils.escapeSplChars(c_item.uom_code) || c_field_seperator ||
894: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_date) || c_field_seperator ||
895: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_days) || c_field_seperator ||
888: msc_sda_utils.escapeSplChars(c_item.product_family_item_desc) || c_field_seperator ||
889: msc_sda_utils.escapeSplChars(c_item.planning_exception_set) || c_field_seperator ||
890: msc_sda_utils.escapeSplChars(c_item.repetitive_type) || c_field_seperator ||
891: msc_sda_utils.escapeSplChars(c_item.standard_cost) || c_field_seperator ||
892: msc_sda_utils.escapeSplChars(c_item.carrying_cost) || c_field_seperator ||
893: msc_sda_utils.escapeSplChars(c_item.uom_code) || c_field_seperator ||
894: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_date) || c_field_seperator ||
895: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_days) || c_field_seperator ||
896: msc_sda_utils.escapeSplChars(c_item.inventory_use_up_date) || c_field_seperator ||
889: msc_sda_utils.escapeSplChars(c_item.planning_exception_set) || c_field_seperator ||
890: msc_sda_utils.escapeSplChars(c_item.repetitive_type) || c_field_seperator ||
891: msc_sda_utils.escapeSplChars(c_item.standard_cost) || c_field_seperator ||
892: msc_sda_utils.escapeSplChars(c_item.carrying_cost) || c_field_seperator ||
893: msc_sda_utils.escapeSplChars(c_item.uom_code) || c_field_seperator ||
894: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_date) || c_field_seperator ||
895: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_days) || c_field_seperator ||
896: msc_sda_utils.escapeSplChars(c_item.inventory_use_up_date) || c_field_seperator ||
897: msc_sda_utils.escapeSplChars(c_item.planning_make_buy_code_text) || c_field_seperator ||
890: msc_sda_utils.escapeSplChars(c_item.repetitive_type) || c_field_seperator ||
891: msc_sda_utils.escapeSplChars(c_item.standard_cost) || c_field_seperator ||
892: msc_sda_utils.escapeSplChars(c_item.carrying_cost) || c_field_seperator ||
893: msc_sda_utils.escapeSplChars(c_item.uom_code) || c_field_seperator ||
894: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_date) || c_field_seperator ||
895: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_days) || c_field_seperator ||
896: msc_sda_utils.escapeSplChars(c_item.inventory_use_up_date) || c_field_seperator ||
897: msc_sda_utils.escapeSplChars(c_item.planning_make_buy_code_text) || c_field_seperator ||
898: msc_sda_utils.escapeSplChars(c_item.ato_forecast_control_text) || c_field_seperator ||
891: msc_sda_utils.escapeSplChars(c_item.standard_cost) || c_field_seperator ||
892: msc_sda_utils.escapeSplChars(c_item.carrying_cost) || c_field_seperator ||
893: msc_sda_utils.escapeSplChars(c_item.uom_code) || c_field_seperator ||
894: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_date) || c_field_seperator ||
895: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_days) || c_field_seperator ||
896: msc_sda_utils.escapeSplChars(c_item.inventory_use_up_date) || c_field_seperator ||
897: msc_sda_utils.escapeSplChars(c_item.planning_make_buy_code_text) || c_field_seperator ||
898: msc_sda_utils.escapeSplChars(c_item.ato_forecast_control_text) || c_field_seperator ||
899: msc_sda_utils.escapeSplChars(c_item.shrinkage_rate) || c_field_seperator ||
892: msc_sda_utils.escapeSplChars(c_item.carrying_cost) || c_field_seperator ||
893: msc_sda_utils.escapeSplChars(c_item.uom_code) || c_field_seperator ||
894: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_date) || c_field_seperator ||
895: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_days) || c_field_seperator ||
896: msc_sda_utils.escapeSplChars(c_item.inventory_use_up_date) || c_field_seperator ||
897: msc_sda_utils.escapeSplChars(c_item.planning_make_buy_code_text) || c_field_seperator ||
898: msc_sda_utils.escapeSplChars(c_item.ato_forecast_control_text) || c_field_seperator ||
899: msc_sda_utils.escapeSplChars(c_item.shrinkage_rate) || c_field_seperator ||
900: msc_sda_utils.escapeSplChars(c_item.preprocessing_lead_time) || c_field_seperator ||
893: msc_sda_utils.escapeSplChars(c_item.uom_code) || c_field_seperator ||
894: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_date) || c_field_seperator ||
895: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_days) || c_field_seperator ||
896: msc_sda_utils.escapeSplChars(c_item.inventory_use_up_date) || c_field_seperator ||
897: msc_sda_utils.escapeSplChars(c_item.planning_make_buy_code_text) || c_field_seperator ||
898: msc_sda_utils.escapeSplChars(c_item.ato_forecast_control_text) || c_field_seperator ||
899: msc_sda_utils.escapeSplChars(c_item.shrinkage_rate) || c_field_seperator ||
900: msc_sda_utils.escapeSplChars(c_item.preprocessing_lead_time) || c_field_seperator ||
901: msc_sda_utils.escapeSplChars(c_item.full_lead_time) || c_field_seperator ||
894: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_date) || c_field_seperator ||
895: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_days) || c_field_seperator ||
896: msc_sda_utils.escapeSplChars(c_item.inventory_use_up_date) || c_field_seperator ||
897: msc_sda_utils.escapeSplChars(c_item.planning_make_buy_code_text) || c_field_seperator ||
898: msc_sda_utils.escapeSplChars(c_item.ato_forecast_control_text) || c_field_seperator ||
899: msc_sda_utils.escapeSplChars(c_item.shrinkage_rate) || c_field_seperator ||
900: msc_sda_utils.escapeSplChars(c_item.preprocessing_lead_time) || c_field_seperator ||
901: msc_sda_utils.escapeSplChars(c_item.full_lead_time) || c_field_seperator ||
902: msc_sda_utils.escapeSplChars(c_item.postprocessing_lead_time) || c_field_seperator ||
895: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_days) || c_field_seperator ||
896: msc_sda_utils.escapeSplChars(c_item.inventory_use_up_date) || c_field_seperator ||
897: msc_sda_utils.escapeSplChars(c_item.planning_make_buy_code_text) || c_field_seperator ||
898: msc_sda_utils.escapeSplChars(c_item.ato_forecast_control_text) || c_field_seperator ||
899: msc_sda_utils.escapeSplChars(c_item.shrinkage_rate) || c_field_seperator ||
900: msc_sda_utils.escapeSplChars(c_item.preprocessing_lead_time) || c_field_seperator ||
901: msc_sda_utils.escapeSplChars(c_item.full_lead_time) || c_field_seperator ||
902: msc_sda_utils.escapeSplChars(c_item.postprocessing_lead_time) || c_field_seperator ||
903: msc_sda_utils.escapeSplChars(c_item.leadtime_variability) || c_field_seperator ||
896: msc_sda_utils.escapeSplChars(c_item.inventory_use_up_date) || c_field_seperator ||
897: msc_sda_utils.escapeSplChars(c_item.planning_make_buy_code_text) || c_field_seperator ||
898: msc_sda_utils.escapeSplChars(c_item.ato_forecast_control_text) || c_field_seperator ||
899: msc_sda_utils.escapeSplChars(c_item.shrinkage_rate) || c_field_seperator ||
900: msc_sda_utils.escapeSplChars(c_item.preprocessing_lead_time) || c_field_seperator ||
901: msc_sda_utils.escapeSplChars(c_item.full_lead_time) || c_field_seperator ||
902: msc_sda_utils.escapeSplChars(c_item.postprocessing_lead_time) || c_field_seperator ||
903: msc_sda_utils.escapeSplChars(c_item.leadtime_variability) || c_field_seperator ||
904: msc_sda_utils.escapeSplChars(c_item.fixed_lead_time) || c_field_seperator ||
897: msc_sda_utils.escapeSplChars(c_item.planning_make_buy_code_text) || c_field_seperator ||
898: msc_sda_utils.escapeSplChars(c_item.ato_forecast_control_text) || c_field_seperator ||
899: msc_sda_utils.escapeSplChars(c_item.shrinkage_rate) || c_field_seperator ||
900: msc_sda_utils.escapeSplChars(c_item.preprocessing_lead_time) || c_field_seperator ||
901: msc_sda_utils.escapeSplChars(c_item.full_lead_time) || c_field_seperator ||
902: msc_sda_utils.escapeSplChars(c_item.postprocessing_lead_time) || c_field_seperator ||
903: msc_sda_utils.escapeSplChars(c_item.leadtime_variability) || c_field_seperator ||
904: msc_sda_utils.escapeSplChars(c_item.fixed_lead_time) || c_field_seperator ||
905: msc_sda_utils.escapeSplChars(c_item.variable_lead_time) || c_field_seperator ||
898: msc_sda_utils.escapeSplChars(c_item.ato_forecast_control_text) || c_field_seperator ||
899: msc_sda_utils.escapeSplChars(c_item.shrinkage_rate) || c_field_seperator ||
900: msc_sda_utils.escapeSplChars(c_item.preprocessing_lead_time) || c_field_seperator ||
901: msc_sda_utils.escapeSplChars(c_item.full_lead_time) || c_field_seperator ||
902: msc_sda_utils.escapeSplChars(c_item.postprocessing_lead_time) || c_field_seperator ||
903: msc_sda_utils.escapeSplChars(c_item.leadtime_variability) || c_field_seperator ||
904: msc_sda_utils.escapeSplChars(c_item.fixed_lead_time) || c_field_seperator ||
905: msc_sda_utils.escapeSplChars(c_item.variable_lead_time) || c_field_seperator ||
906: msc_sda_utils.escapeSplChars(c_item.fixed_order_quantity) || c_field_seperator ||
899: msc_sda_utils.escapeSplChars(c_item.shrinkage_rate) || c_field_seperator ||
900: msc_sda_utils.escapeSplChars(c_item.preprocessing_lead_time) || c_field_seperator ||
901: msc_sda_utils.escapeSplChars(c_item.full_lead_time) || c_field_seperator ||
902: msc_sda_utils.escapeSplChars(c_item.postprocessing_lead_time) || c_field_seperator ||
903: msc_sda_utils.escapeSplChars(c_item.leadtime_variability) || c_field_seperator ||
904: msc_sda_utils.escapeSplChars(c_item.fixed_lead_time) || c_field_seperator ||
905: msc_sda_utils.escapeSplChars(c_item.variable_lead_time) || c_field_seperator ||
906: msc_sda_utils.escapeSplChars(c_item.fixed_order_quantity) || c_field_seperator ||
907: msc_sda_utils.escapeSplChars(c_item.fixed_lot_multiplier) || c_field_seperator ||
900: msc_sda_utils.escapeSplChars(c_item.preprocessing_lead_time) || c_field_seperator ||
901: msc_sda_utils.escapeSplChars(c_item.full_lead_time) || c_field_seperator ||
902: msc_sda_utils.escapeSplChars(c_item.postprocessing_lead_time) || c_field_seperator ||
903: msc_sda_utils.escapeSplChars(c_item.leadtime_variability) || c_field_seperator ||
904: msc_sda_utils.escapeSplChars(c_item.fixed_lead_time) || c_field_seperator ||
905: msc_sda_utils.escapeSplChars(c_item.variable_lead_time) || c_field_seperator ||
906: msc_sda_utils.escapeSplChars(c_item.fixed_order_quantity) || c_field_seperator ||
907: msc_sda_utils.escapeSplChars(c_item.fixed_lot_multiplier) || c_field_seperator ||
908: msc_sda_utils.escapeSplChars(c_item.minimum_order_quantity) || c_field_seperator ||
901: msc_sda_utils.escapeSplChars(c_item.full_lead_time) || c_field_seperator ||
902: msc_sda_utils.escapeSplChars(c_item.postprocessing_lead_time) || c_field_seperator ||
903: msc_sda_utils.escapeSplChars(c_item.leadtime_variability) || c_field_seperator ||
904: msc_sda_utils.escapeSplChars(c_item.fixed_lead_time) || c_field_seperator ||
905: msc_sda_utils.escapeSplChars(c_item.variable_lead_time) || c_field_seperator ||
906: msc_sda_utils.escapeSplChars(c_item.fixed_order_quantity) || c_field_seperator ||
907: msc_sda_utils.escapeSplChars(c_item.fixed_lot_multiplier) || c_field_seperator ||
908: msc_sda_utils.escapeSplChars(c_item.minimum_order_quantity) || c_field_seperator ||
909: msc_sda_utils.escapeSplChars(c_item.maximum_order_quantity) || c_field_seperator ||
902: msc_sda_utils.escapeSplChars(c_item.postprocessing_lead_time) || c_field_seperator ||
903: msc_sda_utils.escapeSplChars(c_item.leadtime_variability) || c_field_seperator ||
904: msc_sda_utils.escapeSplChars(c_item.fixed_lead_time) || c_field_seperator ||
905: msc_sda_utils.escapeSplChars(c_item.variable_lead_time) || c_field_seperator ||
906: msc_sda_utils.escapeSplChars(c_item.fixed_order_quantity) || c_field_seperator ||
907: msc_sda_utils.escapeSplChars(c_item.fixed_lot_multiplier) || c_field_seperator ||
908: msc_sda_utils.escapeSplChars(c_item.minimum_order_quantity) || c_field_seperator ||
909: msc_sda_utils.escapeSplChars(c_item.maximum_order_quantity) || c_field_seperator ||
910: msc_sda_utils.escapeSplChars(c_item.safety_stock_days) || c_field_seperator ||
903: msc_sda_utils.escapeSplChars(c_item.leadtime_variability) || c_field_seperator ||
904: msc_sda_utils.escapeSplChars(c_item.fixed_lead_time) || c_field_seperator ||
905: msc_sda_utils.escapeSplChars(c_item.variable_lead_time) || c_field_seperator ||
906: msc_sda_utils.escapeSplChars(c_item.fixed_order_quantity) || c_field_seperator ||
907: msc_sda_utils.escapeSplChars(c_item.fixed_lot_multiplier) || c_field_seperator ||
908: msc_sda_utils.escapeSplChars(c_item.minimum_order_quantity) || c_field_seperator ||
909: msc_sda_utils.escapeSplChars(c_item.maximum_order_quantity) || c_field_seperator ||
910: msc_sda_utils.escapeSplChars(c_item.safety_stock_days) || c_field_seperator ||
911: msc_sda_utils.escapeSplChars(c_item.safety_stock_percent) || c_field_seperator ||
904: msc_sda_utils.escapeSplChars(c_item.fixed_lead_time) || c_field_seperator ||
905: msc_sda_utils.escapeSplChars(c_item.variable_lead_time) || c_field_seperator ||
906: msc_sda_utils.escapeSplChars(c_item.fixed_order_quantity) || c_field_seperator ||
907: msc_sda_utils.escapeSplChars(c_item.fixed_lot_multiplier) || c_field_seperator ||
908: msc_sda_utils.escapeSplChars(c_item.minimum_order_quantity) || c_field_seperator ||
909: msc_sda_utils.escapeSplChars(c_item.maximum_order_quantity) || c_field_seperator ||
910: msc_sda_utils.escapeSplChars(c_item.safety_stock_days) || c_field_seperator ||
911: msc_sda_utils.escapeSplChars(c_item.safety_stock_percent) || c_field_seperator ||
912: msc_sda_utils.escapeSplChars(c_item.fixed_days_supply) || c_field_seperator ||
905: msc_sda_utils.escapeSplChars(c_item.variable_lead_time) || c_field_seperator ||
906: msc_sda_utils.escapeSplChars(c_item.fixed_order_quantity) || c_field_seperator ||
907: msc_sda_utils.escapeSplChars(c_item.fixed_lot_multiplier) || c_field_seperator ||
908: msc_sda_utils.escapeSplChars(c_item.minimum_order_quantity) || c_field_seperator ||
909: msc_sda_utils.escapeSplChars(c_item.maximum_order_quantity) || c_field_seperator ||
910: msc_sda_utils.escapeSplChars(c_item.safety_stock_days) || c_field_seperator ||
911: msc_sda_utils.escapeSplChars(c_item.safety_stock_percent) || c_field_seperator ||
912: msc_sda_utils.escapeSplChars(c_item.fixed_days_supply) || c_field_seperator ||
913: msc_sda_utils.escapeSplChars(c_item.rounding_control_type) || c_field_seperator ||
906: msc_sda_utils.escapeSplChars(c_item.fixed_order_quantity) || c_field_seperator ||
907: msc_sda_utils.escapeSplChars(c_item.fixed_lot_multiplier) || c_field_seperator ||
908: msc_sda_utils.escapeSplChars(c_item.minimum_order_quantity) || c_field_seperator ||
909: msc_sda_utils.escapeSplChars(c_item.maximum_order_quantity) || c_field_seperator ||
910: msc_sda_utils.escapeSplChars(c_item.safety_stock_days) || c_field_seperator ||
911: msc_sda_utils.escapeSplChars(c_item.safety_stock_percent) || c_field_seperator ||
912: msc_sda_utils.escapeSplChars(c_item.fixed_days_supply) || c_field_seperator ||
913: msc_sda_utils.escapeSplChars(c_item.rounding_control_type) || c_field_seperator ||
914: msc_sda_utils.escapeSplChars(c_item.effectivity_control_type) || c_field_seperator ||
907: msc_sda_utils.escapeSplChars(c_item.fixed_lot_multiplier) || c_field_seperator ||
908: msc_sda_utils.escapeSplChars(c_item.minimum_order_quantity) || c_field_seperator ||
909: msc_sda_utils.escapeSplChars(c_item.maximum_order_quantity) || c_field_seperator ||
910: msc_sda_utils.escapeSplChars(c_item.safety_stock_days) || c_field_seperator ||
911: msc_sda_utils.escapeSplChars(c_item.safety_stock_percent) || c_field_seperator ||
912: msc_sda_utils.escapeSplChars(c_item.fixed_days_supply) || c_field_seperator ||
913: msc_sda_utils.escapeSplChars(c_item.rounding_control_type) || c_field_seperator ||
914: msc_sda_utils.escapeSplChars(c_item.effectivity_control_type) || c_field_seperator ||
915: msc_sda_utils.escapeSplChars(c_item.abc_class_name) || c_field_seperator ||
908: msc_sda_utils.escapeSplChars(c_item.minimum_order_quantity) || c_field_seperator ||
909: msc_sda_utils.escapeSplChars(c_item.maximum_order_quantity) || c_field_seperator ||
910: msc_sda_utils.escapeSplChars(c_item.safety_stock_days) || c_field_seperator ||
911: msc_sda_utils.escapeSplChars(c_item.safety_stock_percent) || c_field_seperator ||
912: msc_sda_utils.escapeSplChars(c_item.fixed_days_supply) || c_field_seperator ||
913: msc_sda_utils.escapeSplChars(c_item.rounding_control_type) || c_field_seperator ||
914: msc_sda_utils.escapeSplChars(c_item.effectivity_control_type) || c_field_seperator ||
915: msc_sda_utils.escapeSplChars(c_item.abc_class_name) || c_field_seperator ||
916: msc_sda_utils.escapeSplChars(c_item.selling_price) || c_field_seperator ||
909: msc_sda_utils.escapeSplChars(c_item.maximum_order_quantity) || c_field_seperator ||
910: msc_sda_utils.escapeSplChars(c_item.safety_stock_days) || c_field_seperator ||
911: msc_sda_utils.escapeSplChars(c_item.safety_stock_percent) || c_field_seperator ||
912: msc_sda_utils.escapeSplChars(c_item.fixed_days_supply) || c_field_seperator ||
913: msc_sda_utils.escapeSplChars(c_item.rounding_control_type) || c_field_seperator ||
914: msc_sda_utils.escapeSplChars(c_item.effectivity_control_type) || c_field_seperator ||
915: msc_sda_utils.escapeSplChars(c_item.abc_class_name) || c_field_seperator ||
916: msc_sda_utils.escapeSplChars(c_item.selling_price) || c_field_seperator ||
917: msc_sda_utils.escapeSplChars(c_item.margin) || c_field_seperator ||
910: msc_sda_utils.escapeSplChars(c_item.safety_stock_days) || c_field_seperator ||
911: msc_sda_utils.escapeSplChars(c_item.safety_stock_percent) || c_field_seperator ||
912: msc_sda_utils.escapeSplChars(c_item.fixed_days_supply) || c_field_seperator ||
913: msc_sda_utils.escapeSplChars(c_item.rounding_control_type) || c_field_seperator ||
914: msc_sda_utils.escapeSplChars(c_item.effectivity_control_type) || c_field_seperator ||
915: msc_sda_utils.escapeSplChars(c_item.abc_class_name) || c_field_seperator ||
916: msc_sda_utils.escapeSplChars(c_item.selling_price) || c_field_seperator ||
917: msc_sda_utils.escapeSplChars(c_item.margin) || c_field_seperator ||
918: msc_sda_utils.escapeSplChars(c_item.average_discount) || c_field_seperator ||
911: msc_sda_utils.escapeSplChars(c_item.safety_stock_percent) || c_field_seperator ||
912: msc_sda_utils.escapeSplChars(c_item.fixed_days_supply) || c_field_seperator ||
913: msc_sda_utils.escapeSplChars(c_item.rounding_control_type) || c_field_seperator ||
914: msc_sda_utils.escapeSplChars(c_item.effectivity_control_type) || c_field_seperator ||
915: msc_sda_utils.escapeSplChars(c_item.abc_class_name) || c_field_seperator ||
916: msc_sda_utils.escapeSplChars(c_item.selling_price) || c_field_seperator ||
917: msc_sda_utils.escapeSplChars(c_item.margin) || c_field_seperator ||
918: msc_sda_utils.escapeSplChars(c_item.average_discount) || c_field_seperator ||
919: msc_sda_utils.escapeSplChars(c_item.net_selling_price) || c_field_seperator ||
912: msc_sda_utils.escapeSplChars(c_item.fixed_days_supply) || c_field_seperator ||
913: msc_sda_utils.escapeSplChars(c_item.rounding_control_type) || c_field_seperator ||
914: msc_sda_utils.escapeSplChars(c_item.effectivity_control_type) || c_field_seperator ||
915: msc_sda_utils.escapeSplChars(c_item.abc_class_name) || c_field_seperator ||
916: msc_sda_utils.escapeSplChars(c_item.selling_price) || c_field_seperator ||
917: msc_sda_utils.escapeSplChars(c_item.margin) || c_field_seperator ||
918: msc_sda_utils.escapeSplChars(c_item.average_discount) || c_field_seperator ||
919: msc_sda_utils.escapeSplChars(c_item.net_selling_price) || c_field_seperator ||
920: msc_sda_utils.escapeSplChars(c_item.service_level) || c_field_seperator ||
913: msc_sda_utils.escapeSplChars(c_item.rounding_control_type) || c_field_seperator ||
914: msc_sda_utils.escapeSplChars(c_item.effectivity_control_type) || c_field_seperator ||
915: msc_sda_utils.escapeSplChars(c_item.abc_class_name) || c_field_seperator ||
916: msc_sda_utils.escapeSplChars(c_item.selling_price) || c_field_seperator ||
917: msc_sda_utils.escapeSplChars(c_item.margin) || c_field_seperator ||
918: msc_sda_utils.escapeSplChars(c_item.average_discount) || c_field_seperator ||
919: msc_sda_utils.escapeSplChars(c_item.net_selling_price) || c_field_seperator ||
920: msc_sda_utils.escapeSplChars(c_item.service_level) || c_field_seperator ||
921: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_days) || c_field_seperator ||
914: msc_sda_utils.escapeSplChars(c_item.effectivity_control_type) || c_field_seperator ||
915: msc_sda_utils.escapeSplChars(c_item.abc_class_name) || c_field_seperator ||
916: msc_sda_utils.escapeSplChars(c_item.selling_price) || c_field_seperator ||
917: msc_sda_utils.escapeSplChars(c_item.margin) || c_field_seperator ||
918: msc_sda_utils.escapeSplChars(c_item.average_discount) || c_field_seperator ||
919: msc_sda_utils.escapeSplChars(c_item.net_selling_price) || c_field_seperator ||
920: msc_sda_utils.escapeSplChars(c_item.service_level) || c_field_seperator ||
921: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_days) || c_field_seperator ||
922: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_date) || c_field_seperator ||
915: msc_sda_utils.escapeSplChars(c_item.abc_class_name) || c_field_seperator ||
916: msc_sda_utils.escapeSplChars(c_item.selling_price) || c_field_seperator ||
917: msc_sda_utils.escapeSplChars(c_item.margin) || c_field_seperator ||
918: msc_sda_utils.escapeSplChars(c_item.average_discount) || c_field_seperator ||
919: msc_sda_utils.escapeSplChars(c_item.net_selling_price) || c_field_seperator ||
920: msc_sda_utils.escapeSplChars(c_item.service_level) || c_field_seperator ||
921: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_days) || c_field_seperator ||
922: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_date) || c_field_seperator ||
923: msc_sda_utils.escapeSplChars(c_item.safety_stock_code) || c_field_seperator ||
916: msc_sda_utils.escapeSplChars(c_item.selling_price) || c_field_seperator ||
917: msc_sda_utils.escapeSplChars(c_item.margin) || c_field_seperator ||
918: msc_sda_utils.escapeSplChars(c_item.average_discount) || c_field_seperator ||
919: msc_sda_utils.escapeSplChars(c_item.net_selling_price) || c_field_seperator ||
920: msc_sda_utils.escapeSplChars(c_item.service_level) || c_field_seperator ||
921: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_days) || c_field_seperator ||
922: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_date) || c_field_seperator ||
923: msc_sda_utils.escapeSplChars(c_item.safety_stock_code) || c_field_seperator ||
924: msc_sda_utils.escapeSplChars(c_item.atp_flag) || c_field_seperator ||
917: msc_sda_utils.escapeSplChars(c_item.margin) || c_field_seperator ||
918: msc_sda_utils.escapeSplChars(c_item.average_discount) || c_field_seperator ||
919: msc_sda_utils.escapeSplChars(c_item.net_selling_price) || c_field_seperator ||
920: msc_sda_utils.escapeSplChars(c_item.service_level) || c_field_seperator ||
921: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_days) || c_field_seperator ||
922: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_date) || c_field_seperator ||
923: msc_sda_utils.escapeSplChars(c_item.safety_stock_code) || c_field_seperator ||
924: msc_sda_utils.escapeSplChars(c_item.atp_flag) || c_field_seperator ||
925: msc_sda_utils.escapeSplChars(c_item.atp_components_flag) || c_field_seperator ||
918: msc_sda_utils.escapeSplChars(c_item.average_discount) || c_field_seperator ||
919: msc_sda_utils.escapeSplChars(c_item.net_selling_price) || c_field_seperator ||
920: msc_sda_utils.escapeSplChars(c_item.service_level) || c_field_seperator ||
921: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_days) || c_field_seperator ||
922: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_date) || c_field_seperator ||
923: msc_sda_utils.escapeSplChars(c_item.safety_stock_code) || c_field_seperator ||
924: msc_sda_utils.escapeSplChars(c_item.atp_flag) || c_field_seperator ||
925: msc_sda_utils.escapeSplChars(c_item.atp_components_flag) || c_field_seperator ||
926: msc_sda_utils.escapeSplChars(c_item.drp_planned) || c_field_seperator ||
919: msc_sda_utils.escapeSplChars(c_item.net_selling_price) || c_field_seperator ||
920: msc_sda_utils.escapeSplChars(c_item.service_level) || c_field_seperator ||
921: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_days) || c_field_seperator ||
922: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_date) || c_field_seperator ||
923: msc_sda_utils.escapeSplChars(c_item.safety_stock_code) || c_field_seperator ||
924: msc_sda_utils.escapeSplChars(c_item.atp_flag) || c_field_seperator ||
925: msc_sda_utils.escapeSplChars(c_item.atp_components_flag) || c_field_seperator ||
926: msc_sda_utils.escapeSplChars(c_item.drp_planned) || c_field_seperator ||
927: msc_sda_utils.escapeSplChars(c_item.weight_uom) || c_field_seperator ||
920: msc_sda_utils.escapeSplChars(c_item.service_level) || c_field_seperator ||
921: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_days) || c_field_seperator ||
922: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_date) || c_field_seperator ||
923: msc_sda_utils.escapeSplChars(c_item.safety_stock_code) || c_field_seperator ||
924: msc_sda_utils.escapeSplChars(c_item.atp_flag) || c_field_seperator ||
925: msc_sda_utils.escapeSplChars(c_item.atp_components_flag) || c_field_seperator ||
926: msc_sda_utils.escapeSplChars(c_item.drp_planned) || c_field_seperator ||
927: msc_sda_utils.escapeSplChars(c_item.weight_uom) || c_field_seperator ||
928: msc_sda_utils.escapeSplChars(c_item.unit_weight) || c_field_seperator ||
921: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_days) || c_field_seperator ||
922: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_date) || c_field_seperator ||
923: msc_sda_utils.escapeSplChars(c_item.safety_stock_code) || c_field_seperator ||
924: msc_sda_utils.escapeSplChars(c_item.atp_flag) || c_field_seperator ||
925: msc_sda_utils.escapeSplChars(c_item.atp_components_flag) || c_field_seperator ||
926: msc_sda_utils.escapeSplChars(c_item.drp_planned) || c_field_seperator ||
927: msc_sda_utils.escapeSplChars(c_item.weight_uom) || c_field_seperator ||
928: msc_sda_utils.escapeSplChars(c_item.unit_weight) || c_field_seperator ||
929: msc_sda_utils.escapeSplChars(c_item.volume_uom) || c_field_seperator ||
922: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_date) || c_field_seperator ||
923: msc_sda_utils.escapeSplChars(c_item.safety_stock_code) || c_field_seperator ||
924: msc_sda_utils.escapeSplChars(c_item.atp_flag) || c_field_seperator ||
925: msc_sda_utils.escapeSplChars(c_item.atp_components_flag) || c_field_seperator ||
926: msc_sda_utils.escapeSplChars(c_item.drp_planned) || c_field_seperator ||
927: msc_sda_utils.escapeSplChars(c_item.weight_uom) || c_field_seperator ||
928: msc_sda_utils.escapeSplChars(c_item.unit_weight) || c_field_seperator ||
929: msc_sda_utils.escapeSplChars(c_item.volume_uom) || c_field_seperator ||
930: msc_sda_utils.escapeSplChars(c_item.pip_flag) || c_field_seperator ||
923: msc_sda_utils.escapeSplChars(c_item.safety_stock_code) || c_field_seperator ||
924: msc_sda_utils.escapeSplChars(c_item.atp_flag) || c_field_seperator ||
925: msc_sda_utils.escapeSplChars(c_item.atp_components_flag) || c_field_seperator ||
926: msc_sda_utils.escapeSplChars(c_item.drp_planned) || c_field_seperator ||
927: msc_sda_utils.escapeSplChars(c_item.weight_uom) || c_field_seperator ||
928: msc_sda_utils.escapeSplChars(c_item.unit_weight) || c_field_seperator ||
929: msc_sda_utils.escapeSplChars(c_item.volume_uom) || c_field_seperator ||
930: msc_sda_utils.escapeSplChars(c_item.pip_flag) || c_field_seperator ||
931: msc_sda_utils.escapeSplChars(c_item.create_supply_flag) || c_field_seperator ||
924: msc_sda_utils.escapeSplChars(c_item.atp_flag) || c_field_seperator ||
925: msc_sda_utils.escapeSplChars(c_item.atp_components_flag) || c_field_seperator ||
926: msc_sda_utils.escapeSplChars(c_item.drp_planned) || c_field_seperator ||
927: msc_sda_utils.escapeSplChars(c_item.weight_uom) || c_field_seperator ||
928: msc_sda_utils.escapeSplChars(c_item.unit_weight) || c_field_seperator ||
929: msc_sda_utils.escapeSplChars(c_item.volume_uom) || c_field_seperator ||
930: msc_sda_utils.escapeSplChars(c_item.pip_flag) || c_field_seperator ||
931: msc_sda_utils.escapeSplChars(c_item.create_supply_flag) || c_field_seperator ||
932: msc_sda_utils.escapeSplChars(c_item.substitution_window) || c_field_seperator ||
925: msc_sda_utils.escapeSplChars(c_item.atp_components_flag) || c_field_seperator ||
926: msc_sda_utils.escapeSplChars(c_item.drp_planned) || c_field_seperator ||
927: msc_sda_utils.escapeSplChars(c_item.weight_uom) || c_field_seperator ||
928: msc_sda_utils.escapeSplChars(c_item.unit_weight) || c_field_seperator ||
929: msc_sda_utils.escapeSplChars(c_item.volume_uom) || c_field_seperator ||
930: msc_sda_utils.escapeSplChars(c_item.pip_flag) || c_field_seperator ||
931: msc_sda_utils.escapeSplChars(c_item.create_supply_flag) || c_field_seperator ||
932: msc_sda_utils.escapeSplChars(c_item.substitution_window) || c_field_seperator ||
933: msc_sda_utils.escapeSplChars(c_item.convergence_text) || c_field_seperator ||
926: msc_sda_utils.escapeSplChars(c_item.drp_planned) || c_field_seperator ||
927: msc_sda_utils.escapeSplChars(c_item.weight_uom) || c_field_seperator ||
928: msc_sda_utils.escapeSplChars(c_item.unit_weight) || c_field_seperator ||
929: msc_sda_utils.escapeSplChars(c_item.volume_uom) || c_field_seperator ||
930: msc_sda_utils.escapeSplChars(c_item.pip_flag) || c_field_seperator ||
931: msc_sda_utils.escapeSplChars(c_item.create_supply_flag) || c_field_seperator ||
932: msc_sda_utils.escapeSplChars(c_item.substitution_window) || c_field_seperator ||
933: msc_sda_utils.escapeSplChars(c_item.convergence_text) || c_field_seperator ||
934: msc_sda_utils.escapeSplChars(c_item.divergence_text) || c_field_seperator ||
927: msc_sda_utils.escapeSplChars(c_item.weight_uom) || c_field_seperator ||
928: msc_sda_utils.escapeSplChars(c_item.unit_weight) || c_field_seperator ||
929: msc_sda_utils.escapeSplChars(c_item.volume_uom) || c_field_seperator ||
930: msc_sda_utils.escapeSplChars(c_item.pip_flag) || c_field_seperator ||
931: msc_sda_utils.escapeSplChars(c_item.create_supply_flag) || c_field_seperator ||
932: msc_sda_utils.escapeSplChars(c_item.substitution_window) || c_field_seperator ||
933: msc_sda_utils.escapeSplChars(c_item.convergence_text) || c_field_seperator ||
934: msc_sda_utils.escapeSplChars(c_item.divergence_text) || c_field_seperator ||
935: msc_sda_utils.escapeSplChars(c_item.continous_transfer_text) || c_field_seperator ||
928: msc_sda_utils.escapeSplChars(c_item.unit_weight) || c_field_seperator ||
929: msc_sda_utils.escapeSplChars(c_item.volume_uom) || c_field_seperator ||
930: msc_sda_utils.escapeSplChars(c_item.pip_flag) || c_field_seperator ||
931: msc_sda_utils.escapeSplChars(c_item.create_supply_flag) || c_field_seperator ||
932: msc_sda_utils.escapeSplChars(c_item.substitution_window) || c_field_seperator ||
933: msc_sda_utils.escapeSplChars(c_item.convergence_text) || c_field_seperator ||
934: msc_sda_utils.escapeSplChars(c_item.divergence_text) || c_field_seperator ||
935: msc_sda_utils.escapeSplChars(c_item.continous_transfer_text) || c_field_seperator ||
936: msc_sda_utils.escapeSplChars(c_item.exclude_from_budget) || c_field_seperator ||
929: msc_sda_utils.escapeSplChars(c_item.volume_uom) || c_field_seperator ||
930: msc_sda_utils.escapeSplChars(c_item.pip_flag) || c_field_seperator ||
931: msc_sda_utils.escapeSplChars(c_item.create_supply_flag) || c_field_seperator ||
932: msc_sda_utils.escapeSplChars(c_item.substitution_window) || c_field_seperator ||
933: msc_sda_utils.escapeSplChars(c_item.convergence_text) || c_field_seperator ||
934: msc_sda_utils.escapeSplChars(c_item.divergence_text) || c_field_seperator ||
935: msc_sda_utils.escapeSplChars(c_item.continous_transfer_text) || c_field_seperator ||
936: msc_sda_utils.escapeSplChars(c_item.exclude_from_budget) || c_field_seperator ||
937: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_window) || c_field_seperator ||
930: msc_sda_utils.escapeSplChars(c_item.pip_flag) || c_field_seperator ||
931: msc_sda_utils.escapeSplChars(c_item.create_supply_flag) || c_field_seperator ||
932: msc_sda_utils.escapeSplChars(c_item.substitution_window) || c_field_seperator ||
933: msc_sda_utils.escapeSplChars(c_item.convergence_text) || c_field_seperator ||
934: msc_sda_utils.escapeSplChars(c_item.divergence_text) || c_field_seperator ||
935: msc_sda_utils.escapeSplChars(c_item.continous_transfer_text) || c_field_seperator ||
936: msc_sda_utils.escapeSplChars(c_item.exclude_from_budget) || c_field_seperator ||
937: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_window) || c_field_seperator ||
938: msc_sda_utils.escapeSplChars(c_item.days_max_inv_window) || c_field_seperator ||
931: msc_sda_utils.escapeSplChars(c_item.create_supply_flag) || c_field_seperator ||
932: msc_sda_utils.escapeSplChars(c_item.substitution_window) || c_field_seperator ||
933: msc_sda_utils.escapeSplChars(c_item.convergence_text) || c_field_seperator ||
934: msc_sda_utils.escapeSplChars(c_item.divergence_text) || c_field_seperator ||
935: msc_sda_utils.escapeSplChars(c_item.continous_transfer_text) || c_field_seperator ||
936: msc_sda_utils.escapeSplChars(c_item.exclude_from_budget) || c_field_seperator ||
937: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_window) || c_field_seperator ||
938: msc_sda_utils.escapeSplChars(c_item.days_max_inv_window) || c_field_seperator ||
939: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_supply) || c_field_seperator ||
932: msc_sda_utils.escapeSplChars(c_item.substitution_window) || c_field_seperator ||
933: msc_sda_utils.escapeSplChars(c_item.convergence_text) || c_field_seperator ||
934: msc_sda_utils.escapeSplChars(c_item.divergence_text) || c_field_seperator ||
935: msc_sda_utils.escapeSplChars(c_item.continous_transfer_text) || c_field_seperator ||
936: msc_sda_utils.escapeSplChars(c_item.exclude_from_budget) || c_field_seperator ||
937: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_window) || c_field_seperator ||
938: msc_sda_utils.escapeSplChars(c_item.days_max_inv_window) || c_field_seperator ||
939: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_supply) || c_field_seperator ||
940: msc_sda_utils.escapeSplChars(c_item.days_max_inv_supply) || c_field_seperator ||
933: msc_sda_utils.escapeSplChars(c_item.convergence_text) || c_field_seperator ||
934: msc_sda_utils.escapeSplChars(c_item.divergence_text) || c_field_seperator ||
935: msc_sda_utils.escapeSplChars(c_item.continous_transfer_text) || c_field_seperator ||
936: msc_sda_utils.escapeSplChars(c_item.exclude_from_budget) || c_field_seperator ||
937: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_window) || c_field_seperator ||
938: msc_sda_utils.escapeSplChars(c_item.days_max_inv_window) || c_field_seperator ||
939: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_supply) || c_field_seperator ||
940: msc_sda_utils.escapeSplChars(c_item.days_max_inv_supply) || c_field_seperator ||
941: msc_sda_utils.escapeSplChars(c_item.shelf_life_days) || c_field_seperator ||
934: msc_sda_utils.escapeSplChars(c_item.divergence_text) || c_field_seperator ||
935: msc_sda_utils.escapeSplChars(c_item.continous_transfer_text) || c_field_seperator ||
936: msc_sda_utils.escapeSplChars(c_item.exclude_from_budget) || c_field_seperator ||
937: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_window) || c_field_seperator ||
938: msc_sda_utils.escapeSplChars(c_item.days_max_inv_window) || c_field_seperator ||
939: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_supply) || c_field_seperator ||
940: msc_sda_utils.escapeSplChars(c_item.days_max_inv_supply) || c_field_seperator ||
941: msc_sda_utils.escapeSplChars(c_item.shelf_life_days) || c_field_seperator ||
942: msc_sda_utils.escapeSplChars(c_item.release_time_fence_days) || c_field_seperator ||
935: msc_sda_utils.escapeSplChars(c_item.continous_transfer_text) || c_field_seperator ||
936: msc_sda_utils.escapeSplChars(c_item.exclude_from_budget) || c_field_seperator ||
937: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_window) || c_field_seperator ||
938: msc_sda_utils.escapeSplChars(c_item.days_max_inv_window) || c_field_seperator ||
939: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_supply) || c_field_seperator ||
940: msc_sda_utils.escapeSplChars(c_item.days_max_inv_supply) || c_field_seperator ||
941: msc_sda_utils.escapeSplChars(c_item.shelf_life_days) || c_field_seperator ||
942: msc_sda_utils.escapeSplChars(c_item.release_time_fence_days) || c_field_seperator ||
943: msc_sda_utils.escapeSplChars(c_item.min_shelf_life_days) || c_field_seperator ||
936: msc_sda_utils.escapeSplChars(c_item.exclude_from_budget) || c_field_seperator ||
937: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_window) || c_field_seperator ||
938: msc_sda_utils.escapeSplChars(c_item.days_max_inv_window) || c_field_seperator ||
939: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_supply) || c_field_seperator ||
940: msc_sda_utils.escapeSplChars(c_item.days_max_inv_supply) || c_field_seperator ||
941: msc_sda_utils.escapeSplChars(c_item.shelf_life_days) || c_field_seperator ||
942: msc_sda_utils.escapeSplChars(c_item.release_time_fence_days) || c_field_seperator ||
943: msc_sda_utils.escapeSplChars(c_item.min_shelf_life_days) || c_field_seperator ||
944: msc_sda_utils.escapeSplChars(c_item.unit_volume) || c_field_seperator ||
937: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_window) || c_field_seperator ||
938: msc_sda_utils.escapeSplChars(c_item.days_max_inv_window) || c_field_seperator ||
939: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_supply) || c_field_seperator ||
940: msc_sda_utils.escapeSplChars(c_item.days_max_inv_supply) || c_field_seperator ||
941: msc_sda_utils.escapeSplChars(c_item.shelf_life_days) || c_field_seperator ||
942: msc_sda_utils.escapeSplChars(c_item.release_time_fence_days) || c_field_seperator ||
943: msc_sda_utils.escapeSplChars(c_item.min_shelf_life_days) || c_field_seperator ||
944: msc_sda_utils.escapeSplChars(c_item.unit_volume) || c_field_seperator ||
945: msc_sda_utils.escapeSplChars(c_item.max_early_days) || c_field_seperator ||
938: msc_sda_utils.escapeSplChars(c_item.days_max_inv_window) || c_field_seperator ||
939: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_supply) || c_field_seperator ||
940: msc_sda_utils.escapeSplChars(c_item.days_max_inv_supply) || c_field_seperator ||
941: msc_sda_utils.escapeSplChars(c_item.shelf_life_days) || c_field_seperator ||
942: msc_sda_utils.escapeSplChars(c_item.release_time_fence_days) || c_field_seperator ||
943: msc_sda_utils.escapeSplChars(c_item.min_shelf_life_days) || c_field_seperator ||
944: msc_sda_utils.escapeSplChars(c_item.unit_volume) || c_field_seperator ||
945: msc_sda_utils.escapeSplChars(c_item.max_early_days) || c_field_seperator ||
946: msc_sda_utils.escapeSplChars(c_item.demand_fulfillment_lt) || c_field_seperator ||
939: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_supply) || c_field_seperator ||
940: msc_sda_utils.escapeSplChars(c_item.days_max_inv_supply) || c_field_seperator ||
941: msc_sda_utils.escapeSplChars(c_item.shelf_life_days) || c_field_seperator ||
942: msc_sda_utils.escapeSplChars(c_item.release_time_fence_days) || c_field_seperator ||
943: msc_sda_utils.escapeSplChars(c_item.min_shelf_life_days) || c_field_seperator ||
944: msc_sda_utils.escapeSplChars(c_item.unit_volume) || c_field_seperator ||
945: msc_sda_utils.escapeSplChars(c_item.max_early_days) || c_field_seperator ||
946: msc_sda_utils.escapeSplChars(c_item.demand_fulfillment_lt) || c_field_seperator ||
947: msc_sda_utils.escapeSplChars(to_char(c_item.end_of_life_date, c_datetime_format)) || c_field_seperator ||
940: msc_sda_utils.escapeSplChars(c_item.days_max_inv_supply) || c_field_seperator ||
941: msc_sda_utils.escapeSplChars(c_item.shelf_life_days) || c_field_seperator ||
942: msc_sda_utils.escapeSplChars(c_item.release_time_fence_days) || c_field_seperator ||
943: msc_sda_utils.escapeSplChars(c_item.min_shelf_life_days) || c_field_seperator ||
944: msc_sda_utils.escapeSplChars(c_item.unit_volume) || c_field_seperator ||
945: msc_sda_utils.escapeSplChars(c_item.max_early_days) || c_field_seperator ||
946: msc_sda_utils.escapeSplChars(c_item.demand_fulfillment_lt) || c_field_seperator ||
947: msc_sda_utils.escapeSplChars(to_char(c_item.end_of_life_date, c_datetime_format)) || c_field_seperator ||
948: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_demands_text) || c_field_seperator ||
941: msc_sda_utils.escapeSplChars(c_item.shelf_life_days) || c_field_seperator ||
942: msc_sda_utils.escapeSplChars(c_item.release_time_fence_days) || c_field_seperator ||
943: msc_sda_utils.escapeSplChars(c_item.min_shelf_life_days) || c_field_seperator ||
944: msc_sda_utils.escapeSplChars(c_item.unit_volume) || c_field_seperator ||
945: msc_sda_utils.escapeSplChars(c_item.max_early_days) || c_field_seperator ||
946: msc_sda_utils.escapeSplChars(c_item.demand_fulfillment_lt) || c_field_seperator ||
947: msc_sda_utils.escapeSplChars(to_char(c_item.end_of_life_date, c_datetime_format)) || c_field_seperator ||
948: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_demands_text) || c_field_seperator ||
949: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_returns_text) || c_field_seperator ||
942: msc_sda_utils.escapeSplChars(c_item.release_time_fence_days) || c_field_seperator ||
943: msc_sda_utils.escapeSplChars(c_item.min_shelf_life_days) || c_field_seperator ||
944: msc_sda_utils.escapeSplChars(c_item.unit_volume) || c_field_seperator ||
945: msc_sda_utils.escapeSplChars(c_item.max_early_days) || c_field_seperator ||
946: msc_sda_utils.escapeSplChars(c_item.demand_fulfillment_lt) || c_field_seperator ||
947: msc_sda_utils.escapeSplChars(to_char(c_item.end_of_life_date, c_datetime_format)) || c_field_seperator ||
948: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_demands_text) || c_field_seperator ||
949: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_returns_text) || c_field_seperator ||
950: msc_sda_utils.escapeSplChars(c_item.interarrival_time) || c_field_seperator ||
943: msc_sda_utils.escapeSplChars(c_item.min_shelf_life_days) || c_field_seperator ||
944: msc_sda_utils.escapeSplChars(c_item.unit_volume) || c_field_seperator ||
945: msc_sda_utils.escapeSplChars(c_item.max_early_days) || c_field_seperator ||
946: msc_sda_utils.escapeSplChars(c_item.demand_fulfillment_lt) || c_field_seperator ||
947: msc_sda_utils.escapeSplChars(to_char(c_item.end_of_life_date, c_datetime_format)) || c_field_seperator ||
948: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_demands_text) || c_field_seperator ||
949: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_returns_text) || c_field_seperator ||
950: msc_sda_utils.escapeSplChars(c_item.interarrival_time) || c_field_seperator ||
951: msc_sda_utils.escapeSplChars(to_char(c_item.life_time_buy_date, c_datetime_format)) || c_field_seperator ||
944: msc_sda_utils.escapeSplChars(c_item.unit_volume) || c_field_seperator ||
945: msc_sda_utils.escapeSplChars(c_item.max_early_days) || c_field_seperator ||
946: msc_sda_utils.escapeSplChars(c_item.demand_fulfillment_lt) || c_field_seperator ||
947: msc_sda_utils.escapeSplChars(to_char(c_item.end_of_life_date, c_datetime_format)) || c_field_seperator ||
948: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_demands_text) || c_field_seperator ||
949: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_returns_text) || c_field_seperator ||
950: msc_sda_utils.escapeSplChars(c_item.interarrival_time) || c_field_seperator ||
951: msc_sda_utils.escapeSplChars(to_char(c_item.life_time_buy_date, c_datetime_format)) || c_field_seperator ||
952: msc_sda_utils.escapeSplChars(c_item.preposition_point) || c_field_seperator ||
945: msc_sda_utils.escapeSplChars(c_item.max_early_days) || c_field_seperator ||
946: msc_sda_utils.escapeSplChars(c_item.demand_fulfillment_lt) || c_field_seperator ||
947: msc_sda_utils.escapeSplChars(to_char(c_item.end_of_life_date, c_datetime_format)) || c_field_seperator ||
948: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_demands_text) || c_field_seperator ||
949: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_returns_text) || c_field_seperator ||
950: msc_sda_utils.escapeSplChars(c_item.interarrival_time) || c_field_seperator ||
951: msc_sda_utils.escapeSplChars(to_char(c_item.life_time_buy_date, c_datetime_format)) || c_field_seperator ||
952: msc_sda_utils.escapeSplChars(c_item.preposition_point) || c_field_seperator ||
953: msc_sda_utils.escapeSplChars(c_item.repair_cost) || c_field_seperator ||
946: msc_sda_utils.escapeSplChars(c_item.demand_fulfillment_lt) || c_field_seperator ||
947: msc_sda_utils.escapeSplChars(to_char(c_item.end_of_life_date, c_datetime_format)) || c_field_seperator ||
948: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_demands_text) || c_field_seperator ||
949: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_returns_text) || c_field_seperator ||
950: msc_sda_utils.escapeSplChars(c_item.interarrival_time) || c_field_seperator ||
951: msc_sda_utils.escapeSplChars(to_char(c_item.life_time_buy_date, c_datetime_format)) || c_field_seperator ||
952: msc_sda_utils.escapeSplChars(c_item.preposition_point) || c_field_seperator ||
953: msc_sda_utils.escapeSplChars(c_item.repair_cost) || c_field_seperator ||
954: msc_sda_utils.escapeSplChars(c_item.repair_lead_time) || c_field_seperator ||
947: msc_sda_utils.escapeSplChars(to_char(c_item.end_of_life_date, c_datetime_format)) || c_field_seperator ||
948: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_demands_text) || c_field_seperator ||
949: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_returns_text) || c_field_seperator ||
950: msc_sda_utils.escapeSplChars(c_item.interarrival_time) || c_field_seperator ||
951: msc_sda_utils.escapeSplChars(to_char(c_item.life_time_buy_date, c_datetime_format)) || c_field_seperator ||
952: msc_sda_utils.escapeSplChars(c_item.preposition_point) || c_field_seperator ||
953: msc_sda_utils.escapeSplChars(c_item.repair_cost) || c_field_seperator ||
954: msc_sda_utils.escapeSplChars(c_item.repair_lead_time) || c_field_seperator ||
955: msc_sda_utils.escapeSplChars(c_item.repair_program_text) || c_field_seperator ||
948: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_demands_text) || c_field_seperator ||
949: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_returns_text) || c_field_seperator ||
950: msc_sda_utils.escapeSplChars(c_item.interarrival_time) || c_field_seperator ||
951: msc_sda_utils.escapeSplChars(to_char(c_item.life_time_buy_date, c_datetime_format)) || c_field_seperator ||
952: msc_sda_utils.escapeSplChars(c_item.preposition_point) || c_field_seperator ||
953: msc_sda_utils.escapeSplChars(c_item.repair_cost) || c_field_seperator ||
954: msc_sda_utils.escapeSplChars(c_item.repair_lead_time) || c_field_seperator ||
955: msc_sda_utils.escapeSplChars(c_item.repair_program_text) || c_field_seperator ||
956: msc_sda_utils.escapeSplChars(c_item.repair_yield) || c_field_seperator ||
949: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_returns_text) || c_field_seperator ||
950: msc_sda_utils.escapeSplChars(c_item.interarrival_time) || c_field_seperator ||
951: msc_sda_utils.escapeSplChars(to_char(c_item.life_time_buy_date, c_datetime_format)) || c_field_seperator ||
952: msc_sda_utils.escapeSplChars(c_item.preposition_point) || c_field_seperator ||
953: msc_sda_utils.escapeSplChars(c_item.repair_cost) || c_field_seperator ||
954: msc_sda_utils.escapeSplChars(c_item.repair_lead_time) || c_field_seperator ||
955: msc_sda_utils.escapeSplChars(c_item.repair_program_text) || c_field_seperator ||
956: msc_sda_utils.escapeSplChars(c_item.repair_yield) || c_field_seperator ||
957: msc_sda_utils.escapeSplChars(c_item.std_dmd_over_horizon) || c_field_seperator ||
950: msc_sda_utils.escapeSplChars(c_item.interarrival_time) || c_field_seperator ||
951: msc_sda_utils.escapeSplChars(to_char(c_item.life_time_buy_date, c_datetime_format)) || c_field_seperator ||
952: msc_sda_utils.escapeSplChars(c_item.preposition_point) || c_field_seperator ||
953: msc_sda_utils.escapeSplChars(c_item.repair_cost) || c_field_seperator ||
954: msc_sda_utils.escapeSplChars(c_item.repair_lead_time) || c_field_seperator ||
955: msc_sda_utils.escapeSplChars(c_item.repair_program_text) || c_field_seperator ||
956: msc_sda_utils.escapeSplChars(c_item.repair_yield) || c_field_seperator ||
957: msc_sda_utils.escapeSplChars(c_item.std_dmd_over_horizon) || c_field_seperator ||
958: msc_sda_utils.escapeSplChars(c_item.repetitive_planning_flag_text);
951: msc_sda_utils.escapeSplChars(to_char(c_item.life_time_buy_date, c_datetime_format)) || c_field_seperator ||
952: msc_sda_utils.escapeSplChars(c_item.preposition_point) || c_field_seperator ||
953: msc_sda_utils.escapeSplChars(c_item.repair_cost) || c_field_seperator ||
954: msc_sda_utils.escapeSplChars(c_item.repair_lead_time) || c_field_seperator ||
955: msc_sda_utils.escapeSplChars(c_item.repair_program_text) || c_field_seperator ||
956: msc_sda_utils.escapeSplChars(c_item.repair_yield) || c_field_seperator ||
957: msc_sda_utils.escapeSplChars(c_item.std_dmd_over_horizon) || c_field_seperator ||
958: msc_sda_utils.escapeSplChars(c_item.repetitive_planning_flag_text);
959:
952: msc_sda_utils.escapeSplChars(c_item.preposition_point) || c_field_seperator ||
953: msc_sda_utils.escapeSplChars(c_item.repair_cost) || c_field_seperator ||
954: msc_sda_utils.escapeSplChars(c_item.repair_lead_time) || c_field_seperator ||
955: msc_sda_utils.escapeSplChars(c_item.repair_program_text) || c_field_seperator ||
956: msc_sda_utils.escapeSplChars(c_item.repair_yield) || c_field_seperator ||
957: msc_sda_utils.escapeSplChars(c_item.std_dmd_over_horizon) || c_field_seperator ||
958: msc_sda_utils.escapeSplChars(c_item.repetitive_planning_flag_text);
959:
960: l_row_count := l_row_count + 1;
953: msc_sda_utils.escapeSplChars(c_item.repair_cost) || c_field_seperator ||
954: msc_sda_utils.escapeSplChars(c_item.repair_lead_time) || c_field_seperator ||
955: msc_sda_utils.escapeSplChars(c_item.repair_program_text) || c_field_seperator ||
956: msc_sda_utils.escapeSplChars(c_item.repair_yield) || c_field_seperator ||
957: msc_sda_utils.escapeSplChars(c_item.std_dmd_over_horizon) || c_field_seperator ||
958: msc_sda_utils.escapeSplChars(c_item.repetitive_planning_flag_text);
959:
960: l_row_count := l_row_count + 1;
961:
954: msc_sda_utils.escapeSplChars(c_item.repair_lead_time) || c_field_seperator ||
955: msc_sda_utils.escapeSplChars(c_item.repair_program_text) || c_field_seperator ||
956: msc_sda_utils.escapeSplChars(c_item.repair_yield) || c_field_seperator ||
957: msc_sda_utils.escapeSplChars(c_item.std_dmd_over_horizon) || c_field_seperator ||
958: msc_sda_utils.escapeSplChars(c_item.repetitive_planning_flag_text);
959:
960: l_row_count := l_row_count + 1;
961:
962: if (l_row_count = 1) then
961:
962: if (l_row_count = 1) then
963: l_one_record := c_sdview_items_data || c_bang_separator || c_record_seperator || l_one_record;
964: end if;
965: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
966: end loop;
967: println('getItemsData out');
968: end getItemsData;
969:
1028: begin
1029: println('getExceptionsData in');
1030: for c_excp_summary in c_excp_summary_cur loop
1031: l_one_record :=
1032: msc_sda_utils.escapeSplChars(p_chain_query_id||'-'||c_excp_summary.exception_type) || c_field_seperator ||
1033: msc_sda_utils.escapeSplChars(c_excp_summary.exception_type_text) || c_field_seperator ||
1034: msc_sda_utils.escapeSplChars(c_excp_summary.excp_all_count) || c_field_seperator ||
1035: msc_sda_utils.escapeSplChars(c_excp_summary.excp_no_count);
1036:
1029: println('getExceptionsData in');
1030: for c_excp_summary in c_excp_summary_cur loop
1031: l_one_record :=
1032: msc_sda_utils.escapeSplChars(p_chain_query_id||'-'||c_excp_summary.exception_type) || c_field_seperator ||
1033: msc_sda_utils.escapeSplChars(c_excp_summary.exception_type_text) || c_field_seperator ||
1034: msc_sda_utils.escapeSplChars(c_excp_summary.excp_all_count) || c_field_seperator ||
1035: msc_sda_utils.escapeSplChars(c_excp_summary.excp_no_count);
1036:
1037: l_row_count := l_row_count + 1;
1030: for c_excp_summary in c_excp_summary_cur loop
1031: l_one_record :=
1032: msc_sda_utils.escapeSplChars(p_chain_query_id||'-'||c_excp_summary.exception_type) || c_field_seperator ||
1033: msc_sda_utils.escapeSplChars(c_excp_summary.exception_type_text) || c_field_seperator ||
1034: msc_sda_utils.escapeSplChars(c_excp_summary.excp_all_count) || c_field_seperator ||
1035: msc_sda_utils.escapeSplChars(c_excp_summary.excp_no_count);
1036:
1037: l_row_count := l_row_count + 1;
1038: if (l_row_count = 1) then
1031: l_one_record :=
1032: msc_sda_utils.escapeSplChars(p_chain_query_id||'-'||c_excp_summary.exception_type) || c_field_seperator ||
1033: msc_sda_utils.escapeSplChars(c_excp_summary.exception_type_text) || c_field_seperator ||
1034: msc_sda_utils.escapeSplChars(c_excp_summary.excp_all_count) || c_field_seperator ||
1035: msc_sda_utils.escapeSplChars(c_excp_summary.excp_no_count);
1036:
1037: l_row_count := l_row_count + 1;
1038: if (l_row_count = 1) then
1039: l_one_record := c_sdview_excp_data || c_bang_separator || c_record_seperator || l_one_record;
1037: l_row_count := l_row_count + 1;
1038: if (l_row_count = 1) then
1039: l_one_record := c_sdview_excp_data || c_bang_separator || c_record_seperator || l_one_record;
1040: end if;
1041: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1042: end loop;
1043: println('getExceptionsData out');
1044: end getExceptionsData;
1045:
1065: end if;
1066: for c_userpref in c_userpref_cur
1067: loop
1068: l_one_record :=
1069: msc_sda_utils.escapeSplChars(c_userpref.name) || c_field_seperator ||
1070: msc_sda_utils.escapeSplChars(c_userpref.key) || c_field_seperator ||
1071: msc_sda_utils.escapeSplChars(c_userpref.value);
1072:
1073: l_row_count := l_row_count + 1;
1066: for c_userpref in c_userpref_cur
1067: loop
1068: l_one_record :=
1069: msc_sda_utils.escapeSplChars(c_userpref.name) || c_field_seperator ||
1070: msc_sda_utils.escapeSplChars(c_userpref.key) || c_field_seperator ||
1071: msc_sda_utils.escapeSplChars(c_userpref.value);
1072:
1073: l_row_count := l_row_count + 1;
1074: if (l_row_count = 1) then
1067: loop
1068: l_one_record :=
1069: msc_sda_utils.escapeSplChars(c_userpref.name) || c_field_seperator ||
1070: msc_sda_utils.escapeSplChars(c_userpref.key) || c_field_seperator ||
1071: msc_sda_utils.escapeSplChars(c_userpref.value);
1072:
1073: l_row_count := l_row_count + 1;
1074: if (l_row_count = 1) then
1075: l_one_record := l_stream_label || c_bang_separator || c_record_seperator || l_one_record;
1073: l_row_count := l_row_count + 1;
1074: if (l_row_count = 1) then
1075: l_one_record := l_stream_label || c_bang_separator || c_record_seperator || l_one_record;
1076: end if;
1077: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1078: end loop;
1079: println('getWorkSheetPrefData out');
1080: end getWorkSheetPrefData;
1081:
1078: end loop;
1079: println('getWorkSheetPrefData out');
1080: end getWorkSheetPrefData;
1081:
1082: procedure sendSDRowTypes(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1083: cursor c_sd_rowtypes_cur is
1084: select lookup_code, meaning
1085: from mfg_lookups
1086: where lookup_type = c_sdview_rowtype_lookup
1136: l_total_row_flag := 1;
1137: end if;
1138:
1139: l_token := c_sd_rowtypes.lookup_code
1140: || c_field_seperator || msc_sda_utils.escapeSplChars(c_sd_rowtypes.meaning)
1141: || c_field_seperator || l_flag || c_field_seperator || l_visible_flag || c_field_seperator || l_total_row_flag;
1142: if (l_one_record is null) then
1143: l_one_record := c_sdview_rowtypes || c_bang_separator || c_sd_total_row_types || c_record_seperator || l_token;
1144: else
1144: else
1145: l_one_record := l_one_record || c_record_seperator || l_token;
1146: end if;
1147: end loop;
1148: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1149: end sendSDRowTypes;
1150:
1151: procedure sendFcstRowTypes(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1152: cursor c_fcst_rowtypes_cur is
1147: end loop;
1148: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1149: end sendSDRowTypes;
1150:
1151: procedure sendFcstRowTypes(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1152: cursor c_fcst_rowtypes_cur is
1153: select lookup_code, meaning
1154: from mfg_lookups
1155: where lookup_type = c_fcstview_rowtype_lookup
1180: l_total_row_flag := 1;
1181: end if;
1182:
1183: l_token := c_fcst_rowtypes.lookup_code
1184: || c_field_seperator || msc_sda_utils.escapeSplChars(c_fcst_rowtypes.meaning)
1185: || c_field_seperator || l_flag || c_field_seperator || l_visible_flag || c_field_seperator || l_total_row_flag;
1186: if (l_one_record is null) then
1187: l_one_record := c_fcstview_rowtypes || c_bang_separator || c_fcst_total_row_types || c_record_seperator || l_token;
1188: else
1188: else
1189: l_one_record := l_one_record || c_record_seperator || l_token;
1190: end if;
1191: end loop;
1192: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1193: end sendFcstRowTypes;
1194:
1195: procedure sendHistRowTypes(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1196: cursor c_hist_rowtypes_cur is
1191: end loop;
1192: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1193: end sendFcstRowTypes;
1194:
1195: procedure sendHistRowTypes(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1196: cursor c_hist_rowtypes_cur is
1197: select lookup_code, meaning
1198: from mfg_lookups
1199: where lookup_type = c_histview_rowtype_lookup
1210: l_flag := 0;
1211: l_visible_flag := 1;
1212: l_total_row_flag := 2;
1213: l_token := c_hist_rowtypes.lookup_code
1214: || c_field_seperator || msc_sda_utils.escapeSplChars(c_hist_rowtypes.meaning)
1215: || c_field_seperator || l_flag || c_field_seperator || l_visible_flag || c_field_seperator || l_total_row_flag;
1216: if (l_one_record is null) then
1217: l_one_record := c_histview_rowtypes || c_bang_separator || c_hist_total_row_types || c_record_seperator || l_token;
1218: else
1218: else
1219: l_one_record := l_one_record || c_record_seperator || l_token;
1220: end if;
1221: end loop;
1222: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1223: end sendHistRowTypes;
1224:
1225: function getTokenizedMsg(p_msg varchar2) return varchar2 is
1226: l_msg_text varchar2(300);
1229: l_msg_text:= FND_MESSAGE.get;
1230: if (l_msg_text is null) then
1231: l_msg_text:= p_msg|| c_field_seperator || p_msg;
1232: else
1233: l_msg_text:= p_msg|| c_field_seperator || msc_sda_utils.escapeSplChars(l_msg_text);
1234: end if;
1235: return l_msg_text;
1236: end getTokenizedMsg;
1237:
1235: return l_msg_text;
1236: end getTokenizedMsg;
1237:
1238: procedure addMessages(p_msg varchar2, p_out_data_index in out nocopy number,
1239: p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1240: l_one_record varchar2(1200) := null;
1241: l_token varchar2(1000);
1242: begin
1243: l_one_record := getTokenizedMsg(p_msg);
1240: l_one_record varchar2(1200) := null;
1241: l_token varchar2(1000);
1242: begin
1243: l_one_record := getTokenizedMsg(p_msg);
1244: msc_sda_utils.addRecordToOutStream(l_one_record, p_out_data_index, p_out_data);
1245: end addMessages;
1246:
1247: procedure sendNlsMessages(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1248: l_one_record varchar2(32000) := null;
1243: l_one_record := getTokenizedMsg(p_msg);
1244: msc_sda_utils.addRecordToOutStream(l_one_record, p_out_data_index, p_out_data);
1245: end addMessages;
1246:
1247: procedure sendNlsMessages(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1248: l_one_record varchar2(32000) := null;
1249: l_token varchar2(1000);
1250: l_out_data_index number := 1;
1251: begin
1250: l_out_data_index number := 1;
1251: begin
1252: l_token := getTokenizedMsg('MENU_ORDER_DETAILS');
1253: l_one_record := c_sdview_nls_messages || c_bang_separator || c_record_seperator || l_token;
1254: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1255:
1256: addMessages('MENU_FORECAST_RULE', l_out_data_index, p_out_data);
1257: addMessages('MENU_CALENDAR', l_out_data_index, p_out_data);
1258: addMessages('MENU_SOURCES', l_out_data_index, p_out_data);
1325: open theCursor for l_sql_stmt using p_lookup_type;
1326: loop
1327: fetch theCursor into l_lookup_code, l_meaning;
1328: exit when theCursor%notfound;
1329: l_token := l_lookup_code || c_field_seperator || msc_sda_utils.escapeSplChars(l_meaning);
1330: if (l_one_record is null) then
1331: l_one_record := SET_FROM_LIST || c_bang_separator || l_token;
1332: else
1333: l_one_record := l_one_record || c_record_seperator || l_token;
1345: open theCursor for l_sql_stmt using p_lookup_type;
1346: loop
1347: fetch theCursor into l_lookup_code, l_meaning;
1348: exit when theCursor%notfound;
1349: l_token := l_lookup_code || c_field_seperator || msc_sda_utils.escapeSplChars(l_meaning);
1350: if (l_one_record is null) then
1351: l_one_record := SET_TO_LIST || c_bang_separator || l_token;
1352: else
1353: l_one_record := l_one_record || c_record_seperator || l_token;
1560: end if;
1561: commit;
1562: end update_pref_set;
1563:
1564: end MSC_SDA_UTILS;