If you want to see which plants you currently have global ranking responsibility for and you are using Biotics, here are two ways to do it. In either case, substitute your 2-letter state or province code for XX in the WHERE statement. (Also works for animal records: substitute 'A' for 'P' in WHERE clause.)

Use the following short query if you are sure you do not have any null ELCODES:
SELECT
ELEMENT_GLOBAL.ELEMENT_GLOBAL_ID,
BCD_ET.ELEMENT_SUBNATIONAL_ID,
ELEMENT_GLOBAL.ELCODE_BCD,
BCD_ET.SNAME,
ELEMENT_GLOBAL.G_RANK_RESP

FROM
BCD_ET,
ELEMENT_GLOBAL

WHERE
ELEMENT_GLOBAL.ELCODE_BCD = BCD_ET.ELCODE and ELEMENT_GLOBAL.G_RANK_RESP like '%XX%'
and BCD_ET.NAME_TYPE_CD = 'P'

Use this longer query if you are not sure:
SELECT
ELEMENT_GLOBAL.ELEMENT_GLOBAL_ID,
ELEMENT_SUBNATIONAL.ELEMENT_SUBNATIONAL_ID as EST_ID,
ELEMENT_GLOBAL.ELCODE_BCD,
SCIENTIFIC_NAME.SCIENTIFIC_NAME as SNAME,
ELEMENT_GLOBAL.G_RANK_RESP

FROM
D_NAME_CATEGORY,
ELEMENT_GLOBAL,
SCIENTIFIC_NAME,
ELEMENT_NATIONAL,
ELEMENT_SUBNATIONAL

WHERE
ELEMENT_GLOBAL.ELEMENT_GLOBAL_ID = ELEMENT_NATIONAL.ELEMENT_GLOBAL_ID
and ELEMENT_NATIONAL.ELEMENT_NATIONAL_ID = ELEMENT_SUBNATIONAL.ELEMENT_NATIONAL_ID
and ELEMENT_SUBNATIONAL.SNAME_ID = SCIENTIFIC_NAME.SCIENTIFIC_NAME_ID
and SCIENTIFIC_NAME.D_NAME_CATEGORY_ID = D_NAME_CATEGORY.D_NAME_CATEGORY_ID
and D_NAME_CATEGORY.NAME_TYPE_CD = 'P'
and ELEMENT_GLOBAL.G_RANK_RESP like '%XX%'