JL Regional Receivables Copy and Void Invoices Report- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Copy and Void Invoices
Application: Latin America Localizations
Source: Regional Receivables Copy and Void Invoices Report (XML) - Not Supported: Reserved For Future Use
Short Name: JLZZRCVI_XML
DB package: JL_JLZZRCVI_XMLP_PKG
Run JL Regional Receivables Copy and Void Invoices Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT 
  rctpv.bs_batch_source_name                        inv_source,
  rctpv.trx_number			inv_number,
  DECODE(rctpv.activity_flag,'Y','X','  ')	activity,
  DECODE(rctpv.posted_flag,'Y','X',' ') 	transferred,
  DECODE(rctpv.complete_flag,'N','X',' ')	incomplete,
  DECODE(rctpv.ctt_class,'INV',' ','X')	class,
  fl.meaning                                                       status,
  rctpv.batch_source_id		batch_id,
  rctpv.doc_sequence_value		doc_sequence
FROM
  ra_customer_trx_partial_v		rctpv,
  fnd_lookups                                                    fl
WHERE   rctpv.batch_source_id = :p_in_batch_source_id
AND    (   rctpv.cust_trx_type_id = NVL(:p_in_cust_trx_type_id,rctpv.cust_trx_type_id) 
             &P_DYNAMIC_WHERE_TRX_TYPE)
and ((:p_in_number_type='DOC_NUM' and rctpv.doc_sequence_value between :p_in_number_low and :p_in_number_high)
        or (:p_in_number_type='TRX_NUM' and rctpv.trx_number between :p_in_number_low and :p_in_number_high))
AND       fl.lookup_type  = 'JLZZ_COPY_STATUS'
AND       fl.lookup_code = rctpv.global_attribute20 
AND       rctpv.global_attribute_category =  DECODE(:p_country_code,'CL','JL.CL.ARXTWMAI.TGW_HEADER'
                                          ,'AR','JL.AR.ARXTWMAI.TGW_HEADER'
                                          ,'CO','JL.CO.ARXTWMAI.TGW_HEADER'
                                          ,NULL)
UNION
SELECT
  rctpv.bs_batch_source_name                       inv_source,
  rctpv.trx_number                                           inv_number,
  DECODE(rctpv.activity_flag,'Y','X','  ')        activity,
  DECODE(rctpv.posted_flag,'Y','X',' ')          transferred,
  DECODE(rctpv.complete_flag,'N','X',' ')       incomplete,
  DECODE(rctpv.ctt_class,'INV',' ','X')            class,
  NULL,
  rctpv.batch_source_id                                   batch_id,
  rctpv.doc_sequence_value                            doc_sequence
FROM
  ra_customer_trx_partial_v             rctpv
WHERE     rctpv.batch_source_id = :p_in_batch_source_id
AND       rctpv.cust_trx_type_id = NVL(:p_in_cust_trx_type_id,rctpv.cust_trx_type_id)
and ((:p_in_number_type='DOC_NUM' and rctpv.doc_sequence_value between :p_in_number_low and :p_in_number_high)
        or (:p_in_number_type='TRX_NUM' and rctpv.trx_number between :p_in_number_low and :p_in_number_high))
AND      (rctpv.global_attribute_category IS NULL OR
               rctpv.global_attribute_category =
DECODE(:p_country_code,'CL','JL.CL.ARXTWMAI.TGW_HEADER'
                                          ,'AR','JL.AR.ARXTWMAI.TGW_HEADER'
                                          ,'CO','JL.CO.ARXTWMAI.TGW_HEADER'
                                          ,NULL) )              
AND       rctpv.global_attribute20 IS NULL
ORDER BY doc_sequence
Parameter Name SQL text Validation
Operating Unit 
 
 LOV
Transaction Batch Source 
 
 LOV Oracle
Transaction Type 
 
 LOV Oracle
Number Type 
 
 LOV Oracle
Number Low 
 
 Char
Number High 
 
 Char
Void Reason 
 
 LOV Oracle
Download
Related Blitz Reports
AR Discount Projection JL Regional Receivables Copy and Void Invoices Preview Report- Not Supported: Reserved For Future Use OKL Termination Quotes AR Customers and Sites AR Transaction Detail AR Invoices Posted to Suspense CAC Internal Order Shipment Margin CAC Intercompany SO Shipping Transaction vs. Invoice Price AR Customer Listing - Detail
Blitz Report™

Blitz Report™ provides multiple benefits: