eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_AAD_MERGE_ANALYSIS_PVT dependencies on XLA_MPA_HEADER_AC_ASSGNS

Line 2947: FROM xla_mpa_header_ac_assgns w

2943: , w.accounting_line_type_code
2944: , w.accounting_line_code
2945: , NULL
2946: , NULL
2947: FROM xla_mpa_header_ac_assgns w
2948: , xla_line_defn_jlt_assgns b
2949: WHERE b.amb_context_code = g_staging_context_code
2950: AND b.application_id = g_application_id
2951: AND b.event_class_code = w.event_class_code

Line 3132: FROM xla_mpa_header_ac_assgns w

3128: , w.accounting_line_type_code
3129: , w.accounting_line_code
3130: , NULL
3131: , NULL
3132: FROM xla_mpa_header_ac_assgns w
3133: LEFT OUTER JOIN xla_line_defn_jlt_assgns s
3134: ON s.amb_context_code = g_staging_context_code
3135: AND s.event_class_code = w.event_class_code
3136: AND s.event_type_code = w.event_type_code

Line 6620: FROM xla_mpa_header_ac_assgns s

6616: , s.accounting_line_code
6617: , s.analytical_criterion_type_code
6618: , s.analytical_criterion_code
6619: , C_MERGE_IMPACT_NEW merge_impact
6620: FROM xla_mpa_header_ac_assgns s
6621: , xla_line_defn_jlt_assgns b
6622: WHERE s.application_id = g_application_id
6623: AND s.amb_context_code = g_staging_context_code
6624: AND b.application_id = g_application_id

Line 6634: FROM xla_mpa_header_ac_assgns w

6630: AND b.accounting_line_type_code = s.accounting_line_type_code
6631: AND b.accounting_line_code = s.accounting_line_code
6632: AND NOT EXISTS
6633: (SELECT 1
6634: FROM xla_mpa_header_ac_assgns w
6635: WHERE w.application_id = g_application_id
6636: AND w.amb_context_code = g_amb_context_code
6637: AND w.event_class_code = s.event_class_code
6638: AND w.event_type_code = s.event_type_code