ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1623869E053B46B63588994 SELECT distinct 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.cancelled_date c_cons_cancelled_date, cons.cancelled_by c_cons_cancelled_by, cons.cancelled_amount c_cons_cancelled_amount, cons.invoice_date c_cons_invoice_date, cons.description c_cons_description, cons.invoice_currency_code c_currency_code FROM jl_br_ap_consolid_invoices cons, po_vendors pv, gl_code_combinations gcc WHERE cons.vendor_id = pv.vendor_id AND gcc.chart_of_accounts_id = &C_CHART_OF_ACCOUNTS_ID AND cons.cancelled_date IS NOT NULL &LP_start_date_predicate &LP_end_date_predicate &C_created_by_predicate ORDER BY cons.invoice_currency_code, upper(pv.vendor_name), cons.invoice_num asc Y JL JLBRPCCR_XML US JL Brazilian Payables Cancelled Consolidated Invoice Register - draft Application: Latin America Localizations Source: Brazilian Payables Cancelled Consolidated Invoice Register (XML) - Not Supported: Reserved For Future Use Short Name: JLBRPCCR_XML DB package: JL_JLBRPCCR_XMLP_PKG BI Publisher &c_chart_of_accounts_id &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_flex_data :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 Y 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