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.JA_CN_SR_EXPORT_PKG dependencies on STANDARD

Line 71: AND pv.EMPLOYEE_ID IS NULL --'Standard Supplier' only

67: PV.SEGMENT1) AS Supplier_Number
68: ,VENDOR_NAME AS Supplier_Name, VENDOR_NAME AS Supplier_Short_Name
69: FROM PO_VENDORS pv, AP_INVOICES_ALL ai
70: WHERE pv.VENDOR_ID = ai.VENDOR_ID
71: AND pv.EMPLOYEE_ID IS NULL --'Standard Supplier' only
72: AND ai.LEGAL_ENTITY_ID = pn_legal_entity_id --LEGAL_ENTITY_ID
73: AND to_char(ai.GL_DATE,'YYYY') = pv_accounting_year --Accounting Year
74: AND AP_INVOICES_PKG.GET_APPROVAL_STATUS( ai.INVOICE_ID,
75: ai.INVOICE_AMOUNT, ai.PAYMENT_STATUS_FLAG,ai.INVOICE_TYPE_LOOKUP_CODE) IN