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_JEFILPIP_XMLP_PKG dependencies on AP_INVOICES_ALL

Line 589: AP_INVOICES_ALL PP

585: MAX(ID.ACCOUNTING_DATE) INVPP_GL_DATE
586: FROM
587: AP_INVOICE_DISTRIBUTIONS_ALL ID,
588: AP_INVOICE_DISTRIBUTIONS_ALL PPD,
589: AP_INVOICES_ALL PP
590: WHERE ID.INVOICE_ID = P_INVOICE_ID
591: AND ( ( ID.LINE_TYPE_LOOKUP_CODE = 'PREPAY'
592: AND ID.PREPAY_DISTRIBUTION_ID = PPD.INVOICE_DISTRIBUTION_ID ) )
593: AND PPD.INVOICE_ID = PP.INVOICE_ID

Line 607: AP_INVOICES_ALL PP

603: FROM
604: AP_INVOICE_DISTRIBUTIONS_ALL ID,
605: AP_INVOICE_DISTRIBUTIONS_ALL PPD,
606: AP_INVOICE_DISTRIBUTIONS_ALL AID,
607: AP_INVOICES_ALL PP
608: WHERE ID.INVOICE_ID = P_INVOICE_ID
609: AND ID.LINE_TYPE_LOOKUP_CODE = 'TAX'
610: AND AID.LINE_TYPE_LOOKUP_CODE = 'PREPAY'
611: AND ID.PREPAY_TAX_PARENT_ID = AID.INVOICE_DISTRIBUTION_ID