SQL Id | SQL Text |
3r0q2w331jup9 | SELECT /*+ USE_HASH ("A1") USE_HASH ("A2") */ "A1"."INS_NAME", "A1"."END_TIME", "A1"."APP_NO", "A1"."END_TIME", "A1"."END_TIME", "A1"."STATUS_CODE", "A1"."INS_NAME", "A2"."PS_ORG_NO", "A2"."APP_NO", "
;A2"."APP_MODE", "A2"."PS_ORG_NO", "A2"."PERMENANT_REDUCE_FLAG", "A2"."ELEC_TYPE_CODE", "A2"."APP_ID", "A2"."APP_NO", "A2"."PS_ORG_NO" FROM "P_PROC_INSTANCE" "A1", "ARC_S_APP" "A2" WHERE "A2"."PS_ORG_NO" LIKE :1 AND "A2"."APP_NO"="A1"."APP_NO" AND "A1".&q
uot;END_TIME"<:2 AND "A1"."END_TIME">=:3 AND "A1"."STATUS_CODE"='02' |
9tatc9qjgq2qu |
SELECT "A1"."INS_NAME", "A1"."INS_NAME", "A1"."APP_NO", "A1"."END_TIME", "A1"."END_TIME", "A1"."STATUS_CODE", "A1"."INS_NAME", "A1"."INS_NAME", "A2"."PS_ORG_NO", "A2"."APP_NO", "A2"."PS_ORG_NO", "A2"."CONS_NO", "A2"."CONS_NO", "A2"
;."CONS_NAME", "A2"."PS_ORG_NO", "A2"."ELEC_ADDR", "A2"."VOLT_CODE", "A2"."TRADE_CODE", "A2"."HEC_INDUSTRY_CODE", "A2"."ELEC_TYPE_CODE", "A2"."ELEC_TYPE_CODE", "A2"."APP_ID", "A2"."T_RUN_CAP", "A2"."ORGN_RUN_CAP", "A2"."T_CONTRACT_CAP", "A2"."ORGN_CONTRAC
T_CAP", "A2"."CONS_ID", "A2"."CUST_ID", "A2"."APP_NO", "A2"."PS_ORG_NO" FROM "P_PROC_INSTANCE" "A1", "ARC_S_APP" "A2" WHERE "A2"."PS_ORG_NO" LIKE :1 AND "A2"."APP_NO"="A1"."APP_NO" AND "A1"."END_TIME">=:2 AND "A1"."END_TIME"<:3 AND "A1"."INS_NAME"&l
t;>'103' AND "A1"."INS_NAME"<>'112' AND "A1"."INS_NAME"<>'217' AND "A1"."STATUS_CODE"='02' |
ca4ukj0ujvz3x |
SELECT "A1"."INS_NAME", "A1"."APP_NO", "A1"."INS_NAME", "A1"."END_TIME", "A1"."END_TIME", "A1"."STATUS_CODE", "A1"."INS_NAME", "A2"."PS_ORG_NO", "A2"."APP_NO", "A2"."PS_ORG_NO", "A2"."CONS_NO", "A2"."CONS_NO", "A2"."CONS_NAME", "A2&quo
t;."PS_ORG_NO", "A2"."ELEC_ADDR", "A2"."VOLT_CODE", "A2"."TRADE_CODE", "A2"."HEC_INDUSTRY_CODE", "A2"."ELEC_TYPE_CODE", "A2"."ELEC_TYPE_CODE", "A2"."CONS_ID", "A2"."CUST_ID", "A2"."APP_ID", "A2"."APP_NO", "A2"."PS_ORG_NO" FROM "P_PROC_INSTANCE" "A1",
"ARC_S_APP" "A2" WHERE "A2"."PS_ORG_NO" LIKE :1 AND "A1"."APP_NO"="A2"."APP_NO" AND "A1"."INS_NAME"<>'103' AND "A1"."INS_NAME"<>'112' AND "A1"."INS_NAME"<>'217' AND "A1"."END_TIME">=:2 AND "A1"."END_TIME"<:3 AND "A1"."STATUS_CODE"='02'
|
d9dkp2jmgfvr3 | select sa_resource.RES_ID as "RES_ID", sa_resource.MODULE_NAME as "MODULE_NAME", sa_resource.RES_NAME as "RES_NAME", sa_resource.RES_TYPE as "RES_TYPE", sa_resource.PERMISSION_ID as "PERMISSION_ID", sa_resource.ATTR1 as "ATTR1", sa_resource.ATTR2 as "ATTR2", sa_resource.ATTR3 as "ATTR3", sa_resource.ATTR4 as &quo
t;ATTR4", sa_resource.FOLDER_ID as "FOLDER_ID", sa_resource.HEIGHT as "HEIGHT", sa_resource.PANEL_TITLE as "PANEL_TITLE", sa_resource.B_PANEL as "B_PANEL", sa_resource.VALID_FLAG as "VALID_FLAG", sa_resource.START_TIME as "START_TIME", sa_resource.END_TIME as "END_TIME" from sa_resource where sa_resource.RES_TYPE = 'component' and sa_resource.ATTR1 = :1 and sa_resource.ATTR2 = :2 |