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

Line 213: AND (aia.invoice_type_lookup_code IN ('CREDIT','DEBIT','STANDARD','AWT','EXPENSE REPORT','MIXED')

209: AND gcc.code_combination_id = xal.code_combination_id
210: AND gcc.code_combination_id = p_in_code_comb_id
211: AND ((PRPMT_PROCESSING_PARAM = 2)
212: OR (PRPMT_PROCESSING_PARAM = 1
213: AND (aia.invoice_type_lookup_code IN ('CREDIT','DEBIT','STANDARD','AWT','EXPENSE REPORT','MIXED')
214: OR (aia.invoice_type_lookup_code = 'PREPAYMENT'
215: AND (CASE WHEN asps.recon_accounting_flag='Y'
216: THEN ac.cleared_date
217: WHEN asps.recon_accounting_flag='N'

Line 223: --for standard invoice

219: EXCEPTION
220: WHEN NO_DATA_FOUND THEN
221: gn_open_payment_balance:=0;
222: END;
223: --for standard invoice
224: BEGIN
225: SELECT SUM(NVL(xal.accounted_cr,0)-NVL(xal.accounted_dr,0))
226: INTO gn_open_invoice_balance
227: FROM ap_invoices ai

Line 239: AND ai.invoice_type_lookup_code IN ('CREDIT','DEBIT','STANDARD','AWT','EXPENSE REPORT','MIXED')

235: AND ai.org_id = p_in_orgs_id
236: AND ai.vendor_site_id = p_in_sup_site_id
237: AND ai.invoice_currency_code = p_in_curr
238: AND ai.gl_date < PERIOD_START_DATE_PARAM
239: AND ai.invoice_type_lookup_code IN ('CREDIT','DEBIT','STANDARD','AWT','EXPENSE REPORT','MIXED')
240: AND xte.source_id_int_1 = ai.invoice_id
241: AND xte.application_id = 200
242: AND xe.application_id = 200
243: AND xah.application_id = 200