APPWORX QUERIES

APPWORX QUERIES- 

 

------------------------------------------------
QUERY 1: Chain and Job Details
------------------------------------------------
   SELECT CHAIN_MODULE,
          SO_TASK_NAME, SO_OPERATOR agent_name,
          SO_MODULE,
          SO_JOB_DESCR,
          SO_CHAIN_ORDER,
          SO_DAYS_OF_WEEK,
          SO_ACT_FLAG,
          SO_CHAIN_SEQ,
          SO_DET_SEQ,
          SO_JOB_SEQ
     FROM AW_CHAIN_DETAIL_VIEW@DB_LINK
  

     -----------------------------------------------------------------------
     Specific agent related query
     -----------------------------------------------------------------------
     SELECT distinct CHAIN,
           AGENT agent_name
     FROM am_chains@DB_LINK
     where (AGENT ='&Agent_name' or AGENT is NULL)
   
------------------------------------------------
QUERY 2: Chain / Job Conditions
------------------------------------------------
SELECT MODULE,
      TASK_NAME,
      CONDITION_ORDER,
      CONDITION,
      ACTION,
      ACTION_ARGUMENTS
 FROM AM_CONDITIONS@DB_LINK

------------------------------------------------
Query 3: Chain / Job Prompts
------------------------------------------------

select acdv.CHAIN_MODULE,
acdv.SO_TASK_NAME,
acdv.SO_MODULE,
acdv.SO_JOB_DESCR,
acdv.SO_CHAIN_SEQ,
acdv.SO_DET_SEQ,
acdv.SO_JOB_SEQ,
acdv.SO_CHAIN_ORDER,
sjp.SO_PROMPT,
sjp.SO_PROMPT_DESCR,
sjp.SO_PROMPT_DFLT,
sjp.SO_VARIABLE_NAME,
sjp.SO_MIN_VALUE,
sjp.SO_MAX_VALUE,
sjp.SO_UPPER_CASE,
sjp.SO_REQUIRED,
(
select
sca.so_det_arg
from so_chain_args@DB_LINK sca
where acdv.so_det_seq = sca.so_det_seq
and sjp.so_prompt = sca.so_det_arg_no
) sca_so_det_arg
from
 aw_chain_detail_view@DB_LINK acdv
,So_job_prompts@DB_LINK sjp
where acdv.SO_JOB_SEQ = sjp.SO_JOB_SEQ

------------------------------------------------
Query 4: Chain / Job Schedule
------------------------------------------------

select AW_JOB_SEQ,
AW_SCH_SEQ,
AW_SCH_NAME,
AW_SCH_UNITS,
AW_START_TIME,
AW_SCH_INTERVAL,
AW_DAYS_OF_WEEK,
AW_HOLIDAY_GRP,
AW_MULTI_START,
AW_ACTIVE
from  AW_MODULE_SCHED@DB_LINK

-----------------------
select AW_JOB_SEQ,
AW_SCH_SEQ,
AW_SCH_NAME,
AW_SCH_UNITS,
AW_SCH_START,
AW_START_TIME,
AW_SCH_END,
AW_SCH_INTERVAL,
AW_DAYS_OF_WEEK,
AW_HOLIDAY_GRP,
AW_MULTI_START,
AW_ACTIVE Schedule_Active,AW_TIME_ZONE Timezone ,(select aw_tz_name from AW_TIMEZONE_LIST@DB_LINK where AW_TZ_SEQ= aa.AW_TIME_ZONE) timezone_name
from  AW_MODULE_SCHED@DB_LINK aa