[Home] [Help]
2354: -- for the rcv txn id
2355: Cursor rcv_txn_serial_num (p_txn_id in number) is
2356: select rst.serial_num,
2357: rst.lot_num
2358: from rcv_serial_transactions rst,
2359: rcv_transactions rt
2360: where rt.transaction_id = p_txn_id
2361: and rst.transaction_id = rt.transaction_id;
2362:
3516: select rcvt.serial_num,
3517: rcvt.lot_num
3518: into l_serial_num,
3519: l_lot_num
3520: from rcv_serial_transactions rcvt
3521: where rcvt.transaction_id = DEL.transaction_id
3522: and rownum = 1
3523: and not exists (Select 'NOT EXIST'
3524: from csd_repairs cra,
3884: select rcvt.serial_num,
3885: rcvt.lot_num
3886: into l_serial_num,
3887: l_lot_num
3888: from rcv_serial_transactions rcvt
3889: where rcvt.transaction_id = DEL.transaction_id
3890: and rownum = 1
3891: and not exists (Select 'NOT EXIST'
3892: from csd_repairs cra,
4161: select rcvt.serial_num,
4162: rcvt.lot_num
4163: into l_serial_num,
4164: l_lot_num
4165: from rcv_serial_transactions rcvt
4166: where rcvt.transaction_id = RCV.transaction_id
4167: and rownum = 1
4168: and not exists (Select 'NOT EXIST'
4169: from csd_repairs cra,
4932: select rcvt.serial_num,
4933: rcvt.lot_num
4934: into l_serial_num,
4935: l_lot_num
4936: from rcv_serial_transactions rcvt
4937: where rcvt.transaction_id = DEL.transaction_id
4938: and rownum = 1
4939: and not exists (Select 'NOT EXIST'
4940: from csd_repairs cra,
5305: select rcvt.serial_num,
5306: rcvt.lot_num
5307: into l_serial_num,
5308: l_lot_num
5309: from rcv_serial_transactions rcvt
5310: where rcvt.transaction_id = DEL.transaction_id
5311: and rownum = 1
5312: and not exists (Select 'NOT EXIST'
5313: from csd_repairs cra,
5587: select rcvt.serial_num,
5588: rcvt.lot_num
5589: into l_serial_num,
5590: l_lot_num
5591: from rcv_serial_transactions rcvt
5592: where rcvt.transaction_id = RCV.transaction_id
5593: and rownum = 1;
5594:
5595: --bug#7452134.