The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT count(*) INTO l_lpn_count
FROM wsh_delivery_assignments_v
WHERE delivery_id = p_delivery_id
AND parent_delivery_detail_id is null;
SELECT 'Y'
FROM mtl_material_transactions mmt ,
mtl_material_transactions_temp mmtt,
wsh_delivery_assignments wda,
wsh_delivery_details wdd
WHERE mmtt.transaction_temp_id = p_transaction_id
AND wda.delivery_id = p_delivery_id
AND mmt.organization_id = mmtt.organization_id
AND mmt.transaction_source_type_id IN (INV_GLOBALS.G_SOURCETYPE_SALESORDER,INV_GLOBALS.G_SOURCETYPE_INTORDER)
AND mmt.transaction_action_id = INV_GLOBALS.G_ACTION_STGXFR
AND mmtt.transfer_lpn_id = mmt.transfer_lpn_id
AND mmt.move_order_line_id = wdd.move_order_line_id
AND wda.delivery_detail_id = wdd.delivery_detail_id
AND ROWNUM<2;
SELECT wda.delivery_id, wdd.organization_id, wdd.subinventory
FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
, wsh_delivery_details wdd
WHERE wda.delivery_detail_id = p_transaction_id
AND wnd.delivery_id = wda.delivery_id
AND wdd.delivery_detail_id(+) = wda.delivery_detail_id;
SELECT wda.delivery_id, mmtt.organization_id, mmtt.subinventory_code
FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd,
wsh_delivery_details wdd, mtl_material_transactions_temp mmtt
WHERE mmtt.move_order_line_id = wdd.move_order_line_id
AND wda.delivery_detail_id = wdd.delivery_detail_id
AND wnd.delivery_id = wda.delivery_id
AND mmtt.transaction_temp_id = p_transaction_id;
SELECT DISTINCT(wda.delivery_id)
FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd,
wsh_delivery_details wdd, mtl_material_transactions_temp mmtt
--wms_packaging_hist wph
WHERE mmtt.move_order_line_id = wdd.move_order_line_id (+)
AND wda.delivery_detail_id (+) = wdd.delivery_detail_id
AND wnd.delivery_id (+) = wda.delivery_id
AND mmtt.cartonization_id = p_transaction_id; -- Bug 2374644
SELECT move_order_line_id
FROM mtl_material_transactions_temp mmtt
WHERE mmtt.transaction_temp_id = p_transaction_id;
SELECT delivery_detail_id
FROM wsh_delivery_details wdd
WHERE wdd.move_order_line_id = l_move_order_line_id;
SELECT delivery_id
FROM wsh_delivery_assignments_v wda
WHERE wda.delivery_detail_id = l_delivery_detail_id;*/
SELECT wda.delivery_id, mmtt.organization_id, mmtt.transfer_subinventory
FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
, mtl_material_transactions_temp mmtt
WHERE wda.delivery_detail_id = wdd.delivery_detail_id
AND wdd.move_order_line_id = mmtt.move_order_line_id
AND mmtt.transaction_temp_id = p_transaction_id;
SELECT wda.delivery_id
FROM wsh_delivery_assignments_v wda
,wsh_delivery_details wdd
WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
AND wda.delivery_id IS NOT NULL
AND wdd.lpn_id IS NOT NULL
AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
AND exists(
select lpn_id from wms_license_plate_numbers
where lpn_id = wdd.lpn_id
and outermost_lpn_id = p_lpn_id)
AND rownum<2;
/* Patchset J- Select attribute1..attribute15, tp_attribute1..tp_attribute15
*, global_attribute1..global_attribute15, attribute_category,
* tp_attribute_category, global_attribute_category from wsh_new_deliveries
*/
CURSOR c_delivery(p_delivery_id NUMBER) IS
SELECT wnd.delivery_id delivery_number
-- Added by joabraha for Bug 3549300
, nvl(wnd.customer_id,addr.customer_id) customer_id -- Modified for Bug# 14784146
, wnd.organization_id organization_id
--
/*Bug 3969347 -Added two columns ship_from_addressee
and ship_to_addressee to obtain data
for these label fields.*/
, hro.name ship_from_addressee
-- , rac.customer_name ship_to_addressee Commented for Bug#4445708
--End of fix for Bug 3969347
, addr.addressee ship_to_addressee --Added for fix of Bug#4445708
, rac.customer_name customer_name
, rac.customer_name customer
, hrl.address_line_1 ship_from_address1
, hrl.address_line_2 ship_from_address2
, hrl.address_line_3 ship_from_address3
, hrl.address_line_4 ship_from_address4
, hrl.city ship_from_city
, hrl.postal_code ship_from_postal_code
, hrl.state ship_from_state
, hrl.county ship_from_county
, hrl.country ship_from_country
, hrl.province ship_from_province
, hrl1.address_line_1 ship_to_address1
, hrl1.address_line_2 ship_to_address2
, hrl1.address_line_3 ship_to_address3
, hrl1.address_line_4 ship_to_address4
, hrl1.city ship_to_city
, hrl1.postal_code ship_to_postal_code
, hrl1.state ship_to_state
, hrl1.county ship_to_county
, hrl1.country ship_to_country
, hrl1.province ship_to_province
-- Bug 2878652, get carrier name from wsh_carriers_v
-- Bug 5121507, Get carrier in order of Trip->Delivery
-- Get carrier_id first, then query carrier_name later
--, wcv.carrier_name carrier
, nvl(wt.carrier_id, wnd.carrier_id) carrier_id
, null carrier
, wnd.waybill waybill
, wnd.waybill airbill
, wdi.sequence_number bill_of_lading
-- Bug 2878652, get ship_method_name with ship_method_code
, fcl.meaning ship_method
, wnd.gross_weight shipment_gross_weight
, wnd.weight_uom_code shipment_gross_weight_uom
, (wnd.gross_weight - wnd.net_weight) shipment_tare_weight
, wnd.weight_uom_code shipment_tare_weight_uom
, wnd.volume shipment_volume
, wnd.volume_uom_code shipment_volume_uom
, get_total_number_of_lpns(wnd.delivery_id) total_number_of_lpns
, wnd.attribute_category new_del_attribute_category
, wnd.attribute1 new_del_attribute1
, wnd.attribute2 new_del_attribute2
, wnd.attribute3 new_del_attribute3
, wnd.attribute4 new_del_attribute4
, wnd.attribute5 new_del_attribute5
, wnd.attribute6 new_del_attribute6
, wnd.attribute7 new_del_attribute7
, wnd.attribute8 new_del_attribute8
, wnd.attribute9 new_del_attribute9
, wnd.attribute10 new_del_attribute10
, wnd.attribute11 new_del_attribute11
, wnd.attribute12 new_del_attribute12
, wnd.attribute13 new_del_attribute13
, wnd.attribute14 new_del_attribute14
, wnd.attribute15 new_del_attribute15
, wnd.tp_attribute_category new_del_tp_attr_category
, wnd.tp_attribute1 new_del_tp_attr1
, wnd.tp_attribute2 new_del_tp_attr2
, wnd.tp_attribute3 new_del_tp_attr3
, wnd.tp_attribute4 new_del_tp_attr4
, wnd.tp_attribute5 new_del_tp_attr5
, wnd.tp_attribute6 new_del_tp_attr6
, wnd.tp_attribute7 new_del_tp_attr7
, wnd.tp_attribute8 new_del_tp_attr8
, wnd.tp_attribute9 new_del_tp_attr9
, wnd.tp_attribute10 new_del_tp_attr10
, wnd.tp_attribute11 new_del_tp_attr11
, wnd.tp_attribute12 new_del_tp_attr12
, wnd.tp_attribute13 new_del_tp_attr13
, wnd.tp_attribute14 new_del_tp_attr14
, wnd.tp_attribute15 new_del_tp_attr15
, wnd.global_attribute_category new_del_global_attr_category
, wnd.global_attribute1 new_del_global_attr1
, wnd.global_attribute2 new_del_global_attr2
, wnd.global_attribute3 new_del_global_attr3
, wnd.global_attribute4 new_del_global_attr4
, wnd.global_attribute5 new_del_global_attr5
, wnd.global_attribute6 new_del_global_attr6
, wnd.global_attribute7 new_del_global_attr7
, wnd.global_attribute8 new_del_global_attr8
, wnd.global_attribute9 new_del_global_attr9
, wnd.global_attribute10 new_del_global_attr10
, wnd.global_attribute11 new_del_global_attr11
, wnd.global_attribute12 new_del_global_attr12
, wnd.global_attribute13 new_del_global_attr13
, wnd.global_attribute14 new_del_global_attr14
, wnd.global_attribute15 new_del_global_attr15
FROM
--
-- Modification Start for Bug # - 4418524
--
-- As part of TCA related changes ra_customers, ra_contacts views are
-- obsoleted in R12. The columns fetched from these views are fetched
-- from hz_parties and hz_cust_accounts.
--
-- Following table alias are commented
-- ra_customers rac
--
-- Following Queries are added to replace the above commented
-- views
--
( SELECT CUST_ACCT.cust_account_id customer_id,
SUBSTRB(PARTY.party_name,1,50) customer_name
FROM hz_parties PARTY
, hz_cust_accounts CUST_ACCT
WHERE CUST_ACCT.party_id = PARTY.party_id
) rac,
--
-- Modification End for Bug # - 4418524
--
(select loc.location_id location_id,loc.address_line_1 address_line_1
,loc.address_line_2 address_line_2,loc.address_line_3 address_line_3
,loc.loc_information13 address_line_4,loc.town_or_city city
,loc.postal_code postal_code,loc.region_2 state,loc.region_1 county
,loc.country country, DECODE(LOC.STYLE,'CA',(SELECT MEANING
FROM FND_COMMON_LOOKUPS
WHERE LOOKUP_TYPE = 'CA_PROVINCE'
AND LOOKUP_CODE = LOC.REGION_1
AND ROWNUM < 2),
'CA_GLB',(SELECT MEANING
FROM FND_COMMON_LOOKUPS
WHERE LOOKUP_TYPE = 'CA_PROVINCE'
AND LOOKUP_CODE = LOC.REGION_1
AND ROWNUM < 2),
LOC.REGION_3) PROVINCE -- Modified for bug 7281160
from hr_locations_all loc
union all
select hz.location_id location_id,hz.address1 address_line_1
,hz.address2 address_line_2,hz.address3 address_line_3
,hz.address4 address_line_4,hz.city city,hz.postal_code postal_code
,hz.state state,hz.county county,hz.country country,hz.province province
from hz_locations hz ) hrl,
--Bug 3969347 -Adding the table hr_organization_units
hr_organization_units hro,
--End of fix for Bug 3969347.
(select loc.location_id location_id,loc.address_line_1 address_line_1
,loc.address_line_2 address_line_2,loc.address_line_3 address_line_3
,loc.loc_information13 address_line_4,loc.town_or_city city
,loc.postal_code postal_code,loc.region_2 state,loc.region_1 county
,loc.country country, DECODE(LOC.STYLE,'CA',(SELECT MEANING
FROM FND_COMMON_LOOKUPS
WHERE LOOKUP_TYPE = 'CA_PROVINCE'
AND LOOKUP_CODE = LOC.REGION_1
AND ROWNUM < 2),
'CA_GLB',(SELECT MEANING
FROM FND_COMMON_LOOKUPS
WHERE LOOKUP_TYPE = 'CA_PROVINCE'
AND LOOKUP_CODE = LOC.REGION_1
AND ROWNUM < 2),
LOC.REGION_3) PROVINCE -- Modified for bug 7281160
from hr_locations_all loc
union all
select hz.location_id location_id,hz.address1 address_line_1
,hz.address2 address_line_2,hz.address3 address_line_3
,hz.address4 address_line_4,hz.city city,hz.postal_code postal_code
,hz.state state,hz.county county,hz.country country,hz.province province
from hz_locations hz ) hrl1,
wsh_new_deliveries wnd,
wsh_delivery_legs wdl,
wsh_document_instances wdi
-- Bug 2878652, get carrier name and ship method name
, fnd_common_lookups fcl
-- Bug 5121507 Getting Carrier in the order of Trip->Delivery
--, wsh_carriers_v wcv
, wsh_trip_stops wts
, wsh_trips wt
--Added to fix the issue reported in the Bug#4445708
, ( select wda.delivery_id delivery_id, party_site.addressee addressee -- Added p_delivery_id 13108954
, wdd.customer_id customer_id
from wsh_delivery_details wdd
, wsh_delivery_assignments wda
, hz_cust_site_uses_all hcsua
, hz_party_sites party_site
, hz_loc_assignments loc_assign
, hz_locations loc
, hz_cust_acct_sites_all acct_site
where wdd.delivery_detail_id = wda.delivery_detail_id
and wda.delivery_id = p_delivery_id
and wdd.container_flag = 'N'
and hcsua.site_use_id = wdd.ship_to_site_use_id
and acct_site.cust_acct_site_id = hcsua.cust_acct_site_id
AND acct_site.party_site_id = party_site.party_site_id
AND loc.location_id = party_site.location_id
AND loc.location_id = loc_assign.location_id
AND NVL ( acct_site.org_id, -99 ) = NVL ( loc_assign.org_id, -99 )
and rownum = 1
) addr
WHERE wnd.delivery_id = p_delivery_id
AND rac.customer_id(+) = addr.customer_id -- wnd.customer_id Modified for Bug# 14784146
and addr.delivery_id(+) = wnd.delivery_id -- 13108954
AND hrl.location_id(+) = wnd.INITIAL_PICKUP_LOCATION_ID
AND hrl1.location_id(+) = wnd.ULTIMATE_DROPOFF_LOCATION_ID
AND wdl.delivery_id (+) = wnd.delivery_id
AND wdi.entity_id (+) = wdl.delivery_leg_id
AND wdi.entity_name (+) = 'WSH_DELIVERY_LEGS' -- Bug 3905110
--Bug 3969347 --Added this condition to join the table hr_organization_units.
AND hro.organization_id(+) = wnd.organization_id
--End of fix for Bug 3969347
AND wdi.document_type(+) = 'BOL'
AND fcl.lookup_type(+) = 'SHIP_METHOD'
AND fcl.lookup_code(+) = wnd.ship_method_code
--Bug 5121507 Getting Carrier in the order of Trip->Delivery
AND wnd.delivery_id = wdl.delivery_id(+)
AND wdl.pick_up_stop_id = wts.stop_id (+)
AND wts.trip_id = wt.trip_id (+);
l_selected_fields INV_LABEL.label_field_variable_tbl_type;
l_selected_fields_count NUMBER;
SELECT DISTINCT(source_header_id)
INTO l_sales_order_header_id
FROM wsh_delivery_details wdd,
wsh_delivery_assignments wda
WHERE wdd.delivery_detail_id = wda.delivery_detail_id
AND wda.delivery_id = l_delivery_id
AND wdd.container_flag = 'N' ;
trace(' Getting selected fields ');
x_variables => l_selected_fields
, x_variables_count => l_selected_fields_count
, p_format_id => p_label_type_info.default_format_id);
IF (l_selected_fields_count=0) OR (l_selected_fields.count =0 ) THEN
IF (l_debug = 1) THEN
trace('no fields defined for this format: ' || p_label_type_info.default_format_id || ',' ||p_label_type_info.default_format_name);
trace(' Found variable defined for this format, cont = ' || l_selected_fields_count);
SELECT carrier_name
INTO v_delivery.carrier
FROM wsh_carriers_v
WHERE carrier_id = v_delivery.carrier_id
AND ROWNUM<2;
/* insert a record into wms_label_requests entity to
call the label rules engine to get appropriate label */
INV_LABEL.GET_FORMAT_WITH_RULE
( p_document_id =>p_label_type_info.label_type_id,
P_LABEL_FORMAT_ID => p_label_type_info.manual_format_id,
p_delivery_id =>l_delivery_id,
--p_printer_name =>l_printer,-- Removed in R12: 4396558
P_BUSINESS_FLOW_CODE => p_label_type_info.business_flow_code,
P_LAST_UPDATE_DATE =>sysdate,
P_LAST_UPDATED_BY =>FND_GLOBAL.user_id,
P_CREATION_DATE =>sysdate,
P_CREATED_BY =>FND_GLOBAL.user_id,
x_return_status =>l_return_status,
x_label_format_id =>l_label_format_id,
x_label_format =>l_label_format,
x_label_request_id =>l_label_request_id,
-- Added by joabraha for Bug 3549300
p_customer_id => v_delivery.customer_id,
p_organization_id => v_delivery.organization_id,
-- Added by dchithir for bug 5740331
p_sales_order_header_id => l_sales_order_header_id,
p_lpn_id => p_input_param.lpn_id -- 12529483
);
x_variables => l_selected_fields
, x_variables_count => l_selected_fields_count
, p_format_id => l_label_format_id);
IF (l_selected_fields_count=0) OR (l_selected_fields.count =0 ) THEN
IF (l_debug = 1) THEN
trace('no fields defined for this format: ' || l_label_format|| ',' ||l_label_format_id);
trace(' Found selected_fields for format ' || l_label_format ||', num='|| l_selected_fields_count);
/* Loop for each selected fields, find the columns and write into the XML_content*/
FOR i IN 1..l_selected_fields.count LOOP
IF (l_debug = 1) THEN
l_column_name_list := l_column_name_list || ',' ||l_selected_fields(i).column_name;
IF (l_selected_fields(i).SQL_STMT IS NOT NULL AND l_selected_fields(i).column_name = 'sql_stmt') THEN
IF (l_debug = 1) THEN
trace('Custom Labels Trace [INVLAP7B.pls]: ------------------------- REPORT BEGIN-------------------------------------');
trace('Custom Labels Trace [INVLAP7B.pls]: LABEL_FIELD_ID : ' || l_selected_fields(i).label_field_id);
trace('Custom Labels Trace [INVLAP7B.pls]: FIELD_VARIABLE_NAME : ' || l_selected_fields(i).variable_name);
trace('Custom Labels Trace [INVLAP7B.pls]: COLUMN_NAME : ' || l_selected_fields(i).column_name);
trace('Custom Labels Trace [INVLAP7B.pls]: SQL_STMT : ' || l_selected_fields(i).sql_stmt);
l_sql_stmt := l_selected_fields(i).sql_stmt;
|| l_selected_fields(i).variable_name
|| '">'
|| l_sql_stmt_result
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'current_date' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || INV_LABEL.G_DATE || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || INV_LABEL.G_USER || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'airbill' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.airbill || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'bill_of_lading' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.bill_of_lading || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'carrier' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.carrier || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'customer' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.customer || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'delivery_number' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.delivery_number || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_from_postal_code' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_from_postal_code || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_from_state' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_from_state || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_from_address1' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_from_address1 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_from_address2' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_from_address2 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_from_address3' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_from_address3 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_from_address4' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_from_address4 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_from_city' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_from_city || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_from_country' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_from_country || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_from_county' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_from_county || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_from_province' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_from_province || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_from_state' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_from_state || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'shipment_gross_weight' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.shipment_gross_weight || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'shipment_gross_weight_uom' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.shipment_gross_weight_uom || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_method' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_method || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'shipment_tare_weight' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.shipment_tare_weight || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'shipment_tare_weight_uom' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.shipment_tare_weight_uom || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_to_address1' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_to_address1 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_to_address2' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_to_address2 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_to_address3' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_to_address3 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_to_address4' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_to_address4 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_to_city' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_to_city || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_to_country' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_to_country || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_to_county' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_to_county || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_to_postal_code' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_to_postal_code || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_to_province' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_to_province || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_to_state' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_to_state || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'shipment_volume' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.shipment_volume || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'shipment_volume_uom' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.shipment_volume_uom || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'total_number_of_lpns' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.total_number_of_lpns || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'waybill' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.waybill || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_attribute1' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_attribute1 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_attribute2' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_attribute2 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_attribute3' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_attribute3 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_attribute4' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_attribute4 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_attribute5' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_attribute5 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_attribute6' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_attribute6 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_attribute7' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_attribute7 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_attribute8' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_attribute8 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_attribute9' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_attribute9 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_attribute10' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_attribute10 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_attribute11' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_attribute11 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_attribute12' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_attribute12 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_attribute13' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_attribute13 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_attribute14' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_attribute14 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_attribute15' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_attribute15 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_attribute_category' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_attribute_category || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_tp_attr1' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_tp_attr1 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_tp_attr2' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_tp_attr2 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_tp_attr3' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_tp_attr3 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_tp_attr4' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_tp_attr4 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_tp_attr5' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_tp_attr5 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_tp_attr6' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_tp_attr6 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_tp_attr7' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_tp_attr7 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_tp_attr8' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_tp_attr8 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_tp_attr9' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_tp_attr9 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_tp_attr10' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_tp_attr10 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_tp_attr11' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_tp_attr11 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_tp_attr12' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_tp_attr12 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_tp_attr13' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_tp_attr13 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_tp_attr14' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_tp_attr14 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_tp_attr15' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_tp_attr15 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_tp_attr_category' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_tp_attr_category || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_global_attr1' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_global_attr1 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_global_attr2' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_global_attr2 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_global_attr3' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_global_attr3 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_global_attr4' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_global_attr4 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_global_attr5' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_global_attr5 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_global_attr6' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_global_attr6 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_global_attr7' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_global_attr7 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_global_attr8' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_global_attr8 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_global_attr9' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_global_attr9 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_global_attr10' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_global_attr10 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_global_attr11' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_global_attr11 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_global_attr12' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_global_attr12 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_global_attr13' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_global_attr13 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_global_attr14' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_global_attr14 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_global_attr15' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_global_attr15 || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'new_del_global_attr_category' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.new_del_global_attr_category || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_from_addressee' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_from_addressee || VARIABLE_E;
ELSIF LOWER(l_selected_fields(i).column_name) = 'ship_to_addressee' THEN
l_delivery_data := l_delivery_data || VARIABLE_B ||
l_selected_fields(i).variable_name || '">' || v_delivery.ship_to_addressee || VARIABLE_E;