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 7884: , xla_prod_acct_headers b

7880: , s.line_definition_owner_code
7881: , s.line_definition_code
7882: , C_MERGE_IMPACT_NEW merge_impact
7883: FROM xla_aad_line_defn_assgns s
7884: , xla_prod_acct_headers b
7885: WHERE s.application_id = g_application_id
7886: AND s.amb_context_code = g_staging_context_code
7887: AND b.application_id = g_application_id
7888: AND b.amb_context_code = g_amb_context_code

Line 7973: , xla_prod_acct_headers b

7969: , s.analytical_criterion_type_code
7970: , s.analytical_criterion_code
7971: , C_MERGE_IMPACT_NEW merge_impact
7972: FROM xla_aad_header_ac_assgns s
7973: , xla_prod_acct_headers b
7974: WHERE s.application_id = g_application_id
7975: AND s.amb_context_code = g_staging_context_code
7976: AND b.application_id = g_application_id
7977: AND b.amb_context_code = g_amb_context_code

Line 8096: JOIN xla_prod_acct_headers b

8092: ,w.source_type_code w_source_type_code
8093: ,s.source_code s_source_code
8094: ,w.source_code w_source_code
8095: FROM xla_aad_hdr_acct_attrs s
8096: JOIN xla_prod_acct_headers b
8097: ON b.application_id = g_application_id
8098: AND b.amb_context_code = g_amb_context_code
8099: AND b.product_rule_type_code = s.product_rule_type_code
8100: AND b.product_rule_code = s.product_rule_code

Line 8243: FROM xla_prod_acct_headers s

8239: , s.description_type_code s_description_type_code
8240: , w.description_type_code w_description_type_code
8241: , s.description_code s_description_code
8242: , w.description_code w_description_code
8243: FROM xla_prod_acct_headers s
8244: JOIN xla_product_rules_b b
8245: ON b.application_id = g_application_id
8246: AND b.amb_context_code = g_amb_context_code
8247: AND b.product_rule_type_code = s.product_rule_type_code

Line 8249: LEFT OUTER JOIN xla_prod_acct_headers w

8245: ON b.application_id = g_application_id
8246: AND b.amb_context_code = g_amb_context_code
8247: AND b.product_rule_type_code = s.product_rule_type_code
8248: AND b.product_rule_code = s.product_rule_code
8249: LEFT OUTER JOIN xla_prod_acct_headers w
8250: ON w.application_id = g_application_id
8251: AND w.amb_context_code = g_amb_context_code
8252: AND w.product_rule_type_code = s.product_rule_type_code
8253: AND w.product_rule_code = s.product_rule_code

Line 8686: FROM xla_prod_acct_headers h

8682: -- Cursor to return AADs that shares any common component with the AADs that
8683: -- was assigned with the group l_curr_group_num
8684: CURSOR c_aad_group IS
8685: SELECT h.product_rule_type_code, h.product_rule_code
8686: FROM xla_prod_acct_headers h
8687: WHERE h.application_id = g_application_id
8688: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8689: AND EXISTS (SELECT 1
8690: FROM xla_prod_acct_headers pah

Line 8690: FROM xla_prod_acct_headers pah

8686: FROM xla_prod_acct_headers h
8687: WHERE h.application_id = g_application_id
8688: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8689: AND EXISTS (SELECT 1
8690: FROM xla_prod_acct_headers pah
8691: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8692: WHERE pah.application_id = g_application_id
8693: AND pah.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8694: AND pah.description_type_code = h.description_type_code

Line 8730: FROM xla_prod_acct_headers pah

8726: AND h.line_definition_code = xal.line_definition_code
8727: AND h.application_id = g_application_id
8728: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8729: AND EXISTS (SELECT 1
8730: FROM xla_prod_acct_headers pah
8731: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8732: WHERE pah.application_id = g_application_id
8733: AND pah.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8734: AND pah.description_type_code = h.description_type_code