Wednesday, September 2, 2009

Flexfield

Some interesting querys regardless flexfield:

select APPLICATION_ID,ID_FLEX_CODE,ID_FLEX_NAME from FND_ID_FLEXS;
 return information about flexfield stored in our eBS.



select fdftl.title,

fdf.application_table_name
from apps.fnd_descriptive_flexs fdf,
apps.fnd_descriptive_flexs_tl fdftl
where fdf.descriptive_flexfield_name=
fdftl.descriptive_flexfield_name
and fdf.application_id='101'
and fdftl.title not like '$SRS$%'
order by fdftl.title;


order by fdftl.title;return information about flexfield about Oracle General Ledger- application ID 101 and not show information form flexfield used with SRC.

Information extracted from this:
http://www.jiltin.com/index.php/oracle-applications/11i-scripts/oracle-applications-key-flex-field-structures-how-to-retrieve-information/

No comments:

Post a Comment