The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ol.global_attribute1 op_fiscal_code,
ol.global_attribute2 freight_acc_expense,
ol.global_attribute3 insurance_acc_expense,
ol.global_attribute4 other_acc_expense,
ol.global_attribute5 item_line_fiscal_class,
ol.global_attribute6 item_line_trx_reason,
nvl(ol.global_attribute9,msi.global_attribute3) item_origin, --bug 11795200
msi.global_attribute4 item_fiscal_type,
nvl(ol.global_attribute10,msi.global_attribute5) fed_trib_situation, --bug 11795200
nvl(ol.global_attribute11,msi.global_attribute6) sta_trib_situation --bug 11795200
FROM oe_order_lines ol,
mtl_system_items msi
WHERE line_id = l_line_id
AND msi.inventory_item_id(+) = l_inventory_item_id
AND msi.organization_id = l_so_organization_id;
SELECT REFERENCE_CUSTOMER_TRX_LINE_ID,
REFERENCE_LINE_ID
INTO l_invoice_line_id,
l_order_line_id
FROM oe_order_lines
WHERE line_id = l_line_id;
SELECT del.gross_weight,
del.net_weight,
del.global_attribute3,
del.global_attribute1,
del.global_attribute2,
del.global_attribute4,
del.global_attribute5,
del.global_attribute6,
del.global_attribute7,
del.global_attribute8,
del.global_attribute9,
del.global_attribute10,
del.global_attribute11
INTO l_gross_weight,
l_net_weight,
l_volume_qty,
l_volume_type,
l_volume_number,
l_veh_plate_state_code,
l_veh_antt_inscr,
l_tow_veh_plate_num,
l_tow_veh_plate_state_code,
l_tow_veh_antt_inscr,
l_seal_number,
l_wagon_code,
l_ferry_code
FROM wsh_new_deliveries del
WHERE del.name =
p_interface_line_rec.interface_line_attribute3;
SELECT t.vehicle_number
INTO l_vehicle_number
FROM wsh_new_deliveries del,
wsh_delivery_legs dl,
wsh_trip_stops pickup_stop,
wsh_trips t
WHERE del.name =
p_interface_line_rec.interface_line_attribute3
AND del.delivery_id = dl.delivery_id
AND dl.pick_up_stop_id = pickup_stop.stop_id
AND pickup_stop.trip_id = t.trip_id
AND pickup_stop.actual_departure_date =
(SELECT min(pickup_stop_x.actual_departure_date)
FROM wsh_new_deliveries del_x,
wsh_delivery_legs dl_x,
wsh_trip_stops pickup_stop_x,
wsh_trips tx
WHERE del_x.delivery_id = del.delivery_id
AND del_x.delivery_id = dl_x.delivery_id
AND dl_x.pick_up_stop_id =
pickup_stop_x.stop_id
AND pickup_stop_x.trip_id = tx.trip_id
);
select global_attribute5,
global_attribute6
into l_fsc_cls_code,
l_trx_cls_code
from oe_order_lines
where line_id = l_line_id;
SELECT global_attribute2,
global_attribute3
INTO l_fsc_cls_code,
l_trx_cls_code
FROM ra_customer_trx_lines
WHERE customer_trx_line_id = l_invoice_line_id;
select global_attribute5,
global_attribute6
into l_fsc_cls_code,
l_trx_cls_code
from oe_order_lines
where line_id = l_order_line_id;
SELECT il.global_attribute1 op_fiscal_code,
il.global_attribute4 item_origin,
il.global_attribute5 item_fiscal_type,
il.global_attribute6 fed_trib_situation,
il.global_attribute7 sta_trib_situation
INTO l_op_fiscal_code,
l_item_origin,
l_item_fiscal_type,
l_fed_trib_situation,
l_sta_trib_situation
FROM ra_customer_trx_lines il
WHERE il.customer_trx_line_id = l_invoice_line_id;
SELECT ol.global_attribute1 op_fiscal_code,
msi.global_attribute3 item_origin,
msi.global_attribute4 item_fiscal_type,
msi.global_attribute5 fed_trib_situation,
msi.global_attribute6 sta_trib_situation
INTO l_op_fiscal_code,
l_item_origin,
l_item_fiscal_type,
l_fed_trib_situation,
l_sta_trib_situation
FROM oe_order_lines ol, mtl_system_items msi
WHERE ol.line_id = l_order_line_id
AND msi.inventory_item_id(+) =
p_interface_line_rec.inventory_item_id
AND msi.organization_id = l_so_organization_id;
SELECT ol.global_attribute1 op_fiscal_code,
ol.global_attribute2 freight_acc_expense,
ol.global_attribute3 insurance_acc_expense,
ol.global_attribute4 other_acc_expense,
ol.global_attribute5 item_line_fiscal_class,
ol.global_attribute6 item_line_trx_reason,
msi.global_attribute3 item_origin,
msi.global_attribute4 item_fiscal_type,
msi.global_attribute5 fed_trib_situation,
msi.global_attribute6 sta_trib_situation
FROM oe_order_lines ol,
mtl_system_items msi
WHERE line_id = l_line_id
AND msi.inventory_item_id(+) = l_inventory_item_id
AND msi.organization_id = l_so_organization_id;
SELECT REFERENCE_CUSTOMER_TRX_LINE_ID,
REFERENCE_LINE_ID
INTO l_invoice_line_id,
l_order_line_id
FROM oe_order_lines
WHERE line_id = l_line_id;
SELECT del.gross_weight,
del.net_weight,
del.global_attribute3,
del.global_attribute1,
del.global_attribute2,
del.global_attribute4,
del.global_attribute5,
del.global_attribute6,
del.global_attribute7,
del.global_attribute8,
del.global_attribute9,
del.global_attribute10,
del.global_attribute11
INTO l_gross_weight,
l_net_weight,
l_volume_qty,
l_volume_type,
l_volume_number,
l_veh_plate_state_code,
l_veh_antt_inscr,
l_tow_veh_plate_num,
l_tow_veh_plate_state_code,
l_tow_veh_antt_inscr,
l_seal_number,
l_wagon_code,
l_ferry_code
FROM wsh_new_deliveries del
WHERE del.name =
x_interface_line_rec.interface_line_attribute3;
SELECT t.vehicle_number
INTO l_vehicle_number
FROM wsh_new_deliveries del,
wsh_delivery_legs dl,
wsh_trip_stops pickup_stop,
wsh_trips t
WHERE del.name =
x_interface_line_rec.interface_line_attribute3
AND del.delivery_id = dl.delivery_id
AND dl.pick_up_stop_id = pickup_stop.stop_id
AND pickup_stop.trip_id = t.trip_id
AND pickup_stop.actual_departure_date =
(SELECT min(pickup_stop_x.actual_departure_date)
FROM wsh_new_deliveries del_x,
wsh_delivery_legs dl_x,
wsh_trip_stops pickup_stop_x,
wsh_trips tx
WHERE del_x.delivery_id = del.delivery_id
AND del_x.delivery_id = dl_x.delivery_id
AND dl_x.pick_up_stop_id =
pickup_stop_x.stop_id
AND pickup_stop_x.trip_id = tx.trip_id
);
select global_attribute5,
global_attribute6
into l_fsc_cls_code,
l_trx_cls_code
from oe_order_lines
where line_id = l_line_id;
SELECT global_attribute2,
global_attribute3
INTO l_fsc_cls_code,
l_trx_cls_code
FROM ra_customer_trx_lines
WHERE customer_trx_line_id = l_invoice_line_id;
select global_attribute5,
global_attribute6
into l_fsc_cls_code,
l_trx_cls_code
from oe_order_lines
where line_id = l_order_line_id;
SELECT il.global_attribute1 op_fiscal_code,
il.global_attribute4 item_origin,
il.global_attribute5 item_fiscal_type,
il.global_attribute6 fed_trib_situation,
il.global_attribute7 sta_trib_situation
INTO l_op_fiscal_code,
l_item_origin,
l_item_fiscal_type,
l_fed_trib_situation,
l_sta_trib_situation
FROM ra_customer_trx_lines il
WHERE il.customer_trx_line_id = l_invoice_line_id;
SELECT ol.global_attribute1 op_fiscal_code,
msi.global_attribute3 item_origin,
msi.global_attribute4 item_fiscal_type,
msi.global_attribute5 fed_trib_situation,
msi.global_attribute6 sta_trib_situation
INTO l_op_fiscal_code,
l_item_origin,
l_item_fiscal_type,
l_fed_trib_situation,
l_sta_trib_situation
FROM oe_order_lines ol, mtl_system_items msi
WHERE ol.line_id = l_order_line_id
AND msi.inventory_item_id(+) =
x_interface_line_rec.inventory_item_id
AND msi.organization_id = l_so_organization_id;
SELECT substr(mtl.global_attribute2,1,30)
INTO l_tran_nat
FROM mtl_system_items mtl
WHERE mtl.organization_id = l_inventory_org_id
AND mtl.inventory_item_id = p_line_rec.inventory_item_id;
SELECT substr(mtl.global_attribute2,1,30)
INTO l_tran_nat
FROM mtl_system_items mtl
WHERE mtl.organization_id = l_so_organization_id
AND mtl.inventory_item_id = p_line_rec.inventory_item_id;
SELECT fc.classification_code
INTO l_fcc_code
FROM zx_fc_product_fiscal_v fc,
mtl_item_categories mic
WHERE
((fc.country_code = l_country_code
AND fc.country_code in ('AR', 'BR', 'CO'))
or
fc.country_code is NULL
)
AND mic.inventory_item_id = p_line_rec.inventory_item_id
AND mic.organization_id = l_inventory_org_id
AND mic.category_id = fc.category_id
AND mic.category_set_id = fc.category_set_id
-- AND fc.structure_name = 'Fiscal Classification' -- Commented for Bug#7125709
AND fc.structure_code = 'FISCAL_CLASSIFICATION' -- Added as a fix for Bug#7125709
AND EXISTS
(SELECT 1
FROM JL_ZZ_AR_TX_FSC_CLS_ALL
WHERE fiscal_classification_code = fc.classification_code
AND org_id = l_org_id
AND enabled_flag = 'Y')
AND ROWNUM =1;
SELECT fc.classification_code
INTO l_fcc_code
FROM zx_fc_product_fiscal_v fc,
mtl_item_categories mic
WHERE
((fc.country_code = l_country_code
AND fc.country_code in ('AR', 'BR', 'CO'))
or
fc.country_code is NULL
)
AND mic.inventory_item_id = p_line_rec.inventory_item_id
AND mic.organization_id = l_so_organization_id
AND mic.category_id = fc.category_id
AND mic.category_set_id = fc.category_set_id
-- AND fc.structure_name = 'Fiscal Classification' -- Commented for Bug#7125709
AND fc.structure_code = 'FISCAL_CLASSIFICATION' -- Added as a fix for Bug#7125709
AND EXISTS
(SELECT 1
FROM JL_ZZ_AR_TX_FSC_CLS_ALL
WHERE fiscal_classification_code = fc.classification_code
AND org_id = l_org_id
AND enabled_flag = 'Y')
AND ROWNUM =1;
SELECT substr(mtl.global_attribute2,1,30),
substr(mtl.global_attribute3,1,30),
substr(mtl.global_attribute5,1,30),
substr(mtl.global_attribute6,1,30)
FROM mtl_system_items mtl
WHERE mtl.organization_id = c_inventory_org_id
AND mtl.inventory_item_id = c_inventory_item_id;
SELECT fc.classification_code
FROM zx_fc_product_fiscal_v fc,
mtl_item_categories mic
WHERE
((fc.country_code = c_country_code
AND fc.country_code in ('AR', 'BR', 'CO'))
or
fc.country_code is NULL
)
AND mic.inventory_item_id = c_inventory_item_id
AND mic.organization_id = c_inventory_org_id
AND mic.category_id = fc.category_id
AND mic.category_set_id = fc.category_set_id
AND fc.structure_code = 'FISCAL_CLASSIFICATION' -- Added as a fix for Bug#7125709
AND rownum = 1
AND EXISTS
(SELECT 1
FROM JL_ZZ_AR_TX_FSC_CLS_ALL
WHERE fiscal_classification_code = fc.classification_code
AND org_id = c_org_id
AND enabled_flag = 'Y');
SELECT substr(mtl.global_attribute1,1,30),
substr(mtl.global_attribute2,1,30),
substr(mtl.global_attribute3,1,30),
substr(mtl.global_attribute5,1,30),
substr(mtl.global_attribute6,1,30)
INTO l_fcc_code,
l_tran_nat,
l_item_orig,
l_fed_trib,
l_sta_trib
FROM mtl_system_items mtl
WHERE mtl.organization_id = l_inventory_org_id
AND mtl.inventory_item_id = x_line_rec.inventory_item_id;
SELECT substr(mtl.global_attribute2,1,30)
INTO l_tran_nat
FROM mtl_system_items mtl
WHERE mtl.organization_id = l_inventory_org_id
AND mtl.inventory_item_id = x_line_rec.inventory_item_id;
SELECT substr(mtl.global_attribute2,1,30)
INTO l_tran_nat
FROM mtl_system_items mtl
WHERE mtl.organization_id = l_so_organization_id
AND mtl.inventory_item_id = x_line_rec.inventory_item_id;
SELECT fc.classification_code
INTO l_fcc_code
FROM zx_fc_product_fiscal_v fc,
mtl_item_categories mic
WHERE
((fc.country_code = l_country_code
AND fc.country_code in ('AR', 'BR', 'CO'))
or
fc.country_code is NULL
)
AND mic.inventory_item_id = x_line_rec.inventory_item_id
AND mic.organization_id = x_line_rec.ship_from_org_id --l_inventory_org_id
AND mic.category_id = fc.category_id
AND mic.category_set_id = fc.category_set_id
-- AND fc.structure_name = 'Fiscal Classification' -- Commented for Bug#7125709
AND fc.structure_code = 'FISCAL_CLASSIFICATION' -- Added as a fix for Bug#7125709
AND rownum = 1
AND EXISTS
(SELECT 1
FROM JL_ZZ_AR_TX_FSC_CLS_ALL
WHERE fiscal_classification_code = fc.classification_code
AND org_id = l_org_id
AND enabled_flag = 'Y');
SELECT fc.classification_code
INTO l_fcc_code
FROM zx_fc_product_fiscal_v fc,
mtl_item_categories mic
WHERE
((fc.country_code = l_country_code
AND fc.country_code in ('AR', 'BR', 'CO'))
or
fc.country_code is NULL
)
AND mic.inventory_item_id = x_line_rec.inventory_item_id
AND mic.organization_id = l_so_organization_id
AND mic.category_id = fc.category_id
AND mic.category_set_id = fc.category_set_id
-- AND fc.structure_name = 'Fiscal Classification' -- Commented for Bug#7125709
AND fc.structure_code = 'FISCAL_CLASSIFICATION' -- Added as a fix for Bug#7125709
AND EXISTS
(SELECT 1
FROM JL_ZZ_AR_TX_FSC_CLS_ALL
WHERE fiscal_classification_code = fc.classification_code
AND org_id = l_org_id
AND enabled_flag = 'Y')
AND ROWNUM =1;
SELECT order_type_id
INTO l_order_type_id
FROM OE_ORDER_HEADERS_ALL
WHERE header_id = x_line_rec.header_id;