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
Run AR Invoice Print Preview and other Oracle EBS reports with Blitz Report™ on our demo environment
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 XLA Subledger Period Close Exceptions AR Sales Journal by GL Account XLA Third Party Balances AP Payables Posted Invoice Register AP Payables Posted Payment Register XLA Complete Multiperiod Accounting JG Global Journals and Third Party PA Create Accounting
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™