Order Management - EBS (MOSC)

MOSC Banner

Can we add a new fields for the additional columns provided in the sold_to_contact lov in oracle app

edited Nov 15, 2017 4:00AM in Order Management - EBS (MOSC) 2 commentsAnswered

Hi,

Can we add new fields(example phone area code and phone number) to the additional columns provided in the sold_to_contact lov in oracle apps 11i.

Form name : OEXOEORD.fmb

LOV: SOLD_TO_CONTACT

Record group query in the seeded form is given below

OEXOEORD.fmb (11i)-->

LOV  - SOLD_TO_CONTACT

Record Group - SOLD_TO_CONTACT

select con.name name,

       con.contact_id,

       con.job_title,

       con.email_address,

       ar.meaning,

       loc.address1,

       loc.address2,

       loc.address3,

       loc.address4,

       decode(loc.city,null,null,loc.city||' ,')||

       decode(loc.state,null,null,loc.state||' ,')||

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