APPS.INV_LPN_TRX_PUB dependencies on RCV_TRANSACTIONS

Line 1581: FROM rcv_transactions

1577: ELSIF(v_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt) THEN
1578: BEGIN
1579: SELECT shipment_line_id
1580: INTO l_shipment_line_id
1581: FROM rcv_transactions
1582: WHERE transaction_id =v_mmtt.rcv_transaction_id;
1583: EXCEPTION
1584: WHEN NO_DATA_FOUND THEN
1585: IF (l_debug = 1) THEN

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

1582: WHERE transaction_id =v_mmtt.rcv_transaction_id;
1583: EXCEPTION
1584: WHEN NO_DATA_FOUND THEN
1585: IF (l_debug = 1) THEN
1586: inv_log_util.TRACE('no data found rcv_transactions', 'INV_LPN_TRX_PUB', 1);
1587: END IF;
1588:
1589: RAISE fnd_api.g_exc_error;
1590: END;

Line 4468: rcv_transactions_interface rti,mtl_material_transactions_temp mmtt

4464:
4465: IF (v_mmtt.transaction_type_id = 3) THEN
4466:
4467: SELECT Count(1) INTO l_rtv_exist FROM
4468: rcv_transactions_interface rti,mtl_material_transactions_temp mmtt
4469: WHERE rti.interface_transaction_id = mmtt.source_line_id
4470: AND rti.processing_status_code = 'WSH_INTERFACED'
4471: AND rti.group_id = mmtt.transaction_source_name
4472: AND mmtt.transaction_temp_id = v_mmtt.transaction_temp_id ;

Line 5349: SELECT interface_transaction_id FROM rcv_transactions_interface rti,wms_lpn_contents wlc

5345:
5346: -- End of bug 7226314,7355087
5347:
5348: CURSOR c_rtv_exists (p_lpn_id NUMBER ,p_organization_id NUMBER ) IS --RTV Change 16197273
5349: SELECT interface_transaction_id FROM rcv_transactions_interface rti,wms_lpn_contents wlc
5350: WHERE rti.interface_transaction_id = wlc.source_header_id
5351: AND rti.processing_status_code = 'WSH_INTERFACED'
5352: AND rti.to_organization_id = wlc.organization_id
5353: AND wlc.parent_lpn_id = p_lpn_id

Line 5564: FROM rcv_transactions

5560: SELECT interface_transaction_id
5561: , transaction_type
5562: INTO l_rcv_interface_txn_id
5563: , l_rcv_txn_type
5564: FROM rcv_transactions
5565: WHERE transaction_id = p_rcv_transaction_id;
5566: EXCEPTION
5567: WHEN OTHERS THEN
5568: l_rcv_interface_txn_id := NULL;

Line 5892: FROM rcv_transactions

5888: , l_rcv_txn_type
5889: FROM (SELECT interface_transaction_id
5890: , transaction_type
5891: , creation_date
5892: FROM rcv_transactions
5893: WHERE interface_transaction_id = (SELECT interface_transaction_id
5894: FROM rcv_transactions
5895: WHERE transaction_id = p_rcv_transaction_id)
5896: ORDER BY transaction_id DESC)

Line 5894: FROM rcv_transactions

5890: , transaction_type
5891: , creation_date
5892: FROM rcv_transactions
5893: WHERE interface_transaction_id = (SELECT interface_transaction_id
5894: FROM rcv_transactions
5895: WHERE transaction_id = p_rcv_transaction_id)
5896: ORDER BY transaction_id DESC)
5897: WHERE ROWNUM < 2;
5898: --SELECT interface_transaction_id, transaction_type

Line 5900: --FROM rcv_transactions

5896: ORDER BY transaction_id DESC)
5897: WHERE ROWNUM < 2;
5898: --SELECT interface_transaction_id, transaction_type
5899: --INTO l_rcv_interface_txn_id, l_rcv_txn_type
5900: --FROM rcv_transactions
5901: --WHERE transaction_id = p_rcv_transaction_id;
5902: EXCEPTION
5903: WHEN OTHERS THEN
5904: l_rcv_interface_txn_id := NULL;

Line 5914: from rcv_transactions

5910: --stamped on the corresponding RT record.
5911: --p_rcv_transaction_id corresponds to the Return transaction.
5912: select subinventory,locator_id
5913: into l_sub,l_loc_id
5914: from rcv_transactions
5915: where transaction_id = p_rcv_transaction_id;
5916:
5917: IF (p_lpn_id IS NULL
5918: AND p_transfer_lpn_id IS NOT NULL) THEN

Line 6288: FROM rcv_transactions

6284: THEN
6285: BEGIN
6286: SELECT transaction_type
6287: INTO l_rcv_txn_type
6288: FROM rcv_transactions
6289: WHERE transaction_id = p_rcv_transaction_id;
6290: EXCEPTION
6291: WHEN OTHERS THEN
6292: l_rcv_txn_type := NULL;