The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT rti.lpn_id lpn_id
, pha.segment1 purchase_order
, rti.subinventory
, rti.locator_id
FROM rcv_transactions_interface rti, po_headers_all pha
WHERE rti.interface_transaction_id = p_transaction_id
AND rti.po_header_id = pha.po_header_id(+);
SELECT rti.transfer_lpn_id transfer_lpn_id
, pha.segment1 purchase_order
, rti.subinventory
, rti.locator_id
FROM rcv_transactions_interface rti, po_headers_all pha
WHERE rti.interface_transaction_id = p_transaction_id
AND rti.po_header_id = pha.po_header_id(+);
SELECT lpn_id
, content_lpn_id
, transfer_lpn_id
, transfer_subinventory
, subinventory_code
, transaction_type_id
, transaction_action_id
-- Bug 2515486: Added transaction_type_id, transaction_action_id, inventory_item_id
FROM mtl_material_transactions_temp
WHERE transaction_temp_id = p_transaction_id
AND ROWNUM < 2;
SELECT cartonization_id
FROM mtl_material_transactions_temp
WHERE transaction_temp_id = p_transaction_id;
SELECT lpn_id
, subinventory_code
, locator_id
FROM mtl_material_transactions_temp
WHERE transaction_temp_id = p_transaction_id;
SELECT lpn_id
FROM wsh_delivery_details
WHERE delivery_detail_id = p_transaction_id;
SELECT transfer_lpn_id
FROM mtl_material_transactions_temp mmtt
WHERE mmtt.transaction_temp_id = p_transaction_id;
SELECT lpn_id
FROM mtl_txn_request_lines
WHERE line_id = p_transaction_id;
SELECT lpn_id
FROM mtl_transactions_interface
WHERE transaction_interface_id = p_transaction_id;
SELECT wdd2.lpn_id
FROM wsh_new_deliveries wnd
, wsh_delivery_assignments_v wda
, wsh_delivery_details wdd1
, wsh_delivery_details wdd2
WHERE wnd.delivery_id = p_transaction_id
AND wnd.delivery_id = wda.delivery_id
AND wdd1.delivery_detail_id = wda.delivery_detail_id
AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;
SELECT DISTINCT all_lpn.lpn_id
, pha.segment1 purchase_order
, all_lpn.subinventory
, all_lpn.locator_id
FROM (-- LPN_ID
SELECT lpn_id
, po_header_id
, subinventory
, locator_id
FROM rcv_transactions rt
WHERE lpn_id IS NOT NULL
AND rt.group_id = p_transaction_id
AND ((rt.transaction_type IN ('ACCEPT', 'REJECT')
AND p_label_type_info.business_flow_code = 2)
OR (rt.transaction_type = 'DELIVER'
AND p_label_type_info.business_flow_code in (3,4))
OR (rt.transaction_type = 'RECEIVE'
/* modified for bug 4293052 :aujain*/
-- AND rt.routing_header_id <> 3
AND p_label_type_info.business_flow_code = 1
)
)
UNION ALL
-- PARENT LPN of LPN_ID
SELECT lpn.parent_lpn_id
, rt.po_header_id
, rt.subinventory
, rt.locator_id
FROM wms_license_plate_numbers lpn, rcv_transactions rt
WHERE lpn.lpn_id = rt.lpn_id
-- AND lpn.parent_lpn_id <> rt.lpn_id
AND rt.group_id = p_transaction_id
AND lpn.parent_lpn_id is not null
AND ((rt.transaction_type IN ('ACCEPT', 'REJECT')
AND p_label_type_info.business_flow_code = 2)
OR (rt.transaction_type = 'DELIVER'
AND p_label_type_info.business_flow_code in (3,4))
OR (rt.transaction_type = 'RECEIVE'
/* modified for bug 4293052 :aujain*/
-- AND rt.routing_header_id <> 3
AND p_label_type_info.business_flow_code = 1
)
)
UNION ALL
-- OUTERMOSE LPN of LPN_ID, and different than the LPN and parent LPN
SELECT lpn.outermost_lpn_id
, rt.po_header_id
, rt.subinventory
, rt.locator_id
FROM wms_license_plate_numbers lpn, rcv_transactions rt
WHERE lpn.lpn_id = rt.lpn_id
-- AND lpn.outermost_lpn_id <> lpn.lpn_id
-- AND lpn.outermost_lpn_id <> lpn.parent_lpn_id
AND rt.group_id = p_transaction_id
AND ((rt.transaction_type IN ('ACCEPT', 'REJECT')
AND p_label_type_info.business_flow_code = 2)
OR (rt.transaction_type = 'DELIVER'
AND p_label_type_info.business_flow_code in (3,4))
OR (rt.transaction_type = 'RECEIVE'
/* modified for bug 4293052 :aujain*/
-- AND rt.routing_header_id <> 3
AND p_label_type_info.business_flow_code = 1
)
)
UNION ALL
-- Transfer LPN (different than LPN)
SELECT transfer_lpn_id lpn_id
, po_header_id
, subinventory
, locator_id
FROM rcv_transactions rt
WHERE
--rt.transfer_lpn_id <> rt.lpn_id AND
rt.group_id = p_transaction_id
AND ((rt.transaction_type IN ('ACCEPT', 'REJECT')
AND p_label_type_info.business_flow_code = 2)
OR (rt.transaction_type = 'DELIVER'
AND p_label_type_info.business_flow_code in (3,4))
OR (rt.transaction_type = 'RECEIVE'
/* modified for bug 4293052 :aujain*/
--AND rt.routing_header_id <> 3
AND p_label_type_info.business_flow_code = 1
)
)
UNION ALL
-- Parent LPN of Transfer LPN
SELECT lpn.parent_lpn_id
, rt.po_header_id
, rt.subinventory
, rt.locator_id
FROM wms_license_plate_numbers lpn, rcv_transactions rt
WHERE lpn.lpn_id = rt.transfer_lpn_id
-- AND rt.transfer_lpn_id <> rt.lpn_id
-- AND lpn.parent_lpn_id <> lpn.lpn_id
AND lpn.parent_lpn_id is not null
AND rt.group_id = p_transaction_id
AND ((rt.transaction_type IN ('ACCEPT', 'REJECT')
AND p_label_type_info.business_flow_code = 2)
OR (rt.transaction_type = 'DELIVER'
AND p_label_type_info.business_flow_code in (3,4))
OR (rt.transaction_type = 'RECEIVE'
/* modified for bug 4293052 :aujain*/
--AND rt.routing_header_id <> 3
AND p_label_type_info.business_flow_code = 1
)
)
UNION ALL
-- Outermost LPN of Transfer LPN
SELECT lpn.outermost_lpn_id
, rt.po_header_id
, rt.subinventory
, rt.locator_id
FROM wms_license_plate_numbers lpn, rcv_transactions rt
WHERE lpn.lpn_id = rt.transfer_lpn_id
-- AND rt.transfer_lpn_id <> rt.lpn_id
-- AND lpn.outermost_lpn_id <> lpn.lpn_id
-- AND lpn.outermost_lpn_id <> lpn.parent_lpn_id
AND rt.group_id = p_transaction_id
AND ((rt.transaction_type IN ('ACCEPT', 'REJECT')
AND p_label_type_info.business_flow_code = 2)
OR (rt.transaction_type = 'DELIVER'
AND p_label_type_info.business_flow_code in (3,4))
OR (rt.transaction_type = 'RECEIVE'
/* modified for bug 4293052 :aujain*/
--AND rt.routing_header_id <> 3
AND p_label_type_info.business_flow_code = 1
)
)) all_lpn
, po_headers_all pha
, wms_license_plate_numbers wlpn -- Bug 3836623
WHERE pha.po_header_id(+) = all_lpn.po_header_id
-- Bug 3836623
-- Add check for LPN context
-- When cross docking happens, label printing are called for both cross docking and putaway
-- To prevent duplicate labels
-- For putaway business flow, only print if LPN Context is not Picked (11)
AND wlpn.lpn_id = all_lpn.lpn_id
AND (p_label_type_info.business_flow_code <> 4 OR
(p_label_type_info.business_flow_code = 4 AND
wlpn.lpn_context <> 11));
SELECT lpn.lpn_id lpn_id
, lpn.license_plate_number lpn
, msik.concatenated_segments lpn_container_item
, lpn.inventory_item_id inventory_item_id
, NVL(l_subinventory_code, lpn.subinventory_code) subinventory_code
, lpn.revision revision
, lpn.locator_id locator_id
, inv_project.get_locsegs(
milkfv.inventory_location_id
, milkfv.organization_id
) LOCATOR
, lpn.lot_number lot_number
, lpn.serial_number serial_number
, plpn.license_plate_number parent_lpn
, olpn.license_plate_number outermost_lpn
, mp.organization_code ORGANIZATION
, lpn.organization_id organization_id
, lpn.content_volume volume
, lpn.content_volume_uom_code volume_uom
, lpn.gross_weight gross_weight
, lpn.gross_weight_uom_code gross_weight_uom
, lpn.tare_weight tare_weight
, lpn.tare_weight_uom_code tare_weight_uom
, lpn.attribute_category CATEGORY
, lpn.attribute1 attribute1
, lpn.attribute2 attribute2
, lpn.attribute3 attribute3
, lpn.attribute4 attribute4
, lpn.attribute5 attribute5
, lpn.attribute6 attribute6
, lpn.attribute7 attribute7
, lpn.attribute8 attribute8
, lpn.attribute9 attribute9
, lpn.attribute10 attribute10
, lpn.attribute11 attribute11
, lpn.attribute12 attribute12
, lpn.attribute13 attribute13
, lpn.attribute14 attribute14
, lpn.attribute15 attribute15
FROM wms_license_plate_numbers lpn
, wms_license_plate_numbers plpn
, wms_license_plate_numbers olpn
, mtl_system_items_kfv msik
, mtl_parameters mp
, mtl_item_locations milkfv
WHERE lpn.lpn_id = p_lpn_id
AND mp.organization_id(+) = lpn.organization_id
AND msik.inventory_item_id(+) = lpn.inventory_item_id
AND msik.organization_id(+) = lpn.organization_id
AND milkfv.organization_id(+) = lpn.organization_id
AND milkfv.subinventory_code(+) =
NVL(l_subinventory_code, lpn.subinventory_code)
AND milkfv.inventory_location_id(+) =
NVL(l_locator_id, lpn.locator_id)
AND plpn.lpn_id(+) = lpn.parent_lpn_id
AND olpn.lpn_id(+) = lpn.outermost_lpn_id;
SELECT parent_lpn_id
, subinventory
, locator_id
, mcch.cycle_count_header_name
, ppf.full_name requestor
FROM mtl_cycle_count_headers mcch,
mtl_cycle_count_entries mcce,
per_people_f ppf
WHERE cycle_count_entry_id= p_transaction_id
AND ppf.person_id(+) = mcce.counted_by_employee_id_current
AND mcce.cycle_count_header_id=mcch.cycle_count_header_id;
SELECT mcch.cycle_count_header_name,
ppf.full_name requestor
FROM mtl_cycle_count_headers mcch,
mtl_cycle_count_entries mcce,
per_people_f ppf,
mtl_material_transactions_temp mmtt
WHERE mmtt.transaction_temp_id= p_transaction_id
AND mmtt.cycle_count_id = mcce.cycle_count_entry_id
AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
AND ppf.person_id(+) = mcce.counted_by_employee_id_current ;
SELECT distinct
all_lpn.lpn_id
, pha.segment1 purchase_order
, all_lpn.subinventory_code
, all_lpn.locator_id
FROM(
select lpn.lpn_id
, rsl.po_header_id, rsl.po_line_id
, lpn.subinventory_code, lpn.locator_id
, rsh.shipment_header_id
, rsl.po_line_location_id
from wms_license_plate_numbers lpn,
rcv_shipment_headers rsh,
rcv_shipment_lines rsl
where lpn.source_name = rsh.shipment_num
AND lpn.lpn_context = 7
AND rsl.shipment_header_id = rsh.shipment_header_id
and rsh.shipment_header_id = p_transaction_id
and rsl.asn_lpn_id = lpn.lpn_id
AND rsh.asn_type = 'ASN'
UNION
select lpn.parent_lpn_id
, rsl.po_header_id, rsl.po_line_id
, lpn.subinventory_code, lpn.locator_id
, rsh.shipment_header_id
, rsl.po_line_location_id
from wms_license_plate_numbers lpn,
rcv_shipment_headers rsh,
rcv_shipment_lines rsl
where lpn.source_name = rsh.shipment_num
AND lpn.lpn_context = 7
AND rsl.shipment_header_id = rsh.shipment_header_id
and rsl.asn_lpn_id = lpn.lpn_id
and rsh.shipment_header_id = p_transaction_id
AND rsh.asn_type = 'ASN'
UNION
select lpn.outermost_lpn_id
, rsl.po_header_id, rsl.po_line_id
, lpn.subinventory_code, lpn.locator_id
, rsh.shipment_header_id
, rsl.po_line_location_id
from wms_license_plate_numbers lpn,
rcv_shipment_headers rsh,
rcv_shipment_lines rsl
where lpn.source_name = rsh.shipment_num
AND lpn.lpn_context = 7
AND rsl.shipment_header_id = rsh.shipment_header_id
and rsh.shipment_header_id = p_transaction_id
and rsl.asn_lpn_id = lpn.lpn_id
AND rsh.asn_type = 'ASN'
) all_lpn
, po_headers_all pha
, po_lines_all pol
, rcv_shipment_headers rsh
, po_line_locations_all pll
WHERE pha.po_header_id(+) = all_lpn.po_header_id
AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id
AND pol.po_line_id (+) = all_lpn.po_line_id
AND pol.po_header_id (+) = all_lpn.po_header_id
AND pll.line_location_id(+) = all_lpn.po_line_location_id;
select wlfs.format_id label_format_id, wlf.label_entity_type --FOR SETS
from wms_label_set_formats wlfs , wms_label_formats wlf
where WLFS.SET_ID = p_format_set_id
and wlfs.set_id = wlf.label_format_id
and wlf.label_entity_type = 1
AND WLF.DOCUMENT_ID = 3
UNION --FOR FORMATS
select label_format_id,nvl(wlf.label_entity_type,0)
from wms_label_formats wlf
where wlf.label_format_id = p_format_set_id
and nvl(wlf.label_entity_type,0) = 0--for label formats only validation
AND WLF.DOCUMENT_ID = 3 ;
l_selected_fields inv_label.label_field_variable_tbl_type;
l_selected_fields_count NUMBER;
SELECT shipment_num asn_num, shipped_date shipment_date,
expected_receipt_date,freight_terms,
freight_carrier_code, num_of_containers,
bill_of_lading, waybill_airbill_num,
packing_slip,
packaging_code, special_handling_code,
receipt_num, comments
INTO l_rcv_isp_header.asn_num, l_rcv_isp_header.shipment_date,
l_rcv_isp_header.expected_receipt_date, l_rcv_isp_header.freight_terms,
l_rcv_isp_header.freight_carrier, l_rcv_isp_header.num_of_containers,
l_rcv_isp_header.bill_of_lading, l_rcv_isp_header.waybill_airbill_num,
l_rcv_isp_header.packing_slip,
l_rcv_isp_header.packaging_code, l_rcv_isp_header.special_handling_code,
l_rcv_isp_header.receipt_num, l_rcv_isp_header.comments
FROM rcv_shipment_headers
WHERE shipment_header_id = p_transaction_id;
For Cost Group Update Bussiness Flow (11), only one label has to be generated with
the updated cost group. Hence the following code (incrementing i, which controls the
loop iteration) will be executed only if the business flow code is not 11
i.e. Cost Group Update Business flow */
IF (p_label_type_info.business_flow_code NOT IN (11, 28, 29)) THEN -- Modified for bug # 4911236
IF (l_transfer_lpn_id IS NOT NULL)
AND(NVL(l_transfer_lpn_id, -999) <> NVL(l_content_lpn_id, -999)) THEN
l_lpn_table(i) := l_transfer_lpn_id;
/* insert a record into wms_label_requests entity to
call the label rules engine to get appropriate label
In this call if this happens to be for the label-set, the record
from wms_label_request will be deleted inside following API*/
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_organization_id => v_lpn_content.organization_id
, p_inventory_item_id => v_lpn_content.inventory_item_id
, p_subinventory_code => v_lpn_content.subinventory_code
, p_locator_id => v_lpn_content.locator_id
, p_lpn_id => v_lpn_content.lpn_id
, p_lot_number => v_lpn_content.lot_number
, p_revision => v_lpn_content.revision
, p_serial_number => v_lpn_content.serial_number
, 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
--, p_printer_name => l_printer --not used post R12
, x_return_status => l_return_status
, x_label_format_id => l_label_format_set_id
, x_label_format => l_label_format
, x_label_request_id => l_label_request_id
);
----1 Insert record into WMS_LABEL_REQUESTS
----2 get value of l_label_format_id, l_label_format, l_label_request_id
----3 Do not call Rules Engine again, as we know format id
--else
----Do not call get_format_with_rule(), just use the format-id
IF l_label_formats_in_set.label_entity_type = 1 THEN --IT IS LABEL SET
--In R12 call this API for the format AGAIN without calling Rules ENGINE
/* insert a record into wms_label_requests entity */
inv_label.get_format_with_rule
(
p_document_id => p_label_type_info.label_type_id
, p_label_format_id => l_label_formats_in_set.label_format_id --considers manual printer also
, p_organization_id => v_lpn_content.organization_id
, p_inventory_item_id => v_lpn_content.inventory_item_id
, p_subinventory_code => v_lpn_content.subinventory_code
, p_locator_id => v_lpn_content.locator_id
, p_lpn_id => v_lpn_content.lpn_id
, p_lot_number => v_lpn_content.lot_number
, p_revision => v_lpn_content.revision
, p_serial_number => v_lpn_content.serial_number
, 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
--, p_printer_name => l_printer --not used post R12
, p_use_rule_engine => 'N' --------------------------Rules ENgine will NOT get called
, 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
);
x_variables => l_selected_fields
, x_variables_count => l_selected_fields_count
, x_is_variable_exist => l_is_epc_exist
, p_format_id => l_label_format_id
, p_exist_variable_name => 'EPC'
);
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
);
' 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 [INVLAP3B.pls]: ------------------------- REPORT BEGIN-------------------------------------');
trace('Custom Labels Trace [INVLAP3B.pls]: LABEL_FIELD_ID : ' || l_selected_fields(i).label_field_id);
trace('Custom Labels Trace [INVLAP3B.pls]: FIELD_VARIABLE_NAME : ' || l_selected_fields(i).variable_name);
trace('Custom Labels Trace [INVLAP3B.pls]: COLUMN_NAME : ' || l_selected_fields(i).column_name);
trace('Custom Labels Trace [INVLAP3B.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_content_item_data := l_content_item_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_content_item_data := l_content_item_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_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| inv_label.g_user
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'lpn' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.lpn
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'organization' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.ORGANIZATION
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'subinventory_code' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.subinventory_code
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'locator' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.LOCATOR
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'volume' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.volume
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'volume_uom' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.volume_uom
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'gross_weight' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.gross_weight
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'gross_weight_uom' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.gross_weight_uom
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'tare_weight' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.tare_weight
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'tare_weight_uom' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.tare_weight_uom
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'lpn_container_item' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.lpn_container_item
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'parent_lpn' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.parent_lpn
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'outermost_lpn' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.outermost_lpn
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) =
'customer_purchase_order' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| l_purchase_order
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'category' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.CATEGORY
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'attribute1' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.attribute1
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'attribute2' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.attribute2
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'attribute3' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.attribute3
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'attribute4' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.attribute4
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'attribute5' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.attribute5
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'attribute6' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.attribute6
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'attribute7' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.attribute7
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'attribute8' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.attribute8
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'attribute9' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.attribute9
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'attribute10' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.attribute10
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'attribute11' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.attribute11
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'attribute12' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.attribute12
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'attribute13' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.attribute13
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'attribute14' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.attribute14
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'attribute15' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| v_lpn_content.attribute15
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'requestor' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">' || l_requestor
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'cycle_count_name' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">' || l_cycle_count_name
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'asn_number' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| l_rcv_isp_header.asn_num
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'expct_rcpt_date' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| l_rcv_isp_header.expected_receipt_date
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'freight_terms' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| l_rcv_isp_header.freight_terms
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'freight_carrier' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| l_rcv_isp_header.freight_carrier
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'num_of_containers' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| l_rcv_isp_header.num_of_containers
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'bill_of_lading' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| l_rcv_isp_header.bill_of_lading
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'waybill_airbill_num' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| l_rcv_isp_header.waybill_airbill_num
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'comments_header' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| l_rcv_isp_header.comments
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'packaging_code' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| l_rcv_isp_header.packaging_code
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'special_handling_code' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| l_rcv_isp_header.special_handling_code
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'shipment_date' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| l_rcv_isp_header.shipment_date
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'packing_slip_header' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| l_rcv_isp_header.packing_slip
|| variable_e;
ELSIF LOWER(l_selected_fields(i).column_name) = 'epc' THEN
l_content_item_data := l_content_item_data
|| variable_b
|| l_selected_fields(i).variable_name
|| '">'
|| l_epc
|| variable_e;