Is there any way to find out a particular plant code exists in which all variants in SAP APO(table?)

Dear experts,

I am in urgent need of help. We have new plant replacing old plant. Want to understand which table can provide me the variants / program name where the old plant exists, so that I can replace it with the new code.

Thanks.