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
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