So we end up with...

PlantMaterial_numberProduction_VersionResource_Code

CHANC11C-82600001 APAG

CHANC11C-82600001 SIL

CHANC11C-82610001 APAG

CHANC11C-82610001 SIL

CHANC21E-4440 0002 SIL

LEX11C-82600001 SIL

LEX11C-82610001 APAG

LEX11C-82620001 SIL

LEX11C-82630001 SIL

LEX21E-4440 0001 SIL

So we should end up with:

Plant CHANC

-------------

Resource APAG

From Material To Material

11C-8260 11C-8260

11C-8260 11C-8261

11C-8261 11C-8261

11C-8261 11C-8260

Resource SIL

From Material To Material

11C-8260 11C-8260

11C-8260 11C-8261

11C-8260 21E-4440

11C-8261 11C-8260

11C-8261 11C-8261

11C-8261 21E-4440

21E-4440 11C-8260

21E-4440 11C-8261

21E-4440 21E-4440