0

Query to Find scheduled concurrent program's in Oracle apps

posted on , by Adarsh

SELECT fcr.request_id,DECODE(fcpt.user_concurrent_program_name,'Report Set','Report Set:' || fcr.description,fcpt.user_concurrent_program_name) CONC_PROG_NAME,argument_text PARAMETERS,NVL2(fcr.resubmit_interval,'PERIODICALLY',NVL2(fcr.release_class_id, 'ON SPECIFIC DAYS', 'ONCE')) PROG_SCHEDULE_TYPE,DECODE(NVL2(fcr.resubmit_interval,'PERIODICALLY',NVL2(fcr.release_class_id, 'ON SPECIFIC DAYS', 'ONCE')),'PERIODICALLY','EVERY ' || fcr.resubmit_interval || ' ' ||fcr.resubmit_interval_unit_code || ...

Read More
0

SLA Event,Transactions and Ledgers table query

posted on , by Adarsh

SELECT    *FROM    (        SELECT            'N' select_flag,            'N' hide_show,            xgl.name              ledger,            xte.ledger_id,            le.name               legal_entity,          ...

Read More