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 6491: FROM xla_line_defn_ac_assgns s

6487: , s.accounting_line_code
6488: , s.analytical_criterion_type_code
6489: , s.analytical_criterion_code
6490: , C_MERGE_IMPACT_NEW merge_impact
6491: FROM xla_line_defn_ac_assgns s
6492: , xla_line_defn_jlt_assgns b
6493: WHERE s.application_id = g_application_id
6494: AND s.amb_context_code = g_staging_context_code
6495: AND b.application_id = g_application_id

Line 6505: FROM xla_line_defn_ac_assgns w

6501: AND b.accounting_line_type_code = s.accounting_line_type_code
6502: AND b.accounting_line_code = s.accounting_line_code
6503: AND NOT EXISTS
6504: (SELECT 1
6505: FROM xla_line_defn_ac_assgns w
6506: WHERE w.application_id = g_application_id
6507: AND w.amb_context_code = g_amb_context_code
6508: AND w.event_class_code = s.event_class_code
6509: AND w.event_type_code = s.event_type_code

Line 8814: FROM xla_line_defn_ac_assgns xac

8810: AND xah.product_rule_code = grp.product_rule_code
8811: AND grp.group_num = l_curr_group_num
8812: UNION
8813: SELECT 1
8814: FROM xla_line_defn_ac_assgns xac
8815: ,xla_aad_line_defn_assgns xal
8816: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8817: WHERE xac.analytical_criterion_type_code = h.analytical_criterion_type_code
8818: AND xac.analytical_criterion_code = h.analytical_criterion_code

Line 8832: FROM xla_line_defn_ac_assgns h

8828: AND xal.product_rule_code = grp.product_rule_code
8829: AND grp.group_num = l_curr_group_num)
8830: UNION
8831: SELECT xad.product_rule_type_code, xad.product_rule_code
8832: FROM xla_line_defn_ac_assgns h
8833: ,xla_aad_line_defn_assgns xad
8834: WHERE h.application_id = xad.application_id
8835: AND h.amb_context_code = xad.amb_context_code
8836: AND h.event_class_code = xad.event_class_code

Line 8854: FROM xla_line_defn_ac_assgns xac

8850: AND xah.product_rule_code = grp.product_rule_code
8851: AND grp.group_num = l_curr_group_num
8852: UNION
8853: SELECT 1
8854: FROM xla_line_defn_ac_assgns xac
8855: ,xla_aad_line_defn_assgns xal
8856: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8857: WHERE xac.analytical_criterion_type_code = h.analytical_criterion_type_code
8858: AND xac.analytical_criterion_code = h.analytical_criterion_code