JL Brazilian Receivables Bank Return Import - draft

➜ Back to Library
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
Run JL Brazilian Receivables Bank Return Import - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
JL Argentine Payables Withholding Certificate - draft AR Transaction Detail AR Bills Receivable Remittance Batch Management GL Account Analysis (Distributions) CAC Internal Order Shipment Margin JL Argentine Receivables Withholding Taken Flat File - draft JL Regional Receivables Copy and Void Invoices Preview Report- Not Supported: Reserved For Future Use JL Regional Receivables Copy and Void Invoices Report- Not Supported: Reserved For Future Use PA Implementation Options
Blitz Report™

Blitz Report™ provides multiple benefits: