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_TRANSFER_PKG dependencies on XLA_AE_LINES

Line 553: , xla_ae_lines xal

549: When xal.accounted_dr is not null Then 'D'
550: Else 'I'
551: END
552: FROM xla_ae_headers xah
553: , xla_ae_lines xal
554: , xla_subledgers xs
555: , gl_period_statuses gps
556: , v$session ses
557: WHERE xal.application_id = xah.application_id

Line 2211: SELECT 1 FROM xla_ae_lines xal

2207: AND accounting_entry_status_code = 'F'
2208: -- added Bug#8691650
2209: AND EXISTS
2210: (
2211: SELECT 1 FROM xla_ae_lines xal
2212: WHERE xah.ae_header_id = xal.ae_header_id
2213: AND xah.application_id = xal.application_id
2214: )
2215: AND EXISTS

Line 2248: SELECT 1 FROM xla_ae_lines xal

2244: AND accounting_entry_status_code = 'F'
2245: -- added Bug#8691650
2246: AND EXISTS
2247: (
2248: SELECT 1 FROM xla_ae_lines xal
2249: WHERE aeh.ae_header_id = xal.ae_header_id
2250: AND aeh.application_id = xal.application_id
2251: )
2252: AND EXISTS

Line 2283: SELECT 1 FROM xla_ae_lines xal

2279: AND accounting_entry_status_code = 'F'
2280: -- added Bug#8691650
2281: AND EXISTS
2282: (
2283: SELECT 1 FROM xla_ae_lines xal
2284: WHERE aeh.ae_header_id = xal.ae_header_id
2285: AND aeh.application_id = xal.application_id
2286: )
2287: AND EXISTS

Line 2318: SELECT 1 FROM xla_ae_lines xal

2314: AND accounting_entry_status_code = 'F'
2315: -- added Bug#8691650
2316: AND EXISTS
2317: (
2318: SELECT 1 FROM xla_ae_lines xal
2319: WHERE aeh.ae_header_id = xal.ae_header_id
2320: AND aeh.application_id = xal.application_id
2321: )
2322: AND EXISTS

Line 2397: SELECT 1 FROM xla_ae_lines xal

2393: AND aeh.gl_transfer_status_code = ''N''
2394: AND aeh.accounting_entry_status_code = ''F''
2395: AND EXISTS
2396: (
2397: SELECT 1 FROM xla_ae_lines xal
2398: WHERE aeh.ae_header_id = xal.ae_header_id
2399: AND aeh.application_id = xal.application_id
2400: )
2401: AND EXISTS

Line 2709: ,xla_ae_lines ael

2705: ,ael.ae_line_num
2706: ,ael.accounted_dr
2707: ,ael.accounted_cr
2708: FROM xla_ae_headers aeh
2709: ,xla_ae_lines ael
2710: ,gl_je_categories jc
2711: ,gl_period_statuses gps
2712: ,gl_ledgers led
2713: WHERE ael.application_id = aeh.application_id