[Home] [Help]
2416: -- for the rcv txn id
2417: Cursor rcv_txn_serial_num (p_txn_id in number) is
2418: select rst.serial_num,
2419: rst.lot_num
2420: from rcv_serial_transactions rst,
2421: rcv_transactions rt
2422: where rt.transaction_id = p_txn_id
2423: and rst.transaction_id = rt.transaction_id;
2424:
3677: select rcvt.serial_num,
3678: rcvt.lot_num
3679: into l_serial_num,
3680: l_lot_num
3681: from rcv_serial_transactions rcvt
3682: where rcvt.transaction_id = DEL.transaction_id
3683: and rownum = 1
3684: and not exists (Select 'NOT EXIST'
3685: from csd_repairs cra,
4045: select rcvt.serial_num,
4046: rcvt.lot_num
4047: into l_serial_num,
4048: l_lot_num
4049: from rcv_serial_transactions rcvt
4050: where rcvt.transaction_id = DEL.transaction_id
4051: and rownum = 1
4052: and not exists (Select 'NOT EXIST'
4053: from csd_repairs cra,
4322: select rcvt.serial_num,
4323: rcvt.lot_num
4324: into l_serial_num,
4325: l_lot_num
4326: from rcv_serial_transactions rcvt
4327: where rcvt.transaction_id = RCV.transaction_id
4328: and rownum = 1
4329: and not exists (Select 'NOT EXIST'
4330: from csd_repairs cra,
5093: select rcvt.serial_num,
5094: rcvt.lot_num
5095: into l_serial_num,
5096: l_lot_num
5097: from rcv_serial_transactions rcvt
5098: where rcvt.transaction_id = DEL.transaction_id
5099: and rownum = 1
5100: and not exists (Select 'NOT EXIST'
5101: from csd_repairs cra,
5466: select rcvt.serial_num,
5467: rcvt.lot_num
5468: into l_serial_num,
5469: l_lot_num
5470: from rcv_serial_transactions rcvt
5471: where rcvt.transaction_id = DEL.transaction_id
5472: and rownum = 1
5473: and not exists (Select 'NOT EXIST'
5474: from csd_repairs cra,
5748: select rcvt.serial_num,
5749: rcvt.lot_num
5750: into l_serial_num,
5751: l_lot_num
5752: from rcv_serial_transactions rcvt
5753: where rcvt.transaction_id = RCV.transaction_id
5754: and rownum = 1;
5755:
5756: --bug#7452134.