[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pl.picking_line_id
FROM so_picking_lines pl, so_picking_headers ph
WHERE pl.picking_header_id = ph.picking_header_id
AND ph.picking_header_id = ph_id
AND ph.status_code = 'PENDING';
select
count(picking_line_detail_id),
min(picking_line_detail_id),
sum(requested_quantity)
from so_picking_line_details
where picking_line_id = pl_id
and NVL(shipped_quantity, 0) = 0
and NVL(released_flag, 'Y') = 'Y'
group by
warehouse_id,
subinventory,
inventory_location_id,
revision,
lot_number,
CUSTOMER_REQUESTED_LOT_FLAG,
CONTEXT,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
schedule_date,
schedule_level,
schedule_status_code,
demand_id,
demand_class_code,
AUTOSCHEDULED_FLAG,
delivery,
update_flag,
detail_type_code;
SELECT picking_line_detail_id
FROM so_picking_line_details
WHERE picking_line_id = pl_id
FOR UPDATE OF picking_line_detail_id NOWAIT;
DELETE FROM so_picking_line_details
WHERE picking_line_id = pl_id
AND shipped_quantity = 0
AND NVL(released_flag, 'Y') = 'Y'
AND picking_line_detail_id <> keep_pld_id
AND (nvl(warehouse_id, -99999),
nvl(subinventory, -99999),
nvl(inventory_location_id, -99999),
nvl(revision, -99999),
nvl(lot_number, -99999),
nvl(CUSTOMER_REQUESTED_LOT_FLAG, -99999),
nvl(CONTEXT, -99999),
nvl(ATTRIBUTE1, -99999),
nvl(ATTRIBUTE2, -99999),
nvl(ATTRIBUTE3, -99999),
nvl(ATTRIBUTE4, -99999),
nvl(ATTRIBUTE5, -99999),
nvl(ATTRIBUTE6, -99999),
nvl(ATTRIBUTE7, -99999),
nvl(ATTRIBUTE8, -99999),
nvl(ATTRIBUTE9, -99999),
nvl(ATTRIBUTE10, -99999),
nvl(ATTRIBUTE11, -99999),
nvl(ATTRIBUTE12, -99999),
nvl(ATTRIBUTE13, -99999),
nvl(ATTRIBUTE14, -99999),
nvl(ATTRIBUTE15, -99999),
nvl(schedule_date, sysdate),
nvl(schedule_level, -99999),
nvl(schedule_status_code, -99999),
nvl(demand_id, -99999),
nvl(demand_class_code, -99999),
nvl(AUTOSCHEDULED_FLAG, -99999),
nvl(delivery, -99999),
nvl(update_flag, -99999),
nvl(detail_type_code, -99999)) =
(SELECT nvl(warehouse_id, -99999),
nvl(subinventory, -99999),
nvl(inventory_location_id, -99999),
nvl(revision, -99999),
nvl(lot_number, -99999),
nvl(CUSTOMER_REQUESTED_LOT_FLAG, -99999),
nvl(CONTEXT, -99999),
nvl(ATTRIBUTE1, -99999),
nvl(ATTRIBUTE2, -99999),
nvl(ATTRIBUTE3, -99999),
nvl(ATTRIBUTE4, -99999),
nvl(ATTRIBUTE5, -99999),
nvl(ATTRIBUTE6, -99999),
nvl(ATTRIBUTE7, -99999),
nvl(ATTRIBUTE8, -99999),
nvl(ATTRIBUTE9, -99999),
nvl(ATTRIBUTE10, -99999),
nvl(ATTRIBUTE11, -99999),
nvl(ATTRIBUTE12, -99999),
nvl(ATTRIBUTE13, -99999),
nvl(ATTRIBUTE14, -99999),
nvl(ATTRIBUTE15, -99999),
nvl(schedule_date, sysdate),
nvl(schedule_level, -99999),
nvl(schedule_status_code, -99999),
nvl(demand_id, -99999),
nvl(demand_class_code, -99999),
nvl(AUTOSCHEDULED_FLAG, -99999),
nvl(delivery, -99999),
nvl(update_flag, -99999),
nvl(detail_type_code, -99999)
FROM so_picking_line_details
WHERE picking_line_detail_id = keep_pld_id);
UPDATE so_picking_line_details
SET requested_quantity = sum_requested,
serial_number = NULL
WHERE picking_line_detail_id = keep_pld_id;