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_PROD_ACCT_HEADERS

Line 2458: FROM xla_prod_acct_headers w

2454: , NULL accounting_line_type_code
2455: , NULL accounting_line_code
2456: , NULL mpa_accounting_line_type_code
2457: , NULL mpa_accounting_line_code
2458: FROM xla_prod_acct_headers w
2459: , xla_prod_acct_headers s
2460: WHERE s.application_id = g_application_id
2461: AND s.amb_context_code = g_staging_context_code
2462: AND s.product_rule_type_code = w.product_rule_type_code

Line 2459: , xla_prod_acct_headers s

2455: , NULL accounting_line_code
2456: , NULL mpa_accounting_line_type_code
2457: , NULL mpa_accounting_line_code
2458: FROM xla_prod_acct_headers w
2459: , xla_prod_acct_headers s
2460: WHERE s.application_id = g_application_id
2461: AND s.amb_context_code = g_staging_context_code
2462: AND s.product_rule_type_code = w.product_rule_type_code
2463: AND s.product_rule_code = w.product_rule_code

Line 2643: FROM xla_prod_acct_headers w

2639: , NULL accounting_line_type_code
2640: , NULL accounting_line_code
2641: , NULL mpa_accounting_line_type_code
2642: , NULL mpa_accounting_line_code
2643: FROM xla_prod_acct_headers w
2644: LEFT OUTER JOIN xla_prod_acct_headers s
2645: ON s.amb_context_code = g_staging_context_code
2646: AND s.application_id = g_application_id
2647: AND s.product_rule_type_code = w.product_rule_type_code

Line 2644: LEFT OUTER JOIN xla_prod_acct_headers s

2640: , NULL accounting_line_code
2641: , NULL mpa_accounting_line_type_code
2642: , NULL mpa_accounting_line_code
2643: FROM xla_prod_acct_headers w
2644: LEFT OUTER JOIN xla_prod_acct_headers s
2645: ON s.amb_context_code = g_staging_context_code
2646: AND s.application_id = g_application_id
2647: AND s.product_rule_type_code = w.product_rule_type_code
2648: AND s.product_rule_code = w.product_rule_code

Line 2900: , xla_prod_acct_headers b

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
2904: AND b.product_rule_code = w.product_rule_code

Line 3082: LEFT OUTER JOIN xla_prod_acct_headers s

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
3086: AND s.product_rule_code = w.product_rule_code

Line 3494: FROM xla_prod_acct_headers w

3490: SELECT w.product_rule_type_code
3491: , w.product_rule_code
3492: , w.event_class_code
3493: , w.event_type_code
3494: FROM xla_prod_acct_headers w
3495: , xla_product_rules_b b
3496: WHERE b.application_id = g_application_id
3497: AND b.amb_context_code = g_staging_context_code
3498: AND b.product_rule_type_code = w.product_rule_type_code

Line 3505: FROM xla_prod_acct_headers s

3501: AND w.amb_context_code = g_amb_context_code
3502: AND w.product_rule_type_code = C_OWNER_ORACLE
3503: AND NOT EXISTS (
3504: SELECT 1
3505: FROM xla_prod_acct_headers s
3506: WHERE s.application_id = g_application_id
3507: AND s.amb_context_code = g_staging_context_code
3508: AND s.product_rule_type_code = w.product_rule_type_code
3509: AND s.product_rule_code = w.product_rule_code

Line 4068: , xla_prod_acct_headers b

4064: , w.event_type_code
4065: , w.line_definition_owner_code
4066: , w.line_definition_code
4067: FROM xla_aad_line_defn_assgns w
4068: , xla_prod_acct_headers b
4069: WHERE b.amb_context_code = g_staging_context_code
4070: AND b.application_id = g_application_id
4071: AND b.product_rule_type_code = w.product_rule_type_code
4072: AND b.product_rule_code = w.product_rule_code

Line 7894: , xla_prod_acct_headers b

7890: , s.line_definition_owner_code
7891: , s.line_definition_code
7892: , C_MERGE_IMPACT_NEW merge_impact
7893: FROM xla_aad_line_defn_assgns s
7894: , xla_prod_acct_headers b
7895: WHERE s.application_id = g_application_id
7896: AND s.amb_context_code = g_staging_context_code
7897: AND b.application_id = g_application_id
7898: AND b.amb_context_code = g_amb_context_code

Line 7983: , xla_prod_acct_headers b

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
7987: AND b.amb_context_code = g_amb_context_code

Line 8106: JOIN xla_prod_acct_headers b

8102: ,w.source_type_code w_source_type_code
8103: ,s.source_code s_source_code
8104: ,w.source_code w_source_code
8105: FROM xla_aad_hdr_acct_attrs s
8106: JOIN xla_prod_acct_headers b
8107: ON b.application_id = g_application_id
8108: AND b.amb_context_code = g_amb_context_code
8109: AND b.product_rule_type_code = s.product_rule_type_code
8110: AND b.product_rule_code = s.product_rule_code

Line 8253: FROM xla_prod_acct_headers s

8249: , s.description_type_code s_description_type_code
8250: , w.description_type_code w_description_type_code
8251: , s.description_code s_description_code
8252: , w.description_code w_description_code
8253: FROM xla_prod_acct_headers s
8254: JOIN xla_product_rules_b b
8255: ON b.application_id = g_application_id
8256: AND b.amb_context_code = g_amb_context_code
8257: AND b.product_rule_type_code = s.product_rule_type_code

Line 8259: LEFT OUTER JOIN xla_prod_acct_headers w

8255: ON b.application_id = g_application_id
8256: AND b.amb_context_code = g_amb_context_code
8257: AND b.product_rule_type_code = s.product_rule_type_code
8258: AND b.product_rule_code = s.product_rule_code
8259: LEFT OUTER JOIN xla_prod_acct_headers w
8260: ON w.application_id = g_application_id
8261: AND w.amb_context_code = g_amb_context_code
8262: AND w.product_rule_type_code = s.product_rule_type_code
8263: AND w.product_rule_code = s.product_rule_code

Line 8696: FROM xla_prod_acct_headers h

8692: -- Cursor to return AADs that shares any common component with the AADs that
8693: -- was assigned with the group l_curr_group_num
8694: CURSOR c_aad_group IS
8695: SELECT h.product_rule_type_code, h.product_rule_code
8696: FROM xla_prod_acct_headers h
8697: WHERE h.application_id = g_application_id
8698: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8699: AND EXISTS (SELECT 1
8700: FROM xla_prod_acct_headers pah

Line 8700: FROM xla_prod_acct_headers pah

8696: FROM xla_prod_acct_headers h
8697: WHERE h.application_id = g_application_id
8698: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8699: AND EXISTS (SELECT 1
8700: FROM xla_prod_acct_headers pah
8701: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8702: WHERE pah.application_id = g_application_id
8703: AND pah.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8704: AND pah.description_type_code = h.description_type_code

Line 8740: FROM xla_prod_acct_headers pah

8736: AND h.line_definition_code = xal.line_definition_code
8737: AND h.application_id = g_application_id
8738: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8739: AND EXISTS (SELECT 1
8740: FROM xla_prod_acct_headers pah
8741: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8742: WHERE pah.application_id = g_application_id
8743: AND pah.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8744: AND pah.description_type_code = h.description_type_code