On Maintenance Work Order Page, we need to restrict the DFF based on inventory organisation

Summary: In our project customer has not opted for Projects Module, and they want that while creating maintenance work order in fusion, project number should be populated.

So we have created a DFF on the maintenance work order header as Project Number. We have defined the Lookup values under Manage Common Lookup in Modules=Work Orders(MntWork Orders). All the necessary lookup values have been mapped under Manage Common Lookup.

The DFF is made as a Table based dff.

Now we need to restrict the DFF values based on Inventory Organisation.

Ex:- If there are 4 Project Values under Inventory Org="A" and 2 Project values under "B" inventory org, now we try creating the Maintenance work order under "A" inventory org, the DFF value should show only "A" inventory org project values, it should not show "B" Inventory org project values in the LOV.