DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PUB dependencies on MTL_RESERVATIONS

Line 3768: FROM mtl_reservations

3764: END IF;
3765:
3766: SELECT COUNT(1)
3767: INTO l_valid
3768: FROM mtl_reservations
3769: WHERE organization_id = l_organization_id
3770: AND lpn_id = p_lpn_id;
3771:
3772: IF l_valid > 0 THEN

Line 3776: l_table_name := 'MTL_RESERVATIONS';

3772: IF l_valid > 0 THEN
3773: IF l_debug = 1 THEN
3774: mdebug('LPN : '||p_lpn_id||' has existing reservations against it, cannot reuse');
3775: END IF;
3776: l_table_name := 'MTL_RESERVATIONS';
3777: RAISE l_transactions_pending;
3778: END IF;
3779:
3780: SELECT COUNT(1)