[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT unit_number
INTO l_unit_number
FROM mtl_txn_request_lines_v
WHERE line_id = x_source_line
AND move_order_type = 1;
SELECT count(*)
INTO L_quantity
FROM mtl_serial_numbers msn
WHERE msn.current_status = 3
AND msn.inventory_item_id = X_item_id
AND msn.current_organization_id = X_organization_id
AND msn.current_subinventory_code = X_subinventory
AND nvl(msn.current_locator_id,-3113) = nvl(X_locator_id,-3113)
AND nvl(msn.revision,'!@$') = nvl(X_revision,'!@$')
AND nvl(msn.lot_number,'!@$') = nvl(X_lot_number,'!@$')
AND nvl(msn.end_item_unit_number,'!@$') = nvl(L_unit_number,'!@$')
AND nvl(msn.lpn_id, -3113) = nvl(X_lpn_id, -3113) -- BUG fix 2752979
AND nvl(msn.cost_group_id, -3113) = nvl(X_cost_group_id, -3113); -- BUG fix 2752979
SELECT inventory_item_id
, organization_id
, transaction_source_type_id
, transaction_source_id
, trx_source_line_id
, rcv_transaction_id
, sign(primary_quantity)
INTO L_item_id
, L_organization_id
, L_src_type_id
, L_trx_src_id
, L_trx_src_line_id
, L_rcv_trx_id
, L_trx_sign
FROM mtl_material_transactions_temp
WHERE transaction_temp_id = X_trx_temp_id;
SELECT count(fm_serial_number)
INTO L_trx_qty
FROM mtl_serial_numbers_temp msnt
WHERE msnt.transaction_temp_id in (
SELECT X_trx_temp_id FROM dual
UNION ALL
SELECT serial_transaction_temp_id
FROM mtl_transaction_lots_temp
WHERE transaction_temp_id = X_trx_temp_id )
AND rownum = 1;
SELECT count(*) * L_trx_sign
INTO L_trx_qty
FROM mtl_serial_numbers_temp msnt
, mtl_serial_numbers msn
WHERE msnt.transaction_temp_id in (
SELECT X_trx_temp_id FROM dual
UNION ALL
SELECT serial_transaction_temp_id
FROM mtl_transaction_lots_temp
WHERE transaction_temp_id = X_trx_temp_id )
AND msn.serial_number >= msnt.fm_serial_number
AND msn.serial_number <= nvl(msnt.to_serial_number , msnt.fm_serial_number)
AND length(msn.serial_number) = length(msnt.fm_serial_number)
AND msn.inventory_item_id = L_item_id
AND nvl(msn.lot_number,'!@$') = nvl(X_lot_number,'!@$')
AND msn.end_item_unit_number = L_unit_number;