Sunday, July 31, 2011

To Find Column

select
AA.TABLE_TYPE,
AA.TABLE_NAME,
AA.COLUMN_NAME,
--aa.FLEXFIELD_NAME,
decode(AA.FLEXFIELD_NAME, null, AA.DESCRIPTION, bb.form_left_prompt) as DESCRIPTION,
AA.COLUMN_SEQUENCE,
AA.COLUMN_TYPE,
AA.WIDTH,
AA.NULL_ALLOWED_FLAG,
AA.DEFAULT_VALUE
from

(select B.TABLE_TYPE,
B.TABLE_NAME,
A.COLUMN_NAME,
A.COLUMN_SEQUENCE,
A.COLUMN_TYPE,
A.WIDTH,
A.NULL_ALLOWED_FLAG,
A.DESCRIPTION,
A.FLEXFIELD_NAME,
a.flexfield_usage_code,
a.flexfield_application_id,
a.flex_value_set_application_id,
a.flex_value_set_id,
A.DEFAULT_VALUE
from
FND_COLUMNS A,
Fnd_Tables B
WHERE
A.TABLE_ID = B.TABLE_ID
AND B.TABLE_NAME = 'OE_ORDER_LINES_ALL') aa,
------------------
(select c.DESCRIPTIVE_FLEXFIELD_NAME,
c.application_column_name,
c.form_left_prompt,
-- c.descriptive_flex_context_code,
c.form_above_prompt
from Fnd_Descr_Flex_Col_Usage_Tl c, FND_DESCR_FLEX_CONTEXTS_TL d
WHERE c.DESCRIPTIVE_FLEXFIELD_NAME = d.DESCRIPTIVE_FLEXFIELD_NAME
AND c.DESCRIPTIVE_FLEX_CONTEXT_CODE =
d.DESCRIPTIVE_FLEX_CONTEXT_CODE
and c.application_id=d.application_id
AND c.LANGUAGE = d.LANGUAGE
AND c.LANGUAGE = 'JA'
-- and substr(c.descriptive_flex_context_code,4,2)='AR'
) bb

where
aa.column_name = bb.application_column_name(+)
and aa.FLEXFIELD_NAME = bb.descriptive_flexfield_name(+)
order by
AA.COLUMN_SEQUENCE

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect