[Home] [Help]
215: , xas.source_type_code
216: , xas.source_code
217: FROM xla_analytical_sources xas
218: , xla_aad_header_ac_assgns xah
219: , xla_analytical_hdrs_b xahb
220: WHERE xas.analytical_criterion_code = xah.analytical_criterion_code
221: AND xas.analytical_criterion_type_code = xah.analytical_criterion_type_code
222: AND xas.amb_context_code = xah.amb_context_code
223: AND xas.analytical_criterion_code = xahb.analytical_criterion_code
541: 'MEANING','Y'
542: ,'N')
543: , xaht.name
544: FROM xla_aad_header_ac_assgns xah
545: , xla_analytical_hdrs_b xahb
546: , xla_analytical_hdrs_tl xaht
547: WHERE xah.analytical_criterion_code = xahb.analytical_criterion_code
548: AND xah.analytical_criterion_type_code = xahb.analytical_criterion_type_code
549: AND xah.amb_context_code = xahb.amb_context_code
911: 'MEANING','Y'
912: ,'N')
913: , xaht.name
914: FROM xla_mpa_header_ac_assgns xmhc
915: , xla_analytical_hdrs_b xahb
916: , xla_analytical_hdrs_tl xaht
917: WHERE xahb.analytical_criterion_code = xaht.analytical_criterion_code (+)
918: AND xahb.analytical_criterion_type_code = xaht.analytical_criterion_type_code(+)
919: AND xahb.amb_context_code = xaht.amb_context_code (+)
1058: 'MEANING','Y'
1059: ,'N')
1060: , xaht.name
1061: FROM xla_mpa_jlt_ac_assgns xmlc
1062: , xla_analytical_hdrs_b xahb
1063: , xla_analytical_hdrs_tl xaht
1064: WHERE xahb.analytical_criterion_code = xaht.analytical_criterion_code (+)
1065: AND xahb.analytical_criterion_type_code = xaht.analytical_criterion_type_code(+)
1066: AND xahb.amb_context_code = xaht.amb_context_code (+)
1206: 'MEANING','Y'
1207: ,'N')
1208: , xaht.name
1209: FROM xla_line_defn_ac_assgns xlda
1210: , xla_analytical_hdrs_b xahb
1211: , xla_analytical_hdrs_tl xaht
1212: WHERE xahb.analytical_criterion_code = xaht.analytical_criterion_code (+)
1213: AND xahb.analytical_criterion_type_code = xaht.analytical_criterion_type_code (+)
1214: AND xahb.amb_context_code = xaht.amb_context_code (+)