JL Regional Receivables Copy and Void Invoices Preview - draft

Description
Categories: BI Publisher
Application: Latin America Localizations
Source: Regional Receivables Copy and Void Invoices Preview Report (XML) - Not Supported: Reserved For Future Use
Short Name: JLZZRCVP_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
Number High
 
Number Low
 
Number Type
 
LOV Oracle
Transaction Type
 
LOV Oracle
Transaction Batch Source
 
LOV Oracle