Default Item Number on PO Line DFF

Summary:

Hello Experts,

We are looking to create a Mandatory DFF requiring users to associate an Item to their Expense Lines. To make things easier we would like to default the Item Number in the DFF, in case it is an Inventory PO

I have used the ItemId Parameter available for PO_LINES, however am not able to default the Item Number.

Has anyone achieved this successfully?

I've selected Default type=SQL and entered the codes below individually with no luck:

1. select item_number from egp_system_items_b where inventory_item_id =:{PARAMETER.ItemId}
2. select po.item_description from po_lines_all po where po.ITEM_ID =:{PARAMETER.ItemId}