SELECT B.APPLICATION_ID "APPLICATION ID",
l.APPLICATION_NAME "APPLICATION NAME",
T.TITLE "TITLE",
T.FORM_CONTEXT_PROMPT "CONTEXT PROMPT",
CB.DESCRIPTIVE_FLEX_CONTEXT_CODE "D.F CONTEXT CODE",
AB.END_USER_COLUMN_NAME "COLUMN NAME",
AB.APPLICATION_COLUMN_NAME
FROM FND_DESCRIPTIVE_FLEXS_TL T,
FND_DESCRIPTIVE_FLEXS B,
fnd_application_vl L,
FND_DESCR_FLEX_CONTEXTS_TL CT,
FND_DESCR_FLEX_CONTEXTS CB,
FND_DESCR_FLEX_COLUMN_USAGES AB
WHERE 1 =1
AND B.APPLICATION_ID = T.APPLICATION_ID
AND cb.APPLICATION_ID =B.APPLICATION_ID
AND CB.APPLICATION_ID = CT.APPLICATION_ID
AND ab.APPLICATION_ID =B.APPLICATION_ID
AND B.DESCRIPTIVE_FLEXFIELD_NAME = T.DESCRIPTIVE_FLEXFIELD_NAME
AND CB.DESCRIPTIVE_FLEXFIELD_NAME = B.DESCRIPTIVE_FLEXFIELD_NAME
AND AB.DESCRIPTIVE_FLEXFIELD_NAME = B.DESCRIPTIVE_FLEXFIELD_NAME
AND CB.DESCRIPTIVE_FLEXFIELD_NAME = CT.DESCRIPTIVE_FLEXFIELD_NAME
AND CB.DESCRIPTIVE_FLEX_CONTEXT_CODE = CT.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND CB.DESCRIPTIVE_FLEX_CONTEXT_CODE = AB.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND CT.LANGUAGE = USERENV('LANG')
AND B.APPLICATION_ID = l.APPLICATION_ID
AND T.LANGUAGE = userenv('LANG')
--AND B.APPLICATION_ID = 201 -- this is used for testing purpose (PO)
AND T.TITLE NOT LIKE '$%'
AND CB.DESCRIPTIVE_FLEXFIELD_NAME NOT LIKE '$%' -- to exclude Standard DFF's
AND AB.DESCRIPTIVE_FLEXFIELD_NAME NOT LIKE '$%' -- to exclude Standard DFF's
and upper(AB.APPLICATION_COLUMN_NAME) like '%ATTRIBUTE13%'
ORDER BY B.APPLICATION_ID,
l.APPLICATION_NAME,
T.TITLE,
CB.DESCRIPTIVE_FLEX_CONTEXT_CODE,
aB.COLUMN_SEQ_NUM;