AR Invoice Print Preview

➜ Back to Library
Description
Categories: BI Publisher
Application: Receivables
Source: Invoice Print Preview Report (XML)
Short Name: RAXINVPR_XML
DB package: AR_RAXINVPR_XMLP_PKG 
select
        rtrim(rpad(l_types.meaning,11))                       invoice_type,
        A.trx_number                                     trx_number,
        rtrim(rpad(types.name,8))                           type,
        substrb(PARTY.party_name,1,50)                                 name,          B.account_number                            customer_number,         A.trx_date                                     invoice_date,
        P.due_date                                   ps_due_date,
        nvl(
             P.amount_due_original +
            decode(a.initial_customer_trx_id,
                          '', 0,
                              nvl(com_adj.amount,0)
                         ),
              (
                    rec.amount  *
                   (
                      NVL(TL.RELATIVE_AMOUNT, 100) *
                     (100/NVL(T.BASE_AMOUNT,100))
                   )  /  100
              )
           )   amount,
        rtrim(rpad(A.invoice_currency_code,  11))              invoice_currency_code,
        printing_last_printed                           last_print_date,
        decode(printing_pending, 'Y', '*', '')          printing_pending,
        A.last_printed_sequence_num last_printed_sequence_num,
        TL.sequence_num sequence_num,
	AR_RAXINVPR_XMLP_PKG.installment_last_print_datefor(TL.sequence_num, A.last_printed_sequence_num, decode ( printing_pending , 'Y' , '*' , '' ), printing_last_printed) INSTALLMENT_LAST_PRINT_DATE,
	AR_RAXINVPR_XMLP_PKG.INSTALLMENT_PRINTING_PENDING_p INSTALLMENT_PRINTING_PENDING
	,AR_RAXINVPR_XMLP_PKG.D_AmountFormula()
FROM &p_table1
WHERE &p_where1
UNION
select
        rtrim(rpad(l_types.meaning,11))                       invoice_type,
        A.trx_number                                 trx_number,
        rtrim(rpad(types.name,8))                           type,
        substrb(PARTY.party_name,1,50)                                  name,         B.account_number                            customer_number,         A.trx_date                                    invoice_date,
        P.due_date                                  ps_due_date,
        P.amount_due_original +
            decode(a.initial_customer_trx_id,
                          '', 0,
                              nvl(com_adj.amount,0)
                         )                amount,
        rtrim(rpad(A.invoice_currency_code,11) )             invoice_currency_code,
        printing_last_printed                           last_print_date,
        decode(printing_pending, 'Y', '*', '')          printing_pending,
        A.last_printed_sequence_num last_printed_sequence_num,
        P.terms_sequence_number sequence_num,
	AR_RAXINVPR_XMLP_PKG.installment_last_print_datefor(TL.sequence_num, A.last_printed_sequence_num, decode ( printing_pending , 'Y' , '*' , '' ), printing_last_printed) INSTALLMENT_LAST_PRINT_DATE,
	AR_RAXINVPR_XMLP_PKG.INSTALLMENT_PRINTING_PENDING_p INSTALLMENT_PRINTING_PENDING
	,AR_RAXINVPR_XMLP_PKG.D_AmountFormula()
FROM &p_table2
WHERE &p_where2
order by 9,1,3,2,6,7
Parameter Name SQL text Validation
Print Choice 
 
 LOV Oracle
Open Invoices Only 
 
 LOV Oracle
Transaction Type 
 
 LOV Oracle
Transaction Number Low 
 
 LOV Oracle
Transaction Number High 
 
 LOV Oracle
Print Date Low 
 
 Date
Print Date High 
 
 Date
Customer 
 
 LOV Oracle
Batch 
 
 LOV Oracle
Installment Number 
 
 Number
Download
Related Blitz Reports
CST Journal Entries Report - Cost Management AR Sales Journal by GL Account XLA Subledger Period Close Exceptions JE Italian Journal Ledger XLA Subledger Multiperiod Accounting and Accrual Reversal GMF Create Accounting JG Global GL and SLA Account by Journal Lines JG Global Third Party Account Balance JG Global GL and SLA Account Analysis
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: