ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1693869E053B46B63588994 SELECT ret.ENTRY_SEQUENTIAL_NUMBER, ret.BANK_NUMBER, ret.YOUR_NUMBER, ret.BANK_OCCURRENCE_CODE, ret.OCCURRENCE_DATE, ret.GENERATION_DATE, ret.TRADE_NOTE_AMOUNT, ret.DUE_DATE, ret.PROCESSING_DATE, look.MEANING FROM JL_BR_AR_RET_INTERFACE_EXT_V ret, FND_LOOKUPS look WHERE ret.FILE_CONTROL = :P_FILE_CONTROL AND look.LOOKUP_TYPE = 'JLBR_AR_BANK_RETURN_ERRORS' AND look.LOOKUP_CODE = ret.ERROR_CODE AND look.ENABLED_FLAG = 'Y' AND NVL(look.START_DATE_ACTIVE,SYSDATE) <= SYSDATE AND NVL(look.END_DATE_ACTIVE,SYSDATE) >= SYSDATE ORDER BY ret.ENTRY_SEQUENTIAL_NUMBER Y JL JLBRRIVB_XML US JL Brazilian Receivables Bank Return Import - draft Application: Latin America Localizations Source: Brazilian Receivables Bank Return Import Report (XML) - Not Supported: Reserved For Future Use Short Name: JLBRRIVB_XML DB package: JL_JLBRRIVB_XMLP_PKG BI Publisher :cp_base_currency_code :cp_base_precision :cp_organisation_name :operating_unit :p_conc_request_id :p_end_of_report :p_file_control :p_no_data_found 1 10 :p_file_control LOV Oracle JLBR_AR_FILE_CONTROL Y select file_control id, file_control value, null description from jl_br_ar_ret_inter_v order by file_control Y US File Control