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;