[OAUGNet]-Re: DFF Queries

["Mcpeak, Matthew" <vxsmimmcp@SUBARU.com>]

Don,

Here's a query I had sitting around that might help you.

-- DFF differences
select /*+ FIRST_ROWS */
       dff.descriptive_flexfield_name,
       dff.application_table_name,
       app.application_short_Name app,
       u.descriptive_flex_context_code,
       substr(u.application_column_name,1,12) attribute,
       u.column_seq_num,
       u.end_user_column_name
from   fnd_descr_flex_column_usages u,
       fnd_descriptive_flexs dff,
       fnd_application app
where  u.descriptive_flexfield_name not like '$SRS$.%'
and    dff.descriptive_flexfield_name = u.descriptive_flexfield_name
and    app.application_id = dff.table_application_id
--and dff.application_table_name = 'HZ_CUST_ACCT_SITES_ALL'
--and u.descriptive_flexfield_name = 'RA_ADDRESSES_HZ'
--and   u.application_column_Name like 'ATTRIBUTE%'
--and app.application_short_name not in ('SQLAP','AR')
order by app.application_short_Name, descriptive_flexfield_name,
descriptive_flex_context_code, u.column_seq_num

- Matt

mcpeakm@tempus-consulting-group.com
 

-----Original Message-----
From: OAUG Net listserver [mailto:OAUGNet@oaug.com] On Behalf Of Don
Lastine
Sent: Friday, September 19, 2008 1:01 PM
To: OAUG Net listserver
Subject: [OAUGNet]-DFF Queries

I'm trying to find a way to report on my descriptive flex fields in my
11.5.10.2 instance.

Some way to tie the records in FND_DESCRIPTIVE_FLEXS_VL with the related
segment records in FND_DESCR_FLEX_COL_USAGE_VL.  If you have a way to
throw in a join to the context info, FND_DESCR_FLEX_CONTEXTS_VL, that
would be even better.

I've looked thru the TRM and I'm stuck.  Any help will be appreciated!
========================================================================
======
CONFIDENTIALITY NOTICE: The information in this electronic message
(including any attachments) is confidential and may be privileged or
proprietary.  If you are not the intended recipient, any dissemination,
disclosure, copying, downloading, or other use of the information is
prohibited and unauthorized, and may be unlawful, regardless of address
or routing. If you are not the intended recipient, please inform the
sender immediately and permanently delete and destroy the original and
any copies of this message, including any attachments.
========================================================================
======


#############################################################
This message is sent to you because you are subscribed to the mailing
list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com> To switch to the FEED
mode, send any message to <OAUGNet-feed@oaug.com> To switch to the
DIGEST mode, E-mail to <OAUGNet-digest@oaug.com> To switch to the INDEX
mode, E-mail to <OAUGNet-index@oaug.com> Send administrative queries to
<OAUGNet-request@oaug.com>



#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>