Presentation variables(obiee)::
SELECT * FROM OEFG_ORDER_HEADERS WHERE HEADER_ID = '@{PP_HEADER_ID}'
Multiple::
IN (@{PP_HEADER_ID}['@']{'1023'})
Title Dianamically::
INVENTORY (@{PV_SUBINVENTORY_NAME}['@']{'013'})
SELECT * FROM OEFG_ORDER_HEADERS WHERE HEADER_ID = '@{PP_HEADER_ID}'
Multiple::
IN (@{PP_HEADER_ID}['@']{'1023'})
Title Dianamically::
INVENTORY (@{PV_SUBINVENTORY_NAME}['@']{'013'})