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.JE_IL_TAX_PKG dependencies on XLA_AE_HEADERS

Line 609: xla_ae_headers xlah

605: AND a.accounting_date >= pd_start_date
606: AND a.accounting_date <= pd_end_date
607: AND a.reversal_inv_pmt_id IS NULL) aip,
608: xla_ae_lines xdln ,
609: xla_ae_headers xlah
610: WHERE aip.accounting_event_id = xlah.event_id
611: AND xlah.application_id = xdln.application_id
612: AND xlah.ae_header_id = xdln.ae_header_id
613: AND xlah.ledger_id = p_ledger_id

Line 630: xla_ae_headers xlah

626: AND a.accounting_date >= pd_start_date
627: AND a.accounting_date <= pd_end_date
628: AND a.reversal_inv_pmt_id IS NOT NULL) aip,
629: xla_ae_lines xdln ,
630: xla_ae_headers xlah
631: WHERE aip.accounting_event_id = xlah.event_id
632: AND xlah.application_id = xdln.application_id
633: AND xlah.ae_header_id = xdln.ae_header_id
634: AND xlah.ledger_id = p_ledger_id

Line 644: xla_ae_headers xlah ,

640: CURSOR c_get_payevent_awt(cn_invoice_id NUMBER, cn_event_id NUMBER) IS
641: SELECT xlah.event_id event,
642: SUM(nvl(xdln.unrounded_accounted_cr,0)) - SUM(nvl(xdln.unrounded_accounted_dr,0)) pay_amount --modified for bug10262743
643: FROM xla_ae_lines xdln,
644: xla_ae_headers xlah ,
645: ap_invoice_payments_all aip
646: WHERE aip.invoice_id = cn_invoice_id
647: AND aip.check_id = pn_check_id
648: AND aip.accounting_event_id = cn_event_id

Line 679: xla_ae_headers xlah

675: -- SUM(xdln.unrounded_accounted_dr) pay_amount Commented for bug 10279386
676: SUM(nvl(xdln.unrounded_accounted_dr,0)) - SUM(nvl(xdln.unrounded_accounted_cr,0)) pay_amount --modified for bug10279386
677: FROM ap_invoice_distributions_all aid ,
678: xla_distribution_links xdln,
679: xla_ae_headers xlah
680: WHERE aid.invoice_id = cn_invoice_id
681: AND aid.line_type_lookup_code = 'AWT'
682: AND xlah.application_id = xdln.application_id
683: AND xdln.event_id = aid.accounting_event_id

Line 770: xla_ae_headers xlah

766: BEGIN
767: SELECT SUM(xdln.unrounded_accounted_dr) INTO ln_invoice_amount
768: FROM ap_invoice_distributions_all aid ,
769: xla_distribution_links xdln,
770: xla_ae_headers xlah
771: WHERE aid.invoice_id = ln_invoice_id
772: AND aid.line_type_lookup_code <> 'AWT'
773: AND xdln.event_id = aid.accounting_event_id
774: AND xdln.unrounded_accounted_dr IS NOT NULL