AP Matching Hold Agent Notice - draft

Description
Categories: BI Publisher, Financials, Procurement
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
Ledger
 
Name of organization
 
Phone of letter sender
 
Title of letter sender
 
Name of letter sender
 
Ask a question