APPS.INV_LPN_TRX_PUB dependencies on RCV_TRANSACTIONS

Line 1364: FROM rcv_transactions

1360: ELSIF(v_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt) THEN
1361: BEGIN
1362: SELECT shipment_line_id
1363: INTO l_shipment_line_id
1364: FROM rcv_transactions
1365: WHERE transaction_id =v_mmtt.rcv_transaction_id;
1366: EXCEPTION
1367: WHEN NO_DATA_FOUND THEN
1368: IF (l_debug = 1) THEN

Line 1369: inv_log_util.TRACE('no data found rcv_transactions', 'INV_LPN_TRX_PUB', 1);

1365: WHERE transaction_id =v_mmtt.rcv_transaction_id;
1366: EXCEPTION
1367: WHEN NO_DATA_FOUND THEN
1368: IF (l_debug = 1) THEN
1369: inv_log_util.TRACE('no data found rcv_transactions', 'INV_LPN_TRX_PUB', 1);
1370: END IF;
1371:
1372: RAISE fnd_api.g_exc_error;
1373: END;

Line 4992: FROM rcv_transactions

4988: SELECT interface_transaction_id
4989: , transaction_type
4990: INTO l_rcv_interface_txn_id
4991: , l_rcv_txn_type
4992: FROM rcv_transactions
4993: WHERE transaction_id = p_rcv_transaction_id;
4994: EXCEPTION
4995: WHEN OTHERS THEN
4996: l_rcv_interface_txn_id := NULL;

Line 5259: FROM rcv_transactions

5255: , l_rcv_txn_type
5256: FROM (SELECT interface_transaction_id
5257: , transaction_type
5258: , creation_date
5259: FROM rcv_transactions
5260: WHERE interface_transaction_id = (SELECT interface_transaction_id
5261: FROM rcv_transactions
5262: WHERE transaction_id = p_rcv_transaction_id)
5263: ORDER BY transaction_id DESC)

Line 5261: FROM rcv_transactions

5257: , transaction_type
5258: , creation_date
5259: FROM rcv_transactions
5260: WHERE interface_transaction_id = (SELECT interface_transaction_id
5261: FROM rcv_transactions
5262: WHERE transaction_id = p_rcv_transaction_id)
5263: ORDER BY transaction_id DESC)
5264: WHERE ROWNUM < 2;
5265: --SELECT interface_transaction_id, transaction_type

Line 5267: --FROM rcv_transactions

5263: ORDER BY transaction_id DESC)
5264: WHERE ROWNUM < 2;
5265: --SELECT interface_transaction_id, transaction_type
5266: --INTO l_rcv_interface_txn_id, l_rcv_txn_type
5267: --FROM rcv_transactions
5268: --WHERE transaction_id = p_rcv_transaction_id;
5269: EXCEPTION
5270: WHEN OTHERS THEN
5271: l_rcv_interface_txn_id := NULL;

Line 5281: from rcv_transactions

5277: --stamped on the corresponding RT record.
5278: --p_rcv_transaction_id corresponds to the Return transaction.
5279: select subinventory,locator_id
5280: into l_sub,l_loc_id
5281: from rcv_transactions
5282: where transaction_id = p_rcv_transaction_id;
5283:
5284: IF (p_lpn_id IS NULL
5285: AND p_transfer_lpn_id IS NOT NULL) THEN

Line 5578: FROM rcv_transactions

5574: THEN
5575: BEGIN
5576: SELECT transaction_type
5577: INTO l_rcv_txn_type
5578: FROM rcv_transactions
5579: WHERE transaction_id = p_rcv_transaction_id;
5580: EXCEPTION
5581: WHEN OTHERS THEN
5582: l_rcv_txn_type := NULL;