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 960: FROM xla_acct_line_types_b work

956: IS
957: CURSOR c_all_comps IS
958: SELECT work.event_class_code
959: , work.accounting_line_code
960: FROM xla_acct_line_types_b work
961: WHERE work.application_id = g_application_id
962: AND work.amb_context_code = g_amb_context_code
963: AND work.accounting_line_type_code = C_OWNER_SYSTEM
964: AND NOT EXISTS ( SELECT 1

Line 965: FROM xla_acct_line_types_b stage

961: WHERE work.application_id = g_application_id
962: AND work.amb_context_code = g_amb_context_code
963: AND work.accounting_line_type_code = C_OWNER_SYSTEM
964: AND NOT EXISTS ( SELECT 1
965: FROM xla_acct_line_types_b stage
966: WHERE stage.application_id = g_application_id
967: AND stage.amb_context_code = g_staging_context_code
968: AND stage.event_class_code = work.event_class_code
969: AND stage.accounting_line_type_code = C_OWNER_SYSTEM

Line 1177: DELETE FROM xla_acct_line_types_b w

1173: p_encoded_message => '# xla_jlt_acct_attrs deleted = '||l_num_rows,
1174: p_component_code => 'clean_oracle_jlts');
1175:
1176: FORALL i IN 1..l_codes.COUNT
1177: DELETE FROM xla_acct_line_types_b w
1178: WHERE application_id = g_application_id
1179: AND amb_context_code = g_amb_context_code
1180: AND event_class_code = l_event_class_codes(i)
1181: AND accounting_line_type_code = C_OWNER_SYSTEM

Line 1185: trace(p_msg => '# xla_acct_line_types_b deleted = '||l_num_rows,

1181: AND accounting_line_type_code = C_OWNER_SYSTEM
1182: AND accounting_line_code = l_codes(i);
1183: l_num_rows := SQL%ROWCOUNT;
1184: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1185: trace(p_msg => '# xla_acct_line_types_b deleted = '||l_num_rows,
1186: p_module => l_log_module,
1187: p_level => C_LEVEL_STATEMENT);
1188: END IF;
1189: -- Bug : 9923803

Line 1196: p_encoded_message => '# xla_acct_line_types_b deleted = '||l_num_rows,

1192: p_amb_context_code => g_amb_context_code,
1193: p_application_id => g_application_id,
1194: p_request_code => 'IMPORT' ,
1195: p_log_type_code => 'MERGE',
1196: p_encoded_message => '# xla_acct_line_types_b deleted = '||l_num_rows,
1197: p_component_code => 'clean_oracle_jlts');
1198:
1199: FORALL i IN 1..l_codes.COUNT
1200: DELETE FROM xla_acct_line_types_tl w

Line 2997: FROM xla_acct_line_types_b xal

2993: where mpa_jlt_assgns.application_id = g_application_id
2994: and mpa_jlt_assgns.amb_context_code = g_staging_context_code
2995: AND EXISTS (
2996: SELECT 1
2997: FROM xla_acct_line_types_b xal
2998: WHERE xal.application_id = g_application_id
2999: AND xal.amb_context_code = g_staging_context_code
3000: AND xal.event_class_code = mpa_jlt_assgns.event_class_code
3001: AND xal.accounting_line_type_code = mpa_jlt_assgns.accounting_line_type_code

Line 3081: FROM xla_acct_line_types_b s

3077: and mpa_hdr_ac_assgns1.amb_context_code = g_amb_context_code
3078: and to_char(mpa_hdr_ac_assgns.last_update_date,'DD-MON-YYYY') <> to_char(mpa_hdr_ac_assgns1.last_update_date,'DD-MON-YYYY')
3079: UNION
3080: SELECT 1
3081: FROM xla_acct_line_types_b s
3082: WHERE s.application_id = g_application_id
3083: and s.amb_context_code = g_staging_context_code
3084: and s.event_class_code = mpa_hdr_ac_assgns.event_class_code
3085: and s.accounting_line_type_code = mpa_hdr_ac_assgns.accounting_line_type_code

Line 3104: FROM xla_acct_line_types_b s

3100: and mpa_hdr_ac_assgns.application_id = mpa_hdr_ac_assgns1.application_id
3101: and mpa_hdr_ac_assgns1.amb_context_code = g_amb_context_code
3102: UNION
3103: SELECT 1
3104: FROM xla_acct_line_types_b s
3105: WHERE s.application_id = g_application_id
3106: and s.amb_context_code = g_staging_context_code
3107: and s.event_class_code = mpa_hdr_ac_assgns.event_class_code
3108: and s.accounting_line_type_code = mpa_hdr_ac_assgns.accounting_line_type_code

Line 3163: FROM xla_acct_line_types_b s

3159: AND s.mpa_accounting_line_type_code = mpa_jlt_adr_assgns.mpa_accounting_line_type_code
3160: AND s.mpa_accounting_line_code = mpa_jlt_adr_assgns.mpa_accounting_line_code
3161: UNION
3162: SELECT 1
3163: FROM xla_acct_line_types_b s
3164: WHERE s.application_id = g_application_id
3165: AND s.amb_context_code = g_staging_context_code
3166: AND s.event_class_code = mpa_jlt_adr_assgns.event_class_code
3167: AND s.accounting_line_type_code = mpa_jlt_adr_assgns.accounting_line_type_code

Line 3255: FROM xla_acct_line_types_b s

3251: and mpa_jlt_ac_assgns1.amb_context_code = g_amb_context_code
3252: and to_char(mpa_jlt_ac_assgns.last_update_date,'DD-MON-YYYY') <> to_char(mpa_jlt_ac_assgns1.last_update_date,'DD-MON-YYYY')
3253: UNION
3254: SELECT 1
3255: FROM xla_acct_line_types_b s
3256: WHERE s.application_id = g_application_id
3257: and s.amb_context_code = g_staging_context_code
3258: and s.event_class_code = mpa_jlt_ac_assgns.event_class_code
3259: and s.accounting_line_type_code = mpa_jlt_ac_assgns.accounting_line_type_code

Line 3280: FROM xla_acct_line_types_b s

3276: and mpa_jlt_ac_assgns.application_id = mpa_jlt_ac_assgns1.application_id
3277: and mpa_jlt_ac_assgns1.amb_context_code = g_amb_context_code
3278: UNION
3279: SELECT 1
3280: FROM xla_acct_line_types_b s
3281: WHERE s.application_id = g_application_id
3282: and s.amb_context_code = g_staging_context_code
3283: and s.event_class_code = mpa_jlt_ac_assgns.event_class_code
3284: and s.accounting_line_type_code = mpa_jlt_ac_assgns.accounting_line_type_code

Line 3467: FROM xla_acct_line_types_b xal

3463: WHERE application_id = g_application_id
3464: AND amb_context_code = g_amb_context_code
3465: AND EXISTS (
3466: SELECT 1
3467: FROM xla_acct_line_types_b xal
3468: WHERE xal.application_id = g_application_id -- w.application_id -- changed for bug8635648
3469: AND xal.amb_context_code = g_staging_context_code -- w.amb_context_code -- changed for bug8635648
3470: AND xal.event_class_code = w.event_class_code
3471: AND xal.accounting_line_type_code = w.accounting_line_type_code

Line 3508: FROM xla_acct_line_types_b s

3504: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
3505: AND s.analytical_criterion_code = w.analytical_criterion_code
3506: UNION
3507: SELECT 1
3508: FROM xla_acct_line_types_b s
3509: WHERE s.application_id = g_application_id
3510: AND s.amb_context_code = g_staging_context_code
3511: AND s.event_class_code = w.event_class_code
3512: AND s.accounting_line_type_code = w.accounting_line_type_code

Line 3551: FROM xla_acct_line_types_b s

3547: AND s.mpa_accounting_line_type_code = w.mpa_accounting_line_type_code
3548: AND s.mpa_accounting_line_code = w.mpa_accounting_line_code
3549: UNION
3550: SELECT 1
3551: FROM xla_acct_line_types_b s
3552: WHERE s.application_id = g_application_id
3553: AND s.amb_context_code = g_staging_context_code
3554: AND s.event_class_code = w.event_class_code
3555: AND s.accounting_line_type_code = w.accounting_line_type_code

Line 3594: FROM xla_acct_line_types_b s

3590: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
3591: AND s.analytical_criterion_code = w.analytical_criterion_code
3592: UNION
3593: SELECT 1
3594: FROM xla_acct_line_types_b s
3595: WHERE s.application_id = g_application_id
3596: AND s.amb_context_code = g_staging_context_code
3597: AND s.event_class_code = w.event_class_code
3598: AND s.accounting_line_type_code = w.accounting_line_type_code

Line 3903: 'XLA_ACCT_LINE_TYPES_B'

3899: select entity_code,
3900: event_class_code,
3901: accounting_line_code,
3902: accounting_class_code,
3903: 'XLA_ACCT_LINE_TYPES_B'
3904: from
3905: (select entity_code,
3906: event_class_code,
3907: accounting_line_code,

Line 3909: 'XLA_ACCT_LINE_TYPES_B',

3905: (select entity_code,
3906: event_class_code,
3907: accounting_line_code,
3908: accounting_class_code,
3909: 'XLA_ACCT_LINE_TYPES_B',
3910: amb_context_code,
3911: last_update_date ,
3912: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
3913: from

Line 3918: 'XLA_ACCT_LINE_TYPES_B',

3914: (select entity_code,
3915: event_class_code,
3916: accounting_line_code,
3917: accounting_class_code,
3918: 'XLA_ACCT_LINE_TYPES_B',
3919: amb_context_code,
3920: last_update_date,
3921: lag(last_update_date) over (PARTITION by application_id,
3922: event_class_code,

Line 3927: from xla_acct_line_types_b

3923: accounting_line_code,
3924: accounting_line_type_code
3925: order by amb_context_code
3926: ) lag_date
3927: from xla_acct_line_types_b
3928: order by amb_context_code
3929: ) x
3930: where x.amb_context_code = g_staging_context_code
3931: )

Line 3936: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_acct_line_types_b is :'||l_num_rows,

3932: where flag = 'False';
3933: l_num_rows := SQL%ROWCOUNT;
3934:
3935: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3936: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_acct_line_types_b is :'||l_num_rows,
3937: p_module => l_log_module,
3938: p_level => C_LEVEL_PROCEDURE);
3939: END IF;
3940:

Line 3948: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_acct_line_types_b is :'||l_num_rows,

3944: p_amb_context_code => g_amb_context_code,
3945: p_application_id => g_application_id,
3946: p_request_code => 'IMPORT' ,
3947: p_log_type_code => 'MERGE',
3948: p_encoded_message => 'Number of Rows inserted into aads_gt from xla_acct_line_types_b is :'||l_num_rows,
3949: p_component_code => 'merge_journal_line_types');
3950:
3951: INSERT INTO xla_aads_gt
3952: ( event_class_code

Line 4021: FROM xla_acct_line_types_b s

4017: from xla_conditions condn
4018: where condn.application_id = g_application_id
4019: and condn.amb_context_code = g_staging_context_code
4020: and EXISTS (SELECT 1
4021: FROM xla_acct_line_types_b s
4022: WHERE s.application_id = g_application_id
4023: and s.amb_context_code = g_staging_context_code
4024: and s.event_class_code = condn.event_class_code
4025: and s.accounting_line_type_code = condn.accounting_line_type_code

Line 4077: DELETE FROM xla_acct_line_types_b w

4073: ELSE
4074:
4075: -- Delete the journal line types from the working area if it already
4076: -- exists in the staging area
4077: DELETE FROM xla_acct_line_types_b w
4078: WHERE application_id = g_application_id
4079: AND amb_context_code = g_amb_context_code
4080: AND EXISTS (SELECT 1
4081: FROM xla_acct_line_types_b s

Line 4081: FROM xla_acct_line_types_b s

4077: DELETE FROM xla_acct_line_types_b w
4078: WHERE application_id = g_application_id
4079: AND amb_context_code = g_amb_context_code
4080: AND EXISTS (SELECT 1
4081: FROM xla_acct_line_types_b s
4082: WHERE s.application_id = g_application_id
4083: AND s.amb_context_code = g_staging_context_code
4084: AND s.event_class_code = w.event_class_code
4085: AND s.accounting_line_type_code = w.accounting_line_type_code

Line 4089: trace(p_msg => '# xla_acct_line_types_b delete : '||l_num_rows,

4085: AND s.accounting_line_type_code = w.accounting_line_type_code
4086: AND s.accounting_line_code = w.accounting_line_code);
4087: l_num_rows := SQL%ROWCOUNT;
4088: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4089: trace(p_msg => '# xla_acct_line_types_b delete : '||l_num_rows,
4090: p_module => l_log_module,
4091: p_level => C_LEVEL_STATEMENT);
4092: END IF;
4093: -- Bug : 9923803

Line 4100: p_encoded_message => '# xla_acct_line_types_b delete : '||l_num_rows,

4096: p_amb_context_code => g_amb_context_code,
4097: p_application_id => g_application_id,
4098: p_request_code => 'IMPORT' ,
4099: p_log_type_code => 'MERGE',
4100: p_encoded_message => '# xla_acct_line_types_b delete : '||l_num_rows,
4101: p_component_code => 'merge_journal_line_types');
4102:
4103: DELETE FROM xla_acct_line_types_tl w
4104: WHERE application_id = g_application_id

Line 4160: FROM xla_acct_line_types_b s

4156: DELETE FROM xla_conditions w
4157: WHERE application_id = g_application_id
4158: AND amb_context_code = g_amb_context_code
4159: AND EXISTS (SELECT 1
4160: FROM xla_acct_line_types_b s
4161: WHERE s.application_id = g_application_id
4162: AND s.amb_context_code = g_staging_context_code
4163: AND s.event_class_code = w.event_class_code
4164: AND s.accounting_line_type_code = w.accounting_line_type_code

Line 4184: UPDATE xla_acct_line_types_b

4180: p_component_code => 'merge_journal_line_types');
4181: END IF;
4182:
4183: -- Move the journal line types from staging area to working area
4184: UPDATE xla_acct_line_types_b
4185: SET amb_context_code = g_amb_context_code
4186: WHERE application_id = g_application_id
4187: AND amb_context_code = g_staging_context_code;
4188: l_num_rows := SQL%ROWCOUNT;

Line 4190: trace(p_msg => '# xla_acct_line_types_b updated : '||l_num_rows,

4186: WHERE application_id = g_application_id
4187: AND amb_context_code = g_staging_context_code;
4188: l_num_rows := SQL%ROWCOUNT;
4189: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4190: trace(p_msg => '# xla_acct_line_types_b updated : '||l_num_rows,
4191: p_module => l_log_module,
4192: p_level => C_LEVEL_STATEMENT);
4193: END IF;
4194: -- Bug : 9923803

Line 4201: p_encoded_message => '# xla_acct_line_types_b updated : '||l_num_rows,

4197: p_amb_context_code => g_amb_context_code,
4198: p_application_id => g_application_id,
4199: p_request_code => 'IMPORT' ,
4200: p_log_type_code => 'MERGE',
4201: p_encoded_message => '# xla_acct_line_types_b updated : '||l_num_rows,
4202: p_component_code => 'merge_journal_line_types');
4203:
4204: UPDATE xla_acct_line_types_tl w
4205: SET amb_context_code = g_amb_context_code