Home » Applications » Oracle Fusion Apps & E-Business Suite » Queries flexfield segment values
Queries flexfield segment values [message #145526] Thu, 03 November 2005 12:42 Go to next message
parabol64
Messages: 22
Registered: September 2005
Junior Member
Hi all,
I'm new to Oracle Financials.
What I would like to achieve is the following:
A SQL statement that would return all available values for a particular accounting key flexfield segment.
Say the accounting flexfield is Co.Div.Product; I'd like to get all available companies (in GL). Is that at all possible?
Thanks in advance,
g.

Report message to a moderator

Re: Queries flexfield segment values [message #145552 is a reply to message #145526] Thu, 03 November 2005 14:59 Go to previous messageGo to next message
mchittib
Messages: 87
Registered: September 2005
Member
u can query it from FND_ID_FLEX_SEGMENTS

select * from FND_ID_FLEX_SEGMENTS where application_column_name ='SEGMENT1'

u could change which ever segment u want to see

Report message to a moderator

Re: Queries flexfield segment values [message #145561 is a reply to message #145552] Thu, 03 November 2005 16:40 Go to previous messageGo to next message
parabol64
Messages: 22
Registered: September 2005
Junior Member
Thanks.
But would that be Segment1 of the Accounting Flexfield only?
Cause that's what I'm after.
Is there also a way of tying the segment name and the value's description with the result of the query?

g.

Report message to a moderator

Re: Queries flexfield segment values [message #145663 is a reply to message #145561] Fri, 04 November 2005 12:04 Go to previous message
mchittib
Messages: 87
Registered: September 2005
Member
select * from FND_ID_FLEX_SEGMENTS where segment_name='Company'.

Try lo look into tables and decide what column u need.

If you dont find enough inforation in this table, try fnd_id_flex_values as well.

Report message to a moderator

Previous Topic: Export from Form to Excel
Next Topic: Unable to make Required for one of the fields in AdditionalpersonDetails DFF in HR thru Custom.pll
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 07:12:43 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.