Oracle Reports (MOSC)

MOSC Banner

Converting SQL script to a report that can be run using Concurrent Manager.

edited Mar 11, 2014 12:00PM in Oracle Reports (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center