SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE my_table (
  BPA_NUMBER VARCHAR(10),
  BU VARCHAR(2),
  LINE_NUM INT,
  ITEM_CODE VARCHAR(10),
  ORG_CODE VARCHAR(10),
  STATUS VARCHAR(10)
);

INSERT INTO my_table (BPA_NUMBER, BU, LINE_NUM, ITEM_CODE, ORG_CODE, STATUS)
VALUES ('ES_01', 'ES', 2357, '10032', 'CH_112', 'Active'),
       ('ES_01', 'ES', 2357, '10032', 'CH_112', 'Inactive'),
       ('ES_01', 'ES', 2357, '10032', 'ES_112', 'Active'),
       ('ES_01', 'ES', 2357, '10032', 'ES_112_SVM', 'Active'),
       ('ES_01', 'ES', 2357, '10032', 'ITEM', 'Active'),
       ('ES_01', 'ES', 2357, '10032', 'PT_112', 'Active'),
       ('ES_01', 'ES', 2357, '10032', 'PT_112_SVM', 'Inactive'),
       ('PT_01', 'PT', 9534, '10032', 'CH_112', 'Active'),
       ('PT_01', 'PT', 9534, '10032', 'ES_112', 'Active'),
       ('PT_01', 'PT', 9534, '10032', 'ES_112_SVM', 'Active'),
       ('PT_01', 'PT', 9534, '10032', 'ITEM', 'Active'),
       ('PT_01', 'PT', 9534, '10032', 'PT_112', 'Active'),
       ('PT_01', 'PT', 9534, '10032', 'PT_112_SVM', 'Inactive'),
       ('PT_01', 'PT', 9534, '10032', 'PT_112', 'Inactive');

select * from my_table;

--DROP TABLE my_table;

BPA_NUMBER	BU	LINE_NUM	ITEM_CODE	ORG_CODE	STATUS
ES_01	ES	2357	10032	CH_112	Active
ES_01	ES	2357	10032	CH_112	Inactive
ES_01	ES	2357	10032	ES_112	Active
ES_01	ES	2357	10032	ES_112_SVM	Active
ES_01	ES	2357	10032	ITEM	Active
ES_01	ES	2357	10032	PT_112	Active
ES_01	ES	2357	10032	PT_112_SVM	Inactive
PT_01	PT	9534	10032	CH_112	Active
PT_01	PT	9534	10032	ES_112	Active
PT_01	PT	9534	10032	ES_112_SVM	Active
PT_01	PT	9534	10032	ITEM	Active
PT_01	PT	9534	10032	PT_112	Active
PT_01	PT	9534	10032	PT_112_SVM	Inactive
PT_01	PT	9534	10032	PT_112	Inactive