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 2005: || field_seperator || fnd_number.number_to_canonical(nvl(p_segment_quantity(b),0))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

9792: for c_alloc_qty_cur in c_alloc_qty (p_plan_id, p_trx, l_mfq_query_id, p_query_id)
9793: loop
9794: if (l_parent_link_rec is null) then
9795: l_parent_link_rec := c_alloc_qty_cur.row_index
9796: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(c_alloc_qty_cur.allocated_quantity)), null_space);
9797: else
9798: l_parent_link_rec := l_parent_link_rec|| FIELD_SEPERATOR ||
9799: c_alloc_qty_cur.row_index
9800: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(c_alloc_qty_cur.allocated_quantity)), null_space);

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

9796: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(c_alloc_qty_cur.allocated_quantity)), null_space);
9797: else
9798: l_parent_link_rec := l_parent_link_rec|| FIELD_SEPERATOR ||
9799: c_alloc_qty_cur.row_index
9800: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(c_alloc_qty_cur.allocated_quantity)), null_space);
9801: end if;
9802: l_row_count := l_row_count + 1;
9803: end loop;
9804: l_parent_link_rec := l_row_count || FIELD_SEPERATOR || l_parent_link_rec;

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

10047: || FIELD_SEPERATOR || nvl(escapeSplChars(l_customer_site(i)), null_space)
10048: || FIELD_SEPERATOR || nvl(to_char(l_start_date(i),format_mask), null_space)
10049: || FIELD_SEPERATOR || nvl(to_char(l_end_date(i),format_mask), null_space)
10050: || FIELD_SEPERATOR || nvl(to_char(l_priority(i)),null_space)
10051: || FIELD_SEPERATOR || to_char(round(nvl(fnd_number.number_to_canonical(l_qty(i)),0), round_factor))
10052: || FIELD_SEPERATOR || nvl(escapeSplChars(l_item_desc(i)),null_space)
10053: || FIELD_SEPERATOR || nvl(escapeSplChars(l_category_name(i)),null_space)
10054: || FIELD_SEPERATOR || nvl(escapeSplChars(l_prod_family(i)),null_space)
10055: || FIELD_SEPERATOR || nvl(escapeSplChars(l_planner_code(i)),null_space)

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

10209: || FIELD_SEPERATOR || escapeSplChars(l_org_code(i))
10210: || FIELD_SEPERATOR || l_order_type(i)
10211: || FIELD_SEPERATOR || escapeSplChars(l_order_type_text(i))
10212: || FIELD_SEPERATOR || nvl(escapeSplChars(l_order_number(i)), null_space)
10213: || FIELD_SEPERATOR || to_char(round(nvl(fnd_number.number_to_canonical(l_qty(i)),0), round_factor))
10214: || FIELD_SEPERATOR || nvl(to_char(l_cepst(i),format_mask),null_space)
10215: || FIELD_SEPERATOR || nvl(to_char(l_cepct(i),format_mask),null_space)
10216: || FIELD_SEPERATOR || nvl(to_char(l_ulpst(i),format_mask),null_space)
10217: || FIELD_SEPERATOR || nvl(to_char(l_ulpct(i),format_mask),null_space)

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

10429: || FIELD_SEPERATOR || escapeSplChars(l_dept_code(i))
10430: || FIELD_SEPERATOR || escapeSplChars(l_res_code(i))
10431: || FIELD_SEPERATOR || nvl(to_char(l_start_date(i), format_mask), null_space)
10432: || FIELD_SEPERATOR || nvl(to_char(l_end_date(i), format_mask), null_space)
10433: || FIELD_SEPERATOR || nvl(to_char(round(nvl(fnd_number.number_to_canonical(l_qty(i)),0),round_factor)), null_space)
10434: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(l_adjusted_res_hours(i))), null_space)
10435: || FIELD_SEPERATOR || nvl(to_char(l_batch_number(i)), null_space)
10436: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(l_assigned_units(i))), null_space)
10437: || FIELD_SEPERATOR || nvl(escapeSplChars(to_char(l_alternate_flag(i))), null_space)

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

10430: || FIELD_SEPERATOR || escapeSplChars(l_res_code(i))
10431: || FIELD_SEPERATOR || nvl(to_char(l_start_date(i), format_mask), null_space)
10432: || FIELD_SEPERATOR || nvl(to_char(l_end_date(i), format_mask), null_space)
10433: || FIELD_SEPERATOR || nvl(to_char(round(nvl(fnd_number.number_to_canonical(l_qty(i)),0),round_factor)), null_space)
10434: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(l_adjusted_res_hours(i))), null_space)
10435: || FIELD_SEPERATOR || nvl(to_char(l_batch_number(i)), null_space)
10436: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(l_assigned_units(i))), null_space)
10437: || FIELD_SEPERATOR || nvl(escapeSplChars(to_char(l_alternate_flag(i))), null_space)
10438: || FIELD_SEPERATOR || nvl(escapeSplChars(l_wip_status_text(i)), null_space)

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

10432: || FIELD_SEPERATOR || nvl(to_char(l_end_date(i), format_mask), null_space)
10433: || FIELD_SEPERATOR || nvl(to_char(round(nvl(fnd_number.number_to_canonical(l_qty(i)),0),round_factor)), null_space)
10434: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(l_adjusted_res_hours(i))), null_space)
10435: || FIELD_SEPERATOR || nvl(to_char(l_batch_number(i)), null_space)
10436: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(l_assigned_units(i))), null_space)
10437: || FIELD_SEPERATOR || nvl(escapeSplChars(to_char(l_alternate_flag(i))), null_space)
10438: || FIELD_SEPERATOR || nvl(escapeSplChars(l_wip_status_text(i)), null_space)
10439: || FIELD_SEPERATOR || l_supply_firm_type(i)
10440: || FIELD_SEPERATOR || l_res_firm_type(i)

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

10462: || FIELD_SEPERATOR || nvl(escapeSplChars(to_char(l_op_seq(i))), null_space)
10463: || FIELD_SEPERATOR || nvl(escapeSplChars(l_res_desc(i)), null_space)
10464: || FIELD_SEPERATOR || nvl(escapeSplChars(l_item_name(i)), null_space)
10465: || FIELD_SEPERATOR || nvl(escapeSplChars(l_assy_item_desc(i)), null_space)
10466: || FIELD_SEPERATOR || nvl(to_char(fnd_number.number_to_canonical(l_schedule_qty(i))), null_space)
10467: || FIELD_SEPERATOR || null_space
10468: || FIELD_SEPERATOR || null_space
10469: || FIELD_SEPERATOR || null_space
10470: || FIELD_SEPERATOR || null_space