Monday, 16 July 2012

R12 - AP Suppliers created in last n days

Run the following script to find out AP Suppliers created in the system given a From Date to the query.

SELECT aps.creation_date,
       fu.description created_by,
       fu.email_address,
       aps.vendor_name supplier_name,
       NVL (aps.vendor_name_alt, 'NA') alternate_supplier_name,
       aps.segment1 supplier_number,
       NVL (aps.vendor_type_lookup_code, 'NA') supplier_type,
       NVL (aps.customer_num, 'NA') customer_num_with_supplier,
       NVL (NVL (aps.num_1099, tca_sync_num_1099), 'NA') tax_identification_no,
       NVL (aps.type_1099, 'NA') type_of_1099,
       NVL (aps.organization_type_lookup_code, 'NA') IRS_org_type,
       NVL (TO_CHAR (aps.tax_verification_date, 'DD-MON-YY'), 'NA') tax_verification_date,
       NVL (aps.state_reportable_flag, 'NA') state_reportable_flag,
       aps.federal_reportable_flag federal_reportable_flag
  FROM ap.ap_suppliers aps, applsys.fnd_user fu
 WHERE aps.created_by = fu.user_id
       AND aps.creation_date BETWEEN TO_DATE (:FROM_DATE, 'DD-MON-YYYY') AND SYSDATE;

Note:
1. When asked provide value of FROM_DATE in DD-MON-YYYY format.
2. AP_SUPPLIERS table replaced PO_VENDORS table in R12

No comments:

Post a Comment