| SQL Id | SQL Text |
|---|
| 0p9g2stk4hcz9 | SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_00"), NVL(SUM(C2), :"SYS_B_01"), NVL(SUM(C3), :"SYS_B_02"), NVL(SUM(C4), :"SYS_B_03"), COUNT(DISTINCT C5), NVL(SUM(CASE WHEN C5 IS NULL THEN :"SYS_B_04" ELSE :"SYS_B_05" END), :"SYS_B_06") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("B") FULL("B") NO_PARALLEL_INDEX("B") */ :"SYS_B_07" AS C1, CASE WHEN "B"."EMP_ID"=:"SYS_B_08" AND "B"."APPROVER_ID"<>:"SYS_B_09" THEN :"SYS_B_10" ELSE :"SYS_B_11" END AS C2, CASE WHEN "B"."EMP_ID"=:"SYS_B_12" THEN :"SYS_B_13" ELSE :"SYS_B_14" END AS C3, CASE WHEN "B"."EMP_ID"=:"SYS_B_15" THEN :"SYS_B_16" ELSE :"SYS_B_17" END AS C4, "B"."APPROVER_ID" AS C5 FROM "SFBPM"."AM_APPROVE_LIST" SAMPLE BLOCK (:"SYS_B_18" , :"SYS_B_19") SEED (:"SYS_B_20") "B") SAMPLESUB |
| 0u46hbjta8bp9 |
insert into gt$apply_work_list select /*+ USE_HASH(a fa)*/ distinct A.FORM_HEADER_ID , A.FORM_NO , A.FORM_KIND , A.BEGIN_DATE , A.END_DATE , NVL(A.APPLYER, A.FILLER) , CASE WHEN (FA.APP_VALUE IS NULL OR FA.APP_VALUE <> 'R') AND FA.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NULL THEN 'Dismission' WHEN (FA.APP_VALUE IS NULL OR FA.APP_VALUE <> 'R') AND FA.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NOT NULL AND E.EXT_NO IS NULL THEN LTRIM(RTRIM(E.DISPLAY_NAME)) || '#NO_EXT' WHEN (FA.APP_VALUE IS NULL OR FA.APP_VALUE <> 'R') AND FA.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NOT NULL AND E.EXT_NO IS NOT NULL THEN LTRIM(RTRIM(E.DISPLAY_NAME)) || ' #' || E.EXT_NO ELSE A.FORM_STATUS END AS FORM_STATUS , A.PRIORITY , A.SYSTEM , G.WEB_PATH , CASE A.SYSTEM WHEN 'LOCAL' THEN 0 ELSE 100 END AS SORT_ORDER , L.form_name , L.form_name_langid , CASE WHEN ( empapply.EMP_NAME IS NULL) THEN 'None/Dismission' ELSE RTRIM(EMPAPPLY.EMP_NAME) END AS APPLY_EMP_NAME from FM_FORM_HEADER A join FM_FORM_LIST L on a.FORM_KIND = L.FORM_KIND and A.SYSTEM = L.SYSTEM and L.is_active != '0' AND (L."SYSTEM" != 'LOCAL' OR (L."SYSTEM" = 'LOCAL' AND L.form_kind not in (select form_kind from fm_form_module where UPPER (close_module_name) = UPPER ('Trace_Apply'))))LEFT JOIN GLOBAL_SYSTEM_LIST G ON A.SYSTEM = G.SYSTEM_NAME LEFT JOIN (SELECT * FROM FM_FORM_APPROVE_ACTIVE A WHERE FORM_APPROV
E_ID = (SELECT MIN(FORM_APPROVE_ID) FROM FM_FORM_APPROVE_ACTIVE B WHERE B.FORM_KIND = A.FORM_KIND AND B.FORM_NO = A.FORM_NO)) FA ON A.SYSTEM = FA.SYSTEM AND A.FORM_KIND = FA.FORM_KIND AND A.FORM_NO = FA.FORM_NO left join AM_EMPLOYEE E ON E.EMP_ID = FA.APP_EMP_ID LEFT JOIN (SELECT EMP_ID, DISPLAY_NAME AS EMP_NAME, DEPT_CODE, EXT_NO FROM AM_EMPLOYEE) empapply ON empapply.EMP_ID = case when A.APPLYER = '' OR A.APPLYER is null then A.filler else A.APPLYER END WHERE ((A.APPLYER = '1001K81000000000068X' or A.FILLER = '1001K81000000000068X') OR ( A.APPLYER IN (SELECT APP_EMP_ID FROM GT$AGENT_WORK agent )) )and A.BEGIN_DATE>to_date('1980/01/01', 'yyyy/MM/dd') and A.BEGIN_DATE<=to_date('2018/01/03', 'yyyy/MM/dd')+1 and A.FORM_STATUS<>'DE' and A.FORM_STATUS in ('NC', 'SA', 'RC') |
| 0usvfw300zw1x |
insert into GT$DEAL_WORK_LIST select fa.FORM_APPROVE_ID, fa.FORM_KIND, fa.FORM_NO, fa.END_DATE , case when fa.APP_ACTOR<>'1001A11000000000BFIY' THEN 'Y' else 'N' end as IS_AGENT , fa.SYSTEM , G.WEB_PATH , CASE FA.SYSTEM WHEN 'LOCAL' THEN 0 ELSE 100 END AS SORT_ORDER , CASE WHEN (Faa.APP_VALUE IS NULL OR Faa.APP_VALUE <> 'R') AND Faa.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NULL THEN 'Dismission' WHEN (Faa.APP_VALUE IS NULL OR Faa.APP_VALUE <> 'R') AND Faa.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NOT NULL AND E.EXT_NO IS NULL THEN LTRIM(RTRIM(E.DISPLAY_NAME)) || '#NO_EXT' WHEN (Faa.APP_VALUE IS NULL OR Faa.APP_VALUE <> 'R') AND Faa.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NOT NULL AND E.EXT_NO IS NOT NULL THEN LTRIM(RTRIM(E.DISPLAY_NAME)) || ' #' || E.EXT_NO ELSE fh.FORM_STATUS END AS FORM_STATUS , fl.form_name , fl.form_name_langid , CASE WHEN (empapply.EMP_NAME IS NULL) THEN 'None/Dismission' ELSE RTRIM(EMPAPPLY.EMP_NAME) END AS APPLY_EMP_NAME , RTRIM(EMPAPPLY.EMP_ID) AS APPLYER FROM FM_FORM_APPROVE FA, FM_FORM_HEADER FH LEFT JOIN FM_FORM_LIST FL ON FH.FORM_KIND = FL.FORM_KIND and FH.system = FL.system and FL.is_active != '0' and (FL.system != 'LOCAL' OR (FL.system = 'LOCAL' AND (FL.form_kind not in (select form_kind from fm_form_module where UPPER (close_module_name) = UPPER ('Trace_Deal')))))LEFT JOIN (SELECT EMP_ID, DISPLAY_NAME AS EMP_NAME, DEPT_CODE, EXT_NO F
ROM AM_EMPLOYEE ) empapply ON empapply.EMP_ID = case when fh.APPLYER = '' OR fh.APPLYER is null then fh.filler else fh.APPLYER END LEFT JOIN GLOBAL_SYSTEM_LIST G ON fh.SYSTEM = G.SYSTEM_NAME LEFT JOIN (select a.* from FM_FORM_APPROVE_ACTIVE a Right JOIN (select min(begin_date) as begin_date, form_kind, form_no from FM_FORM_APPROVE_ACTIVE group by form_kind, form_no) b on a.form_kind = b.form_kind and a.form_no = b.form_no and a.begin_date = b.begin_date ) Faa ON FH.SYSTEM = Faa.SYSTEM AND FH.FORM_KIND = FAa.FORM_KIND AND FH.FORM_NO = Faa.FORM_NO left join AM_EMPLOYEE E ON E.EMP_ID = Faa.APP_EMP_ID where (fa.APP_ACTOR='1001A11000000000BFIY' or (fa.app_emp_id = '1001A11000000000BFIY' and fa.APP_ACTOR <> fa.app_emp_id)) and fa.app_status in ('A', 'T') and fa.APP_TYPE='D'and fa.FORM_KIND=fh.FORM_KIND and fa.FORM_NO=fh.FORM_NO and fa.SYSTEM=fh.SYSTEM and fa.END_DATE>to_date('2018/01/03', 'yyyy/MM/dd') and fa.END_DATE <= to_date('2018/01/03', 'yyyy/MM/dd') + 1 and fh.FORM_STATUS<>'DE' and fa.FORM_KIND='SF.FORM.039' and fa.SYSTEM = 'LOCAL' |
| 1cd4dnhdhp0r1 | SELECT t.tablespace_name, t.contents, t.status, NVL(df.allocated_bytes, 0)-NVL((NVL(f.free_bytes, 0)+df.max_free_bytes), 0) usedBytes, NVL((NVL(f.free_bytes, 0)+df.max_free_bytes), 0) freeBytes, NVL(f.free_blocks, 0) freeBlocks FROM sys.dba_tablespaces t, (select ff.tablespace_name, sum(ff.free_bytes) free_bytes, sum(ff.free_blocks) free_blocks from (SELECT fs.tablespace_name, SUM(fs.bytes) free_bytes, SUM(fs.blocks) free_blocks FROM sys.dba_free_space fs, sys.dba_data_files dfs where fs.file_id=dfs.file_id GROUP BY fs.tablespace_name, dfs.autoextensible) ff group by tablespace_name) f, (select dff.tablespace_name, sum(dff.allocated_bytes) allocated_bytes, sum(dff.max_free_bytes) max_free_bytes from (select tablespace_name, autoextensible, sum(decode(sign(maxbytes-bytes), 1, maxbytes, bytes)) allocated_bytes, sum(decode(sign(maxbytes-bytes), 1, abs(maxbytes-bytes), 0)) max_free_bytes from dba_data_files group by tablespace_name, autoextensible) dff group by tablespace_name) df WHERE t.tablespace_name = f.tablespace_name(+) and t.tablespace_name=df.tablespace_name(+) order by tablespace_name |
| 1sw26dvj0a5jj |
SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_00"), NVL(SUM(C2), :"SYS_B_01"), NVL(SUM(C3), :"SYS_B_02"), NVL(SUM(C4), :"SYS_B_03"), COUNT(DISTINCT C5), NVL(SUM(CASE WHEN C5 IS NULL THEN :"SYS_B_04" ELSE :"SYS_B_05" END), :"SYS_B_06") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("FA") FULL("FA") NO_PARALLEL_INDEX("FA") */ :"SYS_B_07" AS C1, CASE WHEN UPPER("FA"."APP_STATUS")=:"SYS_B_08" AND UPPER("FA"."APP_TYPE")=:"SYS_B_09" AND "FA"."APP_EMP_ID"=:"SYS_B_10" THEN :"SYS_B_11" ELSE :"SYS_B_12" END AS C2, CASE WHEN "FA"."APP_EMP_ID"=:"SYS_B_13" THEN :"SYS_B_14" ELSE :"SYS_B_15" END AS C3, CASE WHEN "FA"."APP_EMP_ID"=:"SYS_B_16" THEN :"SYS_B_17" ELSE :"SYS_B_18" END AS C4, "FA"."FORM_NO" AS C5 FROM "SFBPM"."FM_FORM_APPROVE_ACTIVE" SAMPLE BLOCK (:"SYS_B_19" , :"SYS_B_20") SEED (:"SYS_B_21") "FA") SAMPLESUB
|
| 1z4mxspmuc9f0 | Begin info_model.get_interception(:v0, :v1, :v2, :v3); End; |
| 29akfp62f9brq | SELECT * FROM ( SELECT a.article_id, a.article_Type_id, case when TITLE_LENGTH = 0 then a.title when length(a.title) > nvl(TITLE_LENGTH, 10) then substr(a.title, 1, nvl(TITLE_LENGTH, 10)) || '...' else a.TITLE end as title,
case when TITLE_LENGTH = 0 then '' when length(a.TITLE) > nvl(TITLE_LENGTH, 10) then a.TITLE else '' end as summary,
a.publish_date, a.publisher_id, (SELECT b.file_id FROM portal_article_attachment b WHERE b.article_id = a.article_id AND b.file_type='I' AND b.is_summary_picture=1) image_fieldID,
(CASE WHEN ABS(trunc(publish_date) - trunc(SYSDATE)) <=3 THEN 'Y' ELSE 'N' END ) is_new, a.status, a.hot_article_status, a.input_mode, a.image_frame, a.sequence, a.theme_picture
FROM portal_article a, PORTAL_ARTICLE_TYPE b
WHERE a.ARTICLE_TYPE_ID = b.ARTICLE_TYPE_ID and
a.article_type_id = '4af8dc21-076d-4740-bde3-9281ce30f369' AND a.begin_date <= SYSDATE AND a.end_date >= SYSDATE AND a.status IN ('868E74A7-5E14-446e-8BC6-8AF30AA0C062', '77FD3924-BAA7-4222-B892-6BB2E3703536')
ORDER BY a.sequence, a.publish_date desc, a.title ) t WHERE rownum <= 5 |
| 2bxq2hywwkdyr | select employee_id , create_time from sso_access_random where random_id = '0030ccfe-3f44-4f33-ba52-bf026dbb924a' and create_time >= sysdate-(1500/24/60/60)order by create_time desc |
| 2fc36b5tprbnj | SELECT ITEM_VALUE FROM SYSTEM_CONFIG WHERE UPPER (ENTRY_NAME) = UPPER (:B2 ) AND UPPER (ITEM_NAME) = UPPER (:B1 ) ORDER BY ENTRY_NAME, ITEM_NAME |
| 2n7pnwdqtupwc | SELECT * FROM FM_FORM_HEADER A WHERE A.FORM_KIND = 'SF.FORM.016' AND A.FORM_STATUS IN ('RJ', 'RF', 'RC', 'DE') AND TO_CHAR(A.BEGIN_DATE, 'yyyy/mm/dd') > TO_CHAR(SYSDATE - INTERVAL '7' DAY, 'yyyy/dd/dd') |
| 2z0t24tsdhm3f | SELECT ENTRY_NAME, ITEM_NAME, ITEM_VALUE, EXTENDED_ITEM_VALUE, ITEM_DESCRIPTION, EXTENDED_ITEM_VALUE_1 FROM SYSTEM_CONFIG WHERE UPPER (ENTRY_NAME) = UPPER (:B1 ) ORDER BY ENTRY_NAME, ITEM_NAME, ITEM_VALUE |
| 32u1r3mzp1dxr | SELECT COUNT (*) FROM USER_ARGUMENTS WHERE UPPER (PACKAGE_NAME) = UPPER (:B2 ) AND UPPER (OBJECT_NAME) = UPPER (:B1 ) |
| 381xz27ym8szc | SELECT LANGUAGE_VALUE FROM GLOSSARY_RUNTIME WHERE UPPER (LANGUAGE_ID) = UPPER (:B2 ) AND UPPER (LANGUAGE_TYPE) = UPPER (:B1 ) |
| 3bds5fm96y65w | SELECT FORM_KIND, UTILITY.GET_GLOSSARY_RUNTIME (FORM_NAME_LANGID, :B2 , FORM_NAME ) AS FORM_NAME, 'USUAL' AS FORM_TYPE_ID, :B3 AS FORM_TYPE_NAME, TOTALCOUNT, UTILITY.GET_GLOSSARY_RUNTIME (DESCRIPTION_LANGID, :B2 , DESCRIPTION ) AS DESCRIPTION, 'LOCAL' AS SYSTEM, '' AS URL FROM (SELECT A.FORM_KIND, A.FORM_NAME, A.FORM_NAME_LANGID, A.DESCRIPTION, A.DESCRIPTION_LANGID, B.TOTALCOUNT FROM FM_FORM_LIST A, (SELECT FORM_KIND, COUNT (FORM_KIND) AS TOTALCOUNT FROM FM_FORM_HEADER WHERE FILLER = :B1 AND BEGIN_DATE > ADD_MONTHS (SYSDATE, -3) AND BEGIN_DATE <= SYSDATE AND FORM_STATUS != 'DE' GROUP BY FORM_KIND) B WHERE A.FORM_KIND = B.FORM_KIND AND SYSDATE > A.CREATE_DATE AND SYSDATE < A.EXPIRE_DATE AND A.IS_ACTIVE != '0' AND A.FORM_KIND NOT IN (SELECT FORM_KIND FROM FM_FORM_MODULE WHERE CLOSE_MODULE_NAME = 'apply') ORDER BY B.TOTALCOUNT DESC) W WHERE ROWNUM < 16 ORDER BY W.TOTALCOUNT DESC, W.FORM_NAME |
| 3k1tmy83j2qjy | Begin form_define_flow.get_form_phase_define(:v0, :v1, :v2); End; |
| 3m1z5z7ym424x | Begin sf_eas_pkg.check_finanical_form_sa(:v0, :v1, :v2, :v3, :v4, :v5); End; |
| 3pj8tr5c9dc69 |
insert into GT$approve_work_list select fasub.FORM_NO , fasub.FORM_APPROVE_ID , fasub.FORM_KIND , fhsub.FORM_HEADER_ID , CASE WHEN (FA.APP_VALUE IS NULL OR FA.APP_VALUE <> 'R') AND FA.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NULL THEN 'Dismission' WHEN (FA.APP_VALUE IS NULL OR FA.APP_VALUE <> 'R') AND FA.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NOT NULL AND E.EXT_NO IS NULL THEN LTRIM(RTRIM(E.DISPLAY_NAME)) || '#NO_EXT' WHEN (FA.APP_VALUE IS NULL OR FA.APP_VALUE <> 'R') AND FA.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NOT NULL AND E.EXT_NO IS NOT NULL THEN LTRIM(RTRIM(E.DISPLAY_NAME)) || ' #' || E.EXT_NO ELSE fhsub.FORM_STATUS END AS FORM_STATUS , fasub.END_DATE , fhsub.APPLYER , case when fasub.APP_EMP_ID<>fasub.APP_ACTOR AND fasub.APP_EMP_ID = '1001A11000000000BAI3' then 'Y' else 'N' end AS IS_AGENT , fhsub.PRIORITY , fhsub.SYSTEM , G.WEB_PATH , CASE fhsub.SYSTEM WHEN 'LOCAL' THEN 0 ELSE 100 END AS SORT_ORDER , L.form_name , L.FORM_NAME_LANGID , CASE WHEN ( empapply.EMP_NAME IS NULL ) THEN 'None/Dismission' ELSE RTRIM(EMPAPPLY.EMP_NAME) END AS APPLY_EMP_NAME FROM FM_FORM_APPROVE fasub, FM_FORM_HEADER fhsub JOIN FM_FORM_LIST L ON fhsub.FORM_KIND = L.FORM_KIND and fhsub.system = L.system and L.is_active != '0' and (L.system != 'LOCAL' OR (L.system = 'LOCAL' AND L.form_kind not in (select form_kind from fm_form_module
where UPPER (close_modu
le_name) = UPPER ('Trace_Approve'))))LEFT JOIN GLOBAL_SYSTEM_LIST G ON fhsub.SYSTEM = G.SYSTEM_NAME LEFT JOIN FM_FORM_APPROVE_ACTIVE FA ON fhsub.SYSTEM = FA.SYSTEM AND fhsub.FORM_KIND = FA.FORM_KIND AND fhsub.FORM_NO = FA.FORM_NO left join AM_EMPLOYEE E ON E.EMP_ID = FA.APP_EMP_ID LEFT JOIN (SELECT EMP_ID, DISPLAY_NAME AS EMP_NAME, DEPT_CODE, EXT_NO FROM AM_EMPLOYEE) empapply ON empapply.EMP_ID = case when fhsub.APPLYER = '' OR fhsub.APPLYER is null then fhsub.filler else fhsub.APPLYER END where fasub.FORM_KIND=fhsub.FORM_KIND and fasub.FORM_NO=fhsub.FORM_NO and fasub.APP_TYPE in('A', 'P', 'M') and (fasub.APP_ACTOR='1001A11000000000BAI3' or (fasub.app_emp_id = '1001A11000000000BAI3' and fasub.APP_ACTOR <> fasub.app_emp_id))and fasub.app_status in ('A', 'T', 'H')and (fasub.END_DATE>to_date('2018/01/03', 'yyyy/MM/dd') or (fasub.APP_TYPE='M' and fasub.BEGIN_DATE>to_date('2018/01/03', 'yyyy/MM/dd') )) AND (fasub.END_DATE<=to_date('2018/01/03', 'yyyy/MM/dd')+1 or (fasub.APP_TYPE='M' and fasub.BEGIN_DATE<=to_date('2018/01/03', 'yyyy/MM/dd')+1 ))and fasub.FORM_KIND='SF.FORM.070' and fasub.SYSTEM = 'LOCAL' and fhsub.FORM_STATUS<>'DE' |
| 44hkw9wtt6xpn | SELECT * FROM ( SELECT a.article_id, a.article_Type_id, case when TITLE_LENGTH = 0 then a.title when length(a.title) > nvl(TITLE_LENGTH, 10) then substr(a.title, 1, nvl(TITLE_LENGTH, 10)) || '...' else a.TITLE end as title,
case when TITLE_LENGTH = 0 then '' when length(a.TITLE) > nvl(TITLE_LENGTH, 10) then a.TITLE else '' end as summary,
a.publish_date, a.publisher_id, (SELECT b.file_id FROM portal_article_attachment b WHERE b.article_id = a.article_id AND b.file_type='I' AND b.is_summary_picture=1) image_fieldID,
(CASE WHEN ABS(trunc(publish_date) - trunc(SYSDATE)) <=3 THEN 'Y' ELSE 'N' END ) is_new, a.status, a.hot_article_status, a.input_mode, a.image_frame, a.sequence, a.theme_picture
FROM portal_article a, PORTAL_ARTICLE_TYPE b
WHERE a.ARTICLE_TYPE_ID = b.ARTICLE_TYPE_ID and
a.article_type_id = '0423cc6a-d29f-4652-9dd2-84b9c2bab8d3' AND a.begin_date <= SYSDATE AND a.end_date >= SYSDATE AND a.status IN ('868E74A7-5E14-446e-8BC6-8AF30AA0C062', '77FD3924-BAA7-4222-B892-6BB2E3703536')
ORDER BY a.sequence, a.publish_date desc, a.title ) t WHERE rownum <= 5 |
| 47xugzmh5u561 |
select count(0) from (with tabs as
(select a.form_no,
a.apply_dept_name,
a.recruit_position_name,
to_char(a.sendform_date, 'yyyy-MM-dd') as begin_date,
to_char(a.expect_date, 'yyyy-MM-dd') as expect_date,
a.recruit_number,
a.position_band,
a.emmployee_band,
a.current_number,
decode(f.current_status, 'Y', 'ÓÐЧ', 'ÎÞЧ') as status
from sfbpm.sfform002 a
left join sfbpm.Sf_Establist_Worked f
on f.form_no = a.form_no
where f.form_kind = 'SF.FORM.002'
and exists
(select 0
from sfbpm.fm_form_header e
where e.form_kind = 'SF.FORM.002'
and e.form_status = 'AP'
and e.form_no = a.form_no)
and (case nvl(length(trim('1001K8100000000000Y7')), 0)
when 0 then
1
else
(select count(0) from dual where a.apply_dept_id = '1001K8100000000000Y7')
end) = 1
and (case nvl(length(''), 0)
when 0 then
1
else
(case ''
when '0' then
(select count(0)
from sfbpm.sf_org_expend z
where (z.is_store = 'N' or
(z.is_store = 'Y' and z.is_region='N'))
and z.ehr_dept_id = a.apply_dept_id)
else
(select count(0)
from sfbpm.sf_org_expend z
where z.is_store = 'Y'
and z.is_region = 'Y'
and z.ehr_dept_id = a.apply_dept_id)
end)
end) = 1
and (case nvl(length(trim('2017-01-01')), 0)
when 0 then
1
else
(select count(0)
from dual
where to_char(a.sendform_date, 'yyyymmdd') >=
replace('2017-01-01', '-', ''))
end) = 1
and (case nvl(length(trim('' )), 0)
when 0 then
1
else
(select count(0)
from dual
where to_char(a.sendform_date, 'yyyymmdd') <=
replace( '', '-', ''))
end) = 1
order by a.form_no)
select h.*,
m.hired_name || '(' || to_char(m.date_availabel, 'yyyy-MM-dd') || ')' as hired_info
from sfbpm.sfform003 m
inner join tabs h
on m.rcmapply_formno_id = h.form_no
where 1 = 1
and exists (select 0
from sfbpm.fm_form_header n
where n.form_kind = 'SF.FORM.003'
and n.form_status = 'AP'
and n.form_no = m.form_no)) |
| 4y2vbksdbgpkm | Begin facade_trace.approvelist_by_empid(:v0, :v1, :v2, :v3, :v4, :v5, :v6, :v7, :v8, :v9, :v10, :v11, :v12, :v13, :v14, :v15, :v16, :v17, :v18); End; |
| 4y6h01rsqhpdd | SELECT LANGUAGE_VALUE FROM GLOSSARY WHERE ID = :B2 AND UPPER (LANGUAGE_TYPE) = UPPER (:B1 ) |
| 4ztz048yfq32s | SELECT TO_CHAR(current_timestamp AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') AS curr_timestamp, COUNT(username) AS failed_count, TO_CHAR(MIN(timestamp), 'yyyy-mm-dd hh24:mi:ss') AS first_occur_time, TO_CHAR(MAX(timestamp), 'yyyy-mm-dd hh24:mi:ss') AS last_occur_time FROM sys.dba_audit_session WHERE returncode != 0 AND timestamp >= current_timestamp - TO_DSINTERVAL('0 0:30:00') |
| 5zn21xkbc44vg | INSERT INTO IM_MAIL_LW SELECT * FROM IM_MAIL A WHERE A.SEND_KIND <> 'SMS' |
| 65y6zn41uyqsd | Begin sf_eas_pkg.get_easapproverid_by_emp(:v0, :v1, :v2, :v3, :v4, :v5, :v6, :v7); End; |
| 6j64k91dv41qf |
insert into gt$apply_work_list select /*+ USE_HASH(a fa)*/ distinct A.FORM_HEADER_ID , A.FORM_NO , A.FORM_KIND , A.BEGIN_DATE , A.END_DATE , NVL(A.APPLYER, A.FILLER) , CASE WHEN (FA.APP_VALUE IS NULL OR FA.APP_VALUE <> 'R') AND FA.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NULL THEN 'Dismission' WHEN (FA.APP_VALUE IS NULL OR FA.APP_VALUE <> 'R') AND FA.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NOT NULL AND E.EXT_NO IS NULL THEN LTRIM(RTRIM(E.DISPLAY_NAME)) || '#NO_EXT' WHEN (FA.APP_VALUE IS NULL OR FA.APP_VALUE <> 'R') AND FA.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NOT NULL AND E.EXT_NO IS NOT NULL THEN LTRIM(RTRIM(E.DISPLAY_NAME)) || ' #' || E.EXT_NO ELSE A.FORM_STATUS END AS FORM_STATUS , A.PRIORITY , A.SYSTEM , G.WEB_PATH , CASE A.SYSTEM WHEN 'LOCAL' THEN 0 ELSE 100 END AS SORT_ORDER , L.form_name , L.form_name_langid , CASE WHEN ( empapply.EMP_NAME IS NULL) THEN 'None/Dismission' ELSE RTRIM(EMPAPPLY.EMP_NAME) END AS APPLY_EMP_NAME from FM_FORM_HEADER A join FM_FORM_LIST L on a.FORM_KIND = L.FORM_KIND and A.SYSTEM = L.SYSTEM and L.is_active != '0' AND (L."SYSTEM" != 'LOCAL' OR (L."SYSTEM" = 'LOCAL' AND L.form_kind not in (select form_kind from fm_form_module where UPPER (close_module_name) = UPPER ('Trace_Apply'))))LEFT JOIN GLOBAL_SYSTEM_LIST G ON A.SYSTEM = G.SYSTEM_NAME LEFT JOIN (SELECT * FROM FM_FORM_APPROVE_ACTIVE A WHERE FORM_APPROV
E_ID = (SELECT MIN(FORM_APPROVE_ID) FROM FM_FORM_APPROVE_ACTIVE B WHERE B.FORM_KIND = A.FORM_KIND AND B.FORM_NO = A.FORM_NO)) FA ON A.SYSTEM = FA.SYSTEM AND A.FORM_KIND = FA.FORM_KIND AND A.FORM_NO = FA.FORM_NO left join AM_EMPLOYEE E ON E.EMP_ID = FA.APP_EMP_ID LEFT JOIN (SELECT EMP_ID, DISPLAY_NAME AS EMP_NAME, DEPT_CODE, EXT_NO FROM AM_EMPLOYEE) empapply ON empapply.EMP_ID = case when A.APPLYER = '' OR A.APPLYER is null then A.filler else A.APPLYER END WHERE ((A.APPLYER = '0001A1100000000847S4' or A.FILLER = '0001A1100000000847S4') OR ( A.APPLYER IN (SELECT APP_EMP_ID FROM GT$AGENT_WORK agent )) )and A.BEGIN_DATE>to_date('1980/01/01', 'yyyy/MM/dd') and A.BEGIN_DATE<=to_date('2018/01/03', 'yyyy/MM/dd')+1 and A.FORM_STATUS<>'DE' and A.FORM_STATUS in ('NC', 'SA', 'RC') |
| 71cjyzpfnqy9x | SELECT COUNT(0) FROM SFFORM027_SUB3 A WHERE A.FORM_NO = :B1 |
| 76pdq9fg8pb9r | select max(serial) as serial from Exception_Log |
| 7cwhk3rytu3tg | DELETE FROM SF_EAS_APPROVE_TEMP A WHERE A.ID = :B1 AND (A.ID, A.APPROVER_ID, A.SEQUENCE_NO) IN (SELECT ID, APPROVER_ID, SEQUENCE_NO FROM SF_EAS_APPROVE_TEMP GROUP BY ID, APPROVER_ID, SEQUENCE_NO HAVING COUNT(*) > 1) AND ROWID NOT IN (SELECT MIN(ROWID) FROM SF_EAS_APPROVE_TEMP GROUP BY ID, APPROVER_ID, SEQUENCE_NO HAVING COUNT(*) > 1) |
| 7q64qp19mhnpm | Begin facade6.is_add_comment(:v0, :v1, :v2, :v3, :v4); End; |
| 80343682xrugc | Begin sf_eas_pkg.save_distribute_record(:v0, :v1, :v2, :v3, :v4, :v5, :v6, :v7, :v8, :v9, :v10, :v11, :v12, :v13, :v14, :v15, :v16, :v17, :v18, :v19, :v20, :v21, :v22, :v23, :v24); End; |
| 8nmnxr96hbyth | select /*+ rule */ DBA_SCHEDULER_JOB_RUN_DETAILS.JOB_NAME, STATUS, LOG_DATE from DBA_SCHEDULER_JOB_RUN_DETAILS join DBA_SCHEDULER_JOBS on DBA_SCHEDULER_JOBS.JOB_NAME=DBA_SCHEDULER_JOB_RUN_DETAILS.JOB_NAME where (DBA_SCHEDULER_JOB_RUN_DETAILS.JOB_NAME, log_date) in (select JOB_NAME, max(log_date) from DBA_SCHEDULER_JOB_RUN_DETAILS group by JOB_NAME) |
| 8qqc7m8uy8jqq | SELECT * FROM (SELECT 1 AS PRIORITY, BASE_EMP_ID, ADDED_EMP_ID, SERIAL_NO, ROLE_NAME, ADD_POSITION FROM FM_FORM_RULE WHERE FORM_KIND = '*' AND PHASE_ID = '*' AND BEGIN_ON <= SYSDATE AND (END_ON IS NULL OR END_ON > SYSDATE - 1) UNION SELECT 2 AS PRIORITY, BASE_EMP_ID, ADDED_EMP_ID, SERIAL_NO, ROLE_NAME, ADD_POSITION FROM FM_FORM_RULE WHERE FORM_KIND = :B2 AND PHASE_ID = :B1 AND BEGIN_ON <= SYSDATE AND (END_ON IS NULL OR END_ON > SYSDATE - 1) UNION SELECT 3 AS PRIORITY, BASE_EMP_ID, ADDED_EMP_ID, SERIAL_NO, ROLE_NAME, ADD_POSITION FROM FM_FORM_RULE WHERE FORM_KIND = :B2 AND PHASE_ID = '*' AND BEGIN_ON <= SYSDATE AND (END_ON IS NULL OR END_ON > SYSDATE - 1) ) T ORDER BY PRIORITY, SERIAL_NO |
| 8r7kcrhb8bgux | SELECT :B2 || :B1 FROM DUAL |
| 8txqgm42sh0xt | SELECT * FROM ( SELECT a.article_id, a.article_Type_id, case when TITLE_LENGTH = 0 then a.title when length(a.title) > nvl(TITLE_LENGTH, 10) then substr(a.title, 1, nvl(TITLE_LENGTH, 10)) || '...' else a.TITLE end as title,
case when TITLE_LENGTH = 0 then '' when length(a.TITLE) > nvl(TITLE_LENGTH, 10) then a.TITLE else '' end as summary,
a.publish_date, a.publisher_id, (SELECT b.file_id FROM portal_article_attachment b WHERE b.article_id = a.article_id AND b.file_type='I' AND b.is_summary_picture=1) image_fieldID,
(CASE WHEN ABS(trunc(publish_date) - trunc(SYSDATE)) <=3 THEN 'Y' ELSE 'N' END ) is_new, a.status, a.hot_article_status, a.input_mode, a.image_frame, a.sequence, a.theme_picture
FROM portal_article a, PORTAL_ARTICLE_TYPE b
WHERE a.ARTICLE_TYPE_ID = b.ARTICLE_TYPE_ID and
a.article_type_id = '3f59ec5f-30ee-4b0e-8acc-d38201ad9acb' AND a.begin_date <= SYSDATE AND a.end_date >= SYSDATE AND a.status IN ('868E74A7-5E14-446e-8BC6-8AF30AA0C062', '77FD3924-BAA7-4222-B892-6BB2E3703536')
ORDER BY a.sequence, a.publish_date desc, a.title ) t WHERE rownum <= 5 |
| 9d9x01g497u5x | call PKG_SFFORM007.update_last_month_time ( ) |
| 9ndb0q17254x3 | SELECT B.EMP_ID, B.LOGIN_NAME AS LOGIN_NAME, B.EMP_NAME AS EMP_NAME, B.DISPLAY_NAME AS DISPLAY_NAME FROM TABLE (UTILITY.SPLIT_LIST_V2 (:B1 )) A INNER JOIN AM_EMPLOYEE B ON UPPER (A.COLUMN_VALUE) = UPPER (B.EMP_ID) AND UPPER (B.ACTIVE) = 'Y' |
| 9p7sgb3b8w8qf | Begin facade_trace.deallist_by_empid(:v0, :v1, :v2, :v3, :v4, :v5, :v6, :v7, :v8, :v9, :v10, :v11, :v12, :v13, :v14, :v15, :v16, :v17); End; |
| 9r23yvyjanjn5 | Begin facade5.query_applist_by_empid(:v0, :v1, :v2, :v3, :v4, :v5, :v6, :v7, :v8, :v9, :v10, :v11, :v12, :v13, :v14, :v15); End; |
| 9tjhvtxs321r4 | call BPM_CUSTOM_SUPER_PKG.BPM_CUSTOM_SUPER_VIEW ( ) |
| a3yj0byqzuu9f | DELETE FROM SFBPM.FM_FORM_APPROVE C WHERE C.FORM_NO = :B1 AND C.PHASE_ID = 'SF.FORM.024.APPH.15' AND C.FORM_KIND = 'SF.FORM.024' |
| acbjmk8p6mzkw |
insert into GT$DEAL_WORK_LIST select fa.FORM_APPROVE_ID, fa.FORM_KIND, fa.FORM_NO, fa.END_DATE , case when fa.APP_ACTOR<>'0001A1100000000CPHZG' THEN 'Y' else 'N' end as IS_AGENT , fa.SYSTEM , G.WEB_PATH , CASE FA.SYSTEM WHEN 'LOCAL' THEN 0 ELSE 100 END AS SORT_ORDER , CASE WHEN (Faa.APP_VALUE IS NULL OR Faa.APP_VALUE <> 'R') AND Faa.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NULL THEN 'Dismission' WHEN (Faa.APP_VALUE IS NULL OR Faa.APP_VALUE <> 'R') AND Faa.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NOT NULL AND E.EXT_NO IS NULL THEN LTRIM(RTRIM(E.DISPLAY_NAME)) || '#NO_EXT' WHEN (Faa.APP_VALUE IS NULL OR Faa.APP_VALUE <> 'R') AND Faa.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NOT NULL AND E.EXT_NO IS NOT NULL THEN LTRIM(RTRIM(E.DISPLAY_NAME)) || ' #' || E.EXT_NO ELSE fh.FORM_STATUS END AS FORM_STATUS , fl.form_name , fl.form_name_langid , CASE WHEN (empapply.EMP_NAME IS NULL) THEN 'None/Dismission' ELSE RTRIM(EMPAPPLY.EMP_NAME) END AS APPLY_EMP_NAME , RTRIM(EMPAPPLY.EMP_ID) AS APPLYER FROM FM_FORM_APPROVE FA, FM_FORM_HEADER FH LEFT JOIN FM_FORM_LIST FL ON FH.FORM_KIND = FL.FORM_KIND and FH.system = FL.system and FL.is_active != '0' and (FL.system != 'LOCAL' OR (FL.system = 'LOCAL' AND (FL.form_kind not in (select form_kind from fm_form_module where UPPER (close_module_name) = UPPER ('Trace_Deal')))))LEFT JOIN (SELECT EMP_ID, DISPLAY_NAME AS EMP_NAME, DEPT_CODE, EXT_NO F
ROM AM_EMPLOYEE ) empapply ON empapply.EMP_ID = case when fh.APPLYER = '' OR fh.APPLYER is null then fh.filler else fh.APPLYER END LEFT JOIN GLOBAL_SYSTEM_LIST G ON fh.SYSTEM = G.SYSTEM_NAME LEFT JOIN (select a.* from FM_FORM_APPROVE_ACTIVE a Right JOIN (select min(begin_date) as begin_date, form_kind, form_no from FM_FORM_APPROVE_ACTIVE group by form_kind, form_no) b on a.form_kind = b.form_kind and a.form_no = b.form_no and a.begin_date = b.begin_date ) Faa ON FH.SYSTEM = Faa.SYSTEM AND FH.FORM_KIND = FAa.FORM_KIND AND FH.FORM_NO = Faa.FORM_NO left join AM_EMPLOYEE E ON E.EMP_ID = Faa.APP_EMP_ID where (fa.APP_ACTOR='0001A1100000000CPHZG' or (fa.app_emp_id = '0001A1100000000CPHZG' and fa.APP_ACTOR <> fa.app_emp_id)) and fa.app_status in ('A', 'T') and fa.APP_TYPE='D'and fa.FORM_KIND=fh.FORM_KIND and fa.FORM_NO=fh.FORM_NO and fa.SYSTEM=fh.SYSTEM and fa.END_DATE>to_date('2018/01/03', 'yyyy/MM/dd') and fa.END_DATE <= to_date('2018/01/03', 'yyyy/MM/dd') + 1 and fh.FORM_STATUS<>'DE' |
| afbm8u2s8d0kk | INSERT INTO GT$PHASE_DEFINE SELECT :B2 AS SHOWSEQUENCE, A.FORM_PHASE_ID AS FORM_PHASE_ID, A.FORM_PHASE_ID AS FORM_PHASE_ID_HIDDEN, A.FORM_PHASE_NAME AS FORM_PHASE_NAME, A.DESCRIPTION AS DESCRIPTION, A.PHASE_TYPE AS PHASE_TYPE, A.PHASE_TYPE_ALIAS AS PHASE_TYPE_ALIAS, A.SEQUENCE_NO AS SEQUENCE_NO, A.COMPLETE_TYPE AS COMPLETE_TYPE, A.COMPLETE_TYPE_ALIAS AS COMPLETE_TYPE_ALIAS, '' AS CONDITION_ID, '' AS CONDITION_NAME, '' AS CONDITION_SEQUENCE, '' AS CONDITION_NAME_EDIT, '' AS PARTICIPANT_ID, '' AS PARTICIPANT_NAME, 'Y' AS IS_EDIT, '' AS CONDITION_EXPS FROM GT$PHASE_DEFINE_TMP A WHERE A.FORM_PHASE_ID = :B1 |
| aj2n376f5jrw9 | select a.form_no from SFFORM031 a
inner join fm_form_header b
ON a.form_no=b.form_no
where a.id=:p_id
and b.form_kind=:p_form_kind
and b.form_status in('WA', 'UA', 'WP', 'AP') |
| b9jrsu75khts5 | UPDATE BPM_AUTO_EXE_INTERFACE SET END_TIME = SYSDATE, IS_FLAG = :B5 , STEP_NUM = :B4 , OUTPUT_PARAS = :B3 , OUT_MESSAGE = :B2 WHERE ID = :B1 |
| bctd1zkzbwb09 | Begin facade_trace.applylist_by_empid(:v0, :v1, :v2, :v3, :v4, :v5, :v6, :v7, :v8, :v9, :v10, :v11, :v12, :v13, :v14, :v15, :v16, :v17); End; |
| bj9zph7jur2d6 |
select a.*,
c.VOUCHERNUMBER EAS_INFO, --ƾ֤ºÅ
c.VOUCHERNAME EAS_WORD, --ƾ֤×Ö
NVL(c.active, 'N') status
from (select '³ö²îÉêÇëµ¥' form_kind_name,
b.form_kind,
a.form_no,
a.cash_place,
a.emp_applicant applyer,
pkg_sf_hr.get_empname_by_empid(a.emp_applicant) appler_name, --ÉêÇëÈËÐÕÃû
sf_eas_pkg.get_ess_projectname(a.EAS_PROJECT) ABSTRACT,
b.end_date,
b.form_kind form_kind_value,
a.form_no form_no_value
from sfform029 a
inner join fm_form_header b
on a.form_no = b.form_no
and b.form_kind = 'SF.FORM.029'
where exists(select 0 from sf_keep_account org
where org.erp_cashshop=a.cash_place and org.emp_id='0001A110000000009PY7') and b.form_status = 'AP' and a.borrow_money>0 union select '²îÂñ¨Ïúµ¥' form_kind_name,
b.form_kind,
a.form_no,
a.cash_place_id as cash_place,
a.applyer applyer,
pkg_sf_hr.get_empname_by_empid(a.applyer) appler_name, --ÉêÇëÈËÐÕÃû
a.budget_dept_name ABSTRACT,
b.end_date,
b.form_kind form_kind_value,
a.form_no form_no_valu
e
from sfform024 a
inner join fm_form_header b
on a.form_no = b.form_no
and b.form_kind = 'SF.FORM.024'
where exists(select 0 from sf_keep_account org
where org.erp_cashshop=a.cash_place_id and org.emp_id='0001A110000000009PY7')
and b.form_status = 'AP'
and (a.loanamount>0 or a.expense_audit>0) union select '½è¿îµ¥' form_kind_name,
b.form_kind,
a.form_no,
a.cash_place_id as cash_place,
a.applyer applyer,
pkg_sf_hr.get_empname_by_empid(a.applyer) appler_name, --ÉêÇëÈËÐÕÃû
budget_project_name ABSTRACT,
b.end_date,
b.form_kind form_kind_value,
a.form_no form_no_value
from sfform025 a
inner join fm_form_header b
on a.form_no = b.form_no
and b.form_kind = 'SF.FORM.025'
where exists(select 0 from sf_keep_account org
where org.erp_cashshop=a.cash_place_id and org.emp_id='0001A110000000009PY7') and b.form_status = 'AP' union select '±¨Ïúµ¥' form_kind_name,
b.form_kind,
a.form_no,
a.cash_place_id as cash_place,
a.applyer applyer,
pkg_sf_hr.get_empname
_by_empid(a.applyer) appler_name, --ÉêÇëÈËÐÕÃû
sf_eas_pkg.get_ess_projectname(a.budget_project_id) ABSTRACT,
b.end_date,
b.form_kind form_kind_value,
a.form_no form_no_value
from sfform027 a
inner join fm_form_header b
on a.form_no = b.form_no
and b.form_kind = 'SF.FORM.027'
where exists(select 0 from sf_keep_account org
where org.erp_cashshop=a.cash_place_id and org.emp_id='0001A110000000009PY7') and b.form_status = 'AP' union select '»¹¿îµ¥' form_kind_name,
b.form_kind,
a.form_no,
a.cash_place_id as cash_place,
a.applyer,
pkg_sf_hr.get_empname_by_empid(a.applyer) appler_name, --ÉêÇëÈËÐÕÃû
a.budget_project_name abstract,
b.end_date,
b.form_kind form_kind_value,
a.form_no form_no_value
from sfform028 a
inner join fm_form_header b
on a.form_no = b.form_no
and b.form_kind = 'SF.FORM.028'
where exists(select 0 from sf_keep_account org
where org.erp_cashshop=a.cash_place_id and org.emp_id='0001A110000000009PY7') and b.form_status = 'AP' union select 'ÌØÊâÖ§¸¶ÉêÇëµ¥' form_kind_name,
b.
form_kind,
a.form_no,
a.cash_place_id as cash_place,
a.applyer,
pkg_sf_hr.get_empname_by_empid(a.applyer) appler_name, --ÉêÇëÈËÐÕÃû
'Ö°Ô±' ABSTRACT,
b.end_date,
b.form_kind form_kind_value,
a.form_no form_no_value
from sfform055 a
inner join fm_form_header b
on a.form_no = b.form_no
and b.form_kind = 'SF.FORM.055'
where exists(select 0 from sf_keep_account org
where org.erp_cashshop=a.cash_place_id and org.emp_id='0001A110000000009PY7') and b.form_status = 'AP' union select '½»¿îµ¥' form_kind_name,
b.form_kind,
a.form_no,
a.cash_place_id as cash_place,
a.applyer applyer,
a.emp_name appler_name, --ÉêÇëÈËÐÕÃû
a.budget_project_name abstract,
b.end_date,
b.form_kind form_kind_value,
a.form_no form_no_value
from sfform051 a
inner join fm_form_header b
on a.form_no = b.form_no
and b.form_kind = 'SF.FORM.051'
where exists(select 0 from sf_keep_account org
where org.erp_cashshop=a.cash_place_id and org.emp_id='0001A110000000009PY7') and b.form_status = 'AP' union select 'ÎïÆ·²É¹º¸¶¿îµ¥' form_kind_name,
b.form_kind,
a.form_no,
a.cash_place,
a.form_applicant applyer,
pkg_sf_hr.get_empname_by_empid(a.form_applicant) appler_name, --ÉêÇëÈËÐÕÃû
'ÎÞ' abstract,
b.end_date,
b.form_kind form_kind_value,
a.form_no form_no_value
from sfform045 a
inner join fm_form_header b
on a.form_no = b.form_no
and b.form_kind = 'SF.FORM.045'
where exists(select 0 from sf_keep_account org
where org.erp_cashshop=a.cash_place and org.emp_id='0001A110000000009PY7') and b.form_status = 'AP' union select '²ÆÎñתÕËÊÖÐø·Ñ' form_kind_name, 'SF.FORM.CHARGE' form_kind, a.item_no form_no, a.cash_place, '' applyer, '' appler_name, 'תÕËÊÖÐø·Ñ' ABSTRACT, a.create_date end_date, a.form_kind form_kind_value, a.form_no form_no_value from (select * from sf_eas_charges_money b where b.item_no||'/'||b.form_kind||'/'||b.form_no in (select max(c.item_no||'/'||c.form_kind||'/'||c.form_no) from sf_eas_charges_money c group by c.item_no) order by b.item_no)a union select 'ZJN¸öÈË·ÑÓõ¥' form_kind_name,
b.form_kind,
a.form_no,
a.reimbur_cash_place as cash_place,
a.applyer applyer,
pkg_sf_hr.get_empname_by_empid(a.applyer) appler_name, --ÉêÇëÈËÐÕÃû
sf_eas_p
kg.get_ess_projectname(a.reimbur_project) ABSTRACT,
b.end_date,
b.form_kind form_kind_value,
a.form_no form_no_value
from sfform072 a
inner join fm_form_header b
on a.form_no = b.form_no
and b.form_kind = 'SF.FORM.072'
where exists(select 0 from sf_keep_account org
where org.erp_cashshop=a.reimbur_cash_place and org.emp_id='0001A110000000009PY7') and b.form_status = 'AP' union select 'Ô¤¸¶¹¤³Ì¿î' form_kind_name,
b.form_kind,
a.form_no,
a.cash_place_id as cash_place,
a.applyer applyer,
pkg_sf_hr.get_empname_by_empid(a.applyer) appler_name, --ÉêÇëÈËÐÕÃû
sf_eas_pkg.get_ess_projectname(a.budget_project_id) ABSTRACT,
b.end_date,
b.form_kind form_kind_value,
a.form_no form_no_value
from sfform075 a
inner join fm_form_header b
on a.form_no = b.form_no
and b.form_kind = 'SF.FORM.075'
where exists(select 0 from sf_keep_account org
where org.erp_cashshop=a.cash_place_id and org.emp_id='0001A110000000009PY7') and b.form_status = 'AP' union select '·¿×⸶¿îµ¥' form_kind_name,
b.form_kind,
a.form_no,
a.cash_place_id as cash_place,
a.applyer applyer,
pkg_sf_hr.get_empname_by_empid(a.applyer) appler_name, --ÉêÇëÈËÐÕÃû
'' ABSTRACT,
b.end_date,
b.form_kind form_kind_value,
a.form_no form_no_value
from sfform080 a
inner join fm_form_header b
on a.form_no = b.form_no
and b.form_kind = 'SF.FORM.080'
where exists(select 0 from sf_keep_account org
where org.erp_cashshop=a.cash_place_id and org.emp_id='0001A110000000009PY7') and b.form_status = 'AP' union select '·¿×â½»¿îµ¥' form_kind_name,
b.form_kind,
a.form_no,
a.cash_place_id as cash_place,
a.applyer applyer,
pkg_sf_hr.get_empname_by_empid(a.applyer) appler_name, --ÉêÇëÈËÐÕÃû
'' ABSTRACT,
b.end_date,
b.form_kind form_kind_value,
a.form_no form_no_value
from sfform081 a
inner join fm_form_header b
on a.form_no = b.form_no
and b.form_kind = 'SF.FORM.081'
where exists(select 0 from sf_keep_account org
where org.erp_cashshop=a.cash_place_id and org.emp_id='0001A1
10000000009PY7') and b.form_status = 'AP' union select '½±½ðרÓñ¨Ïúµ¥' form_kind_name,
b.form_kind,
a.form_no,
a.cash_place_id as cash_place,
a.applyer applyer,
pkg_sf_hr.get_empname_by_empid(a.applyer) appler_name, --ÉêÇëÈËÐÕÃû
'' ABSTRACT,
b.end_date,
b.form_kind form_kind_value,
a.form_no form_no_value
from sfform084 a
inner join fm_form_header b
on a.form_no = b.form_no
and b.form_kind = 'SF.FORM.084'
where exists(select 0 from sf_keep_account org
where org.erp_cashshop=a.cash_place_id and org.emp_id='0001A110000000009PY7') and b.form_status = 'AP' union select 'רÓñ¨Ïúµ¥' form_kind_name,
b.form_kind,
a.form_no,
a.cash_place_id as cash_place,
a.applyer applyer,
pkg_sf_hr.get_empname_by_empid(a.applyer) appler_name, --ÉêÇëÈËÐÕÃû
sf_eas_pkg.get_ess_projectname(a.budget_project_id) ABSTRACT,
b.end_date,
b.form_kind form_kind_value,
a.form_no form_no_value
from sff
orm091 a
inner join fm_form_header b
on a.form_no = b.form_no
and b.form_kind = 'SF.FORM.091'
where exists(select 0 from sf_keep_account org
where org.erp_cashshop=a.cash_place_id and org.emp_id='0001A110000000009PY7') and b.form_status = 'AP' ) a
left join sf_eas_credetial_info c
on c.form_no = a.form_no
and c.form_kind = a.form_kind
and c.active<>'N'
where 1=1 and c.active is null and a.cash_place='ZBZ' order by a.form_kind, a.form_no |
| bq6mg126pgtmt | SELECT SHOW_SEQUENCE, FORM_PHASE_ID, FORM_PHASE_ID_HIDDEN, FORM_PHASE_NAME, DESCRIPTION, PHASE_TYPE, PHASE_TYPE_ALIAS, SEQUENCE_NO, COMPLETE_TYPE, COMPLETE_TYPE_ALIAS, CONDITION_ID, CONDITION_NAME, CONDITION_SEQUENCE, CONDITION_NAME_EDIT, PARTICIPANT_ID, PARTICIPANT_NAME, IS_EDIT, CONDITION_EXPS FROM GT$PHASE_DEFINE ORDER BY SHOW_SEQUENCE, CONDITION_SEQUENCE |
| c31cbr5c6n90w | INSERT INTO GT$PHASE_DEFINE SELECT :B2 AS SHOWSEQUENCE, '' AS FORM_PHASE_ID, A.FORM_PHASE_ID AS FORM_PHASE_ID_HIDDEN, '' AS FORM_PHASE_NAME, '' AS DESCRIPTION, '' AS PHASE_TYPE, '' AS PHASE_TYPE_ALIAS, '' AS SEQUENCE_NO, '' AS COMPLETE_TYPE, '' AS COMPLETE_TYPE_ALIAS, B.CONDITION_ID AS CONDITION_ID, TO_CHAR (B.SEQUENCE_NO) || '.' || B.CONDITION_NAME AS CONDITION_NAME, TO_CHAR (B.SEQUENCE_NO) AS CONDITION_SEQUENCE, B.CONDITION_NAME AS CONDITION_NAME_EDIT, B.PARTICIPANT_ID AS PARTICIPANT_ID, B.PARTICIPANT_NAME AS PARTICIPANT_NAME, 'N' AS IS_EDIT, UPPER (B.CONDITION_EXPS) AS CONDITION_EXPS FROM GT$PHASE_DEFINE_TMP A, FM_PHASE_RULE B WHERE A.FORM_PHASE_ID = :B1 AND B.FORM_PHASE_ID = :B1 ORDER BY B.SEQUENCE_NO |
| c4r9jpxujffkq | SELECT DRAWING, MIMETYPE FROM AM_SIGNED_DRAWING WHERE EMP_ID = :B1 |
| c95q0986ru2p3 | SELECT * FROM ( SELECT a.article_id, a.article_Type_id, case when TITLE_LENGTH = 0 then a.title when length(a.title) > nvl(TITLE_LENGTH, 10) then substr(a.title, 1, nvl(TITLE_LENGTH, 10)) || '...' else a.TITLE end as title,
case when TITLE_LENGTH = 0 then '' when length(a.TITLE) > nvl(TITLE_LENGTH, 10) then a.TITLE else '' end as summary,
a.publish_date, a.publisher_id, (SELECT b.file_id FROM portal_article_attachment b WHERE b.article_id = a.article_id AND b.file_type='I' AND b.is_summary_picture=1) image_fieldID,
(CASE WHEN ABS(trunc(publish_date) - trunc(SYSDATE)) <=3 THEN 'Y' ELSE 'N' END ) is_new, a.status, a.hot_article_status, a.input_mode, a.image_frame, a.sequence, a.theme_picture
FROM portal_article a, PORTAL_ARTICLE_TYPE b
WHERE a.ARTICLE_TYPE_ID = b.ARTICLE_TYPE_ID and
a.article_type_id = 'ff711a71-eb96-4732-9468-0dab94c11f78' AND a.begin_date <= SYSDATE AND a.end_date >= SYSDATE AND a.status IN ('868E74A7-5E14-446e-8BC6-8AF30AA0C062', '77FD3924-BAA7-4222-B892-6BB2E3703536')
ORDER BY a.sequence, a.publish_date desc, a.title ) t WHERE rownum <= 5 |
| cjst4ggak3hck | Begin facade3.query_approvelist_by_kind_no(:v0, :v1, :v2, :v3); End; |
| ckf0s84rt9x9s | INSERT INTO GT$PHASE_DEFINE SELECT :B2 AS SHOWSEQUENCE, A.FORM_PHASE_ID AS FORM_PHASE_ID, A.FORM_PHASE_ID AS FORM_PHASE_ID_HIDDEN, A.FORM_PHASE_NAME AS FORM_PHASE_NAME, A.DESCRIPTION AS DESCRIPTION, A.PHASE_TYPE AS PHASE_TYPE, A.PHASE_TYPE_ALIAS AS PHASE_TYPE_ALIAS, A.SEQUENCE_NO AS SEQUENCE_NO, A.COMPLETE_TYPE AS COMPLETE_TYPE, A.COMPLETE_TYPE_ALIAS AS COMPLETE_TYPE_ALIAS, '' AS CONDITION_ID, '' AS CONDITION_NAME, '' AS CONDITION_SEQUENCE, '' AS CONDITION_NAME_EDIT, '' AS PARTICIPANT_ID, '' AS PARTICIPANT_NAME, 'Y' AS IS_EDIT, 'TRUE' AS CONDITION_EXPS FROM GT$PHASE_DEFINE_TMP A WHERE A.FORM_PHASE_ID = :B1 ORDER BY A.SEQUENCE_NO |
| cwaw770wjg7va | SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("GS_MEMBER") FULL("GS_MEMBER") NO_PARALLEL_INDEX("GS_MEMBER") */ :"SYS_B_2" AS C1, CASE WHEN LOWER("GS_MEMBER"."ACCOUNT")=:"SYS_B_3" THEN :"SYS_B_4" ELSE :"SYS_B_5" END AS C2 FROM "GREENOFFICE"."GS_MEMBER" SAMPLE BLOCK (:"SYS_B_6" , :"SYS_B_7") SEED (:"SYS_B_8") "GS_MEMBER") SAMPLESUB |
| dcbjb85abzw02 |
insert into GT$DEAL_WORK_LIST select fa.FORM_APPROVE_ID, fa.FORM_KIND, fa.FORM_NO, fa.END_DATE , case when fa.APP_ACTOR<>'1001K810000000000670' THEN 'Y' else 'N' end as IS_AGENT , fa.SYSTEM , G.WEB_PATH , CASE FA.SYSTEM WHEN 'LOCAL' THEN 0 ELSE 100 END AS SORT_ORDER , CASE WHEN (Faa.APP_VALUE IS NULL OR Faa.APP_VALUE <> 'R') AND Faa.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NULL THEN 'Dismission' WHEN (Faa.APP_VALUE IS NULL OR Faa.APP_VALUE <> 'R') AND Faa.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NOT NULL AND E.EXT_NO IS NULL THEN LTRIM(RTRIM(E.DISPLAY_NAME)) || '#NO_EXT' WHEN (Faa.APP_VALUE IS NULL OR Faa.APP_VALUE <> 'R') AND Faa.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NOT NULL AND E.EXT_NO IS NOT NULL THEN LTRIM(RTRIM(E.DISPLAY_NAME)) || ' #' || E.EXT_NO ELSE fh.FORM_STATUS END AS FORM_STATUS , fl.form_name , fl.form_name_langid , CASE WHEN (empapply.EMP_NAME IS NULL) THEN 'None/Dismission' ELSE RTRIM(EMPAPPLY.EMP_NAME) END AS APPLY_EMP_NAME , RTRIM(EMPAPPLY.EMP_ID) AS APPLYER FROM FM_FORM_APPROVE FA, FM_FORM_HEADER FH LEFT JOIN FM_FORM_LIST FL ON FH.FORM_KIND = FL.FORM_KIND and FH.system = FL.system and FL.is_active != '0' and (FL.system != 'LOCAL' OR (FL.system = 'LOCAL' AND (FL.form_kind not in (select form_kind from fm_form_module where UPPER (close_module_name) = UPPER ('Trace_Deal')))))LEFT JOIN (SELECT EMP_ID, DISPLAY_NAME AS EMP_NAME, DEPT_CODE, EXT_NO F
ROM AM_EMPLOYEE ) empapply ON empapply.EMP_ID = case when fh.APPLYER = '' OR fh.APPLYER is null then fh.filler else fh.APPLYER END LEFT JOIN GLOBAL_SYSTEM_LIST G ON fh.SYSTEM = G.SYSTEM_NAME LEFT JOIN (select a.* from FM_FORM_APPROVE_ACTIVE a Right JOIN (select min(begin_date) as begin_date, form_kind, form_no from FM_FORM_APPROVE_ACTIVE group by form_kind, form_no) b on a.form_kind = b.form_kind and a.form_no = b.form_no and a.begin_date = b.begin_date ) Faa ON FH.SYSTEM = Faa.SYSTEM AND FH.FORM_KIND = FAa.FORM_KIND AND FH.FORM_NO = Faa.FORM_NO left join AM_EMPLOYEE E ON E.EMP_ID = Faa.APP_EMP_ID where (fa.APP_ACTOR='1001K810000000000670' or (fa.app_emp_id = '1001K810000000000670' and fa.APP_ACTOR <> fa.app_emp_id)) and fa.app_status in ('A', 'T') and fa.APP_TYPE='D'and fa.FORM_KIND=fh.FORM_KIND and fa.FORM_NO=fh.FORM_NO and fa.SYSTEM=fh.SYSTEM and fa.END_DATE>to_date('2018/01/03', 'yyyy/MM/dd') and fa.END_DATE <= to_date('2018/01/03', 'yyyy/MM/dd') + 1 and fh.FORM_STATUS<>'DE' |
| dcm76bsjf3vd6 |
insert into gt$apply_work_list select /*+ USE_HASH(a fa)*/ distinct A.FORM_HEADER_ID , A.FORM_NO , A.FORM_KIND , A.BEGIN_DATE , A.END_DATE , NVL(A.APPLYER, A.FILLER) , CASE WHEN (FA.APP_VALUE IS NULL OR FA.APP_VALUE <> 'R') AND FA.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NULL THEN 'Dismission' WHEN (FA.APP_VALUE IS NULL OR FA.APP_VALUE <> 'R') AND FA.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NOT NULL AND E.EXT_NO IS NULL THEN LTRIM(RTRIM(E.DISPLAY_NAME)) || '#NO_EXT' WHEN (FA.APP_VALUE IS NULL OR FA.APP_VALUE <> 'R') AND FA.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NOT NULL AND E.EXT_NO IS NOT NULL THEN LTRIM(RTRIM(E.DISPLAY_NAME)) || ' #' || E.EXT_NO ELSE A.FORM_STATUS END AS FORM_STATUS , A.PRIORITY , A.SYSTEM , G.WEB_PATH , CASE A.SYSTEM WHEN 'LOCAL' THEN 0 ELSE 100 END AS SORT_ORDER , L.form_name , L.form_name_langid , CASE WHEN ( empapply.EMP_NAME IS NULL) THEN 'None/Dismission' ELSE RTRIM(EMPAPPLY.EMP_NAME) END AS APPLY_EMP_NAME from FM_FORM_HEADER A join FM_FORM_LIST L on a.FORM_KIND = L.FORM_KIND and A.SYSTEM = L.SYSTEM and L.is_active != '0' AND (L."SYSTEM" != 'LOCAL' OR (L."SYSTEM" = 'LOCAL' AND L.form_kind not in (select form_kind from fm_form_module where UPPER (close_module_name) = UPPER ('Trace_Apply'))))LEFT JOIN GLOBAL_SYSTEM_LIST G ON A.SYSTEM = G.SYSTEM_NAME LEFT JOIN (SELECT * FROM FM_FORM_APPROVE_ACTIVE A WHERE FORM_APPROV
E_ID = (SELECT MIN(FORM_APPROVE_ID) FROM FM_FORM_APPROVE_ACTIVE B WHERE B.FORM_KIND = A.FORM_KIND AND B.FORM_NO = A.FORM_NO)) FA ON A.SYSTEM = FA.SYSTEM AND A.FORM_KIND = FA.FORM_KIND AND A.FORM_NO = FA.FORM_NO left join AM_EMPLOYEE E ON E.EMP_ID = FA.APP_EMP_ID LEFT JOIN (SELECT EMP_ID, DISPLAY_NAME AS EMP_NAME, DEPT_CODE, EXT_NO FROM AM_EMPLOYEE) empapply ON empapply.EMP_ID = case when A.APPLYER = '' OR A.APPLYER is null then A.filler else A.APPLYER END WHERE ((A.APPLYER = '0001A1100000000A3W2G' or A.FILLER = '0001A1100000000A3W2G') OR ( A.APPLYER IN (SELECT APP_EMP_ID FROM GT$AGENT_WORK agent )) )and A.BEGIN_DATE>to_date('1980/01/01', 'yyyy/MM/dd') and A.BEGIN_DATE<=to_date('2018/01/03', 'yyyy/MM/dd')+1 and A.FORM_STATUS<>'DE' and A.FORM_STATUS in ('NC', 'SA', 'RC') |
| f45gwv9g537sz | SELECT PREVIEW_SHOW, CONTINUE_APPROVE, AGENT_APPROVE, ENTRY_MODULE, MAIL_CONTINUE_APPROVE, CULTUREL FROM AM_EMPLOYEE WHERE EMP_ID = :B1 |
| f4yx2jj2j4pkv | select a.budget_dept_name, a.budget_project_name from sfbpm.sfform027 a inner join sfbpm.fm_form_approve b on a.form_no=b.form_no and b.form_kind='SF.FORM.027' where b.app_emp_id='0001A11000000000AS9W' and b.app_status='U'
|
| f9w4h0t9xjrkm | Begin kernel.get_system_config(:v0, :v1, :v2); End; |
| g9pqang0xundt |
insert into gt$apply_work_list select /*+ USE_HASH(a fa)*/ distinct A.FORM_HEADER_ID , A.FORM_NO , A.FORM_KIND , A.BEGIN_DATE , A.END_DATE , NVL(A.APPLYER, A.FILLER) , CASE WHEN (FA.APP_VALUE IS NULL OR FA.APP_VALUE <> 'R') AND FA.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NULL THEN 'Dismission' WHEN (FA.APP_VALUE IS NULL OR FA.APP_VALUE <> 'R') AND FA.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NOT NULL AND E.EXT_NO IS NULL THEN LTRIM(RTRIM(E.DISPLAY_NAME)) || '#NO_EXT' WHEN (FA.APP_VALUE IS NULL OR FA.APP_VALUE <> 'R') AND FA.FORM_APPROVE_ID IS NOT NULL AND E.EMP_ID IS NOT NULL AND E.EXT_NO IS NOT NULL THEN LTRIM(RTRIM(E.DISPLAY_NAME)) || ' #' || E.EXT_NO ELSE A.FORM_STATUS END AS FORM_STATUS , A.PRIORITY , A.SYSTEM , G.WEB_PATH , CASE A.SYSTEM WHEN 'LOCAL' THEN 0 ELSE 100 END AS SORT_ORDER , L.form_name , L.form_name_langid , CASE WHEN ( empapply.EMP_NAME IS NULL) THEN 'None/Dismission' ELSE RTRIM(EMPAPPLY.EMP_NAME) END AS APPLY_EMP_NAME from FM_FORM_HEADER A join FM_FORM_LIST L on a.FORM_KIND = L.FORM_KIND and A.SYSTEM = L.SYSTEM and L.is_active != '0' AND (L."SYSTEM" != 'LOCAL' OR (L."SYSTEM" = 'LOCAL' AND L.form_kind not in (select form_kind from fm_form_module where UPPER (close_module_name) = UPPER ('Trace_Apply'))))LEFT JOIN GLOBAL_SYSTEM_LIST G ON A.SYSTEM = G.SYSTEM_NAME LEFT JOIN (SELECT * FROM FM_FORM_APPROVE_ACTIVE A WHERE FORM_APPROV
E_ID = (SELECT MIN(FORM_APPROVE_ID) FROM FM_FORM_APPROVE_ACTIVE B WHERE B.FORM_KIND = A.FORM_KIND AND B.FORM_NO = A.FORM_NO)) FA ON A.SYSTEM = FA.SYSTEM AND A.FORM_KIND = FA.FORM_KIND AND A.FORM_NO = FA.FORM_NO left join AM_EMPLOYEE E ON E.EMP_ID = FA.APP_EMP_ID LEFT JOIN (SELECT EMP_ID, DISPLAY_NAME AS EMP_NAME, DEPT_CODE, EXT_NO FROM AM_EMPLOYEE) empapply ON empapply.EMP_ID = case when A.APPLYER = '' OR A.APPLYER is null then A.filler else A.APPLYER END WHERE ((A.APPLYER = '0001A11000000002NPNS' or A.FILLER = '0001A11000000002NPNS') OR ( A.APPLYER IN (SELECT APP_EMP_ID FROM GT$AGENT_WORK agent where agent.FORM_KIND='SF.FORM.024' )) ) AND A.FORM_KIND = 'SF.FORM.024' AND A.SYSTEM = 'LOCAL' and A.BEGIN_DATE>to_date('2017/01/01', 'yyyy/MM/dd') and A.BEGIN_DATE<=to_date('2018/01/03', 'yyyy/MM/dd')+1 and A.FORM_STATUS<>'DE' and A.FORM_STATUS in ('AP', 'CL') |
| gaj7j3xcvpvwv | SELECT COUNT (*) FROM FM_PHASE_RULE WHERE FORM_PHASE_ID = :B1 |
| gd400kjd8sx7s | Begin SF_PROMOTION_PKG.ope_entry_data(:v0, :v1, :v2, :v3, :v4, :v5, :v6, :v7, :v8, :v9, :v10, :v11, :v12, :v13, :v14); End; |
| gp4ubhucjkmqk | SELECT CASE WHEN (NVL (PHASE.ALLOW_QUICK_APPROVE, '') = 'Y') THEN 'Y' ELSE 'N' END AS QUIK_APPROVE, LIS.PREVIEW_SHOWAPPLIST, LIS.PREVIEW_SHOWCONTENT FROM FM_FORM_APPROVE APPROVE, FM_FORM_LIST LIS, FM_FORM_PHASE PHASE WHERE APPROVE.FORM_KIND = LIS.FORM_KIND(+) AND (APPROVE.PHASE_ID = PHASE.FORM_PHASE_ID(+)) AND (APPROVE.FORM_APPROVE_ID = :B1 ) |
| gsgcdcmamvj24 | SELECT A.FORM_APPLICANT, A.APPLYER, B.BEGIN_DATE, A.SUBMIT_DEMISSION_DATE, A.DIMISSION_REASON, A.FORM_NO FROM SFBPM.SFFORM005 A INNER JOIN SFBPM.FM_FORM_HEADER B ON A.FORM_NO = B.FORM_NO WHERE B.FORM_KIND = 'SF.FORM.005' AND B.FORM_STATUS = 'AP' AND TO_CHAR(B.END_DATE, 'yyyy/MM/dd') >= '2017/04/05' AND TO_CHAR(B.END_DATE, 'yyyy/MM/dd') <= TO_CHAR(SYSDATE, 'yyyy/MM/dd') AND NOT EXISTS (SELECT 0 FROM SFBPM.BPM_AUTO_EXE_INTERFACE C WHERE C.FORM_KIND = 'SF.FORM.005' AND C.FORM_NO = A.FORM_NO) |
| gxs1thkm91p95 | SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_00"), NVL(SUM(C2), :"SYS_B_01"), NVL(SUM(C3), :"SYS_B_02"), NVL(SUM(C4), :"SYS_B_03"), COUNT(DISTINCT C5), NVL(SUM(CASE WHEN C5 IS NULL THEN :"SYS_B_04" ELSE :"SYS_B_05" END), :"SYS_B_06") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("B") FULL("B") NO_PARALLEL_INDEX("B") */ :"SYS_B_07" AS C1, CASE WHEN "B"."EMP_ID"=:"SYS_B_08" THEN :"SYS_B_09" ELSE :"SYS_B_10" END AS C2, CASE WHEN "B"."EMP_ID"=:"SYS_B_11" THEN :"SYS_B_12" ELSE :"SYS_B_13" END AS C3, CASE WHEN "B"."EMP_ID"=:"SYS_B_14" THEN :"SYS_B_15" ELSE :"SYS_B_16" END AS C4, "B"."APPROVER_ID" AS C5 FROM "SFBPM"."AM_APPROVE_LIST" SAMPLE BLOCK (:"SYS_B_17" , :"SYS_B_18") SEED (:"SYS_B_19") "B") SAMPLESUB |
| gznq3jq9ku899 | SELECT * FROM ( SELECT a.article_id, a.article_Type_id, case when TITLE_LENGTH = 0 then a.title when length(a.title) > nvl(TITLE_LENGTH, 10) then substr(a.title, 1, nvl(TITLE_LENGTH, 10)) || '...' else a.TITLE end as title,
case when TITLE_LENGTH = 0 then '' when length(a.TITLE) > nvl(TITLE_LENGTH, 10) then a.TITLE else '' end as summary,
a.publish_date, a.publisher_id, (SELECT b.file_id FROM portal_article_attachment b WHERE b.article_id = a.article_id AND b.file_type='I' AND b.is_summary_picture=1) image_fieldID,
(CASE WHEN ABS(trunc(publish_date) - trunc(SYSDATE)) <=3 THEN 'Y' ELSE 'N' END ) is_new, a.status, a.hot_article_status, a.input_mode, a.image_frame, a.sequence, a.theme_picture
FROM portal_article a, PORTAL_ARTICLE_TYPE b
WHERE a.ARTICLE_TYPE_ID = b.ARTICLE_TYPE_ID and
a.article_type_id = '4355e37a-be1f-4f68-82af-b5b4b0f1d816' AND a.begin_date <= SYSDATE AND a.end_date >= SYSDATE AND a.status IN ('868E74A7-5E14-446e-8BC6-8AF30AA0C062', '77FD3924-BAA7-4222-B892-6BB2E3703536')
ORDER BY a.sequence, a.publish_date desc, a.title ) t WHERE rownum <= 5 |
| Statistic | Total | per Second | per Trans |
|---|
| Batched IO (bound) vector count | 19,710 | 3.64 | 0.13 |
| Batched IO (full) vector count | 16 | 0.00 | 0.00 |
| Batched IO (space) vector count | 0 | 0.00 | 0.00 |
| Batched IO block miss count | 180,034 | 33.28 | 1.23 |
| Batched IO buffer defrag count | 1,845 | 0.34 | 0.01 |
| Batched IO double miss count | 5,038 | 0.93 | 0.03 |
| Batched IO same unit count | 98,518 | 18.21 | 0.67 |
| Batched IO single block count | 6,568 | 1.21 | 0.04 |
| Batched IO slow jump count | 210 | 0.04 | 0.00 |
| Batched IO vector block count | 75,111 | 13.89 | 0.51 |
| Batched IO vector read count | 13,466 | 2.49 | 0.09 |
| Block Cleanout Optim referenced | 431 | 0.08 | 0.00 |
| CCursor + sql area evicted | 6,673 | 1.23 | 0.05 |
| CPU used by this session | 2,593,731 | 479.49 | 17.67 |
| CPU used when call started | 2,553,748 | 472.10 | 17.40 |
| CR blocks created | 9,416 | 1.74 | 0.06 |
| Cached Commit SCN referenced | 1,021,982 | 188.93 | 6.96 |
| Commit SCN cached | 51,472 | 9.52 | 0.35 |
| DB time | 6,336,416 | 1,171.38 | 43.18 |
| DBWR checkpoint buffers written | 40,001 | 7.39 | 0.27 |
| DBWR checkpoints | 37 | 0.01 | 0.00 |
| DBWR object drop buffers written | 0 | 0.00 | 0.00 |
| DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
| DBWR tablespace checkpoint buffers written | 352 | 0.07 | 0.00 |
| DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR transaction table writes | 423 | 0.08 | 0.00 |
| DBWR undo block writes | 70,027 | 12.95 | 0.48 |
| HSC Heap Segment Block Changes | 2,604,301 | 481.44 | 17.75 |
| Heap Segment Array Inserts | 856,198 | 158.28 | 5.83 |
| Heap Segment Array Updates | 613 | 0.11 | 0.00 |
| IMU CR rollbacks | 1,698 | 0.31 | 0.01 |
| IMU Flushes | 108,902 | 20.13 | 0.74 |
| IMU Redo allocation size | 204,285,772 | 37,765.22 | 1,392.02 |
| IMU commits | 38,238 | 7.07 | 0.26 |
| IMU contention | 219 | 0.04 | 0.00 |
| IMU ktichg flush | 12,836 | 2.37 | 0.09 |
| IMU pool not allocated | 313 | 0.06 | 0.00 |
| IMU recursive-transaction flush | 10 | 0.00 | 0.00 |
| IMU undo allocation size | 380,669,592 | 70,372.36 | 2,593.91 |
| IMU- failed to get a private strand | 313 | 0.06 | 0.00 |
| LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
| Misses for writing mapping | 0 | 0.00 | 0.00 |
| Number of read IOs issued | 111,182 | 20.55 | 0.76 |
| RowCR - row contention | 126 | 0.02 | 0.00 |
| RowCR attempts | 5,991 | 1.11 | 0.04 |
| RowCR hits | 6,318 | 1.17 | 0.04 |
| SMON posted for undo segment recovery | 0 | 0.00 | 0.00 |
| SMON posted for undo segment shrink | 99 | 0.02 | 0.00 |
| SQL*Net roundtrips to/from client | 19,556,040 | 3,615.22 | 133.26 |
| SQL*Net roundtrips to/from dblink | 19,970 | 3.69 | 0.14 |
| active txn count during cleanout | 13,930 | 2.58 | 0.09 |
| application wait time | 2,712 | 0.50 | 0.02 |
| background checkpoints completed | 7 | 0.00 | 0.00 |
| background checkpoints started | 6 | 0.00 | 0.00 |
| background timeouts | 30,055 | 5.56 | 0.20 |
| branch node splits | 2 | 0.00 | 0.00 |
| buffer is not pinned count | 1,893,965,624 | 350,127.36 | 12,905.63 |
| buffer is pinned count | 2,867,611,636 | 530,120.12 | 19,540.13 |
| bytes received via SQL*Net from client | 2,360,087,150 | 436,296.77 | 16,081.82 |
| bytes received via SQL*Net from dblink | 106,258,006 | 19,643.35 | 724.05 |
| bytes sent via SQL*Net to client | 13,260,525,880 | 2,451,402.93 | 90,358.26 |
| bytes sent via SQL*Net to dblink | 5,979,149 | 1,105.33 | 40.74 |
| calls to get snapshot scn: kcmgss | 13,209,507 | 2,441.97 | 90.01 |
| calls to kcmgas | 410,087 | 75.81 | 2.79 |
| calls to kcmgcs | 75,027,023 | 13,869.85 | 511.24 |
| cell physical IO interconnect bytes | 291,979,445,248 | 53,976,688.05 | 1,989,570.68 |
| change write time | 3,018 | 0.56 | 0.02 |
| cleanout - number of ktugct calls | 132,294 | 24.46 | 0.90 |
| cleanouts and rollbacks - consistent read gets | 3,594 | 0.66 | 0.02 |
| cleanouts only - consistent read gets | 123,209 | 22.78 | 0.84 |
| cluster key scan block gets | 356,840 | 65.97 | 2.43 |
| cluster key scans | 315,841 | 58.39 | 2.15 |
| commit batch performed | 1,467 | 0.27 | 0.01 |
| commit batch requested | 1,467 | 0.27 | 0.01 |
| commit batch/immediate performed | 1,786 | 0.33 | 0.01 |
| commit batch/immediate requested | 1,786 | 0.33 | 0.01 |
| commit cleanout failures: block lost | 113,907 | 21.06 | 0.78 |
| commit cleanout failures: buffer being written | 2 | 0.00 | 0.00 |
| commit cleanout failures: callback failure | 759 | 0.14 | 0.01 |
| commit cleanout failures: cannot pin | 1,106 | 0.20 | 0.01 |
| commit cleanouts | 441,850 | 81.68 | 3.01 |
| commit cleanouts successfully completed | 326,076 | 60.28 | 2.22 |
| commit immediate performed | 319 | 0.06 | 0.00 |
| commit immediate requested | 319 | 0.06 | 0.00 |
| commit txn count during cleanout | 150,874 | 27.89 | 1.03 |
| concurrency wait time | 3,520 | 0.65 | 0.02 |
| consistent changes | 2,934,898 | 542.56 | 20.00 |
| consistent gets | 3,689,744,413 | 682,103.44 | 25,142.21 |
| consistent gets - examination | 227,409,692 | 42,040.02 | 1,549.59 |
| consistent gets direct | 8,905,406 | 1,646.30 | 60.68 |
| consistent gets from cache | 3,680,838,950 | 680,457.13 | 25,081.52 |
| consistent gets from cache (fastpath) | 3,445,727,627 | 636,993.35 | 23,479.46 |
| cursor authentications | 31,647 | 5.85 | 0.22 |
| data blocks consistent reads - undo records applied | 46,008 | 8.51 | 0.31 |
| db block changes | 6,647,375 | 1,228.86 | 45.30 |
| db block gets | 5,067,570 | 936.81 | 34.53 |
| db block gets direct | 2,009 | 0.37 | 0.01 |
| db block gets from cache | 5,065,561 | 936.44 | 34.52 |
| db block gets from cache (fastpath) | 406,970 | 75.23 | 2.77 |
| deferred (CURRENT) block cleanout applications | 127,537 | 23.58 | 0.87 |
| dirty buffers inspected | 48,580 | 8.98 | 0.33 |
| doubling up with imu segment | 0 | 0.00 | 0.00 |
| enqueue conversions | 20,949 | 3.87 | 0.14 |
| enqueue releases | 1,359,644 | 251.35 | 9.26 |
| enqueue requests | 1,359,396 | 251.30 | 9.26 |
| enqueue timeouts | 0 | 0.00 | 0.00 |
| enqueue waits | 1,061 | 0.20 | 0.01 |
| exchange deadlocks | 1 | 0.00 | 0.00 |
| execute count | 14,834,555 | 2,742.39 | 101.08 |
| failed probes on index block reclamation | 0 | 0.00 | 0.00 |
| file io service time | 60,100 | 11.11 | 0.41 |
| file io wait time | 13,374,022,332 | 2,472,384.42 | 91,131.63 |
| frame signature mismatch | 0 | 0.00 | 0.00 |
| free buffer inspected | 20,904,122 | 3,864.43 | 142.44 |
| free buffer requested | 20,457,186 | 3,781.81 | 139.40 |
| heap block compress | 34,170 | 6.32 | 0.23 |
| hot buffers moved to head of LRU | 9,168,530 | 1,694.94 | 62.48 |
| immediate (CR) block cleanout applications | 126,803 | 23.44 | 0.86 |
| immediate (CURRENT) block cleanout applications | 41,320 | 7.64 | 0.28 |
| index crx upgrade (positioned) | 6,787 | 1.25 | 0.05 |
| index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
| index fast full scans (full) | 22,158 | 4.10 | 0.15 |
| index fetch by key | 116,165,692 | 21,474.93 | 791.56 |
| index scans kdiixs1 | 56,507,551 | 10,446.25 | 385.05 |
| java call heap collected bytes | 0 | 0.00 | 0.00 |
| java call heap collected count | 0 | 0.00 | 0.00 |
| java call heap gc count | 0 | 0.00 | 0.00 |
| java call heap live object count | 0 | 0.00 | 0.00 |
| java call heap live object count max | 0 | 0.00 | 0.00 |
| java call heap live size | 0 | 0.00 | 0.00 |
| java call heap live size max | 0 | 0.00 | 0.00 |
| java call heap object count | 0 | 0.00 | 0.00 |
| java call heap object count max | 0 | 0.00 | 0.00 |
| java call heap total size | 0 | 0.00 | 0.00 |
| java call heap total size max | 0 | 0.00 | 0.00 |
| java call heap used size | 0 | 0.00 | 0.00 |
| java call heap used size max | 0 | 0.00 | 0.00 |
| java session heap live size | 0 | 0.00 | 0.00 |
| java session heap live size max | 0 | 0.00 | 0.00 |
| java session heap used size | 0 | 0.00 | 0.00 |
| java session heap used size max | 0 | 0.00 | 0.00 |
| leaf node 90-10 splits | 295 | 0.05 | 0.00 |
| leaf node splits | 899 | 0.17 | 0.01 |
| lob reads | 34,288 | 6.34 | 0.23 |
| lob writes | 67,202 | 12.42 | 0.46 |
| lob writes unaligned | 67,186 | 12.42 | 0.46 |
| logons cumulative | 6,661 | 1.23 | 0.05 |
| max cf enq hold time | 0 | 0.00 | 0.00 |
| messages received | 161,740 | 29.90 | 1.10 |
| messages sent | 161,740 | 29.90 | 1.10 |
| min active SCN optimization applied on CR | 57,176 | 10.57 | 0.39 |
| no buffer to keep pinned count | 10,105 | 1.87 | 0.07 |
| no work - consistent read gets | 3,384,873,684 | 625,743.61 | 23,064.79 |
| non-idle wait count | 22,743,182 | 4,204.41 | 154.97 |
| non-idle wait time | 1,996,014 | 368.99 | 13.60 |
| opened cursors cumulative | 10,912,870 | 2,017.40 | 74.36 |
| parse count (describe) | 41 | 0.01 | 0.00 |
| parse count (failures) | 10 | 0.00 | 0.00 |
| parse count (hard) | 98,959 | 18.29 | 0.67 |
| parse count (total) | 6,119,009 | 1,131.19 | 41.70 |
| parse time cpu | 125,519 | 23.20 | 0.86 |
| parse time elapsed | 167,863 | 31.03 | 1.14 |
| physical read IO requests | 2,103,478 | 388.86 | 14.33 |
| physical read bytes | 263,522,467,840 | 48,715,997.90 | 1,795,662.62 |
| physical read total IO requests | 2,145,318 | 396.59 | 14.62 |
| physical read total bytes | 264,204,816,384 | 48,842,140.05 | 1,800,312.20 |
| physical read total multi block requests | 269,505 | 49.82 | 1.84 |
| physical reads | 32,168,273 | 5,946.78 | 219.20 |
| physical reads cache | 20,162,263 | 3,727.29 | 137.39 |
| physical reads cache prefetch | 18,522,858 | 3,424.22 | 126.22 |
| physical reads direct | 12,006,010 | 2,219.49 | 81.81 |
| physical reads direct (lob) | 41,884 | 7.74 | 0.29 |
| physical reads direct temporary tablespace | 3,100,721 | 573.21 | 21.13 |
| physical reads prefetch warmup | 0 | 0.00 | 0.00 |
| physical write IO requests | 196,089 | 36.25 | 1.34 |
| physical write bytes | 26,731,061,248 | 4,941,629.21 | 182,147.53 |
| physical write total IO requests | 360,333 | 66.61 | 2.46 |
| physical write total bytes | 27,774,637,056 | 5,134,549.52 | 189,258.54 |
| physical write total multi block requests | 100,627 | 18.60 | 0.69 |
| physical writes | 3,263,069 | 603.23 | 22.23 |
| physical writes direct | 3,102,728 | 573.58 | 21.14 |
| physical writes direct (lob) | 152 | 0.03 | 0.00 |
| physical writes direct temporary tablespace | 3,102,386 | 573.52 | 21.14 |
| physical writes from cache | 160,341 | 29.64 | 1.09 |
| physical writes non checkpoint | 3,241,354 | 599.21 | 22.09 |
| pinned buffers inspected | 1,956 | 0.36 | 0.01 |
| pinned cursors current | 60 | 0.01 | 0.00 |
| prefetch clients - default | 120 | 0.02 | 0.00 |
| prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
| prefetched blocks aged out before use | 32,882 | 6.08 | 0.22 |
| process last non-idle time | 5,404 | 1.00 | 0.04 |
| recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
| recursive calls | 26,122,907 | 4,829.20 | 178.00 |
| recursive cpu usage | 924,200 | 170.85 | 6.30 |
| redo KB read | 0 | 0.00 | 0.00 |
| redo blocks checksummed by FG (exclusive) | 225,507 | 41.69 | 1.54 |
| redo blocks written | 1,860,354 | 343.91 | 12.68 |
| redo buffer allocation retries | 7 | 0.00 | 0.00 |
| redo entries | 2,962,376 | 547.64 | 20.19 |
| redo log space requests | 7 | 0.00 | 0.00 |
| redo log space wait time | 22 | 0.00 | 0.00 |
| redo ordering marks | 1,970 | 0.36 | 0.01 |
| redo size | 880,079,076 | 162,695.54 | 5,996.93 |
| redo size for direct writes | 8,672 | 1.60 | 0.06 |
| redo subscn max counts | 14,361 | 2.65 | 0.10 |
| redo synch long waits | 55,262 | 10.22 | 0.38 |
| redo synch time | 110,777 | 20.48 | 0.75 |
| redo synch time (usec) | 1,109,530,121 | 205,112.94 | 7,560.42 |
| redo synch writes | 134,364 | 24.84 | 0.92 |
| redo wastage | 41,110,864 | 7,599.95 | 280.13 |
| redo write time | 57,450 | 10.62 | 0.39 |
| redo writes | 154,921 | 28.64 | 1.06 |
| rollback changes - undo records applied | 425 | 0.08 | 0.00 |
| rollbacks only - consistent read gets | 5,988 | 1.11 | 0.04 |
| root node splits | 0 | 0.00 | 0.00 |
| rows fetched via callback | 107,492,401 | 19,871.55 | 732.46 |
| scheduler wait time | 0 | 0.00 | 0.00 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 6,459,716 | 1,194.17 | 44.02 |
| session logical reads | 3,694,815,055 | 683,040.82 | 25,176.76 |
| shared hash latch upgrades - no wait | 2,177,127 | 402.47 | 14.84 |
| shared hash latch upgrades - wait | 7,525 | 1.39 | 0.05 |
| sorts (disk) | 149 | 0.03 | 0.00 |
| sorts (memory) | 3,150,067 | 582.34 | 21.46 |
| sorts (rows) | 394,412,270 | 72,912.90 | 2,687.56 |
| sql area evicted | 93,033 | 17.20 | 0.63 |
| sql area purged | 14 | 0.00 | 0.00 |
| summed dirty queue length | 49,989 | 9.24 | 0.34 |
| switch current to new buffer | 105,359 | 19.48 | 0.72 |
| table fetch by rowid | 2,335,940,485 | 431,832.90 | 15,917.28 |
| table fetch continued row | 852,511 | 157.60 | 5.81 |
| table scan blocks gotten | 1,650,224,349 | 305,068.20 | 11,244.76 |
| table scan rows gotten | 98,286,304,709 | 18,169,666.72 | 669,730.54 |
| table scans (direct read) | 52 | 0.01 | 0.00 |
| table scans (long tables) | 87 | 0.02 | 0.00 |
| table scans (rowid ranges) | 0 | 0.00 | 0.00 |
| table scans (short tables) | 32,641,503 | 6,034.26 | 222.42 |
| total cf enq hold time | 1,990 | 0.37 | 0.01 |
| total number of cf enq holders | 239 | 0.04 | 0.00 |
| total number of times SMON posted | 121 | 0.02 | 0.00 |
| transaction rollbacks | 1,785 | 0.33 | 0.01 |
| transaction tables consistent read rollbacks | 11 | 0.00 | 0.00 |
| transaction tables consistent reads - undo records applied | 1,012 | 0.19 | 0.01 |
| undo change vector size | 522,823,208 | 96,651.55 | 3,562.56 |
| user I/O wait time | 1,706,230 | 315.42 | 11.63 |
| user calls | 22,731,303 | 4,202.22 | 154.89 |
| user commits | 145,769 | 26.95 | 0.99 |
| user rollbacks | 986 | 0.18 | 0.01 |
| workarea executions - onepass | 149 | 0.03 | 0.00 |
| workarea executions - optimal | 2,942,921 | 544.04 | 20.05 |
| write clones created in background | 0 | 0.00 | 0.00 |
| write clones created in foreground | 557 | 0.10 | 0.00 |