Concurrent Program code meanings:
SELECT distinct lookup_code, meaning
FROM fnd_lookup_values
WHERE lookup_type = 'CP_STATUS_CODE'
AND trunc(SYSDATE) BETWEEN nvl(start_date_active
,trunc(SYSDATE)) AND
nvl(end_date_active
,trunc(SYSDATE))
| Code | Meaning |
|---|---|
| E | Error |
| B | Resuming |
| Q | Stamdby |
| W | Paused |
| H | On Hold |
| I | Normal |
| P | Scheduled |
| T | Terminating |
| U | Disabled |
| Z | @Waiting |
| C | Normal |
| Z | Waiting |
| R | @@Normal |
| A | Waiting |
| M | No Manager |
| D | Cancelled |
| G | Warning |
| R | Normal |
| S | Suspended |
| X | Terminated |
| I | @Normal |
| select req.description ,req.request_id ,req.last_update_date ,req.request_date ,req.phase_code ,req.status_code ,req.argument_text ,req.resubmit_interval_unit_code ,req.resubmit_interval ,req.resubmit_time from applsys.fnd_concurrent_requests req, gv$session ses, gv$process proc, apps.fnd_concurrent_programs_vl prog ,apps.fnd_responsibility_vl r ,apps.fnd_user u where req.oracle_process_id=proc.spid(+) and proc.addr = ses.paddr(+) and proc.inst_id = ses.inst_id(+) and req.concurrent_program_id = prog.concurrent_program_id and req.program_application_id = prog.application_id and req.responsibility_id = r.responsibility_id and req.requested_by = u.user_id and phase_code = 'P' and request_date between to_date ('18-MAY-2010 11:00:00','DD-MON-RRRR HH24:MI:SS' ) and to_date ('21-MAY-2010 23:00:00','DD-MON-RRRR HH24:MI:SS' ) and prog.concurrent_program_name not in ('FNDOAMCOL') |
select owner ,name ,enqueue_enabled ,dequeue_enabled from dba_queues where name like 'WF%'; |
| select notification_id ,message_type ,message_name ,recipient_role ,status ,user_key ,item_key ,access_key ,mail_status ,begin_date ,end_date ,due_date ,responder ,user_comment ,original_recipient ,from_user ,to_user ,subject ,from_role ,group_id from wf_notifications |
| select queue, msg_id ,corr_id ,msg_state ,enq_time ,enq_timestamp ,deq_timestamp ,consumer_name ,user_data from applsys.aq$wf_notification_out |
select * from applsys.aq$wf_notification_out where msg_state = 'READY'; |
SELECT
JE_SOURCE_NAME
,USER_JE_SOURCE_NAME
FROM GL_JE_SOURCES_TL
WHERE JE_SOURCE_NAME in ('63','125')
IN ('Assets'
,'Spreadsheet'
,'BUSSUM',
'CLMPAY'
,'CLMPAY-VOID'
,'CLMPAY-RECO'
,'CLMPAY-EFT'
,'CLMPAY-STOP'
,'CLMPAY-EXP'
,'CLAIMS'
,'ADMFEE'
,'CONNING',
'LICENSING'
,'CASH'
,'WRITEOFFS'
,'FEES'
,'ADI Spreadsheet'
,'PAYABLES'
,'INTERCO XFER') |
\