Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE ALPHA (
"SMS" VARCHAR2(40), 
"PGM" VARCHAR2(200), 
"PN" VARCHAR2(200),
"TEAM" VARCHAR2(200),
"NUM" VARCHAR2(200)
);


BEGIN
Insert into ALPHA values ('0','N','AAAAA','R2D2','2350');
Insert into ALPHA values ('1','R','BBBBB','R2D2','2351');
Insert into ALPHA values ('2','L','BBBBB','R2D2','2350');
Insert into ALPHA values ('3','L','CCCCC','R2D2','2350');
Insert into ALPHA values ('4','L','DDDDD','R2D2','2350');
Insert into ALPHA values ('5','L','EEEEE','R2D2','2350');
Insert into ALPHA values ('6','L','FFFFF','R2D2','2350');
Insert into ALPHA values ('7','L','GGGGG','R2D2','2350');
Insert into ALPHA values ('8','N','DDDDD','R2D2','2350');
Insert into ALPHA values ('9','N','CCCCC','R2D2','2350');
Insert into ALPHA values ('10','P','EEEEE','R2D2','2350');
Insert into ALPHA values ('11','N','EEEEE','R2D2','2350');
Insert into ALPHA values ('12','L','HHHHH','R2D2','2350');
Insert into ALPHA values ('13','L','IIIII','R2D2','2350');
Insert into ALPHA values ('14','R','FFFFF','R2D2','2351');
Insert into ALPHA values ('15','R','DDDDD','R2D2','2351');
Insert into ALPHA values ('16','N','JJJJJ','R2D2','2350');
Insert into ALPHA values ('17','N','KKKKK','R2D2','2350');
Insert into ALPHA values ('18','N','HHHHH','R2D2','2350');
Insert into ALPHA values ('19','N','LLLLL','R2D2','2350');
Insert into ALPHA values ('20','N','MMMMM','R2D2','2350');
Insert into ALPHA values ('21','L','NNNNN','R2D2','2350');
Insert into ALPHA values ('22','N','BBBBB','R2D2','2350');
Insert into ALPHA values ('23','L','OOOOO','R2D2','2350');
Insert into ALPHA values ('24','N','FFFFF','R2D2','2350');
Insert into ALPHA values ('25','R','EEEEE','R2D2','2351');
Insert into ALPHA values ('26','L','PPPPP','R2D2','2350');
Insert into ALPHA values ('27','L','QQQQQ','R2D2','2350');
Insert into ALPHA values ('28','N','RRRRR','R2D2','2350');
Insert into ALPHA values ('29','N','PPPPP','R2D2','2350');
Insert into ALPHA values ('30','N','QQQQQ','R2D2','2350');
Insert into ALPHA values ('31','N','SSSSS','R2D2','2333');
Insert into ALPHA values ('32','R','CCCCC','R2D2','2351');
Insert into ALPHA values ('33','N','OOOOO','R2D2','2350');
END;
/
1 rows affected

CREATE TYPE char_list IS TABLE OF CHAR(1);
SELECT sms, pgm, pn, team, num
FROM   (
  SELECT a.*,
         COUNT(
           DISTINCT
           CASE WHEN PGM MEMBER OF char_list('N', 'L') THEN PGM END
         ) OVER (PARTITION BY PN) AS cnt_match,
         COUNT(
           CASE WHEN PGM NOT MEMBER OF char_list('N', 'L') THEN 1 END
         ) OVER (PARTITION BY PN) AS cnt_other
  FROM   ALPHA a
  WHERE  PN   LIKE 'BB%'
  AND    NUM  = '2350'
  AND    TEAM = 'R2D2'
)
WHERE cnt_match = CARDINALITY( char_list('N', 'L') )
AND   cnt_other = 0
ORDER BY PN ASC;


SMS
PGM
PN
TEAM
NUM


2
L
BBBBB
R2D2
2350

22
N
BBBBB
R2D2
2350


SELECT sms, pgm, pn, team, num
FROM   (
  SELECT a.*,
         COUNT(
           DISTINCT
           CASE WHEN PGM MEMBER OF char_list('N', 'L') THEN PGM END
         ) OVER (PARTITION BY PN) AS cnt_match,
         COUNT(
           CASE WHEN PGM NOT MEMBER OF char_list('N', 'L') THEN 1 END
         ) OVER (PARTITION BY PN) AS cnt_other
  FROM   ALPHA a
  WHERE  PN   LIKE '%'
  AND    NUM  = '2350'
  AND    TEAM = 'R2D2'
)
WHERE cnt_match = CARDINALITY( char_list('N', 'L') )
AND   cnt_other = 0
ORDER BY PN ASC;


SMS
PGM
PN
TEAM
NUM


2
L
BBBBB
R2D2
2350

22
N
BBBBB
R2D2
2350

3
L
CCCCC
R2D2
2350

9
N
CCCCC
R2D2
2350

4
L
DDDDD
R2D2
2350

8
N
DDDDD
R2D2
2350

6
L
FFFFF
R2D2
2350

24
N
FFFFF
R2D2
2350

12
L
HHHHH
R2D2
2350

18
N
HHHHH
R2D2
2350

23
L
OOOOO
R2D2
2350

33
N
OOOOO
R2D2
2350

26
L
PPPPP
R2D2
2350

29
N
PPPPP
R2D2
2350

27
L
QQQQQ
R2D2
2350

30
N
QQQQQ
R2D2
2350


WITH match_values (value) AS (
  SELECT 'N' FROM DUAL UNION ALL
  SELECT 'L' FROM DUAL
)
SELECT sms, pgm, pn, team, num
FROM   (
  SELECT a.*,
         COUNT(
           DISTINCT
           CASE WHEN PGM IN (SELECT value FROM match_values) THEN PGM END
         ) OVER (PARTITION BY PN) AS cnt_match,
         COUNT(
           CASE WHEN PGM NOT IN (SELECT value FROM match_values) THEN 1 END
         ) OVER (PARTITION BY PN) AS cnt_other
  FROM   ALPHA a
  WHERE  PN   LIKE 'BB%'
  AND    NUM  = '2350'
  AND    TEAM = 'R2D2'
)
WHERE cnt_match = (SELECT COUNT(*) FROM match_values)
AND   cnt_other = 0
ORDER BY PN ASC;


SMS
PGM
PN
TEAM
NUM


2
L
BBBBB
R2D2
2350

22
N
BBBBB
R2D2
2350
SMS	PGM	PN	TEAM	NUM
2	L	BBBBB	R2D2	2350
22	N	BBBBB	R2D2	2350
3	L	CCCCC	R2D2	2350
9	N	CCCCC	R2D2	2350
4	L	DDDDD	R2D2	2350
8	N	DDDDD	R2D2	2350
6	L	FFFFF	R2D2	2350
24	N	FFFFF	R2D2	2350
12	L	HHHHH	R2D2	2350
18	N	HHHHH	R2D2	2350
23	L	OOOOO	R2D2	2350
33	N	OOOOO	R2D2	2350
26	L	PPPPP	R2D2	2350
29	N	PPPPP	R2D2	2350
27	L	QQQQQ	R2D2	2350
30	N	QQQQQ	R2D2	2350