JL Brazilian Receivables Bank Return Import - draft

Description
Categories: BI Publisher
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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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