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_AAD_HEADER_AC_ASSGNS

Line 2899: FROM xla_aad_header_ac_assgns w

2895: , NULL accounting_line_type_code
2896: , NULL accounting_line_code
2897: , NULL mpa_accounting_line_type_code
2898: , NULL mpa_accounting_line_code
2899: FROM xla_aad_header_ac_assgns w
2900: , xla_prod_acct_headers b
2901: WHERE b.amb_context_code = g_staging_context_code
2902: AND b.application_id = g_application_id
2903: AND b.product_rule_type_code = w.product_rule_type_code

Line 3081: FROM xla_aad_header_ac_assgns w

3077: , NULL accounting_line_type_code
3078: , NULL accounting_line_code
3079: , NULL mpa_accounting_line_type_code
3080: , NULL mpa_accounting_line_code
3081: FROM xla_aad_header_ac_assgns w
3082: LEFT OUTER JOIN xla_prod_acct_headers s
3083: ON s.amb_context_code = g_staging_context_code
3084: AND s.application_id = g_application_id
3085: AND s.product_rule_type_code = w.product_rule_type_code

Line 7982: FROM xla_aad_header_ac_assgns s

7978: , s.event_type_code
7979: , s.analytical_criterion_type_code
7980: , s.analytical_criterion_code
7981: , C_MERGE_IMPACT_NEW merge_impact
7982: FROM xla_aad_header_ac_assgns s
7983: , xla_prod_acct_headers b
7984: WHERE s.application_id = g_application_id
7985: AND s.amb_context_code = g_staging_context_code
7986: AND b.application_id = g_application_id

Line 7994: FROM xla_aad_header_ac_assgns w

7990: AND b.event_class_code = s.event_class_code
7991: AND b.event_type_code = s.event_type_code
7992: AND NOT EXISTS
7993: (SELECT 1
7994: FROM xla_aad_header_ac_assgns w
7995: WHERE w.application_id = g_application_id
7996: AND w.amb_context_code = g_amb_context_code
7997: AND w.product_rule_type_code = s.product_rule_type_code
7998: AND w.product_rule_code = s.product_rule_code

Line 8799: FROM xla_aad_header_ac_assgns h

8795: AND xad.product_rule_code = grp.product_rule_code
8796: AND grp.group_num = l_curr_group_num)
8797: UNION
8798: SELECT h.product_rule_type_code, h.product_rule_code
8799: FROM xla_aad_header_ac_assgns h
8800: WHERE h.application_id = g_application_id
8801: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8802: AND EXISTS (SELECT 1
8803: FROM xla_aad_header_ac_assgns xah

Line 8803: FROM xla_aad_header_ac_assgns xah

8799: FROM xla_aad_header_ac_assgns h
8800: WHERE h.application_id = g_application_id
8801: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8802: AND EXISTS (SELECT 1
8803: FROM xla_aad_header_ac_assgns xah
8804: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8805: WHERE xah.analytical_criterion_type_code = h.analytical_criterion_type_code
8806: AND xah.analytical_criterion_code = h.analytical_criterion_code
8807: AND xah.application_id = g_application_id

Line 8843: FROM xla_aad_header_ac_assgns xah

8839: AND h.line_definition_code = xad.line_definition_code
8840: AND xad.application_id = g_application_id
8841: AND xad.amb_context_code = g_amb_context_code
8842: AND EXISTS (SELECT 1
8843: FROM xla_aad_header_ac_assgns xah
8844: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8845: WHERE xah.analytical_criterion_type_code = h.analytical_criterion_type_code
8846: AND xah.analytical_criterion_code = h.analytical_criterion_code
8847: AND xah.amb_context_code IN (g_amb_context_code,g_staging_context_code)