Bind Variable needed for Requisition Line DFF for Item Number
Summary:
Need to pass the Item Number as a bind variable ( :{PARAMETER.ITEM_NUMBER} is not working) in a DFF (POR_REQUISITION_LINES)
Does anyone know how to achieve this?
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
25B
Code Snippet (add any code snippets that support your topic, if applicable):
select distinct
SINV.INVENTORY_ITEM_ID,
SINV.ORGANIZATION_ID,
SINV.SECONDARY_INVENTORY,
SINV.SOURCE_ORGANIZATION_ID,
ITEM.ITEM_NUMBER,
ORGS.NAME as Organisation_Name
from INV_ITEM_SUB_INVENTORIES SINV,
EGP_SYSTEM_ITEMS ITEM,
HR_ORGANIZATION_UNITS_F_TL ORGS