eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_GANTT_UTILS dependencies on FND_NUMBER

Line 2006: || field_seperator || fnd_number.number_to_canonical(nvl(p_segment_quantity(b),0))

2002: || field_seperator || nvl(to_char(p_consumer_op_seq_num(b)), null_space)
2003: || field_seperator || nvl(to_char(p_consumer_res_seq_num(b)), null_space)
2004: || field_seperator || nvl(to_char(p_segment_start_date(b),format_mask), null_space)
2005: || field_seperator || nvl(to_char(p_segment_end_date(b), format_mask), null_space)
2006: || field_seperator || fnd_number.number_to_canonical(nvl(p_segment_quantity(b),0))
2007: || field_seperator || nvl(to_char(p_consumer_start_date(b), format_mask), null_space)
2008: || field_seperator || nvl(to_char(p_consumer_end_date(b), format_mask), null_space)
2009: || field_seperator || nvl(to_char(p_allocation_type(b)), null_space)
2010: || field_seperator || nvl(to_char(p_dependency_type(b)), null_space)

Line 2087: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_hours(b))), null_space) ||

2083: for b in 1 .. p_start.count loop -- {
2084: if ( p_row_type = RES_REQ_ROW_TYPE ) then
2085: v_one_record := to_char(p_start(b),format_mask) ||
2086: field_seperator || to_char(p_end(b),format_mask) ||
2087: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_hours(b))), null_space) ||
2088: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_units(b))), null_space) ||
2089: field_seperator || nvl(to_char(p_schedule_flag(b)), null_space) ||
2090: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_avail_qty(b))), null_space);
2091: elsif ( p_row_type = SUPP_ALL_ROW_TYPE ) then

Line 2088: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_units(b))), null_space) ||

2084: if ( p_row_type = RES_REQ_ROW_TYPE ) then
2085: v_one_record := to_char(p_start(b),format_mask) ||
2086: field_seperator || to_char(p_end(b),format_mask) ||
2087: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_hours(b))), null_space) ||
2088: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_units(b))), null_space) ||
2089: field_seperator || nvl(to_char(p_schedule_flag(b)), null_space) ||
2090: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_avail_qty(b))), null_space);
2091: elsif ( p_row_type = SUPP_ALL_ROW_TYPE ) then
2092: v_one_record := to_char(p_start(b),format_mask) ||

Line 2090: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_avail_qty(b))), null_space);

2086: field_seperator || to_char(p_end(b),format_mask) ||
2087: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_hours(b))), null_space) ||
2088: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_units(b))), null_space) ||
2089: field_seperator || nvl(to_char(p_schedule_flag(b)), null_space) ||
2090: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_avail_qty(b))), null_space);
2091: elsif ( p_row_type = SUPP_ALL_ROW_TYPE ) then
2092: v_one_record := to_char(p_start(b),format_mask) ||
2093: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_consume_qty(b))), null_space)||
2094: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_overload_qty(b))), null_space)||

Line 2093: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_consume_qty(b))), null_space)||

2089: field_seperator || nvl(to_char(p_schedule_flag(b)), null_space) ||
2090: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_avail_qty(b))), null_space);
2091: elsif ( p_row_type = SUPP_ALL_ROW_TYPE ) then
2092: v_one_record := to_char(p_start(b),format_mask) ||
2093: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_consume_qty(b))), null_space)||
2094: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_overload_qty(b))), null_space)||
2095: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_avail_qty(b))), null_space);
2096: elsif ( p_row_type in (RES_CHARGES_ROW_TYPE, RES_AVAIL_ROW_TYPE) ) then
2097: v_one_record := to_char(p_start(b),format_mask) ||

Line 2094: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_overload_qty(b))), null_space)||

2090: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_avail_qty(b))), null_space);
2091: elsif ( p_row_type = SUPP_ALL_ROW_TYPE ) then
2092: v_one_record := to_char(p_start(b),format_mask) ||
2093: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_consume_qty(b))), null_space)||
2094: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_overload_qty(b))), null_space)||
2095: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_avail_qty(b))), null_space);
2096: elsif ( p_row_type in (RES_CHARGES_ROW_TYPE, RES_AVAIL_ROW_TYPE) ) then
2097: v_one_record := to_char(p_start(b),format_mask) ||
2098: field_seperator || to_char(p_end(b),format_mask) ||

Line 2095: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_avail_qty(b))), null_space);

2091: elsif ( p_row_type = SUPP_ALL_ROW_TYPE ) then
2092: v_one_record := to_char(p_start(b),format_mask) ||
2093: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_consume_qty(b))), null_space)||
2094: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_overload_qty(b))), null_space)||
2095: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_avail_qty(b))), null_space);
2096: elsif ( p_row_type in (RES_CHARGES_ROW_TYPE, RES_AVAIL_ROW_TYPE) ) then
2097: v_one_record := to_char(p_start(b),format_mask) ||
2098: field_seperator || to_char(p_end(b),format_mask) ||
2099: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_hours(b))), null_space)||

Line 2099: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_hours(b))), null_space)||

2095: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_avail_qty(b))), null_space);
2096: elsif ( p_row_type in (RES_CHARGES_ROW_TYPE, RES_AVAIL_ROW_TYPE) ) then
2097: v_one_record := to_char(p_start(b),format_mask) ||
2098: field_seperator || to_char(p_end(b),format_mask) ||
2099: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_hours(b))), null_space)||
2100: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_units(b))), null_space);
2101: elsif ( p_row_type = RES_REQ_DISPLAY_ROW_TYPE ) then
2102: v_one_record := to_char(p_start(b),format_mask) ||
2103: field_seperator || nvl(to_char(p_schedule_flag(b)), null_space)||

Line 2100: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_units(b))), null_space);

2096: elsif ( p_row_type in (RES_CHARGES_ROW_TYPE, RES_AVAIL_ROW_TYPE) ) then
2097: v_one_record := to_char(p_start(b),format_mask) ||
2098: field_seperator || to_char(p_end(b),format_mask) ||
2099: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_hours(b))), null_space)||
2100: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_units(b))), null_space);
2101: elsif ( p_row_type = RES_REQ_DISPLAY_ROW_TYPE ) then
2102: v_one_record := to_char(p_start(b),format_mask) ||
2103: field_seperator || nvl(to_char(p_schedule_flag(b)), null_space)||
2104: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_avail_qty(b))), null_space)||

Line 2104: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_avail_qty(b))), null_space)||

2100: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_units(b))), null_space);
2101: elsif ( p_row_type = RES_REQ_DISPLAY_ROW_TYPE ) then
2102: v_one_record := to_char(p_start(b),format_mask) ||
2103: field_seperator || nvl(to_char(p_schedule_flag(b)), null_space)||
2104: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_avail_qty(b))), null_space)||
2105: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_hours(b))), null_space);
2106: end if;
2107:
2108: v_max_len := nvl(length(oneBigRecord(j)),0) + nvl(length(v_one_record),0);

Line 2105: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_hours(b))), null_space);

2101: elsif ( p_row_type = RES_REQ_DISPLAY_ROW_TYPE ) then
2102: v_one_record := to_char(p_start(b),format_mask) ||
2103: field_seperator || nvl(to_char(p_schedule_flag(b)), null_space)||
2104: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_avail_qty(b))), null_space)||
2105: field_seperator || nvl(to_char(fnd_number.number_to_canonical(p_resource_hours(b))), null_space);
2106: end if;
2107:
2108: v_max_len := nvl(length(oneBigRecord(j)),0) + nvl(length(v_one_record),0);
2109: if v_max_len > 30000 then

Line 2198: || FIELD_SEPERATOR || fnd_number.number_to_canonical(p_qty(b)) || FIELD_SEPERATOR || null_space

2194: || FIELD_SEPERATOR || null_space
2195: || FIELD_SEPERATOR || null_space || FIELD_SEPERATOR || null_space
2196: || FIELD_SEPERATOR || to_char(p_start_date(b), format_mask)
2197: || FIELD_SEPERATOR || to_char(p_end_date(b), format_mask)
2198: || FIELD_SEPERATOR || fnd_number.number_to_canonical(p_qty(b)) || FIELD_SEPERATOR || null_space
2199: || FIELD_SEPERATOR || p_batch_number(b) || FIELD_SEPERATOR || fnd_number.number_to_canonical(p_resource_units(b))
2200: || FIELD_SEPERATOR || null_space || FIELD_SEPERATOR || null_space
2201: || FIELD_SEPERATOR || p_sup_firm_flag(b) || FIELD_SEPERATOR || p_res_firm_flag(b)
2202: || FIELD_SEPERATOR || p_status(b) || FIELD_SEPERATOR || p_applied(b)

Line 2199: || FIELD_SEPERATOR || p_batch_number(b) || FIELD_SEPERATOR || fnd_number.number_to_canonical(p_resource_units(b))

2195: || FIELD_SEPERATOR || null_space || FIELD_SEPERATOR || null_space
2196: || FIELD_SEPERATOR || to_char(p_start_date(b), format_mask)
2197: || FIELD_SEPERATOR || to_char(p_end_date(b), format_mask)
2198: || FIELD_SEPERATOR || fnd_number.number_to_canonical(p_qty(b)) || FIELD_SEPERATOR || null_space
2199: || FIELD_SEPERATOR || p_batch_number(b) || FIELD_SEPERATOR || fnd_number.number_to_canonical(p_resource_units(b))
2200: || FIELD_SEPERATOR || null_space || FIELD_SEPERATOR || null_space
2201: || FIELD_SEPERATOR || p_sup_firm_flag(b) || FIELD_SEPERATOR || p_res_firm_flag(b)
2202: || FIELD_SEPERATOR || p_status(b) || FIELD_SEPERATOR || p_applied(b)
2203: || FIELD_SEPERATOR || p_schedule_flag(b) || FIELD_SEPERATOR || p_supply_id(b)

Line 2224: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(p_schedule_qty(b))), null_space)

2220: || FIELD_SEPERATOR || nvl(to_char(p_op_seq(b)), null_space)
2221: || FIELD_SEPERATOR || nvl(escapeSplChars(p_res_desc(b)), null_space)
2222: || FIELD_SEPERATOR || nvl(escapeSplChars(p_item_name(b)), null_space)
2223: || FIELD_SEPERATOR || nvl(escapeSplChars(p_assy_item_desc(b)), null_space)
2224: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(p_schedule_qty(b))), null_space)
2225: || FIELD_SEPERATOR || nvl(escapeSplChars(p_from_setup_code(b)), null_space)
2226: || FIELD_SEPERATOR || nvl(escapeSplChars(p_to_setup_code(b)), null_space)
2227: || FIELD_SEPERATOR || nvl(escapeSplChars(p_std_op_code(b)), null_space)
2228: || FIELD_SEPERATOR || nvl(to_char(p_changeover_time(b)), null_space)

Line 2230: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(p_min_capacity(b))), null_space)

2226: || FIELD_SEPERATOR || nvl(escapeSplChars(p_to_setup_code(b)), null_space)
2227: || FIELD_SEPERATOR || nvl(escapeSplChars(p_std_op_code(b)), null_space)
2228: || FIELD_SEPERATOR || nvl(to_char(p_changeover_time(b)), null_space)
2229: || FIELD_SEPERATOR || nvl(to_char(p_changeover_penalty(b)), null_space)
2230: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(p_min_capacity(b))), null_space)
2231: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(p_max_capacity(b))), null_space)
2232: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(p_capacity_used(b))), null_space)
2233: || FIELD_SEPERATOR || nvl(to_char(p_group_sequence_id(b)), null_space)
2234: || FIELD_SEPERATOR || nvl(to_char(p_group_sequence_number(b)), null_space)

Line 2231: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(p_max_capacity(b))), null_space)

2227: || FIELD_SEPERATOR || nvl(escapeSplChars(p_std_op_code(b)), null_space)
2228: || FIELD_SEPERATOR || nvl(to_char(p_changeover_time(b)), null_space)
2229: || FIELD_SEPERATOR || nvl(to_char(p_changeover_penalty(b)), null_space)
2230: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(p_min_capacity(b))), null_space)
2231: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(p_max_capacity(b))), null_space)
2232: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(p_capacity_used(b))), null_space)
2233: || FIELD_SEPERATOR || nvl(to_char(p_group_sequence_id(b)), null_space)
2234: || FIELD_SEPERATOR || nvl(to_char(p_group_sequence_number(b)), null_space)
2235: || FIELD_SEPERATOR || nvl(to_char(p_overload_flag(b)), null_space)

Line 2232: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(p_capacity_used(b))), null_space)

2228: || FIELD_SEPERATOR || nvl(to_char(p_changeover_time(b)), null_space)
2229: || FIELD_SEPERATOR || nvl(to_char(p_changeover_penalty(b)), null_space)
2230: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(p_min_capacity(b))), null_space)
2231: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(p_max_capacity(b))), null_space)
2232: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(p_capacity_used(b))), null_space)
2233: || FIELD_SEPERATOR || nvl(to_char(p_group_sequence_id(b)), null_space)
2234: || FIELD_SEPERATOR || nvl(to_char(p_group_sequence_number(b)), null_space)
2235: || FIELD_SEPERATOR || nvl(to_char(p_overload_flag(b)), null_space)
2236: || FIELD_SEPERATOR || null_space

Line 9801: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(c_alloc_qty_cur.allocated_quantity)), null_space);

9797: for c_alloc_qty_cur in c_alloc_qty (p_plan_id, p_trx, l_mfq_query_id, p_query_id)
9798: loop
9799: if (l_parent_link_rec is null) then
9800: l_parent_link_rec := c_alloc_qty_cur.row_index
9801: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(c_alloc_qty_cur.allocated_quantity)), null_space);
9802: else
9803: l_parent_link_rec := l_parent_link_rec|| FIELD_SEPERATOR ||
9804: c_alloc_qty_cur.row_index
9805: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(c_alloc_qty_cur.allocated_quantity)), null_space);

Line 9805: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(c_alloc_qty_cur.allocated_quantity)), null_space);

9801: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(c_alloc_qty_cur.allocated_quantity)), null_space);
9802: else
9803: l_parent_link_rec := l_parent_link_rec|| FIELD_SEPERATOR ||
9804: c_alloc_qty_cur.row_index
9805: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(c_alloc_qty_cur.allocated_quantity)), null_space);
9806: end if;
9807: l_row_count := l_row_count + 1;
9808: end loop;
9809: l_parent_link_rec := l_row_count || FIELD_SEPERATOR || l_parent_link_rec;

Line 10056: || FIELD_SEPERATOR || to_char(round(nvl(fnd_number.number_to_canonical(l_qty(i)),0), round_factor))

10052: || FIELD_SEPERATOR || nvl(escapeSplChars(l_customer_site(i)), null_space)
10053: || FIELD_SEPERATOR || nvl(to_char(l_start_date(i),format_mask), null_space)
10054: || FIELD_SEPERATOR || nvl(to_char(l_end_date(i),format_mask), null_space)
10055: || FIELD_SEPERATOR || nvl(to_char(l_priority(i)),null_space)
10056: || FIELD_SEPERATOR || to_char(round(nvl(fnd_number.number_to_canonical(l_qty(i)),0), round_factor))
10057: || FIELD_SEPERATOR || nvl(escapeSplChars(l_item_desc(i)),null_space)
10058: || FIELD_SEPERATOR || nvl(escapeSplChars(l_category_name(i)),null_space)
10059: || FIELD_SEPERATOR || nvl(escapeSplChars(l_prod_family(i)),null_space)
10060: || FIELD_SEPERATOR || nvl(escapeSplChars(l_planner_code(i)),null_space)

Line 10218: || FIELD_SEPERATOR || to_char(round(nvl(fnd_number.number_to_canonical(l_qty(i)),0), round_factor))

10214: || FIELD_SEPERATOR || escapeSplChars(l_org_code(i))
10215: || FIELD_SEPERATOR || l_order_type(i)
10216: || FIELD_SEPERATOR || escapeSplChars(l_order_type_text(i))
10217: || FIELD_SEPERATOR || nvl(escapeSplChars(l_order_number(i)), null_space)
10218: || FIELD_SEPERATOR || to_char(round(nvl(fnd_number.number_to_canonical(l_qty(i)),0), round_factor))
10219: || FIELD_SEPERATOR || nvl(to_char(l_cepst(i),format_mask),null_space)
10220: || FIELD_SEPERATOR || nvl(to_char(l_cepct(i),format_mask),null_space)
10221: || FIELD_SEPERATOR || nvl(to_char(l_ulpst(i),format_mask),null_space)
10222: || FIELD_SEPERATOR || nvl(to_char(l_ulpct(i),format_mask),null_space)

Line 10438: || FIELD_SEPERATOR || nvl(to_char(round(nvl(fnd_number.number_to_canonical(l_qty(i)),0),round_factor)), null_space)

10434: || FIELD_SEPERATOR || nvl(escapeSplChars(l_dept_code(i)) , null_space)
10435: || FIELD_SEPERATOR || nvl(escapeSplChars(l_res_code(i)), null_space)
10436: || FIELD_SEPERATOR || nvl(to_char(l_start_date(i), format_mask), null_space)
10437: || FIELD_SEPERATOR || nvl(to_char(l_end_date(i), format_mask), null_space)
10438: || FIELD_SEPERATOR || nvl(to_char(round(nvl(fnd_number.number_to_canonical(l_qty(i)),0),round_factor)), null_space)
10439: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(l_adjusted_res_hours(i))), null_space)
10440: || FIELD_SEPERATOR || nvl(to_char(l_batch_number(i)), null_space)
10441: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(l_assigned_units(i))), null_space)
10442: || FIELD_SEPERATOR || nvl(escapeSplChars(to_char(l_alternate_flag(i))), null_space)

Line 10439: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(l_adjusted_res_hours(i))), null_space)

10435: || FIELD_SEPERATOR || nvl(escapeSplChars(l_res_code(i)), null_space)
10436: || FIELD_SEPERATOR || nvl(to_char(l_start_date(i), format_mask), null_space)
10437: || FIELD_SEPERATOR || nvl(to_char(l_end_date(i), format_mask), null_space)
10438: || FIELD_SEPERATOR || nvl(to_char(round(nvl(fnd_number.number_to_canonical(l_qty(i)),0),round_factor)), null_space)
10439: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(l_adjusted_res_hours(i))), null_space)
10440: || FIELD_SEPERATOR || nvl(to_char(l_batch_number(i)), null_space)
10441: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(l_assigned_units(i))), null_space)
10442: || FIELD_SEPERATOR || nvl(escapeSplChars(to_char(l_alternate_flag(i))), null_space)
10443: || FIELD_SEPERATOR || nvl(escapeSplChars(l_wip_status_text(i)), null_space)

Line 10441: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(l_assigned_units(i))), null_space)

10437: || FIELD_SEPERATOR || nvl(to_char(l_end_date(i), format_mask), null_space)
10438: || FIELD_SEPERATOR || nvl(to_char(round(nvl(fnd_number.number_to_canonical(l_qty(i)),0),round_factor)), null_space)
10439: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(l_adjusted_res_hours(i))), null_space)
10440: || FIELD_SEPERATOR || nvl(to_char(l_batch_number(i)), null_space)
10441: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(l_assigned_units(i))), null_space)
10442: || FIELD_SEPERATOR || nvl(escapeSplChars(to_char(l_alternate_flag(i))), null_space)
10443: || FIELD_SEPERATOR || nvl(escapeSplChars(l_wip_status_text(i)), null_space)
10444: || FIELD_SEPERATOR || l_supply_firm_type(i)
10445: || FIELD_SEPERATOR || l_res_firm_type(i)

Line 10471: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(l_schedule_qty(i))), null_space)

10467: || FIELD_SEPERATOR || nvl(escapeSplChars(to_char(l_op_seq(i))), null_space)
10468: || FIELD_SEPERATOR || nvl(escapeSplChars(l_res_desc(i)), null_space)
10469: || FIELD_SEPERATOR || nvl(escapeSplChars(l_item_name(i)), null_space)
10470: || FIELD_SEPERATOR || nvl(escapeSplChars(l_assy_item_desc(i)), null_space)
10471: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(l_schedule_qty(i))), null_space)
10472: || FIELD_SEPERATOR || null_space
10473: || FIELD_SEPERATOR || null_space
10474: || FIELD_SEPERATOR || null_space
10475: || FIELD_SEPERATOR || null_space