AP Matching Hold Agent Notice- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Matching Hold Agent Notice
Application: Payables
Source: Matching Hold Agent Notice (XML) - Not Supported: Reserved For Future Use
Short Name: APXMHLET_XML
DB package: AP_APXMHLET_XMLP_PKG
Description: Matching Hold Agent Notice
Application: Payables
Source: Matching Hold Agent Notice (XML) - Not Supported: Reserved For Future Use
Short Name: APXMHLET_XML
DB package: AP_APXMHLET_XMLP_PKG
Run
AP Matching Hold Agent Notice- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
|
LOV | |
Name of letter sender |
|
Char | |
Title of letter sender |
|
Char | |
Phone of letter sender |
|
Char | |
Name of organization |
|
Char |