Reports2017-11-18T12:27:27+00:00

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
 
By continuing to use the site, you agree to the use of cookies. Accept