ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1643869E053B46B63588994 SELECT pv.vendor_name c_vendor_name, upper(pv.vendor_name) c_upper_vendor_name, cons.consolidated_invoice_id c_consolidated_invoice_id, cons.vendor_id c_cons_vendor_id, cons.invoice_num c_cons_invoice_num, cons.invoice_amount c_cons_invoice_amount, cons.invoice_date c_cons_invoice_date, cons.description c_cons_description, inv.invoice_id c_invoice_id, inv.vendor_id c_inv_vendor_id, inv.invoice_num c_invoice_num, inv.invoice_date c_invoice_date, nvl(inv.invoice_amount,0) - nvl(inv.amount_paid,0) - nvl(inv.discount_amount_taken,0) c_amount_rem, inv.description c_description, inv.invoice_type_lookup_code c_invoice_type, substr(inv.invoice_currency_code,1,4) c_currency_code FROM jl_br_ap_consolid_invoices cons, ap_invoices inv, po_vendors pv WHERE cons.vendor_id = pv.vendor_id AND cons.consolidated_invoice_id = inv.global_attribute10 AND cons.cancelled_date IS NULL &LP_start_date_predicate &LP_end_date_predicate &C_created_by_predicate ORDER BY inv.invoice_currency_code, upper(pv.vendor_name), cons.invoice_num asc Y JL JLBRPCIR_XML US JL Brazilian Payables Consolidated Invoice Register - draft Application: Latin America Localizations Source: Brazilian Payables Consolidated Invoice Register (XML) - Not Supported: Reserved For Future Use Short Name: JLBRPCIR_XML DB package: JL_JLBRPCIR_XMLP_PKG BI Publisher &c_created_by_predicate &lp_end_date_predicate &lp_start_date_predicate :c_chart_of_accounts_id :c_company_name_header :c_created_by_predicate :c_end_date_predicate :c_nla_na :c_nls_all :c_nls_end_of_report :c_nls_no :c_nls_no_data_exists :c_nls_yes :c_start_date_predicate :c_user_id :lp_end_date_predicate :lp_start_date_predicate :operating_unit :p_accounting_period :p_conc_request_id :p_end_date :p_entry_person :p_flexdata :p_min_precision :p_set_of_books_id :p_sob_id :p_start_date 1 10 :p_entry_person LOV Oracle AP_SRS_USER_NAME Y select user_name id, user_name value, null description from fnd_user order by value,description US Entered By (Skip for All) 2 20 :p_start_date Date US First Entered Date 3 30 :p_end_date Date US Last Entered Date 4 40 :p_accounting_period LOV Oracle JLBR_AP_SRS_ALL_PERIODS Y select period_name id, period_name value, null description from gl_period_statuses where application_id=200 and set_of_books_id=fnd_profile.value('gl_set_of_bks_id') order by period_year desc,period_num desc SELECT PERIOD_NAME FROM GL_PERIOD_STATUSES WHERE APPLICATION_ID = 200 AND SET_OF_BOOKS_ID = fnd_profile.value('GL_SET_OF_BKS_ID') AND TO_DATE(:$FLEX$.First_Entered_Date,'YYYY/MM/DD HH24:MI:SS') BETWEEN START_DATE AND END_DATE AND TO_DATE(:$FLEX$.Last_Entered_Date,'YYYY/MM/DD HH24:MI:SS') BETWEEN START_DATE AND END_DATE ORDER BY PERIOD_YEAR DESC, PERIOD_NUM DESC US Accounting Period