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_PVT dependencies on XLA_ACCT_LINE_TYPES_B

Line 812: FROM xla_acct_line_types_b work

808: IS
809: CURSOR c_all_comps IS
810: SELECT work.event_class_code
811: , work.accounting_line_code
812: FROM xla_acct_line_types_b work
813: WHERE work.application_id = g_application_id
814: AND work.amb_context_code = g_amb_context_code
815: AND work.accounting_line_type_code = C_OWNER_SYSTEM
816: AND NOT EXISTS ( SELECT 1

Line 817: FROM xla_acct_line_types_b stage

813: WHERE work.application_id = g_application_id
814: AND work.amb_context_code = g_amb_context_code
815: AND work.accounting_line_type_code = C_OWNER_SYSTEM
816: AND NOT EXISTS ( SELECT 1
817: FROM xla_acct_line_types_b stage
818: WHERE stage.application_id = g_application_id
819: AND stage.amb_context_code = g_staging_context_code
820: AND stage.event_class_code = work.event_class_code
821: AND stage.accounting_line_type_code = C_OWNER_SYSTEM

Line 958: DELETE FROM xla_acct_line_types_b w

954: p_level => C_LEVEL_STATEMENT);
955: END IF;
956:
957: FORALL i IN 1..l_codes.COUNT
958: DELETE FROM xla_acct_line_types_b w
959: WHERE application_id = g_application_id
960: AND amb_context_code = g_amb_context_code
961: AND event_class_code = l_event_class_codes(i)
962: AND accounting_line_type_code = C_OWNER_SYSTEM

Line 966: trace(p_msg => '# xla_acct_line_types_b deleted = '||SQL%ROWCOUNT,

962: AND accounting_line_type_code = C_OWNER_SYSTEM
963: AND accounting_line_code = l_codes(i);
964:
965: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
966: trace(p_msg => '# xla_acct_line_types_b deleted = '||SQL%ROWCOUNT,
967: p_module => l_log_module,
968: p_level => C_LEVEL_STATEMENT);
969: END IF;
970:

Line 2083: FROM xla_acct_line_types_b xal

2079: WHERE application_id = g_application_id
2080: AND amb_context_code = g_amb_context_code
2081: AND EXISTS (
2082: SELECT 1
2083: FROM xla_acct_line_types_b xal
2084: WHERE xal.application_id = w.application_id
2085: AND xal.amb_context_code = w.amb_context_code
2086: AND xal.event_class_code = w.event_class_code
2087: AND xal.accounting_line_type_code = w.accounting_line_type_code

Line 2115: FROM xla_acct_line_types_b s

2111: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
2112: AND s.analytical_criterion_code = w.analytical_criterion_code
2113: UNION
2114: SELECT 1
2115: FROM xla_acct_line_types_b s
2116: WHERE s.application_id = g_application_id
2117: AND s.amb_context_code = g_staging_context_code
2118: AND s.event_class_code = w.event_class_code
2119: AND s.accounting_line_type_code = w.accounting_line_type_code

Line 2149: FROM xla_acct_line_types_b s

2145: AND s.mpa_accounting_line_type_code = w.mpa_accounting_line_type_code
2146: AND s.mpa_accounting_line_code = w.mpa_accounting_line_code
2147: UNION
2148: SELECT 1
2149: FROM xla_acct_line_types_b s
2150: WHERE s.application_id = g_application_id
2151: AND s.amb_context_code = g_staging_context_code
2152: AND s.event_class_code = w.event_class_code
2153: AND s.accounting_line_type_code = w.accounting_line_type_code

Line 2183: FROM xla_acct_line_types_b s

2179: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
2180: AND s.analytical_criterion_code = w.analytical_criterion_code
2181: UNION
2182: SELECT 1
2183: FROM xla_acct_line_types_b s
2184: WHERE s.application_id = g_application_id
2185: AND s.amb_context_code = g_staging_context_code
2186: AND s.event_class_code = w.event_class_code
2187: AND s.accounting_line_type_code = w.accounting_line_type_code

Line 2384: DELETE FROM xla_acct_line_types_b w

2380: ELSE
2381:
2382: -- Delete the journal line types from the working area if it already
2383: -- exists in the staging area
2384: DELETE FROM xla_acct_line_types_b w
2385: WHERE application_id = g_application_id
2386: AND amb_context_code = g_amb_context_code
2387: AND EXISTS (SELECT 1
2388: FROM xla_acct_line_types_b s

Line 2388: FROM xla_acct_line_types_b s

2384: DELETE FROM xla_acct_line_types_b w
2385: WHERE application_id = g_application_id
2386: AND amb_context_code = g_amb_context_code
2387: AND EXISTS (SELECT 1
2388: FROM xla_acct_line_types_b s
2389: WHERE s.application_id = g_application_id
2390: AND s.amb_context_code = g_staging_context_code
2391: AND s.event_class_code = w.event_class_code
2392: AND s.accounting_line_type_code = w.accounting_line_type_code

Line 2396: trace(p_msg => '# xla_acct_line_types_b delete : '||SQL%ROWCOUNT,

2392: AND s.accounting_line_type_code = w.accounting_line_type_code
2393: AND s.accounting_line_code = w.accounting_line_code);
2394:
2395: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2396: trace(p_msg => '# xla_acct_line_types_b delete : '||SQL%ROWCOUNT,
2397: p_module => l_log_module,
2398: p_level => C_LEVEL_STATEMENT);
2399: END IF;
2400:

Line 2440: FROM xla_acct_line_types_b s

2436: DELETE FROM xla_conditions w
2437: WHERE application_id = g_application_id
2438: AND amb_context_code = g_amb_context_code
2439: AND EXISTS (SELECT 1
2440: FROM xla_acct_line_types_b s
2441: WHERE s.application_id = g_application_id
2442: AND s.amb_context_code = g_staging_context_code
2443: AND s.event_class_code = w.event_class_code
2444: AND s.accounting_line_type_code = w.accounting_line_type_code

Line 2456: UPDATE xla_acct_line_types_b

2452:
2453: END IF;
2454:
2455: -- Move the journal line types from staging area to working area
2456: UPDATE xla_acct_line_types_b
2457: SET amb_context_code = g_amb_context_code
2458: WHERE application_id = g_application_id
2459: AND amb_context_code = g_staging_context_code;
2460:

Line 2462: trace(p_msg => '# xla_acct_line_types_b updated : '||SQL%ROWCOUNT,

2458: WHERE application_id = g_application_id
2459: AND amb_context_code = g_staging_context_code;
2460:
2461: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2462: trace(p_msg => '# xla_acct_line_types_b updated : '||SQL%ROWCOUNT,
2463: p_module => l_log_module,
2464: p_level => C_LEVEL_STATEMENT);
2465: END IF;
2466: