APPS.QA_SAMPLING_PKG dependencies on RCV_TRANSACTIONS

Line 506: FROM rcv_transactions_interface

502: -- kabalakr Wed Oct 29 23:19:22 PST 2003.
503:
504: CURSOR int_txn (grp_id NUMBER, txn_id NUMBER) IS
505: SELECT max(interface_transaction_id)
506: FROM rcv_transactions_interface
507: WHERE group_id = grp_id
508: AND parent_transaction_id = txn_id;
509:
510: l_rti_int_txn_id NUMBER;

Line 516: FROM rcv_transactions

512: -- Bug 8806035.ntungare
513: -- Added this cursor and variable for copying the supplier lot number information.
514: CURSOR vend_lot_num (txn_id NUMBER) IS
515: SELECT vendor_lot_num
516: FROM rcv_transactions
517: WHERE transaction_id = txn_id;
518: l_vendor_lot_num VARCHAR2(30) := NULL;
519:
520: -- Bug 6781108

Line 580: -- transaction from the rcv_transactions table.

576: END IF;
577:
578: -- Bug 8806035.ntungare
579: -- Added this cursor to fetch the vendor_lot_number of the
580: -- transaction from the rcv_transactions table.
581: OPEN vend_lot_num(p_transaction_id);
582: FETCH vend_lot_num INTO l_vendor_lot_num;
583: CLOSE vend_lot_num;
584:

Line 1662: FROM rcv_transactions

1658: -- Bug 8806035.ntungare
1659: -- Added this cursor and variable for copying the supplier lot number information.
1660: CURSOR vend_lot_num (txn_id NUMBER) IS
1661: SELECT vendor_lot_num
1662: FROM rcv_transactions
1663: WHERE transaction_id = txn_id;
1664:
1665: l_vendor_lot_num VARCHAR2(30) := NULL;
1666:

Line 1687: -- transaction from the rcv_transactions table.

1683: close plan_count_cur;
1684:
1685: -- Bug 8806035.ntungare
1686: -- Added this cursor to fetch the vendor_lot_number of the
1687: -- transaction from the rcv_transactions table.
1688: OPEN vend_lot_num(p_transaction_id);
1689: FETCH vend_lot_num INTO l_vendor_lot_num;
1690: CLOSE vend_lot_num;
1691: