AP Invoice Audit by Voucher Number - draft

Description
Categories: BI Publisher, Financials, Procurement
Application: Payables
Source: Invoice Audit by Voucher Number (XML) - Not Supported: Reserved For Future Use
Short Name: APXINVAD_XML
DB package: AP_APXINVAD_XMLP_PKG
select a.*,
AP_APXINVAD_XMLP_PKG.c_new_recordsformula(a.doc_sequence_value) C_new_records,
	AP_APXINVAD_XMLP_PKG.C_last_value_p C_last_value from
(select aud.doc_sequence_value,
           aud.doc_sequence_id,
           aud.creation_date,
decode(i.doc_sequence_value,null,:C_deleted,:C_entered) status,
            dsc.name category,
            v.segment1 vendor_num,
            hp.party_name,
            i.invoice_num,
            i.invoice_currency_code,
            i.invoice_amount,
            l.displayed_field paid
from    ap_lookup_codes l,
            ap_doc_sequence_audit aud,
            fnd_doc_sequence_assignments dsa,
            fnd_doc_sequence_categories dsc,
            hz_parties hp,
            ap_suppliers v,
            ap_invoices i
where aud.doc_sequence_id = :C_sequence_id
and     aud.doc_sequence_id = i.doc_sequence_id(+)
and     aud.doc_sequence_value =                 i.doc_sequence_value(+)
and     aud.doc_sequence_value between :P_sequence_from and :P_sequence_to
and     aud.doc_sequence_assignment_id = dsa.doc_sequence_assignment_id
and     dsa.category_code = dsc.code
and     dsa.application_id = dsc.application_id
and     i.party_id = hp.party_id (+)
and     hp.party_id = v.party_id(+)
and     l.lookup_type(+) = 'INVOICE PAYMENT STATUS'
and     l.lookup_code(+) = i.payment_status_flag
order by aud.doc_sequence_value) a
Parameter Name SQL text Validation
Ledger
 
Voucher Number To
 
Number
Voucher Number From
 
Number
Sequence Name
 
LOV Oracle