AP Invoice Audit by Voucher Number- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Invoice Audit by Voucher Number
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
Description: Invoice Audit by Voucher Number
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 | |
|---|---|---|---|
| Operating Unit | LOV | ||
| Sequence Name | LOV Oracle | ||
| Voucher Number From | Number | ||
| Voucher Number To | Number |