DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PUB dependencies on MTL_TRANSACTIONS_INTERFACE

Line 3722: FROM mtl_transactions_interface

3718: END IF;
3719:
3720: SELECT COUNT(1)
3721: INTO l_valid
3722: FROM mtl_transactions_interface
3723: WHERE organization_id = l_organization_id
3724: AND ( lpn_id = p_lpn_id
3725: OR transfer_lpn_id = p_lpn_id
3726: OR content_lpn_id = p_lpn_id

Line 3733: l_table_name := 'MTL_TRANSACTIONS_INTERFACE';

3729: IF l_valid > 0 THEN
3730: IF l_debug = 1 THEN
3731: mdebug('Pending MTI transactions exists against this LPN : '||p_lpn_id||', cannot reuse');
3732: END IF;
3733: l_table_name := 'MTL_TRANSACTIONS_INTERFACE';
3734: RAISE l_transactions_pending;
3735: END IF;
3736:
3737: SELECT COUNT(1)