ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470A851A9E05362FB09050512 select tmp.file_control file_control, i.description,tmp.total_registry,tmp.total_amount,tmp.total_validated_registry,tmp.total_validated_amount from jl_br_ap_int_collection_tmp tmp, FND_LOOKUPS i where tmp.file_control = :p_file_control and (i.lookup_type = 'JLBR_COLLECT_IMPORT_ERROR' and i.lookup_code = tmp.error_code) Y JL JLBRPICR_XML US JL Brazilian Payables Import Bank Collection Documents Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Brazilian Payables Import Bank Collection Documents Report Application: Latin America Localizations Source: Brazilian Payables Import Bank Collection Documents Report (XML) - Not Supported: Reserved For Future Use Short Name: JLBRPICR_XML DB package: JL_JLBRPICR_XMLP_PKG BI Publisher :c_company_name_header :currency_code :operating_unit :p_conc_request_id :p_file_control :p_set_of_books_id 1 -20 :p_set_of_books_id Number fnd_profile.value('GL_SET_OF_BKS_ID') US SOB SOB 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 mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) 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_file_control LOV Oracle JLBR_AP_SRS_FILE_CONTROL Y select file_control id, file_control value, null description from jl_br_ap_int_collect where entry_sequential_number=1 order by file_control Y US File Control File Control