SELECT m.SUBSCRIBER_NUMBER, m.CE_NE_TYPE, m.CE_ID
FROM SRD_MPLS_DETAILS_VIEW m
WHERE NOT EXISTS (
SELECT 1 FROM SRD_NE_RELATION_VIEW r
WHERE r.SUBSCRIBER_NUMBER = m.SUBSCRIBER_NUMBER
)
FETCH FIRST 5 ROWS ONLY;

find attached exaple from 84 server it should return same data in staging platform

I have been fetching for a subscriber numer with a trail and active status, but when I go to the Customer report to find the requestID, I can't find any. I tried several subscriber numbers during around 20 minutes.
Better to proceed with SQL Code

What it does: Returns the current network info for a subscriber — access node ID/category, CE type, ..

Bugs fixed:
NullPointerException in ServiceTrailService.getTransferredOspConnection() when a trail hop references a node/port not found in inventory — null checks added.
ORA-01400 in saveRequestLog when requestNo is empty — guard added.

How to test:

Find a valid subscriber from SRD UI -> Subscriber report — pick one with Active status and trails visible.
Call the API with that subscriber number : requestNo must not be empty
Expected response: accessNodeId, accessNodeCategory, ceType, distanceToExchange
Verify in SRD UI: open the subscriber -> trail panel should show the same access node returned by the API
Note: serviceType and bandwidth parameters are accepted but not used by the current implementation.

fix available with version 4.0.0.5

Please provide a sample in Omantel platforms 179 and 84

I retried to test this API, but I can't find in SRD UI where to get the Request ID matching with the subscriber, Service Type and the Bandwidth

No exception was found in the logs.

To get the details, a subscriber number with an existing trail should be provided.