SELECT c.*
FROM apps.fnd_descriptive_flexs_vl a,
apps.fnd_descr_flex_contexts_vl b,
apps.fnd_descr_flex_col_usage_vl c
WHERE title = 'Receiving Transactions'
AND a.descriptive_flexfield_name = b.descriptive_flexfield_name
AND b.descriptive_flex_context_code = 'Global Data Elements'
AND c.descriptive_flexfield_name = b.descriptive_flexfield_name
AND b.descriptive_flex_context_code = c.descriptive_flex_context_code
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10359218/viewspace-703298/,如需转载,请注明出处,否则将追究法律责任。