Can we add a new fields for the additional columns provided in the sold_to_contact lov in oracle app
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||' ,')||