ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4724E51A9E05362FB09050512 SELECT report_type C_REPORT_NAME, description C_DESCRIPTION, inactive_date C_INACTIVE_DATE, expense_report_id C_REPORT_ID FROM ap_expense_reports WHERE (decode(upper(:p_active_type), 'ACTIVE',nvl(inactive_date, :p_effective_date+1) -:p_effective_date, 'INACTIVE',:p_effective_date -nvl(inactive_date,:p_effective_date+1), 'BOTH',1, null,1) > 0 ) ORDER BY UPPER(report_type) Y SQLAP APXXPXPL_XML US AP Expense Report Template Listing- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Expense Report Template Listing Application: Payables Source: Expense Report Template Listing (XML) - Not Supported: Reserved For Future Use Short Name: APXXPXPL_XML DB package: AP_APXXPXPL_XMLP_PKG BI Publisher :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_chart_of_accounts_id :c_company_name_header :c_nls_all :c_nls_end_of_report :c_nls_no :c_nls_no_data_exists :c_nls_yes :c_report_start_date :operating_unit :p_active_type :p_conc_request_id :p_debug_switch :p_effective_date :p_flexdata :p_min_precision :p_set_of_books_id 1 -20 :p_set_of_books_id Char fnd_profile.value('GL_SET_OF_BKS_ID') Y US Ledger Ledger Id 2 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 3 10 :p_active_type LOV Oracle AP_SRS_ACTIVE_OPTION_MAND Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='ACTIVE_OPTIONS' order by value,description select displayed_field from ap_lookup_codes where lookup_type = 'ACTIVE_OPTIONS' and lookup_code = 'Both' Y US Include Active/Inactive include active/inactive reports 4 20 :p_effective_date Date sysdate Y US Effective Date effective date