Converting SQL script to a report that can be run using Concurrent Manager.
I have 2 SQL scripts that I need to convert to a report. I also need to make the Beginning and End Date user defined. Is there documentation on how I can go about getting this setup so it can be run using Concurrent Manager? The scripts in questions are shown below. Any assistance would be greatly appreciated.
SELECT
chk.VENDOR_NAME Vendor,
chk.BANK_ACCOUNT_NAME Bank_Account,
chk.CHECK_DATE,
chk.CHECK_NUMBER,
chk.AMOUNT,
chk.LAST_UPDATE_DATE,
last_update.USER_NAME || ' - ' || last_update.DESCRIPTION Last_Update,
chk.CREATION_DATE,
created.USER_NAME || ' - ' || created.DESCRIPTION Created_By