2020年3月1日 星期日

依據登陸角色所屬　事業處　
日記帳先改　

@AD_Org_ID@
0
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
0
0
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
0
0
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@SQL=SELECT AD_DeptOrg_ID AS DefaultValue FROM C_Order WHERE C_Order_ID=@C_Order_ID@
0
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
0
@AD_DeptOrg_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@SQL=SELECT AD_DeptOrg_ID AS DefaultValue FROM D_Order WHERE D_Order_ID=@D_Order_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
0
@AD_Org_ID@
0
@AD_Org_ID@
@AD_Org_ID@
0
0
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
0
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
0
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT AD_DeptOrg_ID AS DefaultValue FROM C_CashBook WHERE C_CashBook_ID=@C_CashBook_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
0
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
0
0
0
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT AD_DeptOrg_ID AS DefaultValue FROM GL_Journal WHERE GL_Journal_ID=@GL_Journal_ID@
@AD_Org_ID@
@AD_Org_ID@
0
@SQL=SELECT AD_DeptOrg_ID AS DefaultValue FROM C_Payment WHERE C_Payment_ID=@C_Payment_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
0
@AD_Org_ID@
@AD_DeptOrg_ID@
@AD_Org_ID@
0
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
0
0
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
0
0
0
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@#AD_Org_ID@
0
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@#AD_Org_ID@
@SQL=SELECT AD_DeptOrg_ID AS DefaultValue FROM HW_ICBody WHERE HW_ICBody_ID=@HW_ICBody_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@#AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT AD_DeptOrg_ID AS DefaultValue FROM C_Payment WHERE C_Payment_ID=@C_Payment_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@#AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
0
@SQL=SELECT AD_DeptOrg_ID AS DefaultValue FROM M_InOut WHERE M_InOut_ID=@M_InOut_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT AD_DeptOrg_ID AS DefaultValue FROM Q_Order WHERE Q_Order_ID=@Q_Order_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@SQL=SELECT AD_DeptOrg_ID AS DefaultValue FROM M_Movement WHERE M_Movement_ID=@M_Movement_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
0
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@#AD_DeptOrg_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@#AD_DeptOrg_ID@
@SQL=SELECT @AD_DeptOrg_ID@ AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_DeptOrg_ID@
0
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
0
@AD_Org_ID@
@AD_Org_ID@
0
0
@SQL=SELECT AD_DeptOrg_ID AS DefaultValue FROM HW_BI_Competence WHERE HW_BI_Competence_ID=@HW_BI_Competence_ID@
@SQL=SELECT AD_DeptOrg_ID AS DefaultValue FROM AD_User WHERE AD_User_ID=@AD_User_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@AD_Org_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@SQL=SELECT AD_DeptOrg_ID AS DefaultValue FROM M_InOutLine WHERE M_InOutLine_ID=@M_InOutLine_ID@
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@SQL=SELECT AD_DeptOrg_ID AS DefaultValue FROM HW_Forecast WHERE HW_Forecast_ID=@HW_Forecast_ID@

@SQL=SELECT AD_DeptOrg_ID AS DefaultValue FROM C_BankAccount WHERE C_BankAccount_ID=@C_BankAccount_ID@
@SQL=SELECT AD_DeptOrg_ID AS DefaultValue FROM C_Order WHERE C_Order_ID=@C_Order_ID@


財務報表必須限制只能查閱該事業處

Y
@#Date@
@#AD_Org_ID@
N
Y
@#Date@
@#Date@
@#AD_Org_ID@
0
%
N
@#Date@
@#Date@
@M_Warehouse_ID@
Y
-30
@#Date@
Y
Y
@#Date@
O
99999
Y
N
N
Y
N
N
N
N
1
Y
@#Date@
@#Date@
Y
@#Date@
S
@#Date@
Y
Y
PR
N
@#AD_Org_ID@
@#Date@
@#Date@
N
Y
Y
@#Date@
@#Date@
Y
N
@SQL=SELECT @#AD_Org_ID@ AS DefaultValue FROM Dual
@SQL=SELECT TRUNC(SYSDATE,'MONTH') AS DefaultValue FROM DUAL
#@DATE@
#@DATE@
@#Date@
@#Date@
@#Date@
@SQL=SELECT @#AD_Org_ID@ AS DefaultValue FROM Dual
N
@#Date@
N
N
@SQL=Select @#AD_Org_ID@ AS DefaultValue FROM Dual
@#Date@
@#Date@
@#Date@
Y
N
@#Date@
N
N
@SQL=Select TRUNC(SYSDATE,'MONTH') AS DefaultValue FROM Dual
#@Date@
@#Date@
A
N
@#Date@
@#Date@
@#AD_Org_ID@
@#Date@
@#Date@
@SQL=Select TRUNC(SYSDATE,'MONTH') AS DefaultValue FROM DUAL
@SQL=SELECT @#AD_Org_ID@ AS DefaultValue FROM Dual
Y
PR
N
@#AD_Org_ID@
@#AD_Org_ID@
@#AD_Org_ID@
@SQL=Select @#AD_Org_ID@ AS DefaultValue From Dual
@SQL=Select Trunc(Sysdate,'DDD') AS DefaultValue From Dual
@#Date@
Y
N
@#Date@
@#AD_Org_ID@
@SQL=Select @#AD_Org_ID@ AS DefaultValue From Dual
@SQL=Select Trunc(Sysdate,'Month') AS DefaultValue From Dual
@SQL=SELECT @#AD_Org_ID@ AS DefaultValue FROM Dual
@SQL=SELECT @#AD_Org_ID@ AS DefaultValue FROM Dual
@SQL=SELECT TRUNC(SYSDATE,'MM') AS DefaultValue FROM Dual
@#Date@
Y
N
@Date@
@SQL=SELECT @#AD_Org_ID@  AS DefaultValue FROM Dual
@SQL=Select TRUNC(SYSDATE,'MONTH') AS DefaultValue FROM Dual
#@DATE@
@Date@
@SQL=SELECT @#AD_DeptOrg_ID@ AS DefaultValue FROM Dual
@SQL=SELECT @#AD_Org_ID@ AS DefaultValue FROM DUAL
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
@SQL=SELECT TRUNC(SYSDATE,'mm') AS DefaultValue FROM Dual
'Y'
@SQL=SELECT HW_GET_ROLE_DEPTORG(@#AD_Role_ID@) AS DefaultValue FROM DUAL
1000033
@Date@
@Date@
@SQL=Select Trunc(Sysdate,'DDD') AS DefaultValue From Dual
@SQL=Select @#AD_Org_ID@ AS DefaultValue From Dual
#@DATE@
@SQL=SELECT TRUNC(SYSDATE,'MM') AS DefaultValue FROM Dual
@SQL=SELECT @#AD_Org_ID@ AS DefaultValue FROM Dual
@DATE@
@#DATE@
@#DATE@
@DATE@
@DATE@
@DATE@
@#DATE@
@Date@
@Date@
@Date@
O
@Date@
@Date@
@Date@
@SQL=SELECT TRUNC(SYSDATE,'mm') AS DefaultValue FROM Dual
@SQL=SELECT @#AD_Org_ID@ AS DefaultValue FROM Dual
@Date@
SELECT 1000005 AS DefaultValue From Dual
@SQL=SELECT TRUNC(SYSDATE,'MONTH') AS DefaultValue FROM Dual

張貼者： 於

沒有留言:

張貼留言

訂閱： 張貼留言 (Atom)