APPS.XLA_AE_LINES_PKG dependencies on GL_LEDGERS

Line 6161: gl_ledgers gl,

6157:
6158: SELECT max(glp.start_date)
6159: INTO l_max_first_open_period
6160: FROM gl_period_statuses glp,
6161: gl_ledgers gl,
6162: gl_ledger_relationships glr
6163: WHERE glp.period_name = gl.first_ledger_period_name
6164: AND glp.ledger_id = gl.ledger_id
6165: AND glp.application_id = 101

Line 6211: FROM xla_ae_lines_gt gt1, gl_ledgers gll

6207:
6208:
6209: FOR c_not_reversed_entries IN
6210: (SELECT DISTINCT gt1.event_id, gt1.ledger_id
6211: FROM xla_ae_lines_gt gt1, gl_ledgers gll
6212: WHERE gt1.reversal_code = 'DUMMY_LR'
6213: AND gll.ledger_id = gt1.ledger_id
6214: AND gll.ledger_category_code <> 'PRIMARY'
6215: AND NOT EXISTS (SELECT 1

Line 7716: FROM xla_ae_lines_gt gt1, gl_ledgers gll

7712:
7713:
7714: FOR c_not_reversed_entries IN
7715: (SELECT DISTINCT gt1.event_id, gt1.ledger_id
7716: FROM xla_ae_lines_gt gt1, gl_ledgers gll
7717: WHERE gt1.reversal_code = 'DUMMY_TR'
7718: AND gll.ledger_id = gt1.ledger_id
7719: AND gll.ledger_category_code <> 'PRIMARY'
7720: AND NOT EXISTS (SELECT 1

Line 10102: ,gl_ledgers gl

10098: ,decode( fc2.derive_type, 'EURO', 'EURO', 'EMU',
10099: decode( sign( trunc(nvl(xal.currency_conversion_date, xeg.transaction_date)) -
10100: trunc(fc2.derive_effective)), -1, 'OTHER', 'EMU'), 'OTHER' ) primary_type
10101: FROM xla_ae_lines_gt xal
10102: ,gl_ledgers gl
10103: ,fnd_currencies fc
10104: ,fnd_currencies fc1
10105: ,fnd_currencies fc2
10106: ,xla_events_gt xeg

Line 11216: gl_ledgers gl

11212: /*+ NO_MERGE LEADING(gl) USE_HASH(xal) */
11213: xal.ae_header_id ,
11214: xal.ledger_id
11215: FROM xla_ae_lines_gt xal ,
11216: gl_ledgers gl
11217: WHERE xal.reversal_code IS NULL
11218: AND xal.balance_type_code <> 'X'
11219: AND xal.ledger_id = gl.ledger_id
11220: GROUP BY xal.ae_header_id ,

Line 11628: -- ,xla_gl_ledgers_v xgl

11624: ,xla_ae_lines xal
11625: --Added for bug 12379106
11626: ,xla_events xe
11627: -- ,xla_ledger_relationships_v xlr
11628: -- ,xla_gl_ledgers_v xgl
11629: -- ,xla_ledger_options xlo
11630: WHERE xah.application_id = xdl.application_id
11631: AND xah.ae_header_id = xdl.ae_header_id
11632: -- Bug 8250875 join headers to lines also

Line 11741: ,gl_ledgers gl

11737: ,xte.entity_id xte_entity_id
11738: ,xte.entity_code
11739: FROM xla_ae_lines_gt xal
11740: ,fnd_application_vl fav
11741: ,gl_ledgers gl
11742: ,gl_period_statuses glp
11743: ,xla_transaction_entities_upg xte
11744: WHERE ((reversal_code = C_DUMMY_PRIOR
11745: AND NVL(bflow_prior_entry_status_code,'X') = 'X') -- 5132302

Line 12123: , xla_gl_ledgers_v xgl -- 4478604

12119: , xla_ae_headers xah
12120: , xla_distribution_links xdl
12121: , xla_ae_lines xal
12122: , xla_ledger_relationships_v xlr -- 4478604
12123: , xla_gl_ledgers_v xgl -- 4478604
12124: , xla_ledger_options xlo -- 5204178
12125: WHERE xgl.ledger_id = xalg.ledger_id -- 4478604
12126: AND xlr.ledger_id = xgl.ledger_id -- 4478604
12127: AND xte.application_id = xalg.bflow_application_id

Line 12732: ,gl_ledgers gl

12728: -- Get the start_date of the Primary ledger
12729: SELECT glp.start_date
12730: INTO l_primary_start_date
12731: FROM gl_period_statuses glp
12732: ,gl_ledgers gl
12733: WHERE glp.period_name = gl.first_ledger_period_name
12734: AND glp.ledger_id = gl.ledger_id
12735: AND glp.application_id = 101
12736: AND gl.ledger_id = p_ledger_id;

Line 12998: ,xla_gl_ledgers_v xlr

12994: ,'N')
12995: ,'N') -- 5443083
12996: FROM xla_ae_lines_gt l
12997: ,xla_ae_headers_gt h
12998: ,xla_gl_ledgers_v xlr
12999: WHERE (reversal_code = C_DUMMY_SAME
13000: OR reversal_code = C_MPA_SAME_ENTRY) -- 4655713b
13001: AND l.ae_header_id = h.ae_header_id
13002: AND l.ledger_id = h.ledger_id -- 5443083