APPS.RCV_WSH_INTERFACE_PKG dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 147: DELETE FROM mtl_transaction_lots_temp

143: WHEN OTHERS THEN NULL;
144: END;
145: --
146: BEGIN
147: DELETE FROM mtl_transaction_lots_temp
148: WHERE product_transaction_id = p_bkup_rti_id;
149:
150: IF (g_asn_debug = 'Y') THEN
151: asn_debug.put_line('DELETED MTLT');

Line 512: FROM mtl_transaction_lots_temp

508: ) IS
509:
510: CURSOR lot_cursor IS
511: SELECT *
512: FROM mtl_transaction_lots_temp
513: WHERE transaction_temp_id = p_interface_txn_id;
514:
515: l_progress VARCHAR2(3);
516: rti_rec RCV_TRANSACTIONS_INTERFACE%ROWTYPE;

Line 2355: FROM mtl_transaction_lots_temp mtlt

2351: mtlt.attribute12,
2352: mtlt.attribute13,
2353: mtlt.attribute14,
2354: mtlt.attribute15
2355: FROM mtl_transaction_lots_temp mtlt
2356: WHERE mtlt.transaction_temp_id (+) = p_wdd_rec.source_line_id
2357: AND mtlt.lot_number = p_wdd_rec.lot_number;
2358:
2359: l_lot_inserted := TRUE;