Supplier Payment History Sample Query

-
Supplier Payment History Sample Query

SELECT aps.vendor_name,
         aia.invoice_num,
         TO_CHAR (aia.invoice_date, 'DD-MON-YYYY') invoice_date,
         aia.invoice_type_lookup_code,
         aia.description,
         aia.invoice_currency_code,
         aia.payment_currency_code,
         aia.invoice_amount,
         aia.amount_paid,
         aca.check_number,
         TO_CHAR (aca.check_date, 'DD-MON-YYYY') check_date
    FROM ap_invoices_all aia,
         ap_suppliers aps,
         ap_invoice_payments_all aip,
         ap_checks_all aca
   WHERE     aia.vendor_id = aps.vendor_id
         AND aia.invoice_id = aip.invoice_id
         AND aip.check_id = aca.check_id
         AND aia.vendor_id = NVL (:P_vendor_id, aia.vendor_id)
         AND aia.invoice_date BETWEEN
                                                 NVL (:P_FROM_DATE,
                                                      aia.invoice_date)
                                          AND
                                                 NVL (:P_END_DATE,
                                                      aia.invoice_date)
ORDER BY aia.invoice_date DESC

Comments

Post a Comment

Popular posts from this blog

Deleting the Sourcing Rule Assignments API

-
Deleting the Sourcing Rule Assignments API DECLARE        l_return_status VARCHAR2(200);        l_msg_count  NUMBER;        l_msg_data VARCHAR2(2000);        l_assignment_set_rec mrp_src_assignment_pub.assignment_set_rec_type;        l_assignment_set_val_rec mrp_src_assignment_pub.assignment_set_val_rec_type;        l_assignment_tbl mrp_src_assignment_pub.assignment_tbl_type;        l_assignment_val_tbl mrp_src_assignment_pub.assignment_val_tbl_type;        o_assignment_set_rec mrp_src_assignment_pub.assignment_set_rec_type;        o_assignment_set_val_rec mrp_src_assignment_pub.assignment_set_val_rec_type;        o_assignment_tbl mrp_src_assignment_pub.assignment_tbl_type;        o_assignment_val_tbl mrp_src_assignment_pub.assignment_val_tbl_type; ...
Read more

BarCode with XML Publisher

-
Image
Barcode Steps Code 128 Barcode with XML Publisher Step:1 XML Tags and template Create or use existing oracle reports concurrent program. Change the output format under concurrent program definition to XML, run the concurrent program and get the XML tags. Map the RTF based on the XML tags generated. Step:2 Getting barcode fonts For barcode I have used Code 128 from IDAutomation (you can download from their site) After installing the font on local machine assign one of the IDAutomation font to the field in RTF template (for example an order number and font can be eg: IDAutomationSC128M) Step:3 Barcode font reading by handheld or scanner To make the barcode to be read by scanner, the encoder java code provided by vendor has to be compiled and convert it into a java class file. A.       Below is the class code save the code in a notepad and rename it as BarcodeUtil.java B.       Move the class file with EBSO fil...
Read more
-
 Active project Managers Query SELECT DISTINCT hou.name org_name,        ppa.name project_name,        ppa.segment1 project_number,        ppa.project_type,    pe.full_name Project_Manager,    amount_limit Purchase_Requisition_approval,    pe.email_address,        ppa.start_date,        to_char(ppa.completion_date,'DD-MON-YYYY')completion_date ,        ppa.closed_date,        ppa.enabled_flag   FROM apps.pa_project_parties ppp,    apps.pa_projects_all ppa,    apps.pa_project_role_types pprt,    apps.per_all_people_f pe,    apps.pa_project_assignments pa,    apps.fnd_user u,        apps.hr_operating_units hou,   (SELECT paf.person_id,   paf.assignment_type,       pcr.amount_limit   ...
Read more