BI Publisher (MOSC)

MOSC Banner

How to Bring Category Name into PO Output for Communication

edited Aug 5, 2014 2:34AM in BI Publisher (MOSC) 4 commentsAnswered

Dear Experts,

I have a requirement like to print the category name in the PO  Output For Communication.

the standard xml has only category_id, my question is how to bring category name to the xml

so it can be used in the rtf to print the category at the line level [Highlighted as below,].

<LINES_ROW>

   <LINE_NUM>3</LINE_NUM>

   <ITEM_DESCRIPTION>items needed are plugs for toen hall , tools for intsalation and wire for the wall, alarm for windows</ITEM_DESCRIPTION>

   <CANCEL_FLAG>N</CANCEL_FLAG>

   <UNIT_MEAS_LOOKUP_CODE>Each</UNIT_MEAS_LOOKUP_CODE>

   <ORDER_TYPE_LOOKUP_CODE>QUANTITY</ORDER_TYPE_LOOKUP_CODE>

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