SQL Id | SQL Text |
4nxpj1gp0qjc6 |
SELECT *
FROM (SELECT LI.*,
CASE
WHEN LI.OVERDUED_NE = 1 OR LI.OVERDUED_NE = 3 THEN 1
WHEN LI.OVERDUED_NE = 0 OR LI.OVERDUED_NE = 2 THEN
CASE
WHEN E.SUSPEND_FLAG = 0 THEN
CASE
WHEN SYSTIMESTAMP >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
WHEN E.SUSPEND_FLAG = 1 THEN
CASE
WHEN E.SUSPEND_TIME >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
ELSE 0
END
ELSE 0
END OVERDUED,
CASE
WHEN E.TARGET_OVERDUE_MINTIME IS NULL THEN LI.TARGET_TIME_NE
WHEN LI.TARGET_TIME_NE IS NULL THEN E.TARGET_OVERDUE_MINTIME
WHEN E.TARGET_OVERDUE_MINTIME <= LI.TARGET_TIME_NE THEN E.TARGET_OVERDUE_MINTIME
ELSE LI.TARGET_TIME_NE
END TARGET_TIME,
FTM.WORKFORM_TYPE_KIND
FROM (SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_
STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME AS WI_INSTANCE_NAME,
F.WORKFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :1
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :2
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE F.PROCINST_ID = WF.PROC_INSTANCE_ID
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.
ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:3 LIKE (WF.DEPART_ID || '%')) OR (:4 = WF.DEPART_ID) OR (:5 = WF.DEPART_ID) OR (:6 = WF.DEPART_ID) OR (:7 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :8))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:9 LIKE (F.DEPT_ID || '%')) OR (:10 = F.DEPT_ID) OR (:11 = F.DEPT_ID) OR (:12 = F.DEPT_ID) OR (:13 = F.DEPT_ID) OR (F.DEPT_ID LIKE :14))))))
UNION ALL
SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME AS WI_INSTANCE_NAME,
F.WOR
KFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :15
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :16
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
RT_PROCESSINSTANCE P,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE WF.PROC_INSTANCE_ID = P.PROC_INSTANCE_ID
AND P.PARENT_PROCINC_ID IS NOT NULL
AND F.PROCINST_ID = P.PARENT_PROCINC_ID
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:17 LIKE (WF.DEPART_ID || '%')) OR (:18 = WF.DEPART_ID) OR (:19 = WF.DEPART_ID) OR (:20 = WF.DEPART_ID) OR (:21 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :22))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:23 LIKE (F.DEPT_ID || '%')) OR (:24 = F.DEPT_ID) OR (:25 = F.DEPT_ID) OR (:26 = F.DEPT_ID) OR (:27 = F.DEPT_ID) OR (F.D
EPT_ID LIKE :28))))))
AND NOT EXISTS
(SELECT 1
FROM SA_WORKFORM_INST RF
WHERE WF.PROC_INSTANCE_ID = RF.PROCINST_ID)) LI,
SA_WF_WORKFORM_TYPE_MAP FTM,
(SELECT ACT_INST_ID,
SUSPEND_FLAG,
MIN(TARGET_OVERDUE_MINTIME) AS TARGET_OVERDUE_MINTIME,
MIN(SUSPEND_TIME) AS SUSPEND_TIME
FROM (SELECT A.ACT_INST_ID, B.*
FROM SA_WF_EXAM_ACT_INST A, SA_WF_EXAM_INST B
WHERE A.SUBJECT_INST_ID = B.SUBJECT_INST_ID
AND A.PROC_INST_ID = B.PROC_INST_ID
AND B.COMPLETE_FLAG = 0)
GROUP BY ACT_INST_ID, SUSPEND_FLAG) E
WHERE LI.WI_WORKFORM_TYPE = FTM.WORKFORM_TYPE(+)
AND LI.ACTIVITY_INS_ID = E.ACT_INST_ID(+)) T
WHERE NOT EXISTS (SELECT 1
FROM SA_WF_WORKITEM_EXCLUDED_USER US
WHERE T.WORKITEM_INS_ID = US.WORKITEM_ID
AND US.USER_ID = :29) |
8pg54v2j5v6x0 | select SEQ_A_VOUCHER_ACCT_NO.NEXTVAL from dual |
bks1zny5ra55a |
SELECT *
FROM (SELECT LI.*,
CASE
WHEN LI.OVERDUED_NE = 1 OR LI.OVERDUED_NE = 3 THEN 1
WHEN LI.OVERDUED_NE = 0 OR LI.OVERDUED_NE = 2 THEN
CASE
WHEN E.SUSPEND_FLAG = 0 THEN
CASE
WHEN SYSTIMESTAMP >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
WHEN E.SUSPEND_FLAG = 1 THEN
CASE
WHEN E.SUSPEND_TIME >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
ELSE 0
END
ELSE 0
END OVERDUED,
CASE
WHEN E.TARGET_OVERDUE_MINTIME IS NULL THEN LI.TARGET_TIME_NE
WHEN LI.TARGET_TIME_NE IS NULL THEN E.TARGET_OVERDUE_MINTIME
WHEN E.TARGET_OVERDUE_MINTIME <= LI.TARGET_TIME_NE THEN E.TARGET_OVERDUE_MINTIME
ELSE LI.TARGET_TIME_NE
END TARGET_TIME,
FTM.WORKFORM_TYPE_KIND
FROM (SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_
STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME AS WI_INSTANCE_NAME,
F.WORKFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :1
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :2
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE F.PROCINST_ID = WF.PROC_INSTANCE_ID
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.
ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:3 LIKE (WF.DEPART_ID || '%')) OR (:4 = WF.DEPART_ID) OR (:5 = WF.DEPART_ID) OR (:6 = WF.DEPART_ID) OR (:7 = WF.DEPART_ID) OR (:8 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :9))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:10 LIKE (F.DEPT_ID || '%')) OR (:11 = F.DEPT_ID) OR (:12 = F.DEPT_ID) OR (:13 = F.DEPT_ID) OR (:14 = F.DEPT_ID) OR (:15 = F.DEPT_ID) OR (F.DEPT_ID LIKE :16)
)))))
UNION ALL
SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME
AS WI_INSTANCE_NAME,
F.WORKFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :17
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :18
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
RT_PROCESSINSTANCE P,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE WF.PROC_INSTANCE_ID = P.PROC_INSTANCE_ID
AND P.PARENT_PROCINC_ID IS NOT NULL
AND F.PROCINST_ID = P.PARENT_PROCINC_ID
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:19 LIKE (WF.DEPART_ID || '%')) OR (:20 = WF.DEPART_ID) OR (:21 = WF.DEPART_ID) OR (:22 = WF.DEPART_ID) OR (:23 = WF.DEPART_ID) OR (:24 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :25))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:26 LIKE (F.DEPT_ID || '%')) OR (:27 = F.DEPT_ID) O
R (:28 = F.DEPT_ID) OR (:29 = F.DEPT_ID) OR (:30 = F.DEPT_ID) OR (:31 = F.DEPT_ID) OR (F.DEPT_ID LIKE :32))))))
AND NOT EXISTS
(SELECT 1
FROM SA_WORKFORM_INST RF
WHERE WF.PROC_INSTANCE_ID = RF.PROCINST_ID)) LI,
SA_WF_WORKFORM_TYPE_MAP FTM,
(SELECT ACT_INST_ID,
SUSPEND_FLAG,
MIN(TARGET_OVERDUE_MINTIME) AS TARGET_OVERDUE_MINTIME,
MIN(SUSPEND_TIME) AS SUSPEND_TIME
FROM (SELECT A.ACT_INST_ID, B.*
FROM SA_WF_EXAM_ACT_INST A, SA_WF_EXAM_INST B
WHERE A.SUBJECT_INST_ID = B.SUBJECT_INST_ID
AND A.PROC_INST_ID = B.PROC_INST_ID
AND B.COMPLETE_FLAG = 0)
GROUP BY ACT_INST_ID, SUSPEND_FLAG) E
WHERE LI.WI_WORKFORM_TYPE = FTM.WORKFORM_TYPE(+)
AND LI.ACTIVITY_INS_ID = E.ACT_INST_ID(+)) T
WHERE NOT EXISTS (SELECT 1
FROM SA_WF_WORKITEM_EXCLUDED_USER US
WHERE T.WORKITEM_INS_ID = US.WORKITEM_ID
AND US.USER_ID = :33) |
bn7dr3cnvpqgt | select count(1) from sa_msg_receive, sa_msg, sa_msg_handle where ((sa_msg.MSG_ID = sa_msg_receive.MSG_ID) and (sa_msg.MSG_TYPE = sa_msg_handle.TYPE_ID)) and (sa_msg_receive.RECEIVER_ID = :1 ) |
c56sbwns406ym | select sa_query_template_sql.SQL_ID as "SQL_ID", sa_query_template_sql.TEMPLATE_ID as "TEMPLATE_ID", sa_query_source_sql.QUERY_ID as "QUERY_ID", sa_query_source_sql.SQL_NAME as "SQL_NAME", sa_query_source_sql.SQL_COMMAND as "SQL_COMMAND" from sa_query_template_sql, sa_query_source_sql where (sa_query_template_sql.SQL_ID=sa_query_source_sql.SQL_ID)
and (sa_query_template_sql.TEMPLATE_ID=:1) |
gf0stawtdxnf6 |
select c_cons.CONS_ID as "consId", c_cons.VAT_ID as "vatId", c_cons.CUST_ID as "custId", c_cons.CONS_NO as "consNo", c_cons.CONS_NAME as "consName", c_cons.CUST_QUERY_NO as "custQueryNo", c_cons.TMP_PAY_RELA_NO as "tmpPayRelaNo", c_cons.ORGN_CONS_NO as "orgnConsNo", c_cons.CONS_SORT_CODE as "consSortCode", c_cons.ELEC_ADDR as "elecAddr", c_cons.TRADE_CODE as "tradeCode", c_con
s.ELEC_TYPE_CODE as "elecTypeCode", c_cons.CONTRACT_CAP as "contractCap", c_cons.RUN_CAP as "runCap", c_cons.SHIFT_NO as "shiftNo", c_cons.LODE_ATTR_CODE as "lodeAttrCode", c_cons.VOLT_CODE as "voltCode", c_cons.HEC_INDUSTRY_CODE as "hecIndustryCode", c_cons.HOLIDAY as "holiday", c_cons.BUILD_DATE as "buildDate", c_cons.PS_DATE as "psDate", c_cons.CANCEL_DATE as "cancelDate",
c_cons.DUE_DATE as "dueDate", c_cons.NOTIFY_MODE as "notifyMode", c_cons.SETTLE_MODE as "settleMode", c_cons.STATUS_CODE as "statusCode", c_cons.ORG_NO as "orgNo", c_cons.RRIO_CODE as "rrioCode", c_cons.CHK_CYCLE as "chkCycle", c_cons.LAST_CHK_DATE as "lastChkDate", c_cons.CHECKER_NO as "checkerNo", c_cons.POWEROFF_CODE as "poweroffCode", c_cons.TRANSFER_CODE as "transferCode",
c_cons.MR_SECT_NO as "mrSectNo", c_cons.NOTE_TYPE_CODE as "noteTypeCode", c_cons.TMP_FLAG as "tmpFlag", c_cons.TMP_DATE as "tmpDate", c_cons.MEAS_MODE as "measMode", c_cons.DB_TIMESTAMP as "dbTimestamp" from c_cons where CONS_ID = :1 |