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_LINE_DEFN_AC_ASSGNS

Line 2922: FROM xla_line_defn_ac_assgns w

2918: , w.accounting_line_type_code
2919: , w.accounting_line_code
2920: , NULL
2921: , NULL
2922: FROM xla_line_defn_ac_assgns w
2923: , xla_line_defn_jlt_assgns b
2924: WHERE b.amb_context_code = g_staging_context_code
2925: AND b.application_id = g_application_id
2926: AND b.event_class_code = w.event_class_code

Line 3106: FROM xla_line_defn_ac_assgns w

3102: , w.accounting_line_type_code
3103: , w.accounting_line_code
3104: , NULL
3105: , NULL
3106: FROM xla_line_defn_ac_assgns w
3107: LEFT OUTER JOIN xla_line_defn_jlt_assgns s
3108: ON s.amb_context_code = g_staging_context_code
3109: AND s.event_class_code = w.event_class_code
3110: AND s.event_type_code = w.event_type_code

Line 6481: FROM xla_line_defn_ac_assgns s

6477: , s.accounting_line_code
6478: , s.analytical_criterion_type_code
6479: , s.analytical_criterion_code
6480: , C_MERGE_IMPACT_NEW merge_impact
6481: FROM xla_line_defn_ac_assgns s
6482: , xla_line_defn_jlt_assgns b
6483: WHERE s.application_id = g_application_id
6484: AND s.amb_context_code = g_staging_context_code
6485: AND b.application_id = g_application_id

Line 6495: FROM xla_line_defn_ac_assgns w

6491: AND b.accounting_line_type_code = s.accounting_line_type_code
6492: AND b.accounting_line_code = s.accounting_line_code
6493: AND NOT EXISTS
6494: (SELECT 1
6495: FROM xla_line_defn_ac_assgns w
6496: WHERE w.application_id = g_application_id
6497: AND w.amb_context_code = g_amb_context_code
6498: AND w.event_class_code = s.event_class_code
6499: AND w.event_type_code = s.event_type_code

Line 8804: FROM xla_line_defn_ac_assgns xac

8800: AND xah.product_rule_code = grp.product_rule_code
8801: AND grp.group_num = l_curr_group_num
8802: UNION
8803: SELECT 1
8804: FROM xla_line_defn_ac_assgns xac
8805: ,xla_aad_line_defn_assgns xal
8806: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8807: WHERE xac.analytical_criterion_type_code = h.analytical_criterion_type_code
8808: AND xac.analytical_criterion_code = h.analytical_criterion_code

Line 8822: FROM xla_line_defn_ac_assgns h

8818: AND xal.product_rule_code = grp.product_rule_code
8819: AND grp.group_num = l_curr_group_num)
8820: UNION
8821: SELECT xad.product_rule_type_code, xad.product_rule_code
8822: FROM xla_line_defn_ac_assgns h
8823: ,xla_aad_line_defn_assgns xad
8824: WHERE h.application_id = xad.application_id
8825: AND h.amb_context_code = xad.amb_context_code
8826: AND h.event_class_code = xad.event_class_code

Line 8844: FROM xla_line_defn_ac_assgns xac

8840: AND xah.product_rule_code = grp.product_rule_code
8841: AND grp.group_num = l_curr_group_num
8842: UNION
8843: SELECT 1
8844: FROM xla_line_defn_ac_assgns xac
8845: ,xla_aad_line_defn_assgns xal
8846: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8847: WHERE xac.analytical_criterion_type_code = h.analytical_criterion_type_code
8848: AND xac.analytical_criterion_code = h.analytical_criterion_code