[Home] [Help]
1: package body MSC_SDA_UTILS as
2: /* $Header: MSCSDAUB.pls 120.55 2010/12/17 20:36:08 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');
169: creation_date, created_by, last_updated_by, last_update_date, number1, number2, number3, number4,
170: number5, number6, number7, date1, date2)
171: select l_query_id,sysdate, -1, -1, sysdate,
172: b.lower_item_id, b.higher_item_id, b.highest_item_id, l_level, b.reciprocal_flag,
173: msc_sda_utils.getRepairItem(b.plan_id, b.lower_item_id, b.highest_item_id) repair_item_id,
174: b.prime_item_id,
175: b.effective_date,
176: b.disable_date
177: from msc_item_substitutes b, msc_plans mp
194: creation_date, created_by, last_updated_by, last_update_date, number1, number2, number3, number4,
195: number5, number6, number7, date1, date2)
196: select l_query_id,sysdate, -1, -1, sysdate,
197: b.lower_item_id, b.higher_item_id, b.highest_item_id, l_level, b.reciprocal_flag,
198: msc_sda_utils.getRepairItem(b.plan_id, b.lower_item_id, b.highest_item_id) repair_item_id,
199: b.prime_item_id,
200: b.effective_date,
201: b.disable_date
202: from msc_item_substitutes b, msc_plans mp
457: number5, number6, number7, date1, date2)
458: select l_query_id,sysdate, -1, -1, sysdate,
459: b.lower_item_id, b.higher_item_id, b.highest_item_id, level,
460: b.reciprocal_flag,
461: msc_sda_utils.getRepairItem(plan_id, b.lower_item_id, b.highest_item_id) repair_item_id,
462: b.prime_item_id,
463: (select min(a.effective_date) from msc_item_substitutes a
464: where a.plan_id=p_plan
465: and a.lower_item_id = b.lower_item_id
687: select distinct
688: to_number(null) region_list_id,
689: to_char(null) region_list,
690: p_region_list region_id,
691: msc_sda_utils.getRegionName(p_region_list) region_code,
692: p_region_list sort_column
693: from dual
694: where p_region_type = c_reg_view
695: and p_view_type = 1
697: select distinct
698: mpq.query_id region_list_id,
699: mpq.query_name region_list,
700: mpt.object_type region_id,
701: msc_sda_utils.getRegionName(mpt.object_type) region_code,
702: mpt.sequence_id sort_column
703: from msc_pq_types mpt,
704: msc_personal_queries mpq
705: where mpq.query_id = p_region_list
791:
792: if ( p_region_list is not null) then
793: ll_view_type := 1;
794: elsif (p_org_list is not null) then
795: 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);
796: ll_view_type := 2;
797: end if;
798:
799: for c_regions in c_regions_cur(ll_view_type)
1018: l_temp number;
1019: l_order number := 0;
1020: begin
1021: if p_item_view_type = c_ritems_view then
1022: l_rqid := msc_sda_utils.flushSupersessionChain(p_plan_id, p_item_id,1);
1023:
1024: l_rqid_sorted := getNewFormQueryId;
1025: for c_rchain in c_related_cur
1026: loop
1118: end loop;
1119: return l_query_id;
1120: end createHistCalInMfq;
1121:
1122: procedure spreadTableMessages(p_out_data in out nocopy msc_sda_utils.maxCharTbl) is
1123: cursor c_item_prompts_cur (p_folder_object varchar2) is
1124: select field_type,
1125: field_name,
1126: field_prompt,
1146: l_row_count := l_row_count + 1;
1147: if (l_row_count = 1) then
1148: l_one_record := c_sdview_items_messages || c_bang_separator || c_record_seperator || l_one_record;
1149: end if;
1150: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1151: end loop;
1152:
1153: l_row_count := 0;
1154:
1162: l_row_count := l_row_count + 1;
1163: if (l_row_count = 1) then
1164: l_one_record := c_sdview_comments_messages || c_bang_separator || c_record_seperator || l_one_record;
1165: end if;
1166: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1167: end loop;
1168:
1169: l_row_count := 0;
1170:
1178: l_row_count := l_row_count + 1;
1179: if (l_row_count = 1) then
1180: l_one_record := c_sdview_excp_messages || c_bang_separator || c_record_seperator || l_one_record;
1181: end if;
1182: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1183: end loop;
1184: end spreadTableMessages;
1185:
1186: procedure getCommentsData(p_plan_id number, p_chain_query_id number,
1183: end loop;
1184: end spreadTableMessages;
1185:
1186: procedure getCommentsData(p_plan_id number, p_chain_query_id number,
1187: p_out_data in out nocopy msc_sda_utils.maxCharTbl, p_stream_label varchar2) is
1188:
1189: cursor c_comments_cur is
1190: select distinct mun.note_id,
1191: nvl(mun.last_update_date, mun.creation_date) comment_date,
1209: loop
1210: l_row_count := l_row_count + 1;
1211: l_one_record := to_char(c_comments.note_id)
1212: || c_field_seperator || to_char(c_comments.comment_date, c_date_format)
1213: || c_field_seperator || msc_sda_utils.escapeSplChars(c_comments.comment_text)
1214: || c_field_seperator || msc_sda_utils.escapeSplChars(c_comments.item_name);
1215: if (l_row_count = 1) then
1216: l_one_record := p_stream_label || c_bang_separator || c_record_seperator || l_one_record;
1217: end if;
1210: l_row_count := l_row_count + 1;
1211: l_one_record := to_char(c_comments.note_id)
1212: || c_field_seperator || to_char(c_comments.comment_date, c_date_format)
1213: || c_field_seperator || msc_sda_utils.escapeSplChars(c_comments.comment_text)
1214: || c_field_seperator || msc_sda_utils.escapeSplChars(c_comments.item_name);
1215: if (l_row_count = 1) then
1216: l_one_record := p_stream_label || c_bang_separator || c_record_seperator || l_one_record;
1217: end if;
1218: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1214: || c_field_seperator || msc_sda_utils.escapeSplChars(c_comments.item_name);
1215: if (l_row_count = 1) then
1216: l_one_record := p_stream_label || c_bang_separator || c_record_seperator || l_one_record;
1217: end if;
1218: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1219: end loop;
1220: println('getCommentsData out');
1221: end getCommentsData;
1222:
1316: l_category_set_id := getPreference(p_plan_id, 8, 'CATEGORY_SET_ID');
1317:
1318: for c_item in c_item_cur loop
1319:
1320: msc_sda_utils.attachment_flag(l_note_flag, c_item.sr_instance_id, null, c_item.inventory_item_id, null, p_plan_id);
1321:
1322: l_one_record := c_item.node_id || c_field_seperator ||
1323: msc_sda_utils.escapeSplChars(l_note_flag) || c_field_seperator ||
1324: msc_sda_utils.escapeSplChars(c_item.item_segments) || c_field_seperator ||
1319:
1320: msc_sda_utils.attachment_flag(l_note_flag, c_item.sr_instance_id, null, c_item.inventory_item_id, null, p_plan_id);
1321:
1322: l_one_record := c_item.node_id || c_field_seperator ||
1323: msc_sda_utils.escapeSplChars(l_note_flag) || c_field_seperator ||
1324: msc_sda_utils.escapeSplChars(c_item.item_segments) || c_field_seperator ||
1325: msc_sda_utils.escapeSplChars(c_item.organization_code) || c_field_seperator ||
1326: msc_sda_utils.escapeSplChars(c_item.description) || c_field_seperator ||
1327: msc_sda_utils.escapeSplChars(c_item.planner_code) || c_field_seperator ||
1320: msc_sda_utils.attachment_flag(l_note_flag, c_item.sr_instance_id, null, c_item.inventory_item_id, null, p_plan_id);
1321:
1322: l_one_record := c_item.node_id || c_field_seperator ||
1323: msc_sda_utils.escapeSplChars(l_note_flag) || c_field_seperator ||
1324: msc_sda_utils.escapeSplChars(c_item.item_segments) || c_field_seperator ||
1325: msc_sda_utils.escapeSplChars(c_item.organization_code) || c_field_seperator ||
1326: msc_sda_utils.escapeSplChars(c_item.description) || c_field_seperator ||
1327: msc_sda_utils.escapeSplChars(c_item.planner_code) || c_field_seperator ||
1328: msc_sda_utils.escapeSplChars(c_item.nettable_inventory_quantity) || c_field_seperator ||
1321:
1322: l_one_record := c_item.node_id || c_field_seperator ||
1323: msc_sda_utils.escapeSplChars(l_note_flag) || c_field_seperator ||
1324: msc_sda_utils.escapeSplChars(c_item.item_segments) || c_field_seperator ||
1325: msc_sda_utils.escapeSplChars(c_item.organization_code) || c_field_seperator ||
1326: msc_sda_utils.escapeSplChars(c_item.description) || c_field_seperator ||
1327: msc_sda_utils.escapeSplChars(c_item.planner_code) || c_field_seperator ||
1328: msc_sda_utils.escapeSplChars(c_item.nettable_inventory_quantity) || c_field_seperator ||
1329: msc_sda_utils.escapeSplChars(c_item.nonnettable_inventory_quantity) || c_field_seperator ||
1322: l_one_record := c_item.node_id || c_field_seperator ||
1323: msc_sda_utils.escapeSplChars(l_note_flag) || c_field_seperator ||
1324: msc_sda_utils.escapeSplChars(c_item.item_segments) || c_field_seperator ||
1325: msc_sda_utils.escapeSplChars(c_item.organization_code) || c_field_seperator ||
1326: msc_sda_utils.escapeSplChars(c_item.description) || c_field_seperator ||
1327: msc_sda_utils.escapeSplChars(c_item.planner_code) || c_field_seperator ||
1328: msc_sda_utils.escapeSplChars(c_item.nettable_inventory_quantity) || c_field_seperator ||
1329: msc_sda_utils.escapeSplChars(c_item.nonnettable_inventory_quantity) || c_field_seperator ||
1330: msc_sda_utils.escapeSplChars(c_item.buyer_name) || c_field_seperator ||
1323: msc_sda_utils.escapeSplChars(l_note_flag) || c_field_seperator ||
1324: msc_sda_utils.escapeSplChars(c_item.item_segments) || c_field_seperator ||
1325: msc_sda_utils.escapeSplChars(c_item.organization_code) || c_field_seperator ||
1326: msc_sda_utils.escapeSplChars(c_item.description) || c_field_seperator ||
1327: msc_sda_utils.escapeSplChars(c_item.planner_code) || c_field_seperator ||
1328: msc_sda_utils.escapeSplChars(c_item.nettable_inventory_quantity) || c_field_seperator ||
1329: msc_sda_utils.escapeSplChars(c_item.nonnettable_inventory_quantity) || c_field_seperator ||
1330: msc_sda_utils.escapeSplChars(c_item.buyer_name) || c_field_seperator ||
1331: msc_sda_utils.escapeSplChars(c_item.mrp_planning_code_text) || c_field_seperator ||
1324: msc_sda_utils.escapeSplChars(c_item.item_segments) || c_field_seperator ||
1325: msc_sda_utils.escapeSplChars(c_item.organization_code) || c_field_seperator ||
1326: msc_sda_utils.escapeSplChars(c_item.description) || c_field_seperator ||
1327: msc_sda_utils.escapeSplChars(c_item.planner_code) || c_field_seperator ||
1328: msc_sda_utils.escapeSplChars(c_item.nettable_inventory_quantity) || c_field_seperator ||
1329: msc_sda_utils.escapeSplChars(c_item.nonnettable_inventory_quantity) || c_field_seperator ||
1330: msc_sda_utils.escapeSplChars(c_item.buyer_name) || c_field_seperator ||
1331: msc_sda_utils.escapeSplChars(c_item.mrp_planning_code_text) || c_field_seperator ||
1332: msc_sda_utils.escapeSplChars(c_item.critical_component_flag) || c_field_seperator ||
1325: msc_sda_utils.escapeSplChars(c_item.organization_code) || c_field_seperator ||
1326: msc_sda_utils.escapeSplChars(c_item.description) || c_field_seperator ||
1327: msc_sda_utils.escapeSplChars(c_item.planner_code) || c_field_seperator ||
1328: msc_sda_utils.escapeSplChars(c_item.nettable_inventory_quantity) || c_field_seperator ||
1329: msc_sda_utils.escapeSplChars(c_item.nonnettable_inventory_quantity) || c_field_seperator ||
1330: msc_sda_utils.escapeSplChars(c_item.buyer_name) || c_field_seperator ||
1331: msc_sda_utils.escapeSplChars(c_item.mrp_planning_code_text) || c_field_seperator ||
1332: msc_sda_utils.escapeSplChars(c_item.critical_component_flag) || c_field_seperator ||
1333: msc_sda_utils.escapeSplChars(c_item.wip_supply_type_text) || c_field_seperator ||
1326: msc_sda_utils.escapeSplChars(c_item.description) || c_field_seperator ||
1327: msc_sda_utils.escapeSplChars(c_item.planner_code) || c_field_seperator ||
1328: msc_sda_utils.escapeSplChars(c_item.nettable_inventory_quantity) || c_field_seperator ||
1329: msc_sda_utils.escapeSplChars(c_item.nonnettable_inventory_quantity) || c_field_seperator ||
1330: msc_sda_utils.escapeSplChars(c_item.buyer_name) || c_field_seperator ||
1331: msc_sda_utils.escapeSplChars(c_item.mrp_planning_code_text) || c_field_seperator ||
1332: msc_sda_utils.escapeSplChars(c_item.critical_component_flag) || c_field_seperator ||
1333: msc_sda_utils.escapeSplChars(c_item.wip_supply_type_text) || c_field_seperator ||
1334: msc_sda_utils.escapeSplChars(c_item.bom_item_type_text) || c_field_seperator ||
1327: msc_sda_utils.escapeSplChars(c_item.planner_code) || c_field_seperator ||
1328: msc_sda_utils.escapeSplChars(c_item.nettable_inventory_quantity) || c_field_seperator ||
1329: msc_sda_utils.escapeSplChars(c_item.nonnettable_inventory_quantity) || c_field_seperator ||
1330: msc_sda_utils.escapeSplChars(c_item.buyer_name) || c_field_seperator ||
1331: msc_sda_utils.escapeSplChars(c_item.mrp_planning_code_text) || c_field_seperator ||
1332: msc_sda_utils.escapeSplChars(c_item.critical_component_flag) || c_field_seperator ||
1333: msc_sda_utils.escapeSplChars(c_item.wip_supply_type_text) || c_field_seperator ||
1334: msc_sda_utils.escapeSplChars(c_item.bom_item_type_text) || c_field_seperator ||
1335: msc_sda_utils.escapeSplChars(c_item.end_assembly_pegging_text) || c_field_seperator ||
1328: msc_sda_utils.escapeSplChars(c_item.nettable_inventory_quantity) || c_field_seperator ||
1329: msc_sda_utils.escapeSplChars(c_item.nonnettable_inventory_quantity) || c_field_seperator ||
1330: msc_sda_utils.escapeSplChars(c_item.buyer_name) || c_field_seperator ||
1331: msc_sda_utils.escapeSplChars(c_item.mrp_planning_code_text) || c_field_seperator ||
1332: msc_sda_utils.escapeSplChars(c_item.critical_component_flag) || c_field_seperator ||
1333: msc_sda_utils.escapeSplChars(c_item.wip_supply_type_text) || c_field_seperator ||
1334: msc_sda_utils.escapeSplChars(c_item.bom_item_type_text) || c_field_seperator ||
1335: msc_sda_utils.escapeSplChars(c_item.end_assembly_pegging_text) || c_field_seperator ||
1336: msc_sda_utils.escapeSplChars(c_item.base_model) || c_field_seperator ||
1329: msc_sda_utils.escapeSplChars(c_item.nonnettable_inventory_quantity) || c_field_seperator ||
1330: msc_sda_utils.escapeSplChars(c_item.buyer_name) || c_field_seperator ||
1331: msc_sda_utils.escapeSplChars(c_item.mrp_planning_code_text) || c_field_seperator ||
1332: msc_sda_utils.escapeSplChars(c_item.critical_component_flag) || c_field_seperator ||
1333: msc_sda_utils.escapeSplChars(c_item.wip_supply_type_text) || c_field_seperator ||
1334: msc_sda_utils.escapeSplChars(c_item.bom_item_type_text) || c_field_seperator ||
1335: msc_sda_utils.escapeSplChars(c_item.end_assembly_pegging_text) || c_field_seperator ||
1336: msc_sda_utils.escapeSplChars(c_item.base_model) || c_field_seperator ||
1337: msc_sda_utils.escapeSplChars(c_item.category) || c_field_seperator ||
1330: msc_sda_utils.escapeSplChars(c_item.buyer_name) || c_field_seperator ||
1331: msc_sda_utils.escapeSplChars(c_item.mrp_planning_code_text) || c_field_seperator ||
1332: msc_sda_utils.escapeSplChars(c_item.critical_component_flag) || c_field_seperator ||
1333: msc_sda_utils.escapeSplChars(c_item.wip_supply_type_text) || c_field_seperator ||
1334: msc_sda_utils.escapeSplChars(c_item.bom_item_type_text) || c_field_seperator ||
1335: msc_sda_utils.escapeSplChars(c_item.end_assembly_pegging_text) || c_field_seperator ||
1336: msc_sda_utils.escapeSplChars(c_item.base_model) || c_field_seperator ||
1337: msc_sda_utils.escapeSplChars(c_item.category) || c_field_seperator ||
1338: msc_sda_utils.escapeSplChars(c_item.category_desc) || c_field_seperator ||
1331: msc_sda_utils.escapeSplChars(c_item.mrp_planning_code_text) || c_field_seperator ||
1332: msc_sda_utils.escapeSplChars(c_item.critical_component_flag) || c_field_seperator ||
1333: msc_sda_utils.escapeSplChars(c_item.wip_supply_type_text) || c_field_seperator ||
1334: msc_sda_utils.escapeSplChars(c_item.bom_item_type_text) || c_field_seperator ||
1335: msc_sda_utils.escapeSplChars(c_item.end_assembly_pegging_text) || c_field_seperator ||
1336: msc_sda_utils.escapeSplChars(c_item.base_model) || c_field_seperator ||
1337: msc_sda_utils.escapeSplChars(c_item.category) || c_field_seperator ||
1338: msc_sda_utils.escapeSplChars(c_item.category_desc) || c_field_seperator ||
1339: msc_sda_utils.escapeSplChars(c_item.product_family_item) || c_field_seperator ||
1332: msc_sda_utils.escapeSplChars(c_item.critical_component_flag) || c_field_seperator ||
1333: msc_sda_utils.escapeSplChars(c_item.wip_supply_type_text) || c_field_seperator ||
1334: msc_sda_utils.escapeSplChars(c_item.bom_item_type_text) || c_field_seperator ||
1335: msc_sda_utils.escapeSplChars(c_item.end_assembly_pegging_text) || c_field_seperator ||
1336: msc_sda_utils.escapeSplChars(c_item.base_model) || c_field_seperator ||
1337: msc_sda_utils.escapeSplChars(c_item.category) || c_field_seperator ||
1338: msc_sda_utils.escapeSplChars(c_item.category_desc) || c_field_seperator ||
1339: msc_sda_utils.escapeSplChars(c_item.product_family_item) || c_field_seperator ||
1340: msc_sda_utils.escapeSplChars(c_item.product_family_item_desc) || c_field_seperator ||
1333: msc_sda_utils.escapeSplChars(c_item.wip_supply_type_text) || c_field_seperator ||
1334: msc_sda_utils.escapeSplChars(c_item.bom_item_type_text) || c_field_seperator ||
1335: msc_sda_utils.escapeSplChars(c_item.end_assembly_pegging_text) || c_field_seperator ||
1336: msc_sda_utils.escapeSplChars(c_item.base_model) || c_field_seperator ||
1337: msc_sda_utils.escapeSplChars(c_item.category) || c_field_seperator ||
1338: msc_sda_utils.escapeSplChars(c_item.category_desc) || c_field_seperator ||
1339: msc_sda_utils.escapeSplChars(c_item.product_family_item) || c_field_seperator ||
1340: msc_sda_utils.escapeSplChars(c_item.product_family_item_desc) || c_field_seperator ||
1341: msc_sda_utils.escapeSplChars(c_item.planning_exception_set) || c_field_seperator ||
1334: msc_sda_utils.escapeSplChars(c_item.bom_item_type_text) || c_field_seperator ||
1335: msc_sda_utils.escapeSplChars(c_item.end_assembly_pegging_text) || c_field_seperator ||
1336: msc_sda_utils.escapeSplChars(c_item.base_model) || c_field_seperator ||
1337: msc_sda_utils.escapeSplChars(c_item.category) || c_field_seperator ||
1338: msc_sda_utils.escapeSplChars(c_item.category_desc) || c_field_seperator ||
1339: msc_sda_utils.escapeSplChars(c_item.product_family_item) || c_field_seperator ||
1340: msc_sda_utils.escapeSplChars(c_item.product_family_item_desc) || c_field_seperator ||
1341: msc_sda_utils.escapeSplChars(c_item.planning_exception_set) || c_field_seperator ||
1342: msc_sda_utils.escapeSplChars(c_item.repetitive_type) || c_field_seperator ||
1335: msc_sda_utils.escapeSplChars(c_item.end_assembly_pegging_text) || c_field_seperator ||
1336: msc_sda_utils.escapeSplChars(c_item.base_model) || c_field_seperator ||
1337: msc_sda_utils.escapeSplChars(c_item.category) || c_field_seperator ||
1338: msc_sda_utils.escapeSplChars(c_item.category_desc) || c_field_seperator ||
1339: msc_sda_utils.escapeSplChars(c_item.product_family_item) || c_field_seperator ||
1340: msc_sda_utils.escapeSplChars(c_item.product_family_item_desc) || c_field_seperator ||
1341: msc_sda_utils.escapeSplChars(c_item.planning_exception_set) || c_field_seperator ||
1342: msc_sda_utils.escapeSplChars(c_item.repetitive_type) || c_field_seperator ||
1343: msc_sda_utils.escapeSplChars(c_item.standard_cost) || c_field_seperator ||
1336: msc_sda_utils.escapeSplChars(c_item.base_model) || c_field_seperator ||
1337: msc_sda_utils.escapeSplChars(c_item.category) || c_field_seperator ||
1338: msc_sda_utils.escapeSplChars(c_item.category_desc) || c_field_seperator ||
1339: msc_sda_utils.escapeSplChars(c_item.product_family_item) || c_field_seperator ||
1340: msc_sda_utils.escapeSplChars(c_item.product_family_item_desc) || c_field_seperator ||
1341: msc_sda_utils.escapeSplChars(c_item.planning_exception_set) || c_field_seperator ||
1342: msc_sda_utils.escapeSplChars(c_item.repetitive_type) || c_field_seperator ||
1343: msc_sda_utils.escapeSplChars(c_item.standard_cost) || c_field_seperator ||
1344: msc_sda_utils.escapeSplChars(c_item.carrying_cost) || c_field_seperator ||
1337: msc_sda_utils.escapeSplChars(c_item.category) || c_field_seperator ||
1338: msc_sda_utils.escapeSplChars(c_item.category_desc) || c_field_seperator ||
1339: msc_sda_utils.escapeSplChars(c_item.product_family_item) || c_field_seperator ||
1340: msc_sda_utils.escapeSplChars(c_item.product_family_item_desc) || c_field_seperator ||
1341: msc_sda_utils.escapeSplChars(c_item.planning_exception_set) || c_field_seperator ||
1342: msc_sda_utils.escapeSplChars(c_item.repetitive_type) || c_field_seperator ||
1343: msc_sda_utils.escapeSplChars(c_item.standard_cost) || c_field_seperator ||
1344: msc_sda_utils.escapeSplChars(c_item.carrying_cost) || c_field_seperator ||
1345: msc_sda_utils.escapeSplChars(c_item.uom_code) || c_field_seperator ||
1338: msc_sda_utils.escapeSplChars(c_item.category_desc) || c_field_seperator ||
1339: msc_sda_utils.escapeSplChars(c_item.product_family_item) || c_field_seperator ||
1340: msc_sda_utils.escapeSplChars(c_item.product_family_item_desc) || c_field_seperator ||
1341: msc_sda_utils.escapeSplChars(c_item.planning_exception_set) || c_field_seperator ||
1342: msc_sda_utils.escapeSplChars(c_item.repetitive_type) || c_field_seperator ||
1343: msc_sda_utils.escapeSplChars(c_item.standard_cost) || c_field_seperator ||
1344: msc_sda_utils.escapeSplChars(c_item.carrying_cost) || c_field_seperator ||
1345: msc_sda_utils.escapeSplChars(c_item.uom_code) || c_field_seperator ||
1346: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_date) || c_field_seperator ||
1339: msc_sda_utils.escapeSplChars(c_item.product_family_item) || c_field_seperator ||
1340: msc_sda_utils.escapeSplChars(c_item.product_family_item_desc) || c_field_seperator ||
1341: msc_sda_utils.escapeSplChars(c_item.planning_exception_set) || c_field_seperator ||
1342: msc_sda_utils.escapeSplChars(c_item.repetitive_type) || c_field_seperator ||
1343: msc_sda_utils.escapeSplChars(c_item.standard_cost) || c_field_seperator ||
1344: msc_sda_utils.escapeSplChars(c_item.carrying_cost) || c_field_seperator ||
1345: msc_sda_utils.escapeSplChars(c_item.uom_code) || c_field_seperator ||
1346: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_date) || c_field_seperator ||
1347: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_days) || c_field_seperator ||
1340: msc_sda_utils.escapeSplChars(c_item.product_family_item_desc) || c_field_seperator ||
1341: msc_sda_utils.escapeSplChars(c_item.planning_exception_set) || c_field_seperator ||
1342: msc_sda_utils.escapeSplChars(c_item.repetitive_type) || c_field_seperator ||
1343: msc_sda_utils.escapeSplChars(c_item.standard_cost) || c_field_seperator ||
1344: msc_sda_utils.escapeSplChars(c_item.carrying_cost) || c_field_seperator ||
1345: msc_sda_utils.escapeSplChars(c_item.uom_code) || c_field_seperator ||
1346: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_date) || c_field_seperator ||
1347: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_days) || c_field_seperator ||
1348: msc_sda_utils.escapeSplChars(c_item.inventory_use_up_date) || c_field_seperator ||
1341: msc_sda_utils.escapeSplChars(c_item.planning_exception_set) || c_field_seperator ||
1342: msc_sda_utils.escapeSplChars(c_item.repetitive_type) || c_field_seperator ||
1343: msc_sda_utils.escapeSplChars(c_item.standard_cost) || c_field_seperator ||
1344: msc_sda_utils.escapeSplChars(c_item.carrying_cost) || c_field_seperator ||
1345: msc_sda_utils.escapeSplChars(c_item.uom_code) || c_field_seperator ||
1346: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_date) || c_field_seperator ||
1347: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_days) || c_field_seperator ||
1348: msc_sda_utils.escapeSplChars(c_item.inventory_use_up_date) || c_field_seperator ||
1349: msc_sda_utils.escapeSplChars(c_item.planning_make_buy_code_text) || c_field_seperator ||
1342: msc_sda_utils.escapeSplChars(c_item.repetitive_type) || c_field_seperator ||
1343: msc_sda_utils.escapeSplChars(c_item.standard_cost) || c_field_seperator ||
1344: msc_sda_utils.escapeSplChars(c_item.carrying_cost) || c_field_seperator ||
1345: msc_sda_utils.escapeSplChars(c_item.uom_code) || c_field_seperator ||
1346: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_date) || c_field_seperator ||
1347: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_days) || c_field_seperator ||
1348: msc_sda_utils.escapeSplChars(c_item.inventory_use_up_date) || c_field_seperator ||
1349: msc_sda_utils.escapeSplChars(c_item.planning_make_buy_code_text) || c_field_seperator ||
1350: msc_sda_utils.escapeSplChars(c_item.ato_forecast_control_text) || c_field_seperator ||
1343: msc_sda_utils.escapeSplChars(c_item.standard_cost) || c_field_seperator ||
1344: msc_sda_utils.escapeSplChars(c_item.carrying_cost) || c_field_seperator ||
1345: msc_sda_utils.escapeSplChars(c_item.uom_code) || c_field_seperator ||
1346: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_date) || c_field_seperator ||
1347: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_days) || c_field_seperator ||
1348: msc_sda_utils.escapeSplChars(c_item.inventory_use_up_date) || c_field_seperator ||
1349: msc_sda_utils.escapeSplChars(c_item.planning_make_buy_code_text) || c_field_seperator ||
1350: msc_sda_utils.escapeSplChars(c_item.ato_forecast_control_text) || c_field_seperator ||
1351: msc_sda_utils.escapeSplChars(c_item.shrinkage_rate) || c_field_seperator ||
1344: msc_sda_utils.escapeSplChars(c_item.carrying_cost) || c_field_seperator ||
1345: msc_sda_utils.escapeSplChars(c_item.uom_code) || c_field_seperator ||
1346: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_date) || c_field_seperator ||
1347: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_days) || c_field_seperator ||
1348: msc_sda_utils.escapeSplChars(c_item.inventory_use_up_date) || c_field_seperator ||
1349: msc_sda_utils.escapeSplChars(c_item.planning_make_buy_code_text) || c_field_seperator ||
1350: msc_sda_utils.escapeSplChars(c_item.ato_forecast_control_text) || c_field_seperator ||
1351: msc_sda_utils.escapeSplChars(c_item.shrinkage_rate) || c_field_seperator ||
1352: msc_sda_utils.escapeSplChars(c_item.preprocessing_lead_time) || c_field_seperator ||
1345: msc_sda_utils.escapeSplChars(c_item.uom_code) || c_field_seperator ||
1346: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_date) || c_field_seperator ||
1347: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_days) || c_field_seperator ||
1348: msc_sda_utils.escapeSplChars(c_item.inventory_use_up_date) || c_field_seperator ||
1349: msc_sda_utils.escapeSplChars(c_item.planning_make_buy_code_text) || c_field_seperator ||
1350: msc_sda_utils.escapeSplChars(c_item.ato_forecast_control_text) || c_field_seperator ||
1351: msc_sda_utils.escapeSplChars(c_item.shrinkage_rate) || c_field_seperator ||
1352: msc_sda_utils.escapeSplChars(c_item.preprocessing_lead_time) || c_field_seperator ||
1353: msc_sda_utils.escapeSplChars(c_item.full_lead_time) || c_field_seperator ||
1346: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_date) || c_field_seperator ||
1347: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_days) || c_field_seperator ||
1348: msc_sda_utils.escapeSplChars(c_item.inventory_use_up_date) || c_field_seperator ||
1349: msc_sda_utils.escapeSplChars(c_item.planning_make_buy_code_text) || c_field_seperator ||
1350: msc_sda_utils.escapeSplChars(c_item.ato_forecast_control_text) || c_field_seperator ||
1351: msc_sda_utils.escapeSplChars(c_item.shrinkage_rate) || c_field_seperator ||
1352: msc_sda_utils.escapeSplChars(c_item.preprocessing_lead_time) || c_field_seperator ||
1353: msc_sda_utils.escapeSplChars(c_item.full_lead_time) || c_field_seperator ||
1354: msc_sda_utils.escapeSplChars(c_item.postprocessing_lead_time) || c_field_seperator ||
1347: msc_sda_utils.escapeSplChars(c_item.planning_time_fence_days) || c_field_seperator ||
1348: msc_sda_utils.escapeSplChars(c_item.inventory_use_up_date) || c_field_seperator ||
1349: msc_sda_utils.escapeSplChars(c_item.planning_make_buy_code_text) || c_field_seperator ||
1350: msc_sda_utils.escapeSplChars(c_item.ato_forecast_control_text) || c_field_seperator ||
1351: msc_sda_utils.escapeSplChars(c_item.shrinkage_rate) || c_field_seperator ||
1352: msc_sda_utils.escapeSplChars(c_item.preprocessing_lead_time) || c_field_seperator ||
1353: msc_sda_utils.escapeSplChars(c_item.full_lead_time) || c_field_seperator ||
1354: msc_sda_utils.escapeSplChars(c_item.postprocessing_lead_time) || c_field_seperator ||
1355: msc_sda_utils.escapeSplChars(c_item.leadtime_variability) || c_field_seperator ||
1348: msc_sda_utils.escapeSplChars(c_item.inventory_use_up_date) || c_field_seperator ||
1349: msc_sda_utils.escapeSplChars(c_item.planning_make_buy_code_text) || c_field_seperator ||
1350: msc_sda_utils.escapeSplChars(c_item.ato_forecast_control_text) || c_field_seperator ||
1351: msc_sda_utils.escapeSplChars(c_item.shrinkage_rate) || c_field_seperator ||
1352: msc_sda_utils.escapeSplChars(c_item.preprocessing_lead_time) || c_field_seperator ||
1353: msc_sda_utils.escapeSplChars(c_item.full_lead_time) || c_field_seperator ||
1354: msc_sda_utils.escapeSplChars(c_item.postprocessing_lead_time) || c_field_seperator ||
1355: msc_sda_utils.escapeSplChars(c_item.leadtime_variability) || c_field_seperator ||
1356: msc_sda_utils.escapeSplChars(c_item.fixed_lead_time) || c_field_seperator ||
1349: msc_sda_utils.escapeSplChars(c_item.planning_make_buy_code_text) || c_field_seperator ||
1350: msc_sda_utils.escapeSplChars(c_item.ato_forecast_control_text) || c_field_seperator ||
1351: msc_sda_utils.escapeSplChars(c_item.shrinkage_rate) || c_field_seperator ||
1352: msc_sda_utils.escapeSplChars(c_item.preprocessing_lead_time) || c_field_seperator ||
1353: msc_sda_utils.escapeSplChars(c_item.full_lead_time) || c_field_seperator ||
1354: msc_sda_utils.escapeSplChars(c_item.postprocessing_lead_time) || c_field_seperator ||
1355: msc_sda_utils.escapeSplChars(c_item.leadtime_variability) || c_field_seperator ||
1356: msc_sda_utils.escapeSplChars(c_item.fixed_lead_time) || c_field_seperator ||
1357: msc_sda_utils.escapeSplChars(c_item.variable_lead_time) || c_field_seperator ||
1350: msc_sda_utils.escapeSplChars(c_item.ato_forecast_control_text) || c_field_seperator ||
1351: msc_sda_utils.escapeSplChars(c_item.shrinkage_rate) || c_field_seperator ||
1352: msc_sda_utils.escapeSplChars(c_item.preprocessing_lead_time) || c_field_seperator ||
1353: msc_sda_utils.escapeSplChars(c_item.full_lead_time) || c_field_seperator ||
1354: msc_sda_utils.escapeSplChars(c_item.postprocessing_lead_time) || c_field_seperator ||
1355: msc_sda_utils.escapeSplChars(c_item.leadtime_variability) || c_field_seperator ||
1356: msc_sda_utils.escapeSplChars(c_item.fixed_lead_time) || c_field_seperator ||
1357: msc_sda_utils.escapeSplChars(c_item.variable_lead_time) || c_field_seperator ||
1358: msc_sda_utils.escapeSplChars(c_item.fixed_order_quantity) || c_field_seperator ||
1351: msc_sda_utils.escapeSplChars(c_item.shrinkage_rate) || c_field_seperator ||
1352: msc_sda_utils.escapeSplChars(c_item.preprocessing_lead_time) || c_field_seperator ||
1353: msc_sda_utils.escapeSplChars(c_item.full_lead_time) || c_field_seperator ||
1354: msc_sda_utils.escapeSplChars(c_item.postprocessing_lead_time) || c_field_seperator ||
1355: msc_sda_utils.escapeSplChars(c_item.leadtime_variability) || c_field_seperator ||
1356: msc_sda_utils.escapeSplChars(c_item.fixed_lead_time) || c_field_seperator ||
1357: msc_sda_utils.escapeSplChars(c_item.variable_lead_time) || c_field_seperator ||
1358: msc_sda_utils.escapeSplChars(c_item.fixed_order_quantity) || c_field_seperator ||
1359: msc_sda_utils.escapeSplChars(c_item.fixed_lot_multiplier) || c_field_seperator ||
1352: msc_sda_utils.escapeSplChars(c_item.preprocessing_lead_time) || c_field_seperator ||
1353: msc_sda_utils.escapeSplChars(c_item.full_lead_time) || c_field_seperator ||
1354: msc_sda_utils.escapeSplChars(c_item.postprocessing_lead_time) || c_field_seperator ||
1355: msc_sda_utils.escapeSplChars(c_item.leadtime_variability) || c_field_seperator ||
1356: msc_sda_utils.escapeSplChars(c_item.fixed_lead_time) || c_field_seperator ||
1357: msc_sda_utils.escapeSplChars(c_item.variable_lead_time) || c_field_seperator ||
1358: msc_sda_utils.escapeSplChars(c_item.fixed_order_quantity) || c_field_seperator ||
1359: msc_sda_utils.escapeSplChars(c_item.fixed_lot_multiplier) || c_field_seperator ||
1360: msc_sda_utils.escapeSplChars(c_item.minimum_order_quantity) || c_field_seperator ||
1353: msc_sda_utils.escapeSplChars(c_item.full_lead_time) || c_field_seperator ||
1354: msc_sda_utils.escapeSplChars(c_item.postprocessing_lead_time) || c_field_seperator ||
1355: msc_sda_utils.escapeSplChars(c_item.leadtime_variability) || c_field_seperator ||
1356: msc_sda_utils.escapeSplChars(c_item.fixed_lead_time) || c_field_seperator ||
1357: msc_sda_utils.escapeSplChars(c_item.variable_lead_time) || c_field_seperator ||
1358: msc_sda_utils.escapeSplChars(c_item.fixed_order_quantity) || c_field_seperator ||
1359: msc_sda_utils.escapeSplChars(c_item.fixed_lot_multiplier) || c_field_seperator ||
1360: msc_sda_utils.escapeSplChars(c_item.minimum_order_quantity) || c_field_seperator ||
1361: msc_sda_utils.escapeSplChars(c_item.maximum_order_quantity) || c_field_seperator ||
1354: msc_sda_utils.escapeSplChars(c_item.postprocessing_lead_time) || c_field_seperator ||
1355: msc_sda_utils.escapeSplChars(c_item.leadtime_variability) || c_field_seperator ||
1356: msc_sda_utils.escapeSplChars(c_item.fixed_lead_time) || c_field_seperator ||
1357: msc_sda_utils.escapeSplChars(c_item.variable_lead_time) || c_field_seperator ||
1358: msc_sda_utils.escapeSplChars(c_item.fixed_order_quantity) || c_field_seperator ||
1359: msc_sda_utils.escapeSplChars(c_item.fixed_lot_multiplier) || c_field_seperator ||
1360: msc_sda_utils.escapeSplChars(c_item.minimum_order_quantity) || c_field_seperator ||
1361: msc_sda_utils.escapeSplChars(c_item.maximum_order_quantity) || c_field_seperator ||
1362: msc_sda_utils.escapeSplChars(c_item.safety_stock_days) || c_field_seperator ||
1355: msc_sda_utils.escapeSplChars(c_item.leadtime_variability) || c_field_seperator ||
1356: msc_sda_utils.escapeSplChars(c_item.fixed_lead_time) || c_field_seperator ||
1357: msc_sda_utils.escapeSplChars(c_item.variable_lead_time) || c_field_seperator ||
1358: msc_sda_utils.escapeSplChars(c_item.fixed_order_quantity) || c_field_seperator ||
1359: msc_sda_utils.escapeSplChars(c_item.fixed_lot_multiplier) || c_field_seperator ||
1360: msc_sda_utils.escapeSplChars(c_item.minimum_order_quantity) || c_field_seperator ||
1361: msc_sda_utils.escapeSplChars(c_item.maximum_order_quantity) || c_field_seperator ||
1362: msc_sda_utils.escapeSplChars(c_item.safety_stock_days) || c_field_seperator ||
1363: msc_sda_utils.escapeSplChars(c_item.safety_stock_percent) || c_field_seperator ||
1356: msc_sda_utils.escapeSplChars(c_item.fixed_lead_time) || c_field_seperator ||
1357: msc_sda_utils.escapeSplChars(c_item.variable_lead_time) || c_field_seperator ||
1358: msc_sda_utils.escapeSplChars(c_item.fixed_order_quantity) || c_field_seperator ||
1359: msc_sda_utils.escapeSplChars(c_item.fixed_lot_multiplier) || c_field_seperator ||
1360: msc_sda_utils.escapeSplChars(c_item.minimum_order_quantity) || c_field_seperator ||
1361: msc_sda_utils.escapeSplChars(c_item.maximum_order_quantity) || c_field_seperator ||
1362: msc_sda_utils.escapeSplChars(c_item.safety_stock_days) || c_field_seperator ||
1363: msc_sda_utils.escapeSplChars(c_item.safety_stock_percent) || c_field_seperator ||
1364: msc_sda_utils.escapeSplChars(c_item.fixed_days_supply) || c_field_seperator ||
1357: msc_sda_utils.escapeSplChars(c_item.variable_lead_time) || c_field_seperator ||
1358: msc_sda_utils.escapeSplChars(c_item.fixed_order_quantity) || c_field_seperator ||
1359: msc_sda_utils.escapeSplChars(c_item.fixed_lot_multiplier) || c_field_seperator ||
1360: msc_sda_utils.escapeSplChars(c_item.minimum_order_quantity) || c_field_seperator ||
1361: msc_sda_utils.escapeSplChars(c_item.maximum_order_quantity) || c_field_seperator ||
1362: msc_sda_utils.escapeSplChars(c_item.safety_stock_days) || c_field_seperator ||
1363: msc_sda_utils.escapeSplChars(c_item.safety_stock_percent) || c_field_seperator ||
1364: msc_sda_utils.escapeSplChars(c_item.fixed_days_supply) || c_field_seperator ||
1365: msc_sda_utils.escapeSplChars(c_item.rounding_control_type) || c_field_seperator ||
1358: msc_sda_utils.escapeSplChars(c_item.fixed_order_quantity) || c_field_seperator ||
1359: msc_sda_utils.escapeSplChars(c_item.fixed_lot_multiplier) || c_field_seperator ||
1360: msc_sda_utils.escapeSplChars(c_item.minimum_order_quantity) || c_field_seperator ||
1361: msc_sda_utils.escapeSplChars(c_item.maximum_order_quantity) || c_field_seperator ||
1362: msc_sda_utils.escapeSplChars(c_item.safety_stock_days) || c_field_seperator ||
1363: msc_sda_utils.escapeSplChars(c_item.safety_stock_percent) || c_field_seperator ||
1364: msc_sda_utils.escapeSplChars(c_item.fixed_days_supply) || c_field_seperator ||
1365: msc_sda_utils.escapeSplChars(c_item.rounding_control_type) || c_field_seperator ||
1366: msc_sda_utils.escapeSplChars(c_item.effectivity_control_type) || c_field_seperator ||
1359: msc_sda_utils.escapeSplChars(c_item.fixed_lot_multiplier) || c_field_seperator ||
1360: msc_sda_utils.escapeSplChars(c_item.minimum_order_quantity) || c_field_seperator ||
1361: msc_sda_utils.escapeSplChars(c_item.maximum_order_quantity) || c_field_seperator ||
1362: msc_sda_utils.escapeSplChars(c_item.safety_stock_days) || c_field_seperator ||
1363: msc_sda_utils.escapeSplChars(c_item.safety_stock_percent) || c_field_seperator ||
1364: msc_sda_utils.escapeSplChars(c_item.fixed_days_supply) || c_field_seperator ||
1365: msc_sda_utils.escapeSplChars(c_item.rounding_control_type) || c_field_seperator ||
1366: msc_sda_utils.escapeSplChars(c_item.effectivity_control_type) || c_field_seperator ||
1367: msc_sda_utils.escapeSplChars(c_item.abc_class_name) || c_field_seperator ||
1360: msc_sda_utils.escapeSplChars(c_item.minimum_order_quantity) || c_field_seperator ||
1361: msc_sda_utils.escapeSplChars(c_item.maximum_order_quantity) || c_field_seperator ||
1362: msc_sda_utils.escapeSplChars(c_item.safety_stock_days) || c_field_seperator ||
1363: msc_sda_utils.escapeSplChars(c_item.safety_stock_percent) || c_field_seperator ||
1364: msc_sda_utils.escapeSplChars(c_item.fixed_days_supply) || c_field_seperator ||
1365: msc_sda_utils.escapeSplChars(c_item.rounding_control_type) || c_field_seperator ||
1366: msc_sda_utils.escapeSplChars(c_item.effectivity_control_type) || c_field_seperator ||
1367: msc_sda_utils.escapeSplChars(c_item.abc_class_name) || c_field_seperator ||
1368: msc_sda_utils.escapeSplChars(c_item.selling_price) || c_field_seperator ||
1361: msc_sda_utils.escapeSplChars(c_item.maximum_order_quantity) || c_field_seperator ||
1362: msc_sda_utils.escapeSplChars(c_item.safety_stock_days) || c_field_seperator ||
1363: msc_sda_utils.escapeSplChars(c_item.safety_stock_percent) || c_field_seperator ||
1364: msc_sda_utils.escapeSplChars(c_item.fixed_days_supply) || c_field_seperator ||
1365: msc_sda_utils.escapeSplChars(c_item.rounding_control_type) || c_field_seperator ||
1366: msc_sda_utils.escapeSplChars(c_item.effectivity_control_type) || c_field_seperator ||
1367: msc_sda_utils.escapeSplChars(c_item.abc_class_name) || c_field_seperator ||
1368: msc_sda_utils.escapeSplChars(c_item.selling_price) || c_field_seperator ||
1369: msc_sda_utils.escapeSplChars(c_item.margin) || c_field_seperator ||
1362: msc_sda_utils.escapeSplChars(c_item.safety_stock_days) || c_field_seperator ||
1363: msc_sda_utils.escapeSplChars(c_item.safety_stock_percent) || c_field_seperator ||
1364: msc_sda_utils.escapeSplChars(c_item.fixed_days_supply) || c_field_seperator ||
1365: msc_sda_utils.escapeSplChars(c_item.rounding_control_type) || c_field_seperator ||
1366: msc_sda_utils.escapeSplChars(c_item.effectivity_control_type) || c_field_seperator ||
1367: msc_sda_utils.escapeSplChars(c_item.abc_class_name) || c_field_seperator ||
1368: msc_sda_utils.escapeSplChars(c_item.selling_price) || c_field_seperator ||
1369: msc_sda_utils.escapeSplChars(c_item.margin) || c_field_seperator ||
1370: msc_sda_utils.escapeSplChars(c_item.average_discount) || c_field_seperator ||
1363: msc_sda_utils.escapeSplChars(c_item.safety_stock_percent) || c_field_seperator ||
1364: msc_sda_utils.escapeSplChars(c_item.fixed_days_supply) || c_field_seperator ||
1365: msc_sda_utils.escapeSplChars(c_item.rounding_control_type) || c_field_seperator ||
1366: msc_sda_utils.escapeSplChars(c_item.effectivity_control_type) || c_field_seperator ||
1367: msc_sda_utils.escapeSplChars(c_item.abc_class_name) || c_field_seperator ||
1368: msc_sda_utils.escapeSplChars(c_item.selling_price) || c_field_seperator ||
1369: msc_sda_utils.escapeSplChars(c_item.margin) || c_field_seperator ||
1370: msc_sda_utils.escapeSplChars(c_item.average_discount) || c_field_seperator ||
1371: msc_sda_utils.escapeSplChars(c_item.net_selling_price) || c_field_seperator ||
1364: msc_sda_utils.escapeSplChars(c_item.fixed_days_supply) || c_field_seperator ||
1365: msc_sda_utils.escapeSplChars(c_item.rounding_control_type) || c_field_seperator ||
1366: msc_sda_utils.escapeSplChars(c_item.effectivity_control_type) || c_field_seperator ||
1367: msc_sda_utils.escapeSplChars(c_item.abc_class_name) || c_field_seperator ||
1368: msc_sda_utils.escapeSplChars(c_item.selling_price) || c_field_seperator ||
1369: msc_sda_utils.escapeSplChars(c_item.margin) || c_field_seperator ||
1370: msc_sda_utils.escapeSplChars(c_item.average_discount) || c_field_seperator ||
1371: msc_sda_utils.escapeSplChars(c_item.net_selling_price) || c_field_seperator ||
1372: msc_sda_utils.escapeSplChars(c_item.service_level) || c_field_seperator ||
1365: msc_sda_utils.escapeSplChars(c_item.rounding_control_type) || c_field_seperator ||
1366: msc_sda_utils.escapeSplChars(c_item.effectivity_control_type) || c_field_seperator ||
1367: msc_sda_utils.escapeSplChars(c_item.abc_class_name) || c_field_seperator ||
1368: msc_sda_utils.escapeSplChars(c_item.selling_price) || c_field_seperator ||
1369: msc_sda_utils.escapeSplChars(c_item.margin) || c_field_seperator ||
1370: msc_sda_utils.escapeSplChars(c_item.average_discount) || c_field_seperator ||
1371: msc_sda_utils.escapeSplChars(c_item.net_selling_price) || c_field_seperator ||
1372: msc_sda_utils.escapeSplChars(c_item.service_level) || c_field_seperator ||
1373: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_days) || c_field_seperator ||
1366: msc_sda_utils.escapeSplChars(c_item.effectivity_control_type) || c_field_seperator ||
1367: msc_sda_utils.escapeSplChars(c_item.abc_class_name) || c_field_seperator ||
1368: msc_sda_utils.escapeSplChars(c_item.selling_price) || c_field_seperator ||
1369: msc_sda_utils.escapeSplChars(c_item.margin) || c_field_seperator ||
1370: msc_sda_utils.escapeSplChars(c_item.average_discount) || c_field_seperator ||
1371: msc_sda_utils.escapeSplChars(c_item.net_selling_price) || c_field_seperator ||
1372: msc_sda_utils.escapeSplChars(c_item.service_level) || c_field_seperator ||
1373: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_days) || c_field_seperator ||
1374: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_date) || c_field_seperator ||
1367: msc_sda_utils.escapeSplChars(c_item.abc_class_name) || c_field_seperator ||
1368: msc_sda_utils.escapeSplChars(c_item.selling_price) || c_field_seperator ||
1369: msc_sda_utils.escapeSplChars(c_item.margin) || c_field_seperator ||
1370: msc_sda_utils.escapeSplChars(c_item.average_discount) || c_field_seperator ||
1371: msc_sda_utils.escapeSplChars(c_item.net_selling_price) || c_field_seperator ||
1372: msc_sda_utils.escapeSplChars(c_item.service_level) || c_field_seperator ||
1373: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_days) || c_field_seperator ||
1374: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_date) || c_field_seperator ||
1375: msc_sda_utils.escapeSplChars(c_item.safety_stock_code) || c_field_seperator ||
1368: msc_sda_utils.escapeSplChars(c_item.selling_price) || c_field_seperator ||
1369: msc_sda_utils.escapeSplChars(c_item.margin) || c_field_seperator ||
1370: msc_sda_utils.escapeSplChars(c_item.average_discount) || c_field_seperator ||
1371: msc_sda_utils.escapeSplChars(c_item.net_selling_price) || c_field_seperator ||
1372: msc_sda_utils.escapeSplChars(c_item.service_level) || c_field_seperator ||
1373: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_days) || c_field_seperator ||
1374: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_date) || c_field_seperator ||
1375: msc_sda_utils.escapeSplChars(c_item.safety_stock_code) || c_field_seperator ||
1376: msc_sda_utils.escapeSplChars(c_item.atp_flag) || c_field_seperator ||
1369: msc_sda_utils.escapeSplChars(c_item.margin) || c_field_seperator ||
1370: msc_sda_utils.escapeSplChars(c_item.average_discount) || c_field_seperator ||
1371: msc_sda_utils.escapeSplChars(c_item.net_selling_price) || c_field_seperator ||
1372: msc_sda_utils.escapeSplChars(c_item.service_level) || c_field_seperator ||
1373: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_days) || c_field_seperator ||
1374: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_date) || c_field_seperator ||
1375: msc_sda_utils.escapeSplChars(c_item.safety_stock_code) || c_field_seperator ||
1376: msc_sda_utils.escapeSplChars(c_item.atp_flag) || c_field_seperator ||
1377: msc_sda_utils.escapeSplChars(c_item.atp_components_flag) || c_field_seperator ||
1370: msc_sda_utils.escapeSplChars(c_item.average_discount) || c_field_seperator ||
1371: msc_sda_utils.escapeSplChars(c_item.net_selling_price) || c_field_seperator ||
1372: msc_sda_utils.escapeSplChars(c_item.service_level) || c_field_seperator ||
1373: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_days) || c_field_seperator ||
1374: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_date) || c_field_seperator ||
1375: msc_sda_utils.escapeSplChars(c_item.safety_stock_code) || c_field_seperator ||
1376: msc_sda_utils.escapeSplChars(c_item.atp_flag) || c_field_seperator ||
1377: msc_sda_utils.escapeSplChars(c_item.atp_components_flag) || c_field_seperator ||
1378: msc_sda_utils.escapeSplChars(c_item.drp_planned) || c_field_seperator ||
1371: msc_sda_utils.escapeSplChars(c_item.net_selling_price) || c_field_seperator ||
1372: msc_sda_utils.escapeSplChars(c_item.service_level) || c_field_seperator ||
1373: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_days) || c_field_seperator ||
1374: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_date) || c_field_seperator ||
1375: msc_sda_utils.escapeSplChars(c_item.safety_stock_code) || c_field_seperator ||
1376: msc_sda_utils.escapeSplChars(c_item.atp_flag) || c_field_seperator ||
1377: msc_sda_utils.escapeSplChars(c_item.atp_components_flag) || c_field_seperator ||
1378: msc_sda_utils.escapeSplChars(c_item.drp_planned) || c_field_seperator ||
1379: msc_sda_utils.escapeSplChars(c_item.weight_uom) || c_field_seperator ||
1372: msc_sda_utils.escapeSplChars(c_item.service_level) || c_field_seperator ||
1373: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_days) || c_field_seperator ||
1374: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_date) || c_field_seperator ||
1375: msc_sda_utils.escapeSplChars(c_item.safety_stock_code) || c_field_seperator ||
1376: msc_sda_utils.escapeSplChars(c_item.atp_flag) || c_field_seperator ||
1377: msc_sda_utils.escapeSplChars(c_item.atp_components_flag) || c_field_seperator ||
1378: msc_sda_utils.escapeSplChars(c_item.drp_planned) || c_field_seperator ||
1379: msc_sda_utils.escapeSplChars(c_item.weight_uom) || c_field_seperator ||
1380: msc_sda_utils.escapeSplChars(c_item.unit_weight) || c_field_seperator ||
1373: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_days) || c_field_seperator ||
1374: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_date) || c_field_seperator ||
1375: msc_sda_utils.escapeSplChars(c_item.safety_stock_code) || c_field_seperator ||
1376: msc_sda_utils.escapeSplChars(c_item.atp_flag) || c_field_seperator ||
1377: msc_sda_utils.escapeSplChars(c_item.atp_components_flag) || c_field_seperator ||
1378: msc_sda_utils.escapeSplChars(c_item.drp_planned) || c_field_seperator ||
1379: msc_sda_utils.escapeSplChars(c_item.weight_uom) || c_field_seperator ||
1380: msc_sda_utils.escapeSplChars(c_item.unit_weight) || c_field_seperator ||
1381: msc_sda_utils.escapeSplChars(c_item.volume_uom) || c_field_seperator ||
1374: msc_sda_utils.escapeSplChars(c_item.demand_time_fence_date) || c_field_seperator ||
1375: msc_sda_utils.escapeSplChars(c_item.safety_stock_code) || c_field_seperator ||
1376: msc_sda_utils.escapeSplChars(c_item.atp_flag) || c_field_seperator ||
1377: msc_sda_utils.escapeSplChars(c_item.atp_components_flag) || c_field_seperator ||
1378: msc_sda_utils.escapeSplChars(c_item.drp_planned) || c_field_seperator ||
1379: msc_sda_utils.escapeSplChars(c_item.weight_uom) || c_field_seperator ||
1380: msc_sda_utils.escapeSplChars(c_item.unit_weight) || c_field_seperator ||
1381: msc_sda_utils.escapeSplChars(c_item.volume_uom) || c_field_seperator ||
1382: msc_sda_utils.escapeSplChars(c_item.pip_flag) || c_field_seperator ||
1375: msc_sda_utils.escapeSplChars(c_item.safety_stock_code) || c_field_seperator ||
1376: msc_sda_utils.escapeSplChars(c_item.atp_flag) || c_field_seperator ||
1377: msc_sda_utils.escapeSplChars(c_item.atp_components_flag) || c_field_seperator ||
1378: msc_sda_utils.escapeSplChars(c_item.drp_planned) || c_field_seperator ||
1379: msc_sda_utils.escapeSplChars(c_item.weight_uom) || c_field_seperator ||
1380: msc_sda_utils.escapeSplChars(c_item.unit_weight) || c_field_seperator ||
1381: msc_sda_utils.escapeSplChars(c_item.volume_uom) || c_field_seperator ||
1382: msc_sda_utils.escapeSplChars(c_item.pip_flag) || c_field_seperator ||
1383: msc_sda_utils.escapeSplChars(c_item.create_supply_flag) || c_field_seperator ||
1376: msc_sda_utils.escapeSplChars(c_item.atp_flag) || c_field_seperator ||
1377: msc_sda_utils.escapeSplChars(c_item.atp_components_flag) || c_field_seperator ||
1378: msc_sda_utils.escapeSplChars(c_item.drp_planned) || c_field_seperator ||
1379: msc_sda_utils.escapeSplChars(c_item.weight_uom) || c_field_seperator ||
1380: msc_sda_utils.escapeSplChars(c_item.unit_weight) || c_field_seperator ||
1381: msc_sda_utils.escapeSplChars(c_item.volume_uom) || c_field_seperator ||
1382: msc_sda_utils.escapeSplChars(c_item.pip_flag) || c_field_seperator ||
1383: msc_sda_utils.escapeSplChars(c_item.create_supply_flag) || c_field_seperator ||
1384: msc_sda_utils.escapeSplChars(c_item.substitution_window) || c_field_seperator ||
1377: msc_sda_utils.escapeSplChars(c_item.atp_components_flag) || c_field_seperator ||
1378: msc_sda_utils.escapeSplChars(c_item.drp_planned) || c_field_seperator ||
1379: msc_sda_utils.escapeSplChars(c_item.weight_uom) || c_field_seperator ||
1380: msc_sda_utils.escapeSplChars(c_item.unit_weight) || c_field_seperator ||
1381: msc_sda_utils.escapeSplChars(c_item.volume_uom) || c_field_seperator ||
1382: msc_sda_utils.escapeSplChars(c_item.pip_flag) || c_field_seperator ||
1383: msc_sda_utils.escapeSplChars(c_item.create_supply_flag) || c_field_seperator ||
1384: msc_sda_utils.escapeSplChars(c_item.substitution_window) || c_field_seperator ||
1385: msc_sda_utils.escapeSplChars(c_item.convergence_text) || c_field_seperator ||
1378: msc_sda_utils.escapeSplChars(c_item.drp_planned) || c_field_seperator ||
1379: msc_sda_utils.escapeSplChars(c_item.weight_uom) || c_field_seperator ||
1380: msc_sda_utils.escapeSplChars(c_item.unit_weight) || c_field_seperator ||
1381: msc_sda_utils.escapeSplChars(c_item.volume_uom) || c_field_seperator ||
1382: msc_sda_utils.escapeSplChars(c_item.pip_flag) || c_field_seperator ||
1383: msc_sda_utils.escapeSplChars(c_item.create_supply_flag) || c_field_seperator ||
1384: msc_sda_utils.escapeSplChars(c_item.substitution_window) || c_field_seperator ||
1385: msc_sda_utils.escapeSplChars(c_item.convergence_text) || c_field_seperator ||
1386: msc_sda_utils.escapeSplChars(c_item.divergence_text) || c_field_seperator ||
1379: msc_sda_utils.escapeSplChars(c_item.weight_uom) || c_field_seperator ||
1380: msc_sda_utils.escapeSplChars(c_item.unit_weight) || c_field_seperator ||
1381: msc_sda_utils.escapeSplChars(c_item.volume_uom) || c_field_seperator ||
1382: msc_sda_utils.escapeSplChars(c_item.pip_flag) || c_field_seperator ||
1383: msc_sda_utils.escapeSplChars(c_item.create_supply_flag) || c_field_seperator ||
1384: msc_sda_utils.escapeSplChars(c_item.substitution_window) || c_field_seperator ||
1385: msc_sda_utils.escapeSplChars(c_item.convergence_text) || c_field_seperator ||
1386: msc_sda_utils.escapeSplChars(c_item.divergence_text) || c_field_seperator ||
1387: msc_sda_utils.escapeSplChars(c_item.continous_transfer_text) || c_field_seperator ||
1380: msc_sda_utils.escapeSplChars(c_item.unit_weight) || c_field_seperator ||
1381: msc_sda_utils.escapeSplChars(c_item.volume_uom) || c_field_seperator ||
1382: msc_sda_utils.escapeSplChars(c_item.pip_flag) || c_field_seperator ||
1383: msc_sda_utils.escapeSplChars(c_item.create_supply_flag) || c_field_seperator ||
1384: msc_sda_utils.escapeSplChars(c_item.substitution_window) || c_field_seperator ||
1385: msc_sda_utils.escapeSplChars(c_item.convergence_text) || c_field_seperator ||
1386: msc_sda_utils.escapeSplChars(c_item.divergence_text) || c_field_seperator ||
1387: msc_sda_utils.escapeSplChars(c_item.continous_transfer_text) || c_field_seperator ||
1388: msc_sda_utils.escapeSplChars(c_item.exclude_from_budget) || c_field_seperator ||
1381: msc_sda_utils.escapeSplChars(c_item.volume_uom) || c_field_seperator ||
1382: msc_sda_utils.escapeSplChars(c_item.pip_flag) || c_field_seperator ||
1383: msc_sda_utils.escapeSplChars(c_item.create_supply_flag) || c_field_seperator ||
1384: msc_sda_utils.escapeSplChars(c_item.substitution_window) || c_field_seperator ||
1385: msc_sda_utils.escapeSplChars(c_item.convergence_text) || c_field_seperator ||
1386: msc_sda_utils.escapeSplChars(c_item.divergence_text) || c_field_seperator ||
1387: msc_sda_utils.escapeSplChars(c_item.continous_transfer_text) || c_field_seperator ||
1388: msc_sda_utils.escapeSplChars(c_item.exclude_from_budget) || c_field_seperator ||
1389: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_window) || c_field_seperator ||
1382: msc_sda_utils.escapeSplChars(c_item.pip_flag) || c_field_seperator ||
1383: msc_sda_utils.escapeSplChars(c_item.create_supply_flag) || c_field_seperator ||
1384: msc_sda_utils.escapeSplChars(c_item.substitution_window) || c_field_seperator ||
1385: msc_sda_utils.escapeSplChars(c_item.convergence_text) || c_field_seperator ||
1386: msc_sda_utils.escapeSplChars(c_item.divergence_text) || c_field_seperator ||
1387: msc_sda_utils.escapeSplChars(c_item.continous_transfer_text) || c_field_seperator ||
1388: msc_sda_utils.escapeSplChars(c_item.exclude_from_budget) || c_field_seperator ||
1389: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_window) || c_field_seperator ||
1390: msc_sda_utils.escapeSplChars(c_item.days_max_inv_window) || c_field_seperator ||
1383: msc_sda_utils.escapeSplChars(c_item.create_supply_flag) || c_field_seperator ||
1384: msc_sda_utils.escapeSplChars(c_item.substitution_window) || c_field_seperator ||
1385: msc_sda_utils.escapeSplChars(c_item.convergence_text) || c_field_seperator ||
1386: msc_sda_utils.escapeSplChars(c_item.divergence_text) || c_field_seperator ||
1387: msc_sda_utils.escapeSplChars(c_item.continous_transfer_text) || c_field_seperator ||
1388: msc_sda_utils.escapeSplChars(c_item.exclude_from_budget) || c_field_seperator ||
1389: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_window) || c_field_seperator ||
1390: msc_sda_utils.escapeSplChars(c_item.days_max_inv_window) || c_field_seperator ||
1391: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_supply) || c_field_seperator ||
1384: msc_sda_utils.escapeSplChars(c_item.substitution_window) || c_field_seperator ||
1385: msc_sda_utils.escapeSplChars(c_item.convergence_text) || c_field_seperator ||
1386: msc_sda_utils.escapeSplChars(c_item.divergence_text) || c_field_seperator ||
1387: msc_sda_utils.escapeSplChars(c_item.continous_transfer_text) || c_field_seperator ||
1388: msc_sda_utils.escapeSplChars(c_item.exclude_from_budget) || c_field_seperator ||
1389: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_window) || c_field_seperator ||
1390: msc_sda_utils.escapeSplChars(c_item.days_max_inv_window) || c_field_seperator ||
1391: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_supply) || c_field_seperator ||
1392: msc_sda_utils.escapeSplChars(c_item.days_max_inv_supply) || c_field_seperator ||
1385: msc_sda_utils.escapeSplChars(c_item.convergence_text) || c_field_seperator ||
1386: msc_sda_utils.escapeSplChars(c_item.divergence_text) || c_field_seperator ||
1387: msc_sda_utils.escapeSplChars(c_item.continous_transfer_text) || c_field_seperator ||
1388: msc_sda_utils.escapeSplChars(c_item.exclude_from_budget) || c_field_seperator ||
1389: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_window) || c_field_seperator ||
1390: msc_sda_utils.escapeSplChars(c_item.days_max_inv_window) || c_field_seperator ||
1391: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_supply) || c_field_seperator ||
1392: msc_sda_utils.escapeSplChars(c_item.days_max_inv_supply) || c_field_seperator ||
1393: msc_sda_utils.escapeSplChars(c_item.shelf_life_days) || c_field_seperator ||
1386: msc_sda_utils.escapeSplChars(c_item.divergence_text) || c_field_seperator ||
1387: msc_sda_utils.escapeSplChars(c_item.continous_transfer_text) || c_field_seperator ||
1388: msc_sda_utils.escapeSplChars(c_item.exclude_from_budget) || c_field_seperator ||
1389: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_window) || c_field_seperator ||
1390: msc_sda_utils.escapeSplChars(c_item.days_max_inv_window) || c_field_seperator ||
1391: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_supply) || c_field_seperator ||
1392: msc_sda_utils.escapeSplChars(c_item.days_max_inv_supply) || c_field_seperator ||
1393: msc_sda_utils.escapeSplChars(c_item.shelf_life_days) || c_field_seperator ||
1394: msc_sda_utils.escapeSplChars(c_item.release_time_fence_days) || c_field_seperator ||
1387: msc_sda_utils.escapeSplChars(c_item.continous_transfer_text) || c_field_seperator ||
1388: msc_sda_utils.escapeSplChars(c_item.exclude_from_budget) || c_field_seperator ||
1389: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_window) || c_field_seperator ||
1390: msc_sda_utils.escapeSplChars(c_item.days_max_inv_window) || c_field_seperator ||
1391: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_supply) || c_field_seperator ||
1392: msc_sda_utils.escapeSplChars(c_item.days_max_inv_supply) || c_field_seperator ||
1393: msc_sda_utils.escapeSplChars(c_item.shelf_life_days) || c_field_seperator ||
1394: msc_sda_utils.escapeSplChars(c_item.release_time_fence_days) || c_field_seperator ||
1395: msc_sda_utils.escapeSplChars(c_item.min_shelf_life_days) || c_field_seperator ||
1388: msc_sda_utils.escapeSplChars(c_item.exclude_from_budget) || c_field_seperator ||
1389: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_window) || c_field_seperator ||
1390: msc_sda_utils.escapeSplChars(c_item.days_max_inv_window) || c_field_seperator ||
1391: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_supply) || c_field_seperator ||
1392: msc_sda_utils.escapeSplChars(c_item.days_max_inv_supply) || c_field_seperator ||
1393: msc_sda_utils.escapeSplChars(c_item.shelf_life_days) || c_field_seperator ||
1394: msc_sda_utils.escapeSplChars(c_item.release_time_fence_days) || c_field_seperator ||
1395: msc_sda_utils.escapeSplChars(c_item.min_shelf_life_days) || c_field_seperator ||
1396: msc_sda_utils.escapeSplChars(c_item.unit_volume) || c_field_seperator ||
1389: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_window) || c_field_seperator ||
1390: msc_sda_utils.escapeSplChars(c_item.days_max_inv_window) || c_field_seperator ||
1391: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_supply) || c_field_seperator ||
1392: msc_sda_utils.escapeSplChars(c_item.days_max_inv_supply) || c_field_seperator ||
1393: msc_sda_utils.escapeSplChars(c_item.shelf_life_days) || c_field_seperator ||
1394: msc_sda_utils.escapeSplChars(c_item.release_time_fence_days) || c_field_seperator ||
1395: msc_sda_utils.escapeSplChars(c_item.min_shelf_life_days) || c_field_seperator ||
1396: msc_sda_utils.escapeSplChars(c_item.unit_volume) || c_field_seperator ||
1397: msc_sda_utils.escapeSplChars(c_item.max_early_days) || c_field_seperator ||
1390: msc_sda_utils.escapeSplChars(c_item.days_max_inv_window) || c_field_seperator ||
1391: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_supply) || c_field_seperator ||
1392: msc_sda_utils.escapeSplChars(c_item.days_max_inv_supply) || c_field_seperator ||
1393: msc_sda_utils.escapeSplChars(c_item.shelf_life_days) || c_field_seperator ||
1394: msc_sda_utils.escapeSplChars(c_item.release_time_fence_days) || c_field_seperator ||
1395: msc_sda_utils.escapeSplChars(c_item.min_shelf_life_days) || c_field_seperator ||
1396: msc_sda_utils.escapeSplChars(c_item.unit_volume) || c_field_seperator ||
1397: msc_sda_utils.escapeSplChars(c_item.max_early_days) || c_field_seperator ||
1398: msc_sda_utils.escapeSplChars(c_item.demand_fulfillment_lt) || c_field_seperator ||
1391: msc_sda_utils.escapeSplChars(c_item.days_tgt_inv_supply) || c_field_seperator ||
1392: msc_sda_utils.escapeSplChars(c_item.days_max_inv_supply) || c_field_seperator ||
1393: msc_sda_utils.escapeSplChars(c_item.shelf_life_days) || c_field_seperator ||
1394: msc_sda_utils.escapeSplChars(c_item.release_time_fence_days) || c_field_seperator ||
1395: msc_sda_utils.escapeSplChars(c_item.min_shelf_life_days) || c_field_seperator ||
1396: msc_sda_utils.escapeSplChars(c_item.unit_volume) || c_field_seperator ||
1397: msc_sda_utils.escapeSplChars(c_item.max_early_days) || c_field_seperator ||
1398: msc_sda_utils.escapeSplChars(c_item.demand_fulfillment_lt) || c_field_seperator ||
1399: msc_sda_utils.escapeSplChars(to_char(c_item.end_of_life_date, c_datetime_format)) || c_field_seperator ||
1392: msc_sda_utils.escapeSplChars(c_item.days_max_inv_supply) || c_field_seperator ||
1393: msc_sda_utils.escapeSplChars(c_item.shelf_life_days) || c_field_seperator ||
1394: msc_sda_utils.escapeSplChars(c_item.release_time_fence_days) || c_field_seperator ||
1395: msc_sda_utils.escapeSplChars(c_item.min_shelf_life_days) || c_field_seperator ||
1396: msc_sda_utils.escapeSplChars(c_item.unit_volume) || c_field_seperator ||
1397: msc_sda_utils.escapeSplChars(c_item.max_early_days) || c_field_seperator ||
1398: msc_sda_utils.escapeSplChars(c_item.demand_fulfillment_lt) || c_field_seperator ||
1399: msc_sda_utils.escapeSplChars(to_char(c_item.end_of_life_date, c_datetime_format)) || c_field_seperator ||
1400: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_demands_text) || c_field_seperator ||
1393: msc_sda_utils.escapeSplChars(c_item.shelf_life_days) || c_field_seperator ||
1394: msc_sda_utils.escapeSplChars(c_item.release_time_fence_days) || c_field_seperator ||
1395: msc_sda_utils.escapeSplChars(c_item.min_shelf_life_days) || c_field_seperator ||
1396: msc_sda_utils.escapeSplChars(c_item.unit_volume) || c_field_seperator ||
1397: msc_sda_utils.escapeSplChars(c_item.max_early_days) || c_field_seperator ||
1398: msc_sda_utils.escapeSplChars(c_item.demand_fulfillment_lt) || c_field_seperator ||
1399: msc_sda_utils.escapeSplChars(to_char(c_item.end_of_life_date, c_datetime_format)) || c_field_seperator ||
1400: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_demands_text) || c_field_seperator ||
1401: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_returns_text) || c_field_seperator ||
1394: msc_sda_utils.escapeSplChars(c_item.release_time_fence_days) || c_field_seperator ||
1395: msc_sda_utils.escapeSplChars(c_item.min_shelf_life_days) || c_field_seperator ||
1396: msc_sda_utils.escapeSplChars(c_item.unit_volume) || c_field_seperator ||
1397: msc_sda_utils.escapeSplChars(c_item.max_early_days) || c_field_seperator ||
1398: msc_sda_utils.escapeSplChars(c_item.demand_fulfillment_lt) || c_field_seperator ||
1399: msc_sda_utils.escapeSplChars(to_char(c_item.end_of_life_date, c_datetime_format)) || c_field_seperator ||
1400: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_demands_text) || c_field_seperator ||
1401: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_returns_text) || c_field_seperator ||
1402: msc_sda_utils.escapeSplChars(c_item.interarrival_time) || c_field_seperator ||
1395: msc_sda_utils.escapeSplChars(c_item.min_shelf_life_days) || c_field_seperator ||
1396: msc_sda_utils.escapeSplChars(c_item.unit_volume) || c_field_seperator ||
1397: msc_sda_utils.escapeSplChars(c_item.max_early_days) || c_field_seperator ||
1398: msc_sda_utils.escapeSplChars(c_item.demand_fulfillment_lt) || c_field_seperator ||
1399: msc_sda_utils.escapeSplChars(to_char(c_item.end_of_life_date, c_datetime_format)) || c_field_seperator ||
1400: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_demands_text) || c_field_seperator ||
1401: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_returns_text) || c_field_seperator ||
1402: msc_sda_utils.escapeSplChars(c_item.interarrival_time) || c_field_seperator ||
1403: msc_sda_utils.escapeSplChars(to_char(c_item.life_time_buy_date, c_datetime_format)) || c_field_seperator ||
1396: msc_sda_utils.escapeSplChars(c_item.unit_volume) || c_field_seperator ||
1397: msc_sda_utils.escapeSplChars(c_item.max_early_days) || c_field_seperator ||
1398: msc_sda_utils.escapeSplChars(c_item.demand_fulfillment_lt) || c_field_seperator ||
1399: msc_sda_utils.escapeSplChars(to_char(c_item.end_of_life_date, c_datetime_format)) || c_field_seperator ||
1400: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_demands_text) || c_field_seperator ||
1401: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_returns_text) || c_field_seperator ||
1402: msc_sda_utils.escapeSplChars(c_item.interarrival_time) || c_field_seperator ||
1403: msc_sda_utils.escapeSplChars(to_char(c_item.life_time_buy_date, c_datetime_format)) || c_field_seperator ||
1404: msc_sda_utils.escapeSplChars(c_item.preposition_point) || c_field_seperator ||
1397: msc_sda_utils.escapeSplChars(c_item.max_early_days) || c_field_seperator ||
1398: msc_sda_utils.escapeSplChars(c_item.demand_fulfillment_lt) || c_field_seperator ||
1399: msc_sda_utils.escapeSplChars(to_char(c_item.end_of_life_date, c_datetime_format)) || c_field_seperator ||
1400: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_demands_text) || c_field_seperator ||
1401: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_returns_text) || c_field_seperator ||
1402: msc_sda_utils.escapeSplChars(c_item.interarrival_time) || c_field_seperator ||
1403: msc_sda_utils.escapeSplChars(to_char(c_item.life_time_buy_date, c_datetime_format)) || c_field_seperator ||
1404: msc_sda_utils.escapeSplChars(c_item.preposition_point) || c_field_seperator ||
1405: msc_sda_utils.escapeSplChars(c_item.repair_cost) || c_field_seperator ||
1398: msc_sda_utils.escapeSplChars(c_item.demand_fulfillment_lt) || c_field_seperator ||
1399: msc_sda_utils.escapeSplChars(to_char(c_item.end_of_life_date, c_datetime_format)) || c_field_seperator ||
1400: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_demands_text) || c_field_seperator ||
1401: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_returns_text) || c_field_seperator ||
1402: msc_sda_utils.escapeSplChars(c_item.interarrival_time) || c_field_seperator ||
1403: msc_sda_utils.escapeSplChars(to_char(c_item.life_time_buy_date, c_datetime_format)) || c_field_seperator ||
1404: msc_sda_utils.escapeSplChars(c_item.preposition_point) || c_field_seperator ||
1405: msc_sda_utils.escapeSplChars(c_item.repair_cost) || c_field_seperator ||
1406: msc_sda_utils.escapeSplChars(c_item.repair_lead_time) || c_field_seperator ||
1399: msc_sda_utils.escapeSplChars(to_char(c_item.end_of_life_date, c_datetime_format)) || c_field_seperator ||
1400: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_demands_text) || c_field_seperator ||
1401: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_returns_text) || c_field_seperator ||
1402: msc_sda_utils.escapeSplChars(c_item.interarrival_time) || c_field_seperator ||
1403: msc_sda_utils.escapeSplChars(to_char(c_item.life_time_buy_date, c_datetime_format)) || c_field_seperator ||
1404: msc_sda_utils.escapeSplChars(c_item.preposition_point) || c_field_seperator ||
1405: msc_sda_utils.escapeSplChars(c_item.repair_cost) || c_field_seperator ||
1406: msc_sda_utils.escapeSplChars(c_item.repair_lead_time) || c_field_seperator ||
1407: msc_sda_utils.escapeSplChars(c_item.repair_program_text) || c_field_seperator ||
1400: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_demands_text) || c_field_seperator ||
1401: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_returns_text) || c_field_seperator ||
1402: msc_sda_utils.escapeSplChars(c_item.interarrival_time) || c_field_seperator ||
1403: msc_sda_utils.escapeSplChars(to_char(c_item.life_time_buy_date, c_datetime_format)) || c_field_seperator ||
1404: msc_sda_utils.escapeSplChars(c_item.preposition_point) || c_field_seperator ||
1405: msc_sda_utils.escapeSplChars(c_item.repair_cost) || c_field_seperator ||
1406: msc_sda_utils.escapeSplChars(c_item.repair_lead_time) || c_field_seperator ||
1407: msc_sda_utils.escapeSplChars(c_item.repair_program_text) || c_field_seperator ||
1408: msc_sda_utils.escapeSplChars(c_item.repair_yield) || c_field_seperator ||
1401: msc_sda_utils.escapeSplChars(c_item.fcst_rule_for_returns_text) || c_field_seperator ||
1402: msc_sda_utils.escapeSplChars(c_item.interarrival_time) || c_field_seperator ||
1403: msc_sda_utils.escapeSplChars(to_char(c_item.life_time_buy_date, c_datetime_format)) || c_field_seperator ||
1404: msc_sda_utils.escapeSplChars(c_item.preposition_point) || c_field_seperator ||
1405: msc_sda_utils.escapeSplChars(c_item.repair_cost) || c_field_seperator ||
1406: msc_sda_utils.escapeSplChars(c_item.repair_lead_time) || c_field_seperator ||
1407: msc_sda_utils.escapeSplChars(c_item.repair_program_text) || c_field_seperator ||
1408: msc_sda_utils.escapeSplChars(c_item.repair_yield) || c_field_seperator ||
1409: msc_sda_utils.escapeSplChars(c_item.std_dmd_over_horizon) || c_field_seperator ||
1402: msc_sda_utils.escapeSplChars(c_item.interarrival_time) || c_field_seperator ||
1403: msc_sda_utils.escapeSplChars(to_char(c_item.life_time_buy_date, c_datetime_format)) || c_field_seperator ||
1404: msc_sda_utils.escapeSplChars(c_item.preposition_point) || c_field_seperator ||
1405: msc_sda_utils.escapeSplChars(c_item.repair_cost) || c_field_seperator ||
1406: msc_sda_utils.escapeSplChars(c_item.repair_lead_time) || c_field_seperator ||
1407: msc_sda_utils.escapeSplChars(c_item.repair_program_text) || c_field_seperator ||
1408: msc_sda_utils.escapeSplChars(c_item.repair_yield) || c_field_seperator ||
1409: msc_sda_utils.escapeSplChars(c_item.std_dmd_over_horizon) || c_field_seperator ||
1410: msc_sda_utils.escapeSplChars(c_item.repetitive_planning_flag_text) || c_field_seperator ||
1403: msc_sda_utils.escapeSplChars(to_char(c_item.life_time_buy_date, c_datetime_format)) || c_field_seperator ||
1404: msc_sda_utils.escapeSplChars(c_item.preposition_point) || c_field_seperator ||
1405: msc_sda_utils.escapeSplChars(c_item.repair_cost) || c_field_seperator ||
1406: msc_sda_utils.escapeSplChars(c_item.repair_lead_time) || c_field_seperator ||
1407: msc_sda_utils.escapeSplChars(c_item.repair_program_text) || c_field_seperator ||
1408: msc_sda_utils.escapeSplChars(c_item.repair_yield) || c_field_seperator ||
1409: msc_sda_utils.escapeSplChars(c_item.std_dmd_over_horizon) || c_field_seperator ||
1410: msc_sda_utils.escapeSplChars(c_item.repetitive_planning_flag_text) || c_field_seperator ||
1411: msc_sda_utils.escapeSplChars(c_item.MAX_USAGE_FACTOR) || c_field_seperator ||
1404: msc_sda_utils.escapeSplChars(c_item.preposition_point) || c_field_seperator ||
1405: msc_sda_utils.escapeSplChars(c_item.repair_cost) || c_field_seperator ||
1406: msc_sda_utils.escapeSplChars(c_item.repair_lead_time) || c_field_seperator ||
1407: msc_sda_utils.escapeSplChars(c_item.repair_program_text) || c_field_seperator ||
1408: msc_sda_utils.escapeSplChars(c_item.repair_yield) || c_field_seperator ||
1409: msc_sda_utils.escapeSplChars(c_item.std_dmd_over_horizon) || c_field_seperator ||
1410: msc_sda_utils.escapeSplChars(c_item.repetitive_planning_flag_text) || c_field_seperator ||
1411: msc_sda_utils.escapeSplChars(c_item.MAX_USAGE_FACTOR) || c_field_seperator ||
1412: msc_sda_utils.escapeSplChars(c_item.COMPUTE_SS) || c_field_seperator ||
1405: msc_sda_utils.escapeSplChars(c_item.repair_cost) || c_field_seperator ||
1406: msc_sda_utils.escapeSplChars(c_item.repair_lead_time) || c_field_seperator ||
1407: msc_sda_utils.escapeSplChars(c_item.repair_program_text) || c_field_seperator ||
1408: msc_sda_utils.escapeSplChars(c_item.repair_yield) || c_field_seperator ||
1409: msc_sda_utils.escapeSplChars(c_item.std_dmd_over_horizon) || c_field_seperator ||
1410: msc_sda_utils.escapeSplChars(c_item.repetitive_planning_flag_text) || c_field_seperator ||
1411: msc_sda_utils.escapeSplChars(c_item.MAX_USAGE_FACTOR) || c_field_seperator ||
1412: msc_sda_utils.escapeSplChars(c_item.COMPUTE_SS) || c_field_seperator ||
1413: msc_sda_utils.escapeSplChars(c_item.COMPUTE_EOQ) || c_field_seperator ||
1406: msc_sda_utils.escapeSplChars(c_item.repair_lead_time) || c_field_seperator ||
1407: msc_sda_utils.escapeSplChars(c_item.repair_program_text) || c_field_seperator ||
1408: msc_sda_utils.escapeSplChars(c_item.repair_yield) || c_field_seperator ||
1409: msc_sda_utils.escapeSplChars(c_item.std_dmd_over_horizon) || c_field_seperator ||
1410: msc_sda_utils.escapeSplChars(c_item.repetitive_planning_flag_text) || c_field_seperator ||
1411: msc_sda_utils.escapeSplChars(c_item.MAX_USAGE_FACTOR) || c_field_seperator ||
1412: msc_sda_utils.escapeSplChars(c_item.COMPUTE_SS) || c_field_seperator ||
1413: msc_sda_utils.escapeSplChars(c_item.COMPUTE_EOQ) || c_field_seperator ||
1414: msc_sda_utils.escapeSplChars(c_item.ORDER_COST) || c_field_seperator ||
1407: msc_sda_utils.escapeSplChars(c_item.repair_program_text) || c_field_seperator ||
1408: msc_sda_utils.escapeSplChars(c_item.repair_yield) || c_field_seperator ||
1409: msc_sda_utils.escapeSplChars(c_item.std_dmd_over_horizon) || c_field_seperator ||
1410: msc_sda_utils.escapeSplChars(c_item.repetitive_planning_flag_text) || c_field_seperator ||
1411: msc_sda_utils.escapeSplChars(c_item.MAX_USAGE_FACTOR) || c_field_seperator ||
1412: msc_sda_utils.escapeSplChars(c_item.COMPUTE_SS) || c_field_seperator ||
1413: msc_sda_utils.escapeSplChars(c_item.COMPUTE_EOQ) || c_field_seperator ||
1414: msc_sda_utils.escapeSplChars(c_item.ORDER_COST) || c_field_seperator ||
1415: msc_sda_utils.escapeSplChars(c_item.ROP_SAFETY_STOCK)
1408: msc_sda_utils.escapeSplChars(c_item.repair_yield) || c_field_seperator ||
1409: msc_sda_utils.escapeSplChars(c_item.std_dmd_over_horizon) || c_field_seperator ||
1410: msc_sda_utils.escapeSplChars(c_item.repetitive_planning_flag_text) || c_field_seperator ||
1411: msc_sda_utils.escapeSplChars(c_item.MAX_USAGE_FACTOR) || c_field_seperator ||
1412: msc_sda_utils.escapeSplChars(c_item.COMPUTE_SS) || c_field_seperator ||
1413: msc_sda_utils.escapeSplChars(c_item.COMPUTE_EOQ) || c_field_seperator ||
1414: msc_sda_utils.escapeSplChars(c_item.ORDER_COST) || c_field_seperator ||
1415: msc_sda_utils.escapeSplChars(c_item.ROP_SAFETY_STOCK)
1416: || c_field_seperator || msc_sda_utils.escapeSplChars(c_item.INTERMITTENT_DEMAND);
1409: msc_sda_utils.escapeSplChars(c_item.std_dmd_over_horizon) || c_field_seperator ||
1410: msc_sda_utils.escapeSplChars(c_item.repetitive_planning_flag_text) || c_field_seperator ||
1411: msc_sda_utils.escapeSplChars(c_item.MAX_USAGE_FACTOR) || c_field_seperator ||
1412: msc_sda_utils.escapeSplChars(c_item.COMPUTE_SS) || c_field_seperator ||
1413: msc_sda_utils.escapeSplChars(c_item.COMPUTE_EOQ) || c_field_seperator ||
1414: msc_sda_utils.escapeSplChars(c_item.ORDER_COST) || c_field_seperator ||
1415: msc_sda_utils.escapeSplChars(c_item.ROP_SAFETY_STOCK)
1416: || c_field_seperator || msc_sda_utils.escapeSplChars(c_item.INTERMITTENT_DEMAND);
1417:
1410: msc_sda_utils.escapeSplChars(c_item.repetitive_planning_flag_text) || c_field_seperator ||
1411: msc_sda_utils.escapeSplChars(c_item.MAX_USAGE_FACTOR) || c_field_seperator ||
1412: msc_sda_utils.escapeSplChars(c_item.COMPUTE_SS) || c_field_seperator ||
1413: msc_sda_utils.escapeSplChars(c_item.COMPUTE_EOQ) || c_field_seperator ||
1414: msc_sda_utils.escapeSplChars(c_item.ORDER_COST) || c_field_seperator ||
1415: msc_sda_utils.escapeSplChars(c_item.ROP_SAFETY_STOCK)
1416: || c_field_seperator || msc_sda_utils.escapeSplChars(c_item.INTERMITTENT_DEMAND);
1417:
1418: l_row_count := l_row_count + 1;
1411: msc_sda_utils.escapeSplChars(c_item.MAX_USAGE_FACTOR) || c_field_seperator ||
1412: msc_sda_utils.escapeSplChars(c_item.COMPUTE_SS) || c_field_seperator ||
1413: msc_sda_utils.escapeSplChars(c_item.COMPUTE_EOQ) || c_field_seperator ||
1414: msc_sda_utils.escapeSplChars(c_item.ORDER_COST) || c_field_seperator ||
1415: msc_sda_utils.escapeSplChars(c_item.ROP_SAFETY_STOCK)
1416: || c_field_seperator || msc_sda_utils.escapeSplChars(c_item.INTERMITTENT_DEMAND);
1417:
1418: l_row_count := l_row_count + 1;
1419:
1412: msc_sda_utils.escapeSplChars(c_item.COMPUTE_SS) || c_field_seperator ||
1413: msc_sda_utils.escapeSplChars(c_item.COMPUTE_EOQ) || c_field_seperator ||
1414: msc_sda_utils.escapeSplChars(c_item.ORDER_COST) || c_field_seperator ||
1415: msc_sda_utils.escapeSplChars(c_item.ROP_SAFETY_STOCK)
1416: || c_field_seperator || msc_sda_utils.escapeSplChars(c_item.INTERMITTENT_DEMAND);
1417:
1418: l_row_count := l_row_count + 1;
1419:
1420: if (l_row_count = 1) then
1419:
1420: if (l_row_count = 1) then
1421: l_one_record := c_sdview_items_data || c_bang_separator || c_record_seperator || l_one_record;
1422: end if;
1423: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1424: end loop;
1425: println('getItemsData out');
1426: end getItemsData;
1427:
1486: begin
1487: println('getExceptionsData in');
1488: for c_excp_summary in c_excp_summary_cur loop
1489: l_one_record :=
1490: msc_sda_utils.escapeSplChars(p_chain_query_id||'-'||c_excp_summary.exception_type) || c_field_seperator ||
1491: msc_sda_utils.escapeSplChars(c_excp_summary.exception_type_text) || c_field_seperator ||
1492: msc_sda_utils.escapeSplChars(c_excp_summary.excp_all_count) || c_field_seperator ||
1493: msc_sda_utils.escapeSplChars(c_excp_summary.excp_no_count);
1494:
1487: println('getExceptionsData in');
1488: for c_excp_summary in c_excp_summary_cur loop
1489: l_one_record :=
1490: msc_sda_utils.escapeSplChars(p_chain_query_id||'-'||c_excp_summary.exception_type) || c_field_seperator ||
1491: msc_sda_utils.escapeSplChars(c_excp_summary.exception_type_text) || c_field_seperator ||
1492: msc_sda_utils.escapeSplChars(c_excp_summary.excp_all_count) || c_field_seperator ||
1493: msc_sda_utils.escapeSplChars(c_excp_summary.excp_no_count);
1494:
1495: l_row_count := l_row_count + 1;
1488: for c_excp_summary in c_excp_summary_cur loop
1489: l_one_record :=
1490: msc_sda_utils.escapeSplChars(p_chain_query_id||'-'||c_excp_summary.exception_type) || c_field_seperator ||
1491: msc_sda_utils.escapeSplChars(c_excp_summary.exception_type_text) || c_field_seperator ||
1492: msc_sda_utils.escapeSplChars(c_excp_summary.excp_all_count) || c_field_seperator ||
1493: msc_sda_utils.escapeSplChars(c_excp_summary.excp_no_count);
1494:
1495: l_row_count := l_row_count + 1;
1496: if (l_row_count = 1) then
1489: l_one_record :=
1490: msc_sda_utils.escapeSplChars(p_chain_query_id||'-'||c_excp_summary.exception_type) || c_field_seperator ||
1491: msc_sda_utils.escapeSplChars(c_excp_summary.exception_type_text) || c_field_seperator ||
1492: msc_sda_utils.escapeSplChars(c_excp_summary.excp_all_count) || c_field_seperator ||
1493: msc_sda_utils.escapeSplChars(c_excp_summary.excp_no_count);
1494:
1495: l_row_count := l_row_count + 1;
1496: if (l_row_count = 1) then
1497: l_one_record := c_sdview_excp_data || c_bang_separator || c_record_seperator || l_one_record;
1495: l_row_count := l_row_count + 1;
1496: if (l_row_count = 1) then
1497: l_one_record := c_sdview_excp_data || c_bang_separator || c_record_seperator || l_one_record;
1498: end if;
1499: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1500: end loop;
1501: println('getExceptionsData out');
1502: end getExceptionsData;
1503:
1523: end if;
1524: for c_userpref in c_userpref_cur
1525: loop
1526: l_one_record :=
1527: msc_sda_utils.escapeSplChars(c_userpref.name) || c_field_seperator ||
1528: msc_sda_utils.escapeSplChars(c_userpref.key) || c_field_seperator ||
1529: msc_sda_utils.escapeSplChars(c_userpref.value);
1530:
1531: l_row_count := l_row_count + 1;
1524: for c_userpref in c_userpref_cur
1525: loop
1526: l_one_record :=
1527: msc_sda_utils.escapeSplChars(c_userpref.name) || c_field_seperator ||
1528: msc_sda_utils.escapeSplChars(c_userpref.key) || c_field_seperator ||
1529: msc_sda_utils.escapeSplChars(c_userpref.value);
1530:
1531: l_row_count := l_row_count + 1;
1532: if (l_row_count = 1) then
1525: loop
1526: l_one_record :=
1527: msc_sda_utils.escapeSplChars(c_userpref.name) || c_field_seperator ||
1528: msc_sda_utils.escapeSplChars(c_userpref.key) || c_field_seperator ||
1529: msc_sda_utils.escapeSplChars(c_userpref.value);
1530:
1531: l_row_count := l_row_count + 1;
1532: if (l_row_count = 1) then
1533: l_one_record := l_stream_label || c_bang_separator || c_record_seperator || l_one_record;
1531: l_row_count := l_row_count + 1;
1532: if (l_row_count = 1) then
1533: l_one_record := l_stream_label || c_bang_separator || c_record_seperator || l_one_record;
1534: end if;
1535: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1536: end loop;
1537: println('getWorkSheetPrefData out');
1538: end getWorkSheetPrefData;
1539:
1536: end loop;
1537: println('getWorkSheetPrefData out');
1538: end getWorkSheetPrefData;
1539:
1540: procedure sendSDRowTypes(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1541: cursor c_sd_rowtypes_cur is
1542: select lookup_code, meaning
1543: from mfg_lookups
1544: where lookup_type = c_sdview_rowtype_lookup
1594: l_total_row_flag := 1;
1595: end if;
1596:
1597: l_token := c_sd_rowtypes.lookup_code
1598: || c_field_seperator || msc_sda_utils.escapeSplChars(c_sd_rowtypes.meaning)
1599: || c_field_seperator || l_flag || c_field_seperator || l_visible_flag || c_field_seperator || l_total_row_flag;
1600: if (l_one_record is null) then
1601: l_one_record := c_sdview_rowtypes || c_bang_separator || c_sd_total_row_types || c_record_seperator || l_token;
1602: else
1602: else
1603: l_one_record := l_one_record || c_record_seperator || l_token;
1604: end if;
1605: end loop;
1606: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1607: end sendSDRowTypes;
1608:
1609: procedure sendFcstRowTypes(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1610: cursor c_fcst_rowtypes_cur is
1605: end loop;
1606: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1607: end sendSDRowTypes;
1608:
1609: procedure sendFcstRowTypes(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1610: cursor c_fcst_rowtypes_cur is
1611: select lookup_code, meaning
1612: from mfg_lookups
1613: where lookup_type = c_fcstview_rowtype_lookup
1638: l_total_row_flag := 1;
1639: end if;
1640:
1641: l_token := c_fcst_rowtypes.lookup_code
1642: || c_field_seperator || msc_sda_utils.escapeSplChars(c_fcst_rowtypes.meaning)
1643: || c_field_seperator || l_flag || c_field_seperator || l_visible_flag || c_field_seperator || l_total_row_flag;
1644: if (l_one_record is null) then
1645: l_one_record := c_fcstview_rowtypes || c_bang_separator || c_fcst_total_row_types || c_record_seperator || l_token;
1646: else
1646: else
1647: l_one_record := l_one_record || c_record_seperator || l_token;
1648: end if;
1649: end loop;
1650: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1651: end sendFcstRowTypes;
1652:
1653: procedure sendHistRowTypes(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1654: cursor c_hist_rowtypes_cur is
1649: end loop;
1650: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1651: end sendFcstRowTypes;
1652:
1653: procedure sendHistRowTypes(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1654: cursor c_hist_rowtypes_cur is
1655: select lookup_code, meaning
1656: from mfg_lookups
1657: where lookup_type = c_histview_rowtype_lookup
1668: l_flag := 0;
1669: l_visible_flag := 1;
1670: l_total_row_flag := 2;
1671: l_token := c_hist_rowtypes.lookup_code
1672: || c_field_seperator || msc_sda_utils.escapeSplChars(c_hist_rowtypes.meaning)
1673: || c_field_seperator || l_flag || c_field_seperator || l_visible_flag || c_field_seperator || l_total_row_flag;
1674: if (l_one_record is null) then
1675: l_one_record := c_histview_rowtypes || c_bang_separator || c_hist_total_row_types || c_record_seperator || l_token;
1676: else
1676: else
1677: l_one_record := l_one_record || c_record_seperator || l_token;
1678: end if;
1679: end loop;
1680: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1681: end sendHistRowTypes;
1682:
1683: function getTokenizedMsg(p_msg varchar2) return varchar2 is
1684: l_msg_text varchar2(300);
1687: l_msg_text:= FND_MESSAGE.get;
1688: if (l_msg_text is null) then
1689: l_msg_text:= p_msg|| c_field_seperator || p_msg;
1690: else
1691: l_msg_text:= p_msg|| c_field_seperator || msc_sda_utils.escapeSplChars(l_msg_text);
1692: end if;
1693: return l_msg_text;
1694: end getTokenizedMsg;
1695:
1693: return l_msg_text;
1694: end getTokenizedMsg;
1695:
1696: procedure addMessages(p_msg varchar2, p_out_data_index in out nocopy number,
1697: p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1698: l_one_record varchar2(1200) := null;
1699: l_token varchar2(1000);
1700: begin
1701: l_one_record := getTokenizedMsg(p_msg);
1698: l_one_record varchar2(1200) := null;
1699: l_token varchar2(1000);
1700: begin
1701: l_one_record := getTokenizedMsg(p_msg);
1702: msc_sda_utils.addRecordToOutStream(l_one_record, p_out_data_index, p_out_data);
1703: end addMessages;
1704:
1705: procedure sendNlsMessages(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1706: l_one_record varchar2(32000) := null;
1701: l_one_record := getTokenizedMsg(p_msg);
1702: msc_sda_utils.addRecordToOutStream(l_one_record, p_out_data_index, p_out_data);
1703: end addMessages;
1704:
1705: procedure sendNlsMessages(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) is
1706: l_one_record varchar2(32000) := null;
1707: l_token varchar2(1000);
1708: l_out_data_index number := 1;
1709: begin
1708: l_out_data_index number := 1;
1709: begin
1710: l_token := getTokenizedMsg('MENU_ORDER_DETAILS');
1711: l_one_record := c_sdview_nls_messages || c_bang_separator || c_record_seperator || l_token;
1712: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1713:
1714: addMessages('MENU_FORECAST_RULE', l_out_data_index, p_out_data);
1715: addMessages('MENU_CALENDAR', l_out_data_index, p_out_data);
1716: addMessages('MENU_SOURCES', l_out_data_index, p_out_data);
1752: addMessages('SDA_SAVE_FOLDER', l_out_data_index, p_out_data);
1753: addMessages('MSC_EC_SAVE_SETTINGS', l_out_data_index, p_out_data);
1754:
1755: l_one_record := 'ICX_DATE_FORMAT_MASK'|| c_field_seperator
1756: || msc_sda_utils.escapeSplChars(nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'), 'MM/DD/YYYY'));
1757: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1758: addMessages('MSC_NOTE_SUMMARY', l_out_data_index, p_out_data);
1759: end sendNlsMessages;
1760:
1753: addMessages('MSC_EC_SAVE_SETTINGS', l_out_data_index, p_out_data);
1754:
1755: l_one_record := 'ICX_DATE_FORMAT_MASK'|| c_field_seperator
1756: || msc_sda_utils.escapeSplChars(nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'), 'MM/DD/YYYY'));
1757: msc_sda_utils.addRecordToOutStream(l_one_record, l_out_data_index, p_out_data);
1758: addMessages('MSC_NOTE_SUMMARY', l_out_data_index, p_out_data);
1759: end sendNlsMessages;
1760:
1761: procedure set_shuttle_from_to(p_lookup_type varchar2, p_lookup_code_list varchar2,
1788: open theCursor for l_sql_stmt using p_lookup_type;
1789: loop
1790: fetch theCursor into l_lookup_code, l_meaning;
1791: exit when theCursor%notfound;
1792: l_token := l_lookup_code || c_field_seperator || msc_sda_utils.escapeSplChars(l_meaning);
1793: if (l_one_record is null) then
1794: l_one_record := SET_FROM_LIST || c_bang_separator || l_token;
1795: else
1796: l_one_record := l_one_record || c_record_seperator || l_token;
1808: open theCursor for l_sql_stmt using p_lookup_type;
1809: loop
1810: fetch theCursor into l_lookup_code, l_meaning;
1811: exit when theCursor%notfound;
1812: l_token := l_lookup_code || c_field_seperator || msc_sda_utils.escapeSplChars(l_meaning);
1813: if (l_one_record is null) then
1814: l_one_record := SET_TO_LIST || c_bang_separator || l_token;
1815: else
1816: l_one_record := l_one_record || c_record_seperator || l_token;
2084: p_flag := 1;
2085: end if;
2086: end attachment_flag;
2087:
2088: end MSC_SDA_UTILS;