Technology Stack - EBS (MOSC)

MOSC Banner

Perosnalization Multiple values concatenation error

edited Aug 20, 2021 10:52AM in Technology Stack - EBS (MOSC) 17 commentsAnswered ✓

Hi

I am trying to personzalize field's prompt text

and the value that i use in Value section is:

=SELECT

TO_CHAR(round(

XX_GET_ITEMS_MISC_QTY_PACKAGE.ITEM_QTY_ONHAND_FUNCTION

(:ORDER.SHIP_FROM,

:LINE.SUBINVENTORY,

:LINE.INVENTORY_ITEM_ID,

:LINE.ORDER_QUANTITY_UOM

)

-

XX_GET_ITEMS_MISC_QTY_PACKAGE.ITEM_QTY_RESERVED_FUNCTION

(:ORDER.SHIP_FROM,

:LINE.SUBINVENTORY,

:LINE.INVENTORY_ITEM_ID,

:LINE.ORDER_QUANTITY_UOM

)

,5))available_qty

FROM DUAL

it works fine but i want to concatenate it with 'carton' for example to be like the blue

=SELECT

TO_CHAR(round(

XX_GET_ITEMS_MISC_QTY_PACKAGE.ITEM_QTY_ONHAND_FUNCTION

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center