DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PUB dependencies on MTL_RESERVATIONS

Line 3846: FROM mtl_reservations

3842: END IF;
3843:
3844: SELECT COUNT(1)
3845: INTO l_valid
3846: FROM mtl_reservations
3847: WHERE organization_id = l_organization_id
3848: AND lpn_id = p_lpn_id;
3849:
3850: IF l_valid > 0 THEN

Line 3854: l_table_name := 'MTL_RESERVATIONS';

3850: IF l_valid > 0 THEN
3851: IF l_debug = 1 THEN
3852: mdebug('LPN : '||p_lpn_id||' has existing reservations against it, cannot reuse');
3853: END IF;
3854: l_table_name := 'MTL_RESERVATIONS';
3855: RAISE l_transactions_pending;
3856: END IF;
3857:
3858: SELECT COUNT(1)