AP Payment Audit by Voucher Number

Description
Categories: BI Publisher, Financials, Procurement
Application: Payables
Source: Payment Audit by Voucher Number (XML)
Short Name: APXPAYAD_XML
DB package: AP_APXPAYAD_XMLP_PKG
select aud.doc_sequence_value,
           aud.doc_sequence_id,
           aud.creation_date,
  decode(ch.void_date,null,decode(ch.doc_sequence_value,null,:C_not_entered,:C_entered),:C_deleted) status,              dsc.name category,
            cs.name document,
            ch.check_number,
            ch.currency_code,
            ch.amount,
            ch.vendor_name,
            v.segment1 vendor_num, 
	AP_APXPAYAD_XMLP_PKG.C_last_value_p C_last_value
from     ap_doc_sequence_audit aud,
            fnd_doc_sequence_assignments dsa,
            fnd_doc_sequence_categories dsc,
            ap_check_stocks cs,
            po_vendors v,
            ap_checks ch
where aud.doc_sequence_id = :C_doc_sequence_id
and     aud.doc_sequence_id = ch.doc_sequence_id(+)
and     aud.doc_sequence_value =                 ch.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     ch.vendor_name = v.vendor_name(+)
and     ch.check_stock_id = cs.check_stock_id(+)
order by to_number(aud.doc_sequence_value)
Parameter Name SQL text Validation
Ledger
 
Voucher Number To
 
Number
Voucher Number From
 
Number
Sequence Name
 
LOV Oracle