| SQL Id | SQL Text |
|---|
| 020p727tz1mqw |
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_HEADE
R 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 = '0001A11000000003RC
GY' or A.FILLER = '0001A11000000003RCGY') 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('2017/12/27', 'yyyy/MM/dd')+1 and A.FORM_STATUS<>'DE' and A.FORM_STATUS in ('NC', 'SA', 'RC') |
| 02f7d6kqw66rk | select employee_id , create_time from sso_access_random where random_id = '88699471-076a-4ba7-8abb-67ea50098b8d' and create_time >= sysdate-(1500/24/60/60)order by create_time desc |
| 1vjf026uj8mc4 | select ltrim(rtrim(AP_EMPLOYEE_MAP.EMP_ID)) as EMP_ID , ltrim(rtrim(AP_EMPLOYEE_MAP.GSOURCE_USER_ID)) as GSOURCE_USER_ID from AP_EMPLOYEE_MAP where ( AP_EMPLOYEE_MAP.GSOURCE_USER_ID = '0001A11000000000BJ51'
) |
| 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 |
| 32u1r3mzp1dxr | SELECT COUNT (*) FROM USER_ARGUMENTS WHERE UPPER (PACKAGE_NAME) = UPPER (:B2 ) AND UPPER (OBJECT_NAME) = 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 |
| 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) |
| 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 |
| 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' |
| fy9dsa79u07a4 | select ltrim(rtrim(AP_EMPLOYEE_MAP.EMP_ID)) as EMP_ID , ltrim(rtrim(AP_EMPLOYEE_MAP.GSOURCE_USER_ID)) as GSOURCE_USER_ID from AP_EMPLOYEE_MAP where ( AP_EMPLOYEE_MAP.GSOURCE_USER_ID = '1001A11000000000BH0I'
) |
| gyu7tvqnuum0n |
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_HEADE
R 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 = '0001A11000000001ZV
WM' or A.FILLER = '0001A11000000001ZVWM') 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('2017/12/25', 'yyyy/MM/dd')+1 and A.FORM_STATUS<>'DE' and A.FORM_STATUS in ('NC', 'SA', 'RC') |
| gzayyn2qjg089 | select employee_id , create_time from sso_access_random where random_id = '54e2515b-58f7-41e6-8ba5-a1c82b041b1e' and create_time >= sysdate-(1500/24/60/60)order by create_time desc |
| 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 |