JL Brazilian Receivables Bank Return Import - draft

Description
Categories: BI Publisher
Columns: Entry Sequential Number, Bank Number, Your Number, Bank Occurrence Code, Occurrence Date, Generation Date, Trade Note Amount, Due Date, Processing Date, Meaning ...
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
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
Parameter Name SQL text Validation
File Control
 
LOV Oracle