DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PUB dependencies on MTL_TRANSACTIONS_INTERFACE

Line 3800: FROM mtl_transactions_interface

3796: END IF;
3797:
3798: SELECT COUNT(1)
3799: INTO l_valid
3800: FROM mtl_transactions_interface
3801: WHERE organization_id = l_organization_id
3802: AND ( lpn_id = p_lpn_id
3803: OR transfer_lpn_id = p_lpn_id
3804: OR content_lpn_id = p_lpn_id

Line 3811: l_table_name := 'MTL_TRANSACTIONS_INTERFACE';

3807: IF l_valid > 0 THEN
3808: IF l_debug = 1 THEN
3809: mdebug('Pending MTI transactions exists against this LPN : '||p_lpn_id||', cannot reuse');
3810: END IF;
3811: l_table_name := 'MTL_TRANSACTIONS_INTERFACE';
3812: RAISE l_transactions_pending;
3813: END IF;
3814:
3815: SELECT COUNT(1)