AP Matching Hold Agent Notice- Not Supported: Reserved For Future Use
Description
- Categories
- BI Publisher
- Application
- Payables
- Source
- Matching Hold Agent Notice (XML) - Not Supported: Reserved For Future Use
- Short Name
- APXMHLET_XML
- DB package
- AP_APXMHLET_XMLP_PKG
Imported from BI Publisher
Matching Hold Agent Notice
Matching Hold Agent Notice
SQL 29 lines
SELECT hr.last_name C_LAST_NAME, upper(hr.last_name) C_UPP_LAST_NAME, hr.first_name C_FIRST_NAME, locs.location_code C_LINE1, heds.agent_id C_AGENT_ID, inv.invoice_id C_INVOICE_ID, inv.invoice_num C_INVOICE_NUM, heds.segment1 C_PO_NUM, pv.vendor_name C_VENDOR_NAME, lines.item_description C_DESCRIPTION FROM hr_employees_current_v hr, hr_locations locs, ap_holds h, ap_invoices inv, po_lines lines, po_headers heds, po_vendors pv, po_line_locations linelocs WHERE h.invoice_id=inv.invoice_id AND h.line_location_id = linelocs.line_location_id AND linelocs.po_line_id = lines.po_line_id AND lines.po_header_id = heds.po_header_id AND heds.agent_id=hr.employee_id(+) AND hr.location_id=locs.location_id(+) AND h.release_lookup_code is null AND pv.vendor_id=inv.vendor_id ORDER BY upper(hr.last_name), pv.vendor_name, inv.invoice_num, lines.item_description |
Parameters 5
| Parameter | Type | List of values SQL |
|---|---|---|
| Operating Unit | LOV | |
| Name of letter sender | Char | |
| Title of letter sender | Char | |
| Phone of letter sender | Char | |
| Name of organization | Char |