| SQL Id | SQL Text |
|---|
| 03bbw3hdan15y | SELECT COUNT (*) FROM FM_FORM_FUNCTION WHERE TRIM (FORM_KIND) = '*' AND TRIM (PHASE_ID) = '*' AND UPPER (TRIM (FUNCTION_ID)) = UPPER (:B1 ) AND UPPER (TRIM (OPERATE)) = 'ADDCOMMENT' |
| 047c63w2dbrx0 | SELECT * FROM FM_FORM_ATTRIBUTE WHERE FORM_KIND = :B2 AND FORM_NO = :B1 ORDER BY INSERTED_DATE DESC |
| 05968j8hgvqq1 |
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 = '0001A11000000009D193' or A.FILLER = '0001A11000000009D193') 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') |
| 05sghzkq6r6yv | select ts#, file#, block#, cols, nvl(size$, -1), pctfree$, pctused$, initrans, maxtrans, hashkeys, func, extind, avgchn, nvl(degree, 1), nvl(instances, 1), nvl(flags, 0), nvl(spare1, 0)from clu$ where obj#=:1 |
| 05zm363q67v80 |
SELECT REPLACE (fa.form_approve_id, '.', '') AS form_approve_id,
form_approve_id AS origion_form_approve_id, fa.form_no,
fa.form_kind, fa.phase_id, fa.app_serial, fa.app_assigner,
fa.app_emp_id, fa.app_actor, fa.assign_reason,
CASE
WHEN (am1.emp_id IS NULL AND fa.app_name IS NULL
)
THEN 'NULL'
WHEN ( am1.emp_id IS NULL
AND fa.app_status <> 'D'
AND fa.app_actor = fa.app_emp_id
)
THEN fa.app_name || '/' || 'Dismission'
WHEN ( am1.emp_id IS NULL
AND fa.app_status <> 'D'
AND fa.app_actor IS NOT NULL
AND fa.app_actor <> fa.app_emp_id
)
THEN 'Dismission'
WHEN ( am1.emp_id IS NULL
AND fa.app_status <> 'D'
AND fa.app_actor IS NULL
)
THEN fa.app_name || '/' || 'Dismission'
WHEN (am1.emp_id IS NULL AND fa.app_status = 'D')
THEN fa.app_name
WHEN (am1.ext_no IS NULL AND am1.emp_id IS NOT NULL)
THEN am1.emp_name
ELSE am1.emp_name || ' #' || am1.ext_no
END AS app_emp_name,
CASE
WHEN (am.emp_id IS NULL AND fa.app_name IS NULL
)
THEN 'NULL'
WHEN (am.emp_id IS NULL AND fa.app_status <> 'D')
THEN fa.app_name || '/' || 'Dismission'
WHEN (am.emp_id IS NULL AND fa.app_status = 'D')
THEN fa.app_name
WHEN (am.ext_no IS NULL AND am.emp_id IS NOT NULL)
THEN am.emp_name
ELSE am.emp_name || ' #' || am.ext_no
END AS app_actor_name,
CASE
WHEN (am.emp_id IS NULL AND fa.app_name IS NULL
)
THEN 'NULL'
WHEN (am.emp_id IS NULL AND fa.app_status <> 'D')
THEN fa.app_name || '/' || 'Dismission'
WHEN (am.emp_id IS NULL AND fa.app_status = 'D')
THEN fa.app_name
WHEN (am.emp_id IS NOT NULL AND am.ext_no IS NULL)
THEN am.emp_name
ELSE am.emp_name || ' #' || am.ext_no
END AS approve_emp_name,
CASE
WHEN am.login_name IS NULL
THEN ''
ELSE am.login_name
END app_login_name,
fa.app_role, fa.app_status, fa.assign_type, fa.app_type,
fa.app_value, fa.app_content,
fa.end_date, am.emp_name as ACTOR_DISPLAY_NAME, am2.DISPLAY_NAME as ASSIGNER_DISPLAY_NAME
FROM fm_form_approve fa,
(SELECT login_name,
CASE
WHEN (display_name IS NOT NULL)
THEN display_name
ELSE emp_name
END AS emp_name, emp_id,
ext_no
FROM am_employee) am,
(SELECT login_name,
CASE
WHEN (display_name IS NOT NULL)
THEN display_name
ELSE emp_name
END AS emp_name, emp_id,
ext_no
FROM am_employee) am1,
(SELECT EMP_ID, DISPLAY_NAME FROM AM_EMPLOYEE) am2
WHERE CASE
WHEN fa.app_actor IS NULL
THEN fa.app_emp_id
ELSE fa.app_actor
END = am.emp_id(+)
AND fa.app_emp_id = am1.emp_id(+)
AND fa.APP_ASSIGNER = am2.EMP_ID(+)
AND ( fa.form_kind = 'SF.FORM.004'
AND fa.form_no = CAST (169977 AS VARCHAR2 (30)) AND fa.app_status <
> 'P'
AND fa.app_type <> 'P' ) ORDER BY fa.app_serial ASC, end_date ASC, fa.app_emp_id ASC |
| 07bva7agn48ha |
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='0001A11000000005F41I') 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='0001A11000000005F41I')
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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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
1000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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 a.end_date>=to_date('2017-12-21', 'yyyy/mm/dd') and a.end_date<=to_date('2017-12-22', 'yyyy/mm/dd') and a.cash_place='GZZ' order by a.form_kind, a.form_no |
| 0afzcny7gwut7 |
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 = '0001A11000000009HWHF' or A.FILLER = '0001A11000000009HWHF') 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 ('RJ', 'RF') |
| 0ahxv6zyb7jac |
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='0001A11000000005F41I') 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='0001A11000000005F41I')
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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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
1000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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 a.end_date>=to_date('2017-12-25', 'yyyy/mm/dd') and a.end_date<=to_date('2017-12-26', 'yyyy/mm/dd') and a.cash_place='GZZ' order by a.form_kind, a.form_no |
| 0cf6j0ac46220 | 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("FM_FORM_MODULE") FULL("FM_FORM_MODULE") NO_PARALLEL_INDEX("FM_FORM_MODULE") */ :"SYS_B_2" AS C1, CASE WHEN UPPER("FM_FORM_MODULE"."CLOSE_MODULE_NAME")=:"SYS_B_3" THEN :"SYS_B_4" ELSE :"SYS_B_5" END AS C2 FROM "SFBPM"."FM_FORM_MODULE" "FM_FORM_MODULE") SAMPLESUB |
| 0cshxwujybb6t | --数据库当前负载
with tmp as
(
select t.instance_number, min(t.snap_id) snap_id
from dba_hist_sys_time_model e
inner join dba_hist_snapshot t on t.snap_id = e.snap_id and t.instance_number = e.instance_number
where e.stat_name = 'DB time'
and t.begin_interval_time > sysdate - 1 / 24
group by t.instance_number
)
select a1.instance_number,
-- a1.snap_id,
round((a4.VALUE / 1000000 / 60 - a3.value / 1000000 / 60) / (((systimestamp + 0) - (a2.end_interval_time + 0)) * 24 * 60) * 15, 4) dbtime,
a5.cn sess_total,
sysdate curr_date
-- a2.begin_interval_time,
-- a2.end_interval_time,
-- a3.stat_name
from tmp a1
inner join dba_hist_snapshot a2 on a2.instance_number=a1.instance_number and a2.snap_id=a1.snap_id
inner join dba_hist_sys_time_model a3 on a3.instance_number=a1.instance_number and a3.snap_id=a1.snap_id
inner join gv$SYS_TIME_MODEL a4 on a4.INST_ID=a1.instance_number
left join (select inst_id, count(1) cn from gv$session where username is not null group by inst_id) a5 on a5.inst_id=a1.instance_number
where a3.STAT_NAME = 'DB time'
and a4.STAT_NAME = 'DB time'
|
| 0f62s6kfyapbb |
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"), NVL(SUM(C5), :"SYS_B_04"), COUNT(DISTINCT C6), NVL(SUM(CASE WHEN C6 IS NULL THEN :"SYS_B_05" ELSE :"SYS_B_06" END), :"SYS_B_07") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("FA") FULL("FA") NO_PARALLEL_INDEX("FA") */ :"SYS_B_08" AS C1, CASE WHEN "FA"."FORM_NO"=:"SYS_B_09" AND UPPER("FA"."APP_STATUS")=:"SYS_B_10" AND UPPER("FA"."APP_TYPE")=:"SYS_B_11" AND "FA"."APP_EMP_ID"=:"SYS_B_12" THEN :"SYS_B_13" ELSE :"SYS_B_14" END AS C2, CASE WHEN "FA"."APP_EMP_ID"=:"SYS_B_15" THEN :"SYS_B_16" ELSE :"SYS_B_17" END AS C3, CASE WHEN "FA"."APP_EMP_ID"=:"SYS_B_18" THEN :"SYS_B_19" ELSE :"SYS_B_20" END AS C4, CASE WHEN "FA"."FORM_NO"=:"SYS_B_21" THEN :"SYS_B_22" ELSE :"SYS_B_23" END AS C5, "FA"."FORM_NO" AS C6 FROM "SFBPM"."FM_FORM_APPROVE_ACTIVE" SAMPLE
BLOCK (:"SYS_B_24" , :"SYS_B_25") SEED (:"SYS_B_26") "FA") SAMPLESUB |
| 0h3f6mvwsazq0 | BEGIN DELETE FROM FM_GENERAL_PICKER_DATA WHERE FORM_KIND = 'SF.FORM.071' AND FORM_NO = 28900 AND COLUMN_NAME = 'OVER_APPLYER' AND TABLE_NAME = 'SFFORM071' AND ITEM_NO = '0';INSERT INTO FM_GENERAL_PICKER_DATA(FORM_KIND, FORM_NO, COLUMN_NAME, TEXT, VALUE, TABLE_NAME, ITEM_NO) VALUES ('SF.FORM.071', 28900, 'OVER_APPLYER', N'陈菁/CJ238', N'1001K810000000000670', 'SFFORM071', '0');END; |
| 0h8qwq67rv3sh | SELECT COUNT (*) FROM FM_FORM_FUNCTION WHERE TRIM (FORM_KIND) = :B2 AND TRIM (PHASE_ID) = '*' AND UPPER (TRIM (FUNCTION_ID)) = UPPER (:B1 ) AND UPPER (TRIM (OPERATE)) = 'DEL' |
| 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 |
| 0qn05xy0v0daw | SELECT :B1 || ' PREVIEW_SHOW , APPROVE_PREVIEW, EMP_TYPE, ' FROM DUAL |
| 0u442vng4w845 |
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='1001K810000000000681') 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='1001K810000000000681')
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='1001K810000000000681') 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='1001K810000000000681') 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='1001K810000000000681') 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='1001K810000000000681') 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='1001K810000000000681') 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='1001K810000000000681') 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='1001K810000000000681') 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='1001K810000000000681') 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='1001K810000000000681') 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='1001K8
10000000000681') 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='1001K810000000000681') 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='1001K810000000000681') 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 a.form_no= 1157359 order by a.form_kind, a.form_no |
| 1ng6v39qb5hxg | /*
The name + type results of these queries will be used by the Code Assistant
if the "Describe Context" option is enabled. After typing 3 or more characters
the Code Assistant will show a list of matching names.
Separate multiple queries with semi-colons and use the :schema bind variable
to restrict names to the currently connected user.
In case of an error the query results will be omitted. No error message will
be displayed.
Place this file in the PL/SQL Developer installation directory for all users,
or in the "%APPDATA%\PLSQL Developer" directory for a specific user.
*/
select object_name, object_type
from sys.all_objects o
where o.owner = :schema
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
|
| 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
|
| 1x7d5jy2m2913 | SELECT A.FORM_KIND, A.FORM_NO, A.FILE_SERIAL, TO_CHAR(A.ATTACH_DATE, 'yyyy-mm-dd') AS STR_ATTACH_DATE, A.FILE_SIZE, A.EMP_NAME, A.FILE_TAG, A.FILE_TYPE, A.FILE_NAME FROM FM_UPLOAD_FILE_LIST A WHERE A.FORM_KIND = :B3 AND A.FORM_NO = :B2 AND A.FILE_CATEGORY = :B1 ORDER BY A.FILE_SERIAL |
| 22txf8daw1x1p | Begin SFFORM011_PKG.operator_log_table(:v0, :v1, :v2, :v3, :v4, :v5, :v6, :v7, :v8, :v9, :v10, :v11); 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 |
| 2c1cu06mgawg0 | SELECT DISTINCT A.FLONGNAME AS DISPLAY, A.FID AS VALUE FROM SF_EAS_BGITEMPROJECT A LEFT JOIN SF_EAS_BGBUDGETINGPROJECT B ON A.FID=B.BGITEMPROJECTID LEFT JOIN SF_EAS_PROJECTTYPE C ON A.FID=C.PROFID LEFT JOIN SF_EAS_MODELTYPE D ON C.TYPEFNUMBER=D.TYPENUMBER WHERE A.FISLEAF=1 AND A.FISEFFECTIVE=1 AND B.FORGUNITID='lNuyngEeEADgABhuwKgKZMznrtQ=' AND B.FBGPERIOD='201801' AND D.ID='DD44B07064A049499DAC1F18CF7818AF' AND A.FISSHARE='Y' ORDER BY NLSSORT(DISPLAY, 'NLS_SORT=SCHINESE_PINYIN_M') |
| 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 |
| 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 ) |
| 35dncat8m8du3 | SELECT RPAD('+', LEVEL, '-') || sid || ' ' || sess.module session_detail, ceil(sess.last_call_et / 60) minutes,
wait_event_text,
blocker_sid,
object_name,
RPAD(' ', LEVEL) || sql_text sql_text,
case when blocker_sid is not null then 'alter system disconnect session ' || '''' || blocker_sid || ', ' || BLOCKER_SESS_SERIAL# || '''' || ' immediate;' else '' end sql_kill,
sess.STATUS,
sess.sql_id,
sess.EVENT,
sess.LOGON_TIME,
sess.PREV_EXEC_START,
sess.OSUSER,
sess.MACHINE,
sess.PROGRAM
FROM v$wait_chains c
LEFT OUTER JOIN dba_objects o ON (row_wait_obj# = object_id)
JOIN v$session sess USING (sid)
LEFT OUTER JOIN v$sql sql ON (sql.sql_id = sess.sql_id AND sql.child_number = sess.sql_child_number)
CONNECT BY PRIOR sid = blocker_sid AND PRIOR sess_serial# = blocker_sess_serial# AND PRIOR INSTANCE = blocker_instance
START WITH blocker_is_valid = 'FALSE'
|
| 376ck6g8rz65d | SELECT '设备设施整改或维修申请单-' || A.FORM_NO || '-' || A.APPLYER_INFO || '-' ||
A.BELONG_DEPT_NAME|| '-' ||
(CASE WHEN A.REPAIR_TYPE=1 THEN '整改' ELSE '维修' END) AS DISPLAY,
B.FORM_KIND || '||' || A.FORM_NO AS VALUE
FROM SFFORM082 A
INNER JOIN FM_FORM_HEADER B
ON A.FORM_NO = B.FORM_NO
AND B.FORM_KIND = 'SF.FORM.082'
AND B.FORM_STATUS = 'AP' LEFT JOIN SF_ORG_EXPEND HH ON A.APPLY_DEPT_ID=HH.EHR_DEPT_ID WHERE (A.FORM_APPLICANT = '0001A1100000000DLMRZ' OR EXISTS(SELECT 0 FROM AM_EMPLOYEE JJ WHERE SUBSTR(JJ.DEPT_CODE, 0, 4)=SUBSTR(HH.ID, 0, 4) AND JJ.EMP_ID='0001A1100000000DLMRZ')) and 1=1 AND NOT EXISTS (SELECT 0
FROM SF_FORM_USE_RECORD AA
WHERE AA.FORM_KIND = B.FORM_KIND
AND AA.FORM_NO = B.FORM_NO
AND AA.USE_FORM_NO <> A.FORM_NO
AND AA.USE_FORM_KIND = 'SF.FORM.027'
AND AA.STATUS = 'Y') |
| 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 |
| 3gputsqv4u1j3 |
SELECT endsn.filetype_id as filetype_id, max(filetypename.filetype_name) as filetype_name, endsn.function_id as function_id, max(funcname.function_name) as function_name, sum(endsn.small_read_megabytes - nvl(startsn.small_read_megabytes, 0)) as small_read_megs, sum(endsn.small_write_megabytes - nvl(startsn.small_write_megabytes, 0)) as small_write_megs, sum(endsn.large_read_megabytes - nvl(startsn.large_read_megabytes, 0)) as large_read_megs, sum(endsn.large_write_megabytes - nvl(startsn.large_write_megabytes, 0)) as large_write_megs, sum(endsn.small_read_reqs - nvl(startsn.small_read_reqs, 0)) as small_read_reqs, sum(endsn.small_write_reqs - nvl(startsn.small_write_reqs, 0)) as small_write_reqs, sum(endsn.large_read_reqs - nvl(startsn.large_read_reqs, 0)) as large_read_reqs, sum(endsn.large_write_reqs - nvl(startsn.large_write_reqs, 0)) as large_write_reqs, sum(endsn.number_of_waits
- nvl(startsn.number_of_waits, 0)) as num_waits, sum(endsn.wait_time - nvl(startsn.wait_time, 0)) as wait_time FROM WRH$_IOSTAT_DETAIL endsn, WRH$_IOSTAT_DETAIL startsn, WRH$_IOSTAT_FUNCTION_NAME funcname, WRH$_IOSTAT_FILETYPE_NAME filetypename WHERE startsn.filetype_id(+) = endsn.filetype_id AND startsn.function_id(+) = endsn.function_id AND endsn.dbid = funcname.dbid AND endsn.function_id = funcname.function_id AND endsn.dbid = filetypename.dbid AND endsn.filetype_id = filetypename.filetype_id AND endsn.dbid = :dbid AND endsn.instance_number = :inst AND endsn.snap_id = :eid AND startsn.dbid(+) = :dbid AND startsn.instance_number(+) = endsn.instance_number AND startsn.snap_id(+) = :bid GROUP BY endsn.filetype_id, endsn.function_id ORDER BY endsn.filetype_id ASC, endsn.function_id ASC |
| 3gwj785rhfwh3 |
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='0001A11000000005F41I') 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='0001A11000000005F41I')
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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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
1000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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 a.end_date>=to_date('2017-12-20', 'yyyy/mm/dd') and a.end_date<=to_date('2017-12-21', 'yyyy/mm/dd') order by a.form_kind, a.form_no |
| 3m1z5z7ym424x | Begin sf_eas_pkg.check_finanical_form_sa(:v0, :v1, :v2, :v3, :v4, :v5); End; |
| 3zzj0w7y0s1sa | SELECT /*+RULE*/ATTR_NO, ATTR_NAME, ATTR_TYPE_NAME, ATTR_TYPE_OWNER FROM USER_TYPE_ATTRS WHERE TYPE_NAME IN (SELECT TABLE_NAME FROM ALL_SYNONYMS START WITH SYNONYM_NAME = :1 AND OWNER = 'PUBLIC' CONNECT BY NOCYCLE PRIOR TABLE_NAME = SYNONYM_NAME AND TABLE_OWNER = OWNER UNION SELECT :2 FROM DUAL) ORDER BY ATTR_NO |
| 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 |
| 4wfkdbp1a7hwv | SELECT DISTINCT A.FLONGNAME AS DISPLAY, A.FID AS VALUE FROM SF_EAS_BGITEMPROJECT A LEFT JOIN SF_EAS_BGBUDGETINGPROJECT B ON A.FID=B.BGITEMPROJECTID LEFT JOIN SF_EAS_PROJECTTYPE C ON A.FID=C.PROFID LEFT JOIN SF_EAS_MODELTYPE D ON C.TYPEFNUMBER=D.TYPENUMBER WHERE A.FISLEAF=1 AND A.FISEFFECTIVE=1 AND B.FORGUNITID='3OAAAADfXEfM567U' AND B.FBGPERIOD='201801' AND D.ID='DD44B07064A049499DAC1F18CF7818AF' AND A.FISSHARE='Y' ORDER BY NLSSORT(DISPLAY, 'NLS_SORT=SCHINESE_PINYIN_M') |
| 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 ) |
| 4yyb4104skrwj | update obj$ set obj#=:4, type#=:5, ctime=:6, mtime=:7, stime=:8, status=:9, dataobj#=:10, flags=:11, oid$=:12, spare1=:13, spare2=:14 where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null |
| 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') |
| 5bzn3hcmxrgjn | SELECT DISTINCT A.FLONGNAME AS DISPLAY, A.FID AS VALUE FROM SF_EAS_BGITEMPROJECT A LEFT JOIN SF_EAS_BGBUDGETINGPROJECT B ON A.FID=B.BGITEMPROJECTID LEFT JOIN SF_EAS_PROJECTTYPE C ON A.FID=C.PROFID LEFT JOIN SF_EAS_MODELTYPE D ON C.TYPEFNUMBER=D.TYPENUMBER WHERE A.FISLEAF=1 AND A.FISEFFECTIVE=1 AND B.FORGUNITID='poJ/qHMdS9a642wWIlh+sMznrtQ=' AND B.FBGPERIOD='201801' AND D.ID='2BBF459BB664466DB156C26E675A4857' ORDER BY NLSSORT(DISPLAY, 'NLS_SORT=SCHINESE_PINYIN_M') |
| 5jvf84zg4c49n |
select s.synonym_name as object_name, o.object_type
from sys.all_synonyms s, sys.all_objects o
where s.owner in ('PUBLIC', :schema)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
|
| 5sqdv9xkuk2na | SELECT DISTINCT A.FLONGNAME AS DISPLAY, A.FID AS VALUE FROM SF_EAS_BGITEMPROJECT A LEFT JOIN SF_EAS_BGBUDGETINGPROJECT B ON A.FID=B.BGITEMPROJECTID LEFT JOIN SF_EAS_PROJECTTYPE C ON A.FID=C.PROFID LEFT JOIN SF_EAS_MODELTYPE D ON C.TYPEFNUMBER=D.TYPENUMBER WHERE A.FISLEAF=1 AND A.FISEFFECTIVE=1 AND B.FORGUNITID='lNuyngEeEADgAFLKwKgKZMznrtQ=' AND B.FBGPERIOD='201801' AND D.ID='2BBF459BB664466DB156C26E675A4857' ORDER BY NLSSORT(DISPLAY, 'NLS_SORT=SCHINESE_PINYIN_M') |
| 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; |
| 6q7v1h0p17j5g |
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='0001A11000000005F41I') 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='0001A11000000005F41I')
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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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
1000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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 a.end_date>=to_date('2017-12-27', 'yyyy/mm/dd') and a.end_date<=to_date('2017-12-28', 'yyyy/mm/dd') and a.cash_place='GZZ' order by a.form_kind, a.form_no |
| 74anujtt8zw4h | select o.owner#, o.name, o.namespace, o.obj#, d.d_timestamp, nvl(d.property, 0), o.type#, o.subname, d.d_attrs from dependency$ d, obj$ o where d.p_obj#=:1 and (d.p_timestamp=nvl(:2, d.p_timestamp) or d.property=2) and o.owner#=nvl(:3, o.owner#) and d.d_obj#=o.obj# order by o.obj# |
| 76pdq9fg8pb9r | select max(serial) as serial from Exception_Log |
| 7aw21806wpgzp | select null from all_synonyms where 1=0
|
| 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; |
| 8m9fr2nnrtfkp |
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<>'0001A11000000007413N' 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='0001A11000000007413N' or (fa.app_emp_id = '0001A11000000007413N' 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('2017/01/01', 'yyyy/MM/dd') and fa.END_DATE <= to_date('2017/12/31', 'yyyy/MM/dd') + 1 and fh.FORM_STATUS<>'DE' and fa.FORM_KIND='SF.FORM.027' and fa.SYSTEM = 'LOCAL' |
| 8nja1r29j8c3m |
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='0001A11000000005F41I') 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='0001A11000000005F41I')
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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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
1000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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 a.end_date>=to_date('2017-12-21', 'yyyy/mm/dd') and a.end_date<=to_date('2017-12-22', 'yyyy/mm/dd') order by a.form_kind, a.form_no |
| 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 |
| 98m4pfg8uh97b | update sfbpm.fm_form_approve c
set c.app_emp_id =
(select h.emp_id
from sfbpm.am_employee h
where h.emp_id = '1'
or h.emp_no = 'JXH9') /*调整人的empid*/,
c.app_name =
(select c.dept_code || '/' || c.emp_name || '(' || c.emp_no || ')'
from sfbpm.am_employee c
where c.emp_id = '1'
or c.emp_no = 'JXH9')
where exists
(select 0
from sfbpm.fm_form_approve a
inner join sfbpm.fm_form_header b
on a.form_no = b.form_no
and a.form_kind = b.form_kind
left join sfbpm.am_employee q
on a.app_emp_id = q.emp_id
where b.form_status in ('WA', 'UA', 'WP')
and (a.app_emp_id = '1' or q.emp_no = 'ZB38') /*离职人的empid*/
and a.app_status in ('U', 'W')
and a.form_approve_id = c.form_approve_id) |
| 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; |
| ab4k52xbgna51 |
select a.tablespace_name,
round(a.bytes_alloc / 1024 / 1024) megs_alloc,
round(nvl(b.bytes_free, 0) / 1024 / 1024) megs_free,
round((a.bytes_alloc - nvl(b.bytes_free, 0)) / 1024 / 1024) megs_used,
round((nvl(b.bytes_free, 0) / a.bytes_alloc) * 100) Pct_Free,
100 - round((nvl(b.bytes_free, 0) / a.bytes_alloc) * 100) Pct_used,
round(maxbytes / 1048576) Max
from (select f.tablespace_name,
sum(f.bytes) bytes_alloc,
sum(decode(f.autoextensible, 'YES', f.maxbytes, 'NO', f.bytes)) maxbytes
from dba_data_files f
group by tablespace_name) a,
(select f.tablespace_name, sum(f.bytes) bytes_free
from dba_free_space f
group by tablespace_name) b
where a.tablespace_name = b.tablespace_name(+)
union all
select h.tablespace_name,
round(sum(h.bytes_free + h.bytes_used) / 1048576) megs_alloc,
round(sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) /
1048576) megs_free,
round(sum(nvl(p.bytes_used, 0)) / 1048576) megs_used,
round((sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) /
sum(h.bytes_used + h.bytes_free)) * 100) Pct_Free,
100 -
round((sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) /
sum(h.bytes_used + h.bytes_free)) * 100) pct_used,
round(sum(f.maxbytes) / 1048576) max
from sys.v_$TEMP_SPACE_HEADER h,
sys.v_$Temp_exten
t_pool p,
dba_temp_files f
where p.file_id(+) = h.file_id
and p.tablespace_name(+) = h.tablespace_name
and f.file_id = h.file_id
and f.tablespace_name = h.tablespace_name
group by h.tablespace_name
ORDER BY 1
|
| 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 |
| axbfnyjhwmj91 | call SF_ASSET_PKG.ASSET_DATA_TO_BPM ( ) |
| b8p5rtmuwjc6t | select DBA_SCHEDULER_JOBS.JOB_NAME, STATE as currentState, TO_CHAR(LAST_START_DATE, 'DD-MON-YYYY HH24:MI:SS') as last_start_date, TO_CHAR(NEXT_RUN_DATE, 'DD-MON-YYYY HH24:MI:SS') as next_run_time, ENABLED, extract(second from LAST_RUN_DURATION) as LAST_RUN_DURATION, RUN_COUNT, FAILURE_COUNT, RETRY_COUNT, extract(second from ELAPSED_TIME) from DBA_SCHEDULER_JOBS left outer join DBA_SCHEDULER_RUNNING_JOBS on DBA_SCHEDULER_JOBS.JOB_NAME=DBA_SCHEDULER_RUNNING_JOBS.JOB_NAME |
| 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 |
| bbsaca2bkr56v |
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='0001A11000000005F41I') 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='0001A11000000005F41I')
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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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
1000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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 a.end_date>=to_date('2017-12-27', 'yyyy/mm/dd') and a.end_date<=to_date('2017-12-28', 'yyyy/mm/dd') order by a.form_kind, a.form_no |
| 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; |
| 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 |
| bzdtxrdyvkb6m |
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='0001A11000000005F41I') 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='0001A11000000005F41I')
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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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
1000000005F41I') 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='0001A11000000005F41I') 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='0001A11000000005F41I') 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 a.end_date>=to_date('2017-12-23', 'yyyy/mm/dd') and a.end_date<=to_date('2017-12-24', 'yyyy/mm/dd') and a.cash_place='GZZ' order by a.form_kind, a.form_no |
| 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; |
| 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 |
| df6vzpau9m7cx | SELECT STATUS FROM FM_FORM_APPROVE_OBSERVER WHERE FORM_KIND = UPPER (:B2 ) AND FORM_NO = :B1 |
| dsqr96bbumcpp |
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='1001K810000000000681') 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='1001K810000000000681')
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='1001K810000000000681') 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='1001K810000000000681') 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='1001K810000000000681') 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='1001K810000000000681') 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='1001K810000000000681') 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='1001K810000000000681') 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='1001K810000000000681') 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='1001K810000000000681') 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='1001K810000000000681') 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='1001K8
10000000000681') 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='1001K810000000000681') 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='1001K810000000000681') 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 order by a.form_kind, a.form_no |
| 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; |
| fvj96u8pxymy8 | SELECT COUNT (*) FROM FM_FORM_APPROVE_OBSERVER WHERE FORM_KIND = UPPER (:B2 ) AND FORM_NO = :B1 |
| gaj7j3xcvpvwv | SELECT COUNT (*) FROM FM_PHASE_RULE WHERE FORM_PHASE_ID = :B1 |
| 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 ) |
| gvhhm0q3n6n2k | select last_ddl_time from sys.all_objects
where owner = :object_owner
and object_type = :object_type
and object_name = :object_name
|
| 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 |
| gyrrdqc20rvnt |
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"."FORM_KIND")=:"SYS_B_08" AND UPPER("FA"."APP_STATUS")=:"SYS_B_09" AND UPPER("FA"."APP_TYPE")=:"SYS_B_10" AND "FA"."APP_EMP_ID"=:"SYS_B_11" THEN :"SYS_B_12" ELSE :"SYS_B_13" END AS C2, CASE WHEN "FA"."APP_EMP_ID"=:"SYS_B_14" THEN :"SYS_B_15" ELSE :"SYS_B_16" END AS C3, CASE WHEN "FA"."APP_EMP_ID"=:"SYS_B_17" THEN :"SYS_B_18" ELSE :"SYS_B_19" END AS C4, "FA"."FORM_NO" AS C5 FROM "SFBPM"."FM_FORM_APPROVE_ACTIVE" SAMPLE BLOCK (:"SYS_B_20" , :"SYS_B_21") SEED (:"SYS_B_22") "FA") 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 |