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/
Wednesday, September 2, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment