AP Invoice API
their is a custom API for create AP invoice Using Purchase order number CREATE OR REPLACE procedure APPS.ap_invoice_pk (p_po_number in number, p_org_id in number) as v_invoice_num varchar2(100); v_amount number; v_vendor_id number; v_vendor_site_id number; v_org_id number; v_line_num number; v_quantity number; l_standard_request_id number; -- cursor for enter data in ap_invoice_lines_interface table cursor inv_line is select rownum line_num,quantity*unit_price quantity from PO_LINES_ALL pla,PO_HEADERS_ALL pha where segment1=p_po_number and pla.PO_HEADER_ID=pha.po_header_id; begin --- this query for create new invoice number as in sequence 'ERS-12345-0001' you can chose your sequence type select 'ERS-'||(select distinct receipt_num from RCV_shipment_headerS rsh,RCV_shipment_lines rsl where rsh.shipment_header_id=rsl.shipment_header_id and rsl.po_header_id=(se...