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
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