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_BALANCES_CALC_PKG dependencies on XLA_LEDGER_RELATIONSHIPS_V

Line 230: , xla_ledger_relationships_v xlr

226: , g_accounting_batch_array
227: FROM xla_ae_headers xah
228: , xla_ae_lines xal
229: , gl_period_statuses gps
230: , xla_ledger_relationships_v xlr
231: WHERE xah.application_id = p_application_id
232: AND xah.ledger_id = p_ledger_id
233: AND xah.ae_header_id = xal.ae_header_id
234: AND xah.application_id = xal.application_id

Line 536: , xla_ledger_relationships_v xlr

532: , xla_ae_line_acs acs
533: , xla_analytical_hdrs_b xbh
534: , gl_period_statuses gps
535: , xla_ledger_options xlo
536: , xla_ledger_relationships_v xlr
537: $bal_concurrency$
538: WHERE aeh.application_id = :'||l_summary_bind_count||'
539: AND aeh.accounting_entry_status_code = ''F''
540: AND aeh.balance_type_code = ''A''

Line 991: , xla_ledger_relationships_v xlr

987: ,xla_analytical_hdrs_b xbh --Bug13498442
988: , gl_code_combinations gcc --Bug13498442
989: , xla_ac_bal_interim_gt tmp
990: , xla_ledger_options xlo
991: , xla_ledger_relationships_v xlr
992: WHERE gps.effective_period_num <= xlo.effective_period_num
993: AND gps.effective_period_num >= tmp.effective_period_num
994: AND gps.closing_status IN ('O', 'C', 'P')
995: AND gps.adjustment_period_flag = 'N'

Line 1269: , xla_ledger_relationships_v xlr

1265: FROM xla_ac_bal_interim_gt temp
1266: , xla_analytical_hdrs_b xbh
1267: , gl_code_combinations gcc
1268: , gl_period_statuses gps
1269: , xla_ledger_relationships_v xlr
1270: WHERE xlr.ledger_id = temp.ledger_id
1271: AND gps.ledger_id = DECODE(xlr.ledger_category_code,''ALC''
1272: ,xlr.primary_ledger_id , temp.ledger_id)
1273: AND gps.effective_period_num = temp.effective_period_num

Line 1374: , xla_ledger_relationships_v xlr

1370: FROM xla_ae_headers aeh
1371: , xla_ae_lines ael
1372: , gl_period_statuses gps
1373: , xla_ledger_options xlo
1374: , xla_ledger_relationships_v xlr
1375: $bal_concurrency$
1376: WHERE aeh.accounting_entry_status_code = ''F''
1377: AND aeh.application_id = :'||l_processed_bind_count||'
1378: AND aeh.ledger_id = xlr.ledger_id

Line 1636: , xla_ledger_relationships_v xlr

1632: FROM xla_ae_headers aeh
1633: , xla_ae_lines ael
1634: , gl_period_statuses gps
1635: , xla_ledger_options xlo
1636: , xla_ledger_relationships_v xlr
1637: $bal_concurrency$
1638: WHERE aeh.application_id = :'||l_summary_bind_count||'
1639: AND aeh.accounting_entry_status_code = ''F''
1640: AND aeh.balance_type_code = ''A''

Line 2036: , xla_ledger_relationships_v xlr

2032: , gps.period_year
2033: FROM gl_period_statuses gps
2034: , xla_ctrl_bal_interim_gt tmp
2035: , xla_ledger_options xlo
2036: , xla_ledger_relationships_v xlr
2037: WHERE gps.effective_period_num <= xlo.effective_period_num
2038: AND gps.effective_period_num >= tmp.effective_period_num
2039: AND gps.closing_status IN ('O', 'C', 'P')
2040: AND gps.adjustment_period_flag = 'N'

Line 2261: , xla_ledger_relationships_v xlr

2257: , '||g_prog_id||'
2258: , '||g_req_id||'
2259: FROM xla_ctrl_bal_interim_gt temp
2260: , gl_period_statuses gps
2261: , xla_ledger_relationships_v xlr
2262: WHERE xlr.ledger_id = temp.ledger_id
2263: AND gps.ledger_id = DECODE(xlr.ledger_category_code, ''ALC''
2264: ,xlr.primary_ledger_id , xlr.ledger_id)
2265: AND gps.effective_period_num = temp.effective_period_num

Line 2345: , xla_ledger_relationships_v xlr

2341: FROM xla_ae_headers aeh
2342: , xla_ae_lines ael
2343: , gl_period_statuses gps
2344: , xla_ledger_options xlo
2345: , xla_ledger_relationships_v xlr
2346: $bal_concurrency$
2347: WHERE aeh.accounting_entry_status_code = ''F''
2348: AND aeh.application_id = :'||l_processed_bind_count||'
2349: AND aeh.balance_type_code = ''A''

Line 2656: ,xla_ledger_relationships_v xlr

2652: AND gps.adjustment_period_flag = ''N''
2653: )gps_effective_period_num
2654: , xlo.ledger_id
2655: FROM xla_ledger_options xlo
2656: ,xla_ledger_relationships_v xlr
2657: WHERE xlr.ledger_id = '||p_ledger_id || '
2658: AND xlo.ledger_id = DECODE(xlr.ledger_category_code , ''ALC''
2659: ,xlr.primary_ledger_id, xlr.ledger_id)
2660: AND xlo.application_id = '||p_application_id||'

Line 2677: ,xla_ledger_relationships_v xlr

2673: AND gps.adjustment_period_flag = ''N''
2674: )gps_effective_period_num
2675: , xlo.ledger_id
2676: FROM xla_ledger_options xlo
2677: ,xla_ledger_relationships_v xlr
2678: ,xla_ae_headers xah
2679: WHERE xlo.ledger_id = DECODE(xlr.ledger_category_code , ''ALC''
2680: ,xlr.primary_ledger_id, xlr.ledger_id)
2681: AND xlo.application_id = '||p_application_id||'

Line 3099: from xla_ledger_relationships_v

3095: , xla_ac_balances bal
3096: , gl_code_combinations gcc
3097: , xla_analytical_hdrs_b xbh
3098: , (select ledger_id
3099: from xla_ledger_relationships_v
3100: where (ledger_category_code IN ('PRIMARY','ALC')
3101: and primary_ledger_id = p_ledger_id)
3102: or (ledger_category_code = 'SECONDARY'
3103: and ledger_id = p_ledger_id)

Line 3243: from xla_ledger_relationships_v

3239: ,g_req_id
3240: FROM gl_period_statuses gps
3241: , xla_control_balances bal
3242: ,(select ledger_id
3243: from xla_ledger_relationships_v
3244: where (ledger_category_code IN ('PRIMARY','ALC')
3245: and primary_ledger_id = p_ledger_id)
3246: or (ledger_category_code = 'SECONDARY'
3247: and ledger_id = p_ledger_id)

Line 3467: FROM xla_ledger_relationships_v xlr

3463: )
3464: WHERE ledger_id in
3465: (
3466: SELECT ledger_id
3467: FROM xla_ledger_relationships_v xlr
3468: WHERE (xlr.primary_ledger_id = p_ledger_id OR ledger_id = p_ledger_id)
3469: AND xlr.relationship_enabled_flag = 'Y'
3470: AND xlr.ledger_category_code IN('ALC', 'PRIMARY', 'SECONDARY')
3471: )

Line 3488: FROM xla_ledger_relationships_v xlr

3484: WHERE effective_period_num is null
3485: AND ledger_id in
3486: (
3487: SELECT ledger_id
3488: FROM xla_ledger_relationships_v xlr
3489: WHERE (xlr.primary_ledger_id = p_ledger_id OR ledger_id = p_ledger_id)
3490: AND xlr.relationship_enabled_flag = 'Y'
3491: AND xlr.ledger_category_code IN('ALC', 'PRIMARY', 'SECONDARY')
3492: );

Line 3516: FROM xla_ledger_relationships_v xlr

3512: WHERE effective_period_num is null
3513: AND ledger_id in
3514: (
3515: SELECT ledger_id
3516: FROM xla_ledger_relationships_v xlr
3517: WHERE (xlr.primary_ledger_id = p_ledger_id OR ledger_id = p_ledger_id)
3518: AND xlr.relationship_enabled_flag = 'Y'
3519: AND xlr.ledger_category_code IN('ALC', 'PRIMARY', 'SECONDARY')
3520: );

Line 3554: FROM xla_ledger_relationships_v xlr

3550: SET effective_period_num = l_effective_period_num
3551: WHERE ledger_id in
3552: (
3553: SELECT ledger_id
3554: FROM xla_ledger_relationships_v xlr
3555: WHERE (xlr.primary_ledger_id = p_ledger_id OR ledger_id = p_ledger_id)
3556: AND xlr.relationship_enabled_flag = 'Y'
3557: AND xlr.ledger_category_code IN('ALC', 'PRIMARY', 'SECONDARY')
3558: )

Line 3586: FROM xla_ledger_relationships_v xlr

3582: WHERE effective_period_num is null
3583: AND ledger_id in
3584: (
3585: SELECT ledger_id
3586: FROM xla_ledger_relationships_v xlr
3587: WHERE (xlr.primary_ledger_id = p_ledger_id OR ledger_id = p_ledger_id)
3588: AND xlr.relationship_enabled_flag = 'Y'
3589: AND xlr.ledger_category_code IN('ALC', 'PRIMARY', 'SECONDARY')
3590: );

Line 3614: FROM xla_ledger_relationships_v xlr

3610: WHERE effective_period_num is null
3611: AND ledger_id in
3612: (
3613: SELECT ledger_id
3614: FROM xla_ledger_relationships_v xlr
3615: WHERE (xlr.primary_ledger_id = p_ledger_id OR ledger_id = p_ledger_id)
3616: AND xlr.relationship_enabled_flag = 'Y'
3617: AND xlr.ledger_category_code IN('ALC', 'PRIMARY', 'SECONDARY')
3618: );