Requirement for Dynamic Dependent DFF Values Based on Site Selection in Oracle Fusion

We have two Descriptive Flexfield (DFF) fields:

1. Site DFF (First DFF): This field has two possible values:
   a. San Salvo
   b. At Supplier
2. Building DFF (Second DFF): This field is dependent on the selection made in the Site DFF.

Current Setup:

1. When the user selects San Salvo in the Site DFF, the Building DFF is populated with a fixed dependent value set.
2. When the user selects At Supplier in the Site DFF, the Building DFF currently remains empty (null).

New Requirement:

1. For "San Salvo": The current logic (fixed value set) will remain unchanged.
2. For "At Supplier": We need to implement a SQL query that pulls all active suppliers from the database when "At Supplier" is selected in the Site DFF.