JL Regional Receivables Copy and Void Invoices - draft

Description
Categories: BI Publisher
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
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
Preview Report
 
LOV Oracle
Void Reason
 
LOV Oracle
Number High
 
Number Low
 
Number Type
 
LOV Oracle
Transaction Type
 
LOV Oracle
Transaction Batch Source
 
LOV Oracle