| SQL Id | SQL Text |
|---|
| 05xcf43d9psvm | SELECT NVL(SUM(FAILURES), 0) FROM SYS.DBA_QUEUE_SCHEDULES |
| 06auuh8t1pkmw | BEGIN ECCSV5(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21); END; |
| 0a9g4ajqgzyk2 | SELECT NVL(SUM(NVL(YTD_AMT, 0)), 0) FROM EMP_PLAN_CONSUMP E WHERE E.EMP_PLAN_ID=:B2 AND E.START_DATE <= TRUNC(:B1 ) AND E.END_DATE >= TRUNC(:B1 ) AND E.ACTIVE_FLAG='Y' |
| 0h1mry6myv20c | UPDATE CLAIMS SET ADMISSION_DATE = :B27 , COVERAGE_ID = :B26 , PLAN_ID = :B25 , PROVIDER_ID = :B24 , PROVIDER_NAME = :B23 , PROVIDER_TYPE = :B22 , PRIMARY_DIAGNOSIS = :B21 , BODY_PART1 = :B20 , SECONDARY_DIAGNOSIS = :B19 , BODY_PART2 = :B18 , THIRD_DIAGNOSIS = :B17 , BODY_PART3 = :B16 , PHYSICIAN_ID = :B15 , CPT_CODE1 = :B14 , CPT_CODE2 = :B13 , CPT_CODE3 = :B12 , CPT_CODE4 = :B11 , CPT_CODE5 = :B10 , MC_TAKEN_DAY = :B9 , PAID_TO_CLAIMANT = :B8 , PAID_BY_CLAIMANT = :B7 , AVG_LOS = :B6 , AVG_BILLS = :B5 , TERMINAL_ID = :B4 , LASTEDIT_DATE = :B3 , USER_CODE = :B2 WHERE CLAIMS_ID = :B1 |
| 0h3dgxrrs9mf3 | SELECT ESGETCONDDESCCHN(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11) FROM DUAL |
| 0h6b2sajwb74n | select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| 145bhssvqnd9r | SELECT PAYOR_CODE, CARD_NO_PAYOR_ID, SHORT_NAME, LONG_NAME, ADDRESS, POSTCODE, CITY, STATE, COUNTRY, TEL_NO, FAX_NO, PAYOR_TYPE, CONTACT_PERSON, EMAIL, EDI_ADDRESS, COMM_CODE, BANK_CODE, BANK_AC_NO, ACTIVE_FLAG, LASTEDIT_DATE, USER_CODE, PAYOR_CARD, CARD_EXPIRY_MONTH, CARD_EXPIRY_YEAR, ACCOUNT_NO, LOA_FLAG, FORM_HEADER_ID, ENGLISH_NAME, ENGLISH_ADDR, CURRCD, REIMBURSEMENT_PAYMENT, AGENT_INFO, NETWORK_CODE, ENROLLMENT_SUBMIT_TYPE, ENROLLMENT_PROCESS_TYPE, GENERATE_ENROLLMENT_LOG, GENERATE_CLAIMS_DOWNLOAD, INSERT_BY, INSERT_DATE FROM PAYOR WHERE PAYOR_CODE=:1 |
| 14g06b0fb69ny | UPDATE CLAIMS SET LAST_CLAIMS_STATUS_DATE = :B3 , LAST_TRANSACTION_DATE = :B3 , LAST_TRANSACTION_STATUS = :B2 , LAST_TRANSACTION_REASON = :B1 WHERE CLAIMS_ID = :B4 |
| 1688vp4907h41 |
SELECT DISTINCT TRIM(A.LONG_NAME) || ', ' || A.ADDRESS || ' (' ||
TRIM(A.PROVIDER_CODE) || ')' LONG_NAME,
A.PROVIDER_CODE,
K.FDESC ||
DECODE(K.CTRYCD,
NULL,
'',
K.CTRYCD,
' (' || K.CTRYCD || ') ') AS CTRY,
J.FDESC ||
DECODE(J.STATECD,
NULL,
'',
J.STATECD,
' (' || J.STATECD || ') ') AS STATES,
A.CITY,
B.FDESC||' ('||B.REFCD||') ' ACTIVEFLAG
FROM PROVIDER A, SYC_STATE J, SYC_CTRY K , SYC_REFCD B
WHERE A.STATE = J.STATECD(+)
AND A.COUNTRY = J.CTRYCD(+)
AND A.COUNTRY = K.CTRYCD(+)
AND A.ACTIVE_FLAG = B.REFCD AND B.MODID = 'ES' AND B.REFGRP = 'ACTIVE_FLAG' AND A.PROVIDER_CODE IN (SELECT PROVIDER_CODE FROM CORPORATE_PROVIDER_VIEW WHERE 1=1 ) ORDER BY LONG_NAME
|
| 16fvz00xsk979 | SELECT USRID, OBJID, CTLID, INSBY, INSDT, UPDBY, UPDDT, CLIENTLAYOUT, COND1, COND2, FDESC FROM SYM_USRGRID WHERE USRID = :PARA0 AND OBJID = :PARA1 AND CTLID = :PARA2 |
| 1gfaj4z5hn1kf | delete from dependency$ where d_obj#=:1 |
| 1hqsha3yfhy9z | SELECT ICD_CODE, DESCRIPTION, ICD_CATG_CODE, ACTIVE_FLAG, LASTEDIT_DATE, USER_CODE, ACCIDENTAL, CHRONIC, MINAGE, MAXAGE, GENDER, BODY_PART, ENGLISH_DESC, DETAILS, INCLUDES, EXCLUDES, BODY_SYSTEM, CLAIMS_RELATED, ICD_TYPE, INSERT_BY, INSERT_DATE FROM DIAGNOSIS WHERE ICD_CODE=:1 |
| 1kh275vrfh9kx | BEGIN ESUPDCLAIMSTS(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30); END; |
| 1qxj2jw86gyx0 | SELECT B.SQL_ID, B.HASH_VALUE FROM DBSNMP.MGMT_BASELINE_SQL B WHERE B.INSTANCE_NUMBER = :B1 |
| 2jcrxcs7uujqr | UPDATE SYT_JOB SET ENDTM = SYSDATE, REM = NVL(REM, '')||TO_CHAR(SYSDATE, 'DD/MM/YYYY HH24:MI:SS')||' '||NVL(:B2 , '')||CHR(13)||CHR(10) WHERE JOBID = :B1 |
| 2jp7wuuua1apv | INSERT INTO SYP_DATASYN_MASTER SELECT * FROM SYP_DATASYN WHERE DSTSITEID != :B1 |
| 2tjbhrruadszg | BEGIN esaddquery(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109); END; |
| 2ub8db7jmfac7 | ** SQL Text Not Available ** |
| 2uunxrv2wj57b | update sum$ set containerobj#=:2, containertype=:3, containernam=:4, fullrefreshtim=:5, increfreshtim=:6, lastrefreshscn=:7, lastrefreshdate=:8, refreshmode=:9, pflags=:10, mflags=:11, numdetailtab=:12, numaggregates=:13, numkeycolumns=:14, numjoins=:15, numinlines=:16, sumtextlen=:17, sumtext=:18, fromoffset=:19, fromlen=:20, objcount=:21, metaversion=:22, xpflags=:23, numwhrnodes=:24, numhavnodes=:25, numqbnodes=:26, qbcmarker=:27, markerdty=:28, rw_mode=:29, rw_name=:30, dest_stmt=NULL, src_stmt=NULL, spare1=:31 where obj#=:1 |
| 312hxqnvca8h7 | SELECT sid, owner, type, object FROM v$access WHERE sid = '55' |
| 3j9vafm2mjhur | ** SQL Text Not Available ** |
| 3ktacv9r56b51 | select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order# |
| 3nmpagufkpaxk |
SELECT /*+ INDEX(OP_CLAIMS.C CLAIMS_IDX35)*/ CLAIMS_ID, CLAIMS_NO, CLAIM_TYPE, TRANSMISSION_DATE, ADMISSION_TYPE, BRANCH, ADMISSION_DATE, DISCHARGEABLE_DATE, DOCRCV_DATE, CLAIMS_REC_DATE, CLAIMS_STATUS, PAYOR_CODE, AGENT_CODE, AGENCY_CODE, CENTRE_CODE, CORPORATE_CODE, DEPARTMENT, PRODUCT_CODE, PLAN_ID, POLICY_NO, POLICY_YEAR, POLICY_START_DATE, PLAN_START_DATE, PLAN_END_DATE, PROVIDER_ID, PROVIDER_TYPE, PANEL_PROVIDER, PATIENT_PAYOR_MEMBER_ID, CARD_NO, ORIGBILL_DESPATCH_DATE, NEW_IC, RECORD_NO, SUB_RECORD_NO, PATIENT_NAME, DATE_OF_BIRTH, AGE, GENDER, PATIENT_TYPE, EMPLOYEE_PAYOR_MEMBER_ID, EMPLOYEE_NAME, RELATION, PRIMARY_DIAGNOSIS, AUTHORIZATION_CODE, DUE_TOTAL, DECODE(CLAIMS_STATUS, '22', 0, '43', 0, PAID_TO_CLAIMANT) AS PAID_TO_CLAIMANT, DECODE(CLAIMS_STATUS, '22', DUE_TOTAL, '43', DUE_TOTAL, PAID_BY_CLAIMANT) AS PAID_BY_CLAIMANT, MC_TAKEN_DAY, DECISION_REASON_CODE, DEFERMENT_REASON_CODE, APPROVED_BY, CLAIM_OPEN_DATE, CLAIM_CLOSE_DATE, PAYMENT_PENDING_REASON, PREMIUM_PAID_DATE, PREMIUM_GRACE_DATE, ADMISSION_IN_PREMIUM_GRACEPD, SYSTRC, ICLAIMID, ICLAIMREGDT, APPROVED_REMARKS, TRANSACTION_DATE, ASSESSMENT_REMARK, TRIM(PAYOR_NAME)||' ('||TRIM(PAYOR_CODE)||')' PAYOR_NAME, TRIM(PROVIDER_NAME)||' ('||TRIM(PROVIDER_ID)||')' PROVIDER_NAME, TRIM(DIAGNOSIS_DESCRIPTION)||' ('||TRIM(PRIMARY_DIAGNOSIS)||')' DIAGNOSIS_DESCRIPTION, TRIM(CORPORATE_NAME)||' ('||TRIM(CORPORATE_CODE)||')' CORPORATE_NAME, TRIM(CLAIMS_STATUS
_DESC)||' ('||TRIM(CLAIMS_STATUS)||')' CLAIMS_STATUS_DESC, TRIM(COVERAGE_DESCRIPTION)||' ('||TRIM(COVERAGE_ID)||')' COVERAGE_DESCRIPTION, B4ADJUST_DUE_TOTAL, B4ADJUST_PAID_TO_CLAIMANT, B4ADJUST_PAID_BY_CLAIMANT, CHEQUE_DATE, TO_CHAR(DOCRCV_DATE, 'YYMM') AS DOCRCVDT_YM, TO_CHAR(DOCRCV_DATE, 'YYMMDD') AS DOCRCVDT_YMD, TO_CHAR(CLAIM_CLOSE_DATE, 'YYMM') AS CLOSEDT_YM, TO_CHAR(TRANSACTION_DATE, 'YYMM') AS TIMESTAMP_YM, TRIM(CASE WHEN PAYOR_CODE IN('GBGI005', 'GBGI007') THEN TO_CHAR(PLAN_COV_DESC_ENG) ELSE TO_CHAR(PLAN_COV_DESC) END)||' ('||TRIM(COVERAGE_ID)||')' PLAN_COV_DESC, POLICY_START_YEAR, TO_CHAR(TRANSACTION_DATE, 'YYMMDD') AS TIMESTAMP_YMD FROM OP_CLAIMS WHERE ADMISSION_DATE >= :PARA0 AND ADMISSION_DATE < :PARA1 + 1 AND PAYOR_CODE IN ('AETNA') AND CORPORATE_CODE IN ('AETNA2012') AND PANEL_PROVIDER = 'Y' AND CLAIM_TYPE IN('R', 'B') ORDER BY DISCHARGEABLE_DATE ASC |
| 3sskzykf9xm82 | SELECT CLAIM_NO, CLAIMS_ID, TRANSACTION_DATE, CLAIMS_STATUS, CARD_NO, RESERVED_AMT, PAYOR_REMARKS, APPROVED_DATE, APPROVED_BY, PRINT_CONFIRM, PHYSICIAN_ID, PRINTED_DATE, PRINTED_BY, ATTENTION_TO, FAX_NO, FAX_DATE, FAX_STATUS, PAYOR_CODE, NEW_CLAIMS_STATUS, ACTION_SEQNO, ACTION_BY, ACTION_DATE, ACTION_REM, UPLOAD_DATE, FAX_LOG, RESERVED_DAY, JOURNAL_NO, DOCRCV_DATE, NOTIFY_DATE, DEFERCD, VERIFIED_DATE, VERIFIED_BY, VERIFIED_CODE, VERIFIED_REM, VERIFIED_LIABILITY, PRIVATE_REMARKS, INCOMPLETE_FORM, INCOMPLETE_REPORT, REMINDER, DOCRCV_REPORT, ICD_CODE, CPT_CODE, DOCFAX_DATE, LAST_DOCRCV_DATE, LAST_DOCFAX_DATE, Cancelled_DATE, Cancelled_BY, PROVIDER_NAME, PROVIDER_ADDRESS, PAYMENT_REMARKS, FIRST_PRINT_DATE, FIRST_PRINT_BY, PROVIDER_REFNO, COMPUTETAT, Cancelled_CODE, Cancelled_REM, PAYOR_REMARKS_CATG FROM RSVAMT_TRACKING WHERE CLAIMS_ID=:1 AND TRANSACTION_DATE=:2 |
| 3tr1fvyxumqu3 | UPDATE CLAIMS SET REFERREDOPFORMNO = :B9 , CLAIMS_STATUS = :B8 , CLAIMS_REC_DATE = :B7 , APPROVED_BY = :B6 , LASTEDIT_DATE = :B7 , USER_CODE = :B6 , AVG_LOS = :B5 , AVG_BILLS = :B4 , AUTOPAY = :B3 , REMINDER = :B2 WHERE CLAIMS_ID = :B1 |
| 4hq04xk6kxmfj | INSERT INTO SYP_EVENTLOG (EVENTLOGID, INSBY, INSDT, MODID, EVENTTYP, EVENTCATG, EVENTSRC, EVENTMSG, COMPUTER) VALUES (:B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) |
| 4ht4ya8spqsu4 | ** SQL Text Not Available ** |
| 4x89s6dydx0yz |
SELECT REFERREDPHYSICIAN, REFERREDPHYSICIANSPECIALTY, REFERREDOPFORMNO, CLAIMS_ID, CARD_NO, PAYOR_CODE, PHYSICIAN_ID, AUTHORIZATION_CODE, CLAIM_NO, PROVIDER_ID, PROVIDER_TYPE, DOCTOR_NAME1, DOCTOR_NAME2, DOCTOR_NAME3, PATIENT_NAME, SERVICE_DATE, RECORD_NO, SUB_RECORD_NO, CORPORATE_CODE, SUBSIDIARY_CODE, BRANCH_CODE, PRIMARY_DIAGNOSIS, MC_TAKEN_DAY, CLAIM_TYPE, PLAN_ID, COVERAGE_ID, ADMISSION_DATE, DISCHARGEABLE_DATE, TRANSMISSION_DATE, CLAIMS_REC_DATE, DAYS_IN_HOSPITAL, COVERAGE_DAYS, NON_COVERAGE_DAYS, ADMISSION_TYPE, PATIENT_PREPAID, INS_PREPAID, DUE_TOTAL, PAID_TOTAL, BALANCE_TOTAL, PAID_BY_CLAIMANT, PAID_TO_CLAIMANT, REJECTION_CODE, CLAIMS_STATUS, COMMISSION_FLAG, APPROVAL, APPROVED_BY, REFERRAL, INVOICE_ID, REMARKS, TRIM(DISABILITY_NO) AS DISABILITY_NO, HOSP_INVOICE_NO, REMARKS50, REMARKS60, REMARKS70, REMARKS80, PROCESSED_FLAG, EXPORT40, EXPORT80, CHEQUE_NO, EXPORT90, CLAIMS_PROCESS_STATUS, CLAIMS_REF_ID, TERMINAL_ID, TERMINAL_TYPE, AVG_LOS, AVG_BILLS, BF_LIMIT, SECONDARY_DIAGNOSIS, CHEQUE_DATE, PROVIDER_NAME, PANEL_PROVIDER, DEDUCTIBLE, DEPARTMENT, EMPLOYEE_NAME, POLICY_NO, NEW_IC, AGENT_CODE, AGENCY_CODE, BROKER_CODE, AGENT_TEAM, OFFLINE_REASON, DOCRCV_BY, REVIEW_BY, REVIEW_DATE, SYSTRC, DOCSUBMIT_BY, DOCSUBMIT_DATE, CHEQUE_SENDTO, CHEQUE_TYPE, DELIVERY_TYPE, PAYLINK_CODE, PAYMENT_DESCRIPTION, PAYEE_NAME, ADDR1, ADDR2, ADDR3, ADDR4, POSTCODE, COUNTRY, AUTOPAY, DOCRCV_CE
NTRE, THIRD_DIAGNOSIS, POLICY_YEAR, CPT_CODE1, CPT_CODE2, CPT_CODE3, CPT_CODE4, CPT_CODE5, PAST_DIAGNOSIS1, PAST_DIAGNOSIS1_DUR, PAST_DIAGNOSIS2, PAST_DIAGNOSIS2_DUR, BODY_PART1, BODY_PART2, BODY_PART3, REFERBY_PHYSICIAN, WARNMSG, ERRMSG, AGENT_UNIT, ADVANCE_PAYMENT, AGENT_HPNO, CURRCD, CURRRT, ENGLISH_NAME, EST_LOS, EST_BILLS, SURGICAL_DATE, CURRCD_ORIG, CURRRT_ORIG, DUE_TOTAL_ORIG, BANKACCNO, LIABILITY_AMT, SELFPAID_COLLECTDT, SELFPAID_UPDBY, SELFPAID_UPDDT, SELFPAID_REM, INTERFACE_CLAIM_NO, PATIENT_HPNO, ACCIDENT_DATE, SURGICAL, ACCIDENTAL, EMERGENCY, NOTIFICATION_DATE, DIAGNOSIS_REMARK, CPT_REMARK, CHEQUE_REMARK, REMINDER, COINSRCAP, PRIVATE_REMARK, PREGNANT_MONTH, OUTPATIENT_TREATMENT, ADMISSION_REFERRAL, CLAIMS_RELATED, PAYEE_ICNO, POLICY_STATUS, SMOKER, THIRD_PARTY_POLICY, POLICY_ENDORSEMENT, MEMBER_ENDORSEMENT, PV_NO, REJECTION_NOTE, COINSR_BY_CLAIMANT, ORIGIN_CODE, PREMIUM_PAID_DATE, INTERFACE_CLAIM_NO2, POLICY_ENDORSEMENT_CODE, ADMISSION_REMARK, ADMISSION_PRIVATE_REMARK, REVIEW_REMARK, PLAN_START_DATE, PLAN_END_DATE, POLICY_STATUS_CHANGE_DATE, MEMBER_STATUS, POLICY_START_DATE, MNRB_RISK, FOURTH_DIAGNOSIS, FIFTH_DIAGNOSIS, INTERFACE_CLAIM_NO3, CHEQUE_DESPATCH_BY, CHEQUE_DESPATCH_DATE, SCALEDOWNCAP, SCALEDOWN_BY_CLAIMANT, PATIENT_EMAIL, AGENT_EMAIL, PREAUTH_BENEFIT, CENTRE_CODE, SELFPAID_COLLECTAMT, B4ADJUST_DUE_TOTAL_ORIG, B4ADJUST_DUE_TOTAL, B4ADJUST_PAID_TO_CLAIMANT, B4ADJUST_
PAID_BY_CLAIMANT, AMT_SETTLE_BY_PAYOR, AMT_SETTLE_BY_TPA, AMT_SETTLE_BY_PAYOR_DBNNO, AMT_SETTLE_BY_TPA_DBNNO, SELFPAID_RCPTNO, SELFPAID_CRNNO, HOSP_INVOICE_AMT_ORIG, PREMIUM_GRACE_DATE, MEMBER_PV_NO, MEMBER_CHEQUE_NO, MEMBER_CHEQUE_DATE, HOSP_INVOICE_TYPE, PREAUTH_REQUIRED_TRIGGER, EBANK_BATCHNO, EBANK_DATE, EBANK_RESPONSE, BATCH_NO, BATCH_DATE, CLAIMS_SNO, CLIENT_ID, GSTRT, GSTAMT_ORIG, UNIT, COST_CENTER, SERVICE_FEE, VATRT, VATAMT_ORIG, WHTRT, WHTAMT_ORIG, LAST_TRANSACTION_DATE, DESIGNATION, MC_START_DATE, MC_END_DATE, PACKAGE_CODE, PACKAGE_DESC, PACKAGE_FEE, LEGAL_ENTITY, OFFICE_CODE, SUBSIDIARY, DIVISION, SUBDEPARTMENT, EMPLOYMENT_LOCATION, EMPLOYMENT_REGION, EMPLOYMENT_CATEGORY, EMPLOYMENT_DATE, AMT_DISCOUNT_ORIG, AMT_DISCOUNT_MEMBER_ORIG, OCCUPATION, LAST_CLAIMS_STATUS_DATE, SERVICE_FEE_FORMULA, SERVICE_FEE_FORMULA_RATE, SERVICE_FEE_GSTRT, SERVICE_FEE_VATRT, SERVICE_FEE_GSTAMT, SERVICE_FEE_VATAMT, PAYOR_SERVICE_FEE, PAYOR_SERVICE_FEE_GSTRT, PAYOR_SERVICE_FEE_VATRT, PAYOR_SERVICE_FEE_GSTAMT, PAYOR_SERVICE_FEE_VATAMT, PAYOR_SERVICE_FEE_INVOICE_NO, MEMBER_CONTROL_NO, DUE_TOTAL_GSTAMT_ORIG, DUE_TOTAL_VATAMT_ORIG, REFERRAL_PROVIDER_ID, CPF_PREPAID, CURRCD_PAYOR, CURRRT_PAYOR, XBORDER, MERCHANT_CODE, SELFPAID_BY_MEMBER, SELFPAID_BY_PAYOR, SELFPAID_BY_PROVIDER, SELFPAID_BY_TPA, EST_LOS_ICU, USER_CODE, LASTEDIT_DATE, ASSIGNED_CODE, BIRTH_DATE, GENDER, CARDSITEID, PROVSITEID, TAXINV_RECEIVE_DATE,
ORIGBILL_DESPATCH_DATE, PREPAID_PROVIDER_AMOUNT, PROVIDER_PAYMENT_DUE_DATE, PROVIDER_CRTCD, CLAIMSLIST_RECEIVE_DATE, LAST_TRANSACTION_STATUS, LAST_TRANSACTION_REASON, INS_PREPAID_CRCD, ADMISSION_REASON, CAUSE_AND_PATHOLOGY, POSSIBILITY_RELAPSE, UNDERLYING_MEDICAL_COND, PROGNOSIS, DISCHARGE_MEDICATION, FOLLOWUP_INSTRUCTION, OTHER_THERAPEUTIC_PROCEDURE, MRN FROM CLAIMS WHERE CLAIMS_ID=:1 |
| 4xajgf8w1f769 | UPDATE CLAIMS_ALERT SET USER_CODE = :B4 , LASTEDIT_DATE = :B3 , ALERT_MSG = :B2 WHERE ALERT_NO = :B1 |
| 54kfg798vtpnp | UPDATE SYT_JOB SET STARTTM = SYSDATE, ENDTM = NULL, REM = DECODE(:B2 , NULL, NULL, TO_CHAR(SYSDATE, 'DD/MM/YYYY HH24:MI:SS')||' '||NVL(:B2 , '')||CHR(13)||CHR(10)) WHERE JOBID = :B1 |
| 572fbaj0fdw2b | select output from table(dbms_workload_repository.awr_report_html( :dbid,
:inst_num,
:bid, :eid,
:rpt_options )) |
| 5bk9n151p3dr1 | INSERT INTO EMP_PLAN_CONSUMP (EMP_PLAN_ID, YTD_AMT, LASTEDIT_DATE, USER_CODE, RESERVED_AMT, END_DATE, START_DATE, ACTIVE_FLAG) VALUES (:B5 , 0, :B4 , :B3 , NULL, :B2 , :B1 , 'Y') |
| 5fk0v8km2f811 | select propagation_name, 'BUFFERED', num_msgs ready, 0 from gv$buffered_subscribers b, dba_propagation p, dba_queues q, dba_queue_tables t where b.subscriber_name = p.propagation_name and b.subscriber_address = p.destination_dblink and b.queue_schema = p.source_queue_owner and b.queue_name = p.source_queue_name and p.source_queue_name = q.name and p.source_queue_owner = q.owner and q.queue_table = t.queue_table and b.inst_id=t.owner_instance |
| 5gs3kxgpxp447 | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN dbms_refresh.refresh('"MCSMASTER"."CLAIMS_SELFPAIDOS_VIEW"'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 5h5dn7ngua7d9 |
INSERT INTO EST_CRQ (CRQNO, INSBY, INSDT, UPDBY, UPDDT, RECMODE, RECTYP, PAYORCD, CORPCD, PAYORMEMID, PAYORPMEMID, AGENTCD, AGENCYCD, AGENCYTEAM, AGENCYLOC, BROKERCD, DEPARTMENT, BRANCH, LANG, RACE, POLICYNO, MARSTS, RELATIONSHIP, PLANSTARTDT, PLANENDDT, GROSSPREMIUM, AGENTCOMM, MGMTFEE, MCOFEE, MNRBRISK, EXCLUSION, NAME, ADDR1, ADDR2, ADDR3, ADDR4, CITY, STATE, POSTCD, RESTELNO, OFFTELNO, HPNO, NRIC, PASSPORTNO, PASSPORTCTRY, DOB, GENDER, PLANCD, EMPLOYSTS, PREMIUMPAID, PREMIUMPAIDDT, PREMIUMFREQ, TERMINATEDT, MEMBERENDORSE, POCDDT, POLICYENDORSE, PAYORACCTYP, POLICYSTARTDT, POLICYENDDT, POLICYINFORCE, POLICYSUSPEND, CARDACTIVEDT, CARDNO, EMPID, DEPID, ERRMSG, WARNMSG, PROCBY, PROCDT, PAYORREFNO, PAYORSEQNO, EMBOSSREFNO, EMBOSSBY, EMBOSSDT, CARDRCVBY, CARDRCVDT, CARDDLVBY, CARDDLVDT, POLICYOWNER, INVNO, CARDISSUE, AGENTUNIT, ENGNM, CARDTYP, DESIGNATION, UNIT, SERVFEE, CARDFEE, PLANMASTENDDT, PLANMASTSTARTDT, SERVMTH, PREFERNM, REINSTATEMENTDT, MASTERPOLICYNO, IDTYP, PED, POLICYOWNERIDTYP, POLICYOWNERIDNO, POLICYOWNERADDR, POLICYOWNERRESTELNO, POLICYOWNEROFFTELNO, POLICYOWNERHPNO, SMOKER, THIRDPARTYPOLICY, POLICYENDORSECD, POLICYORIGINCD, POLICYSTSCHGDT, POLICYISSDT, CLIENTID, POLICYOWNERCLIENTID, TAKEOVERDT, MEMBERSTS, SUBSIDIARY, MEMBERCLS, BIZSRC, PREMIUMMODE, EMAIL, PREMIUMGRACEDT, MEMID, BANKCD, BANKNM, BANKACCNO, BANKACCNM, SERVLST, PLANDESC, REST
CTRY, RESTCTRYDESC, BANKBRHCD, COSTCENTER, PANELPROV, PLANCOND, OCCUPATION, LEGALENTITY, OFFICECD, DIVISION, SUBDEPARTMENT, EMPLOYLOC, EMPLOYRGN, EMPLOYCATG, EMPLOYDT, MEMCTLNO, EMBOSSTEXTLINE, OLDCARDNO, ORIGTEXTLINE, TEXTLINE, PAYORBATCHNO, RTNMSG, MAPERRMSG, PAYORRECMODE, PAYORENDORSE, CORPENDORSE) VALUES (:B151 , :B150 , :B149 , :B148 , :B147 , :B146 , :B145 , :B144 , :B143 , :B142 , :B141 , :B140 , :B139 , :B138 , :B137 , :B136 , :B135 , :B134 , :B133 , :B132 , :B131 , :B130 , :B129 , :B128 , :B127 , :B126 , :B125 , :B124 , :B123 , :B122 , :B121 , :B120 , :B119 , :B118 , :B117 , :B116 , :B115 , :B114 , :B113 , :B112 , :B111 , :B110 , :B109 , :B108 , :B107 , :B106 , :B105 , :B104 , :B103 , :B102 , :B101 , :B100 , :B99 , :B98 , :B97 , :B96 , :B95 , :B94 , :B93 , :B92 , :B91 , :B90 , :B89 , :B88 , :B87 , :B86 , :B85 , :B84 , :B83 , :B82 , :B81 , :B80 , :B79 , :B78 , :B77 , :B76 , :B75 , :B74 , :B73 , :B72 , :B71 , :B70 , :B69 , :B68 , :B67 , :B66 , :B65 , :B64 , :B63 , :B62 , :B61 , :B60 , :B59 , :B58 , :B57 , :B56 , :B55 , :B54 , :B53 , :B52 , :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B
12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) |
| 5nvd82aafbmwf | SELECT ACSID, USRID, TIMEIN, REMOTEIP, TIMEOUT, LASTOBJID, LASTACSTM, STS FROM SYT_ACSLOG WHERE USRID=:1 ORDER BY TIMEIN DESC |
| 66u8z4rpn0351 | ** SQL Text Not Available ** |
| 6gv1n8xyyj31w |
UPDATE EMPLOYEE SET AR_GRACE=:1, CARD_ISSUED=:2, DESIGNATION=:3, UNIT=:4, RECORD_STATUS=:5, DEPARTMENT=:6, BRANCH=:7, LOCATION=:8, SUBSIDIARY=:9, LEGAL_ENTITY=:10, CORP_CODE=:11, COST_CENTER=:12, NO_OF_CHILDREN=:13, EMAIL=:14, ACTIVE_FLAG=:15, LASTEDIT_DATE=:16, LTD_SELF_CONSUMP=:17, LTD_FAMILY_CONSUMP=:18, LTD_ALLFAMILY_CONSUMP=:19, USER_CODE=:20, SPOUSE_EMP=:21, SPOUSE_EMP_ID=:22, OFFICE_CODE=:23, NP_VISIT=:24, OPBAL_DENTAL=:25, TM_EMP_CODE=:26, WARD_CLASS=:27, PAYOR_CODE=:28, LAST_NAME=:29, FIRST_NAME=:30, AR_DUEDATE=:31, EMP_NAME=:32, OLD_IC=:33, NEW_IC=:34, DATE_OF_BIRTH=:35, BIRTH_CERT=:36, PASSPORT_NO=:37, POLICY_NO=:38, CONTRACT_NO=:39, CARD_NO=:40, STAFF_NO=:41, GENDER=:42, MARITAL_STATUS=:43, ETHNIC_ID=:44, NATIONALITY=:45, ADDRESS=:46, POSTCODE=:47, CITY=:48, STATE=:49, COUNTRY=:50, TEL_NO1=:51, TEL_NO2=:52, INCOME_TAX_NO=:53, SOCSO_NO=:54, OCCUPATION=:55, EMPLOYMENT_DATE=:56, TERMINATION_DATE=:57, EMPLOYMENT_STATUS=:58, REACTIVATION_DATE=:59, ACTIVATION_DATE=:60, CANCELLATION_DATE=:61, PAYOR_MEMBER_ID=:62, AR_FLAG=:63, MF_FLAG=:64, ABL_FLAG=:65, MF_DUEDATE=:66, MF_GRACE=:67, AGENT_CODE=:68, AGENCY_CODE=:69, BROKER_CODE=:70, LANGUAGE=:71, NATURE_OF_WORK=:72, GROSS_PREMIUM=:73, AGENT_COMM=:74, MGMT_FEES=:75, MCO_FEES=:76, MNRB_RISK=:77, TEL_MOBILE=:78, PASSPORT_COUNTRY=:79, MBA_POLICY_START_DATE=:80, MBA_ACCOUNT_TYP=:81, ENDORSEMENT_DATE=:82, OTHER_PRE_EXISTING=:83, POLICY_ENDORSE=:84
, RELATIONSHIP=:85, AGENT_TEAM=:86, POLICY_OWNER=:87, BLOOD_TYPE=:88, WEIGHT=:89, HEIGHT=:90, PRE_DIAGNOSIS1=:91, PRE_DIAGNOSIS1_SINCE=:92, PRE_TREATMENT1=:93, PRE_DIAGNOSIS2=:94, PRE_DIAGNOSIS2_SINCE=:95, PRE_TREATMENT2=:96, PRE_DIAGNOSIS3=:97, PRE_DIAGNOSIS3_SINCE=:98, PRE_TREATMENT3=:99, ALLERGY_DRUG=:100, ALLERGY_OTHERS=:101, AGENT_UNIT=:102, ENGLISH_NAME=:103, ENGLISH_ADDR=:104, LOA_DESC=:105, PREFERRED_NAME=:106, RACE=:107, PREMIUM_PAID_DATE=:108, MASTER_POLICY_NO=:109, ID_TYPE=:110, POLICY_OWNER_ID_TYPE=:111, POLICY_OWNER_ID_NO=:112, POLICY_OWNER_ADDRESS=:113, POLICY_OWNER_TEL_NO1=:114, POLICY_OWNER_TEL_NO2=:115, POLICY_OWNER_TEL_MOBILE=:116, SMOKER=:117, THIRD_PARTY_POLICY=:118, POLICY_ENDORSEMENT_CODE=:119, ORIGIN_CODE=:120, POLICY_STATUS_CHANGE_DATE=:121, POLICY_ISSUE_DATE=:122, POLICY_END_DATE=:123, CLIENT_ID=:124, POLICY_OWNER_CLIENT_ID=:125, MEMBER_STATUS=:126, MEMBER_CLASS=:127, BUSINESS_SOURCE=:128, PREMIUM_MODE=:129, PREMIUM_FREQUENCY=:130, PREMIUM_GRACE_DATE=:131, BANKCD=:132, BANKNM=:133, BANKACCNO=:134, BANKACCNM=:135, BANKBRHCD=:136, RESTRICTED_COUNTRY=:137, DIVISION=:138, SUBDEPARTMENT=:139, EMPLOYMENT_LOCATION=:140, EMPLOYMENT_REGION=:141, EMPLOYMENT_CATEGORY=:142, MEMBER_CONTROL_NO=:143, PAYOR_ENDORSE=:144, CORP_ENDORSE=:145 WHERE EMPLOYEE_ID=:146 AND DEPENDENT_ID IS NULL
|
| 6k5agh28pr3wp | select propagation_name streams_name, 'PROPAGATION' streams_type, '"'||destination_queue_owner||'"."'||destination_queue_name||'"@'||destination_dblink address, queue_table, owner, source_queue_name from dba_queues, dba_propagation where owner=SOURCE_QUEUE_OWNER and SOURCE_QUEUE_NAME=name |
| 6ph4bzmub7t7b | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN dbms_refresh.refresh('"MCSMASTER"."CLAIMS_CSHOS_PREPAID_VIEW"'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 6wx9cm8knvgx7 | ** SQL Text Not Available ** |
| 7nuw4xwrnuwxq | select col#, intcol#, toid, version#, packed, intcols, intcol#s, flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc |
| 7thvb72a1v97y | INSERT INTO SYP_DATASYN SELECT * FROM SYP_DATASYN_MASTER WHERE DSTSITEID = :B1 |
| 7wt7phk4xns75 | select a.capture_name streams_process_name, a.status streams_process_status, 'CAPTURE' streams_process_type, COUNT(a.error_message) from dba_capture a group by a.capture_name, a.status union all select a.propagation_name streams_process_name, a.status streams_process_status, 'PROPAGATION' streams_process_type, COUNT(a.error_message) from dba_propagation a group by a.propagation_name, a.status union all select a.apply_name streams_process_name, a.status streams_process_status, 'APPLY' streams_process_type, COUNT(a.error_message) from dba_apply a group by a.apply_name, a.status |
| 803u6vwz0ah1p |
select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY'
)) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob
j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj#
and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID |
| 873tct2113sv2 | SELECT C.CLAIMS_ID, C.CARD_NO, C.TERMINAL_ID, C.PROVIDER_ID, C.PAYOR_CODE, C.CORPORATE_CODE, C.ADMISSION_DATE, EPV.CANCELLATION_DATE FROM CLAIMS C, EMP_PLAN_VIEW EPV, CLAIMS_SELFPAIDVALIDCLAIM_VIEW CSV WHERE C.MEMBER_CONTROL_NO = EPV.MEMBER_CONTROL_NO AND C.ADMISSION_DATE >= EPV.START_DATE AND C.ADMISSION_DATE < EPV.END_DATE + 1 AND C.ADMISSION_DATE >= EPV.CANCELLATION_DATE + 1 AND EPV.CANCELLATION_DATE IS NOT NULL AND C.CLAIMS_ID = CSV.CLAIMS_ID AND CSV.SELFPAID_COLLECTION = 'T' AND CSV.SELFPAID_AMOUNT > 0 |
| 8bbknz5s4dk3c | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN sygetdatasyn; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 8hmw7qwv9wq8m | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN eschkexception; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 917k2spwz9y5d | INSERT INTO CLAIMS_ALERT (ALERT_NO, USER_CODE, LASTEDIT_DATE, ALERT_TYPE, ALERT_MSG, CARD_NO, TERMINAL_ID, PROVIDER_CODE, PAYOR_CODE, CORP_CODE, CLAIMS_ID, ADMISSION_DATE, REMARK, MARK_BY, MARK_DATE, MARK_REM) VALUES (:B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) |
| 91kcp0agafank | DELETE FROM SYP_DATASYN_MASTER WHERE SYNID IN (SELECT SYNID FROM SYP_DATASYN) AND DSTSITEID = :B1 |
| 92aaaxj8j42nq |
SELECT EST_QUERY.QUERYNO, EST_QUERY.INSBY, EST_QUERY.INSDT, EST_QUERY.UPDBY, EST_QUERY.UPDDT, EST_QUERY.QUERYDT, EST_QUERY.QUERYTYP, EST_QUERY.QUERYGRP, EST_QUERY.QUERYMODE, EST_QUERY.QUERYSTS, EST_QUERY.QUERYBY, EST_QUERY.RCVBY, EST_QUERY.AUTHLVL, EST_QUERY.DETAILS, EST_QUERY.CARDNO, EST_QUERY.ICNO, EST_QUERY.POLICYNO, EST_QUERY.CORPCD, EST_QUERY.PAYORCD, EST_QUERY.PROVIDERCD, EST_QUERY.TELNO, EST_QUERY.HPNO, EST_QUERY.LASTACTNO, EST_QUERY.CLAIMSID, EST_QUERY.QUERYLVL, EST_QUERY.ACKSENDBY, EST_QUERY.ACKSENDDT, EST_QUERY.CLOSEBY, EST_QUERY.CLOSEDT, EST_QUERY.QUERYCATG, EST_QUERY.BEFENQ, EST_QUERY.CALLERREL, EST_QUERY.PATIENTREL, EST_QUERY.PATIENTNM, EST_QUERY.PATIENTDOB, EST_QUERY.PATIENTICNO, EST_QUERY.PATIENTTELNO, EST_QUERY.PATIENTHPNO, EST_QUERY.PATIENTEMAIL, EST_QUERY.PATIENTFAXNO, EST_QUERY.PATIENTADDR, EST_QUERY.PATIENTCITY, EST_QUERY.PATIENTPOSTCD, EST_QUERY.PATIENTCTRYCD, EST_QUERY.PATIENTSTATECD, EST_QUERY.TRAVELFRDT, EST_QUERY.TRAVELTODT, EST_QUERY.TRAVELORIGLOC, EST_QUERY.PATIENTPHYSNM, EST_QUERY.PATIENTPHYSTELNO, EST_QUERY.PROVREFNO1, EST_QUERY.PROVRATING1, EST_QUERY.PROVREFNO2, EST_QUERY.PROVRATING2, EST_QUERY.PROVREFNO3, EST_QUERY.PROVRATING3, NVL(EST_QUERY.PROVNM, PROVIDER.LONG_NAME)PROVNM, EST_QUERY.PHYSNM, EST_QUERY.PROVTELNO, EST_QUERY.PROVHPNO, EST_QUERY.PROVEMAIL, EST_QUERY.PROVFAXNO, EST_QUERY.PROVCITY, EST_QUERY.PROVPOSTCD, EST_QUERY.PROVCTRYCD, EST_QUERY.PROVSTATECD, EST_QUERY.MEDICALCOMPLAINT, EST_QUERY.RESIDENCE, EST_QUERY.SPEAKTOMEDICALSTAFF, EST_
QUERY.TRANSPORTREQ, EST_QUERY.PREFERPHYS, EST_QUERY.SAWPHYSNM, EST_QUERY.SAWPHYSTELNO, EST_QUERY.SAWPHYSLOC, EST_QUERY.SAWPHYSNMREQFAX, EST_QUERY.DEATHDT, EST_QUERY.PATIENTCURRLOC, EST_QUERY.PATIENTGENDER, EST_QUERY.PATIENTBIRTHPLC, EST_QUERY.PATIENTNAT, EST_QUERY.PATIENTRACE, EST_QUERY.PATIENTMARSTS, EST_QUERY.PATIENTVETERAN, EST_QUERY.SPOUSENM, EST_QUERY.OCCUPATION, EST_QUERY.BIZTYP, EST_QUERY.EDULVL, EST_QUERY.PATIENTFATHERNM, EST_QUERY.PATIENTMOTHERNM, EST_QUERY.DISPOSEREMAINS, EST_QUERY.DISPOSEDT, EST_QUERY.SENDFNRNM, EST_QUERY.SENDFNRADDR, EST_QUERY.SENDFNRCITY, EST_QUERY.SENDFNRPOSTCD, EST_QUERY.SENDFNRCTRYCD, EST_QUERY.SENDFNRSTATECD, EST_QUERY.SENDFNRTELNO, EST_QUERY.SENDFNRFAXNO, EST_QUERY.SENDFNRCONTACT, EST_QUERY.RCVFNRNM, EST_QUERY.RCVFNRADDR, EST_QUERY.RCVFNRCITY, EST_QUERY.RCVFNRPOSTCD, EST_QUERY.RCVFNRCTRYCD, EST_QUERY.RCVFNRSTATECD, EST_QUERY.RCVFNRTELNO, EST_QUERY.RCVFNRFAXNO, EST_QUERY.RCVFNRCONTACT, EST_QUERYACT.ACTNO, EST_QUERYACT.INSBY, EST_QUERYACT.INSDT, EST_QUERYACT.UPDBY, EST_QUERYACT.UPDDT, EST_QUERYACT.QUERYNO, EST_QUERYACT.QUERYSTS, EST_QUERYACT.ASGDT, EST_QUERYACT.ASGBY, EST_QUERYACT.ASGTO, EST_QUERYACT.ASGREM, EST_QUERYACT.ACTDT, EST_QUERYACT.ACTREM , PAYOR.LONG_NAME PAYORNM, CORPORATE.LONG_NAME CORPNM, PROVIDER.LONG_NAME PROVNM, SYC_REFCD.FDESC||' ('||SYC_REFCD.REFCD||')' QUERYCATG, CORPORATE_BRANCH.LONG_NAME BRANNM, EST_QUERY.QUERYGRP FROM EST_QUERY, EST_QUERYACT, SYC_REFCD, PAYOR, CORPORATE, CORPORATE_BRANCH , PROVIDER WHERE EST_QUERY
.LASTACTNO=EST_QUERYACT.ACTNO(+) AND EST_QUERY.QUERYCATG=SYC_REFCD.REFCD AND SYC_REFCD.MODID='ES' AND SYC_REFCD.REFGRP='QUERYCATG' AND EST_QUERY.PAYORCD= PAYOR.PAYOR_CODE(+) AND EST_QUERY.CORPCD= CORPORATE.CORP_CODE(+) AND EST_QUERY.PROVIDERCD= PROVIDER.PROVIDER_CODE(+) AND CORPORATE.CORP_CODE=CORPORATE_BRANCH.CORP_CODE(+) AND EST_QUERY.AUTHLVL <= :1 AND (EST_QUERY.QUERYBY LIKE :2 OR EST_QUERY.CARDNO IN (SELECT CDB.CARD_NO FROM CARD CDA, CARD CDB WHERE CDA.MEMBER_CONTROL_NO = CDB.MEMBER_CONTROL_NO AND CDA.CARD_NO = :3) OR EST_QUERY.POLICYNO=:4 OR EST_QUERY.ICNO=:5 OR EST_QUERY.CLAIMSID=:6) AND (EST_QUERY.QUERYSTS='O' OR EST_QUERY.QUERYSTS='I' OR EST_QUERY.QUERYSTS='C') AND EST_QUERY.QUERYCATG != 'E' ORDER BY EST_QUERY.QUERYNO |
| 95nnzns3cc6t3 | SELECT COUNT(*) FROM CLAIMS_ACTION WHERE PAYOR_CODE IN (SELECT RPAD(STNCD, 7, ' ') FROM SYM_USRSTN WHERE USRID = :1 AND STNTYP = 'PY') AND CLAIMS_STATUS=:2 AND REASON_CODE=:3 |
| 9s6jy22p0a3jf | ** SQL Text Not Available ** |
| a1rk2tczk027s | SELECT JOBNO, INSBY, INSDT, UPDBY, UPDDT, REM, FAXNO, RCVDT, PAGES, PROVCD, ACTIONBY, ACTIONDT, ACTIONTYP, CLAIMSID FROM EST_KIVFAX WHERE JOBNO=:1 |
| a39g3nh6hx8m8 |
UPDATE EST_QUERY SET UPDBY=:1, UPDDT=:2, QUERYDT=:3, QUERYTYP=:4, QUERYGRP=:5, QUERYMODE=:6, QUERYSTS=:7, QUERYBY=:8, RCVBY=:9, AUTHLVL=:10, DETAILS=:11, CARDNO=:12, ICNO=:13, POLICYNO=:14, CORPCD=:15, PAYORCD=:16, PROVIDERCD=:17, TELNO=:18, HPNO=:19, LASTACTNO=:20, CLAIMSID=:21, QUERYLVL=:22, ACKSENDBY=:23, ACKSENDDT=:24, CLOSEBY=:25, CLOSEDT=:26, QUERYCATG=:27, BEFENQ=:28, CALLERREL=:29, PATIENTREL=:30, PATIENTNM=:31, PATIENTDOB=:32, PATIENTICNO=:33, PATIENTTELNO=:34, PATIENTHPNO=:35, PATIENTEMAIL=:36, PATIENTFAXNO=:37, PATIENTADDR=:38, PATIENTCITY=:39, PATIENTPOSTCD=:40, PATIENTCTRYCD=:41, PATIENTSTATECD=:42, TRAVELFRDT=:43, TRAVELTODT=:44, TRAVELORIGLOC=:45, PATIENTPHYSNM=:46, PATIENTPHYSTELNO=:47, PROVREFNO1=:48, PROVRATING1=:49, PROVREFNO2=:50, PROVRATING2=:51, PROVREFNO3=:52, PROVRATING3=:53, PROVNM=:54, PHYSNM=:55, PROVTELNO=:56, PROVHPNO=:57, PROVEMAIL=:58, PROVFAXNO=:59, PROVCITY=:60, PROVPOSTCD=:61, PROVCTRYCD=:62, PROVSTATECD=:63, MEDICALCOMPLAINT=:64, RESIDENCE=:65, SPEAKTOMEDICALSTAFF=:66, TRANSPORTREQ=:67, PREFERPHYS=:68, SAWPHYSNM=:69, SAWPHYSTELNO=:70, SAWPHYSLOC=:71, SAWPHYSNMREQFAX=:72, DEATHDT=:73, PATIENTCURRLOC=:74, PATIENTGENDER=:75, PATIENTBIRTHPLC=:76, PATIENTNAT=:77, PATIENTRACE=:78, PATIENTMARSTS=:79, PATIENTVETERAN=:80, SPOUSENM=:81, OCCUPATION=:82, BIZTYP=:83, EDULVL=:84, PATIENTFATHERNM=:85, PATIENTMOTHERNM=:86, DISPOSEREMAINS=:87, DISPOSEDT=:88, SENDFNRNM=:89
, SENDFNRADDR=:90, SENDFNRCITY=:91, SENDFNRPOSTCD=:92, SENDFNRCTRYCD=:93, SENDFNRSTATECD=:94, SENDFNRTELNO=:95, SENDFNRFAXNO=:96, SENDFNRCONTACT=:97, RCVFNRNM=:98, RCVFNRADDR=:99, RCVFNRCITY=:100, RCVFNRPOSTCD=:101, RCVFNRCTRYCD=:102, RCVFNRSTATECD=:103, RCVFNRTELNO=:104, RCVFNRFAXNO=:105, RCVFNRCONTACT=:106 WHERE QUERYNO=:107 |
| a55w5kkky88yn | SELECT USRID, INSBY, INSDT, UPDBY, UPDDT, RECSTS, FULLNM, PASSWD, USRTYP, EMAIL, MOBILENO, LANG, THEME, PARUSRID, ENCRYPTPASSWD, GRANDUSRID, SCREENNAME, FORUMVIEW, PROFILEAPPROVED, APPROVED, Trusted, FAKEEMAIL, Url, SIGNATURE, TRACKYOURPOSTS, LASTLOGIN, LASTACTIVITY, TIMEZONE, LOCATION, OCCUPATION, INTERESTS, Msn, Yahoo, AIM, ICQ, TOTALPOSTS, HASAVATAR, SHOWUNREADTOPICSONLY, STYLE, SHOWAVATAR, DATEFORMAT, POSTVIEWORDER, FLATVIEW, DISPLAYINMEMBERLIST, AVATARUrl, AVATARTYPE, ATTRIBUTES, PASSWDLASTCHG, ROLEUSRID, NAT, ICNO, DOB, GENDER, RELIGION, MARSTS, TELNO, FAXNO, HPNO, ADDR1, ADDR2, POSTCD, CITY, STATECD, CTRYCD, IPADDR, LOGINRETRYCNT, LOGINLOCKDT, LASTACSID, ESCLMODE FROM SYM_USR WHERE USRID=:1 |
| a5pyncg7v0bw3 | /* OracleOEM */
SELECT PROPAGATION_NAME, MESSAGE_DELIVERY_MODE, TOTAL_NUMBER, TOTAL_BYTES/1024 KBYTES FROM DBA_PROPAGATION P, DBA_QUEUE_SCHEDULES Q
WHERE P.SOURCE_QUEUE_NAME = Q.QNAME AND P.SOURCE_QUEUE_OWNER = Q.SCHEMA AND MESSAGE_DELIVERY_MODE='BUFFERED'
AND Q.DESTINATION LIKE '%'||P.DESTINATION_DBLINK||'%'
|
| abwz0vhd1b7cz | ** SQL Text Not Available ** |
| arc58mfdw3d24 | SELECT MODID, REFGRP, REFCD, INSBY, INSDT, UPDBY, UPDDT, RECSTS, FDESC, SDESC, VAR1, VAR2, VAR3, FUNC1, FUNC2, FUNC3, FDESC1, SDESC1, FDESC2, SDESC2, FDESC3, SDESC3, FDESC4, SDESC4, FDESC5, SDESC5, FDESC6, SDESC6, NOTE, NOTE1, NOTE2, NOTE3, NOTE4, NOTE5, NOTE6 FROM SYC_REFCD WHERE MODID=:1 AND REFGRP=:2 AND REFCD=:3 |
| aw1ycdg41bb32 | INSERT INTO RSVAMT_TRACKING (CLAIM_NO, CLAIMS_ID, TRANSACTION_DATE, CLAIMS_STATUS, CARD_NO, RESERVED_AMT, PAYOR_REMARKS, APPROVED_DATE, APPROVED_BY, PHYSICIAN_ID, PAYOR_CODE, RESERVED_DAY, JOURNAL_NO, DOCRCV_DATE, NOTIFY_DATE, DEFERCD, ACTION_BY, PRIVATE_REMARKS, PRINTED_DATE, PRINTED_BY, INCOMPLETE_FORM, INCOMPLETE_REPORT, REMINDER, DOCRCV_REPORT, FAX_NO, FAX_DATE, DOCFAX_DATE, LAST_DOCRCV_DATE, LAST_DOCFAX_DATE, PROVIDER_NAME, PROVIDER_ADDRESS, PROVIDER_REFNO, COMPUTETAT, PAYOR_REMARKS_CATG) VALUES (:B36 , :B35 , :B30 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , NVL(:B24 , :B23 ), :B22 , NVL(:B21 , :B20 ), :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , NVL(:B12 , :B11 ), :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) |
| b2u9kspucpqwy | SELECT COUNT(*) FROM SYS.DBA_PROPAGATION WHERE ERROR_MESSAGE IS NOT NULL |
| bbvbdu6tr3c2g | UPDATE SYT_ACSLOG SET LASTOBJID=:1, LASTACSTM=:2 WHERE ACSID=:3 |
| bbvr3mpgtgqky | select sql_id, sql_text from v$sqltext where address='0000000587D46310' ORDER BY PIECE |
| bcq7kvtc0t4pr |
SELECT EST_QUERY.QUERYNO, EST_QUERY.INSBY, EST_QUERY.INSDT, EST_QUERY.UPDBY, EST_QUERY.UPDDT, EST_QUERY.QUERYDT, EST_QUERY.QUERYTYP, EST_QUERY.QUERYGRP, EST_QUERY.QUERYMODE, EST_QUERY.QUERYSTS, EST_QUERY.QUERYBY, EST_QUERY.RCVBY, EST_QUERY.AUTHLVL, EST_QUERY.DETAILS, EST_QUERY.CARDNO, EST_QUERY.ICNO, EST_QUERY.POLICYNO, EST_QUERY.CORPCD, EST_QUERY.PAYORCD, EST_QUERY.PROVIDERCD, EST_QUERY.TELNO, EST_QUERY.HPNO, EST_QUERY.LASTACTNO, EST_QUERY.CLAIMSID, EST_QUERY.QUERYLVL, EST_QUERY.ACKSENDBY, EST_QUERY.ACKSENDDT, EST_QUERY.CLOSEBY, EST_QUERY.CLOSEDT, EST_QUERY.QUERYCATG, EST_QUERY.BEFENQ, EST_QUERY.CALLERREL, EST_QUERY.PATIENTREL, EST_QUERY.PATIENTNM, EST_QUERY.PATIENTDOB, EST_QUERY.PATIENTICNO, EST_QUERY.PATIENTTELNO, EST_QUERY.PATIENTHPNO, EST_QUERY.PATIENTEMAIL, EST_QUERY.PATIENTFAXNO, EST_QUERY.PATIENTADDR, EST_QUERY.PATIENTCITY, EST_QUERY.PATIENTPOSTCD, EST_QUERY.PATIENTCTRYCD, EST_QUERY.PATIENTSTATECD, EST_QUERY.TRAVELFRDT, EST_QUERY.TRAVELTODT, EST_QUERY.TRAVELORIGLOC, EST_QUERY.PATIENTPHYSNM, EST_QUERY.PATIENTPHYSTELNO, EST_QUERY.PROVREFNO1, EST_QUERY.PROVRATING1, EST_QUERY.PROVREFNO2, EST_QUERY.PROVRATING2, EST_QUERY.PROVREFNO3, EST_QUERY.PROVRATING3, NVL(EST_QUERY.PROVNM, PROVIDER.LONG_NAME)PROVNM, EST_QUERY.PHYSNM, EST_QUERY.PROVTELNO, EST_QUERY.PROVHPNO, EST_QUERY.PROVEMAIL, EST_QUERY.PROVFAXNO, EST_QUERY.PROVCITY, EST_QUERY.PROVPOSTCD, EST_QUERY.PROVCTRYCD, EST_QUERY.PROVSTATECD, EST_QUERY.MEDICALCOMPLAINT, EST_QUERY.RESIDENCE, EST_QUERY.SPEAKTOMEDICALSTAFF, EST_
QUERY.TRANSPORTREQ, EST_QUERY.PREFERPHYS, EST_QUERY.SAWPHYSNM, EST_QUERY.SAWPHYSTELNO, EST_QUERY.SAWPHYSLOC, EST_QUERY.SAWPHYSNMREQFAX, EST_QUERY.DEATHDT, EST_QUERY.PATIENTCURRLOC, EST_QUERY.PATIENTGENDER, EST_QUERY.PATIENTBIRTHPLC, EST_QUERY.PATIENTNAT, EST_QUERY.PATIENTRACE, EST_QUERY.PATIENTMARSTS, EST_QUERY.PATIENTVETERAN, EST_QUERY.SPOUSENM, EST_QUERY.OCCUPATION, EST_QUERY.BIZTYP, EST_QUERY.EDULVL, EST_QUERY.PATIENTFATHERNM, EST_QUERY.PATIENTMOTHERNM, EST_QUERY.DISPOSEREMAINS, EST_QUERY.DISPOSEDT, EST_QUERY.SENDFNRNM, EST_QUERY.SENDFNRADDR, EST_QUERY.SENDFNRCITY, EST_QUERY.SENDFNRPOSTCD, EST_QUERY.SENDFNRCTRYCD, EST_QUERY.SENDFNRSTATECD, EST_QUERY.SENDFNRTELNO, EST_QUERY.SENDFNRFAXNO, EST_QUERY.SENDFNRCONTACT, EST_QUERY.RCVFNRNM, EST_QUERY.RCVFNRADDR, EST_QUERY.RCVFNRCITY, EST_QUERY.RCVFNRPOSTCD, EST_QUERY.RCVFNRCTRYCD, EST_QUERY.RCVFNRSTATECD, EST_QUERY.RCVFNRTELNO, EST_QUERY.RCVFNRFAXNO, EST_QUERY.RCVFNRCONTACT, EST_QUERYACT.ACTNO, EST_QUERYACT.INSBY, EST_QUERYACT.INSDT, EST_QUERYACT.UPDBY, EST_QUERYACT.UPDDT, EST_QUERYACT.QUERYNO, EST_QUERYACT.QUERYSTS, EST_QUERYACT.ASGDT, EST_QUERYACT.ASGBY, EST_QUERYACT.ASGTO, EST_QUERYACT.ASGREM, EST_QUERYACT.ACTDT, EST_QUERYACT.ACTREM , PAYOR.LONG_NAME PAYORNM, CORPORATE.LONG_NAME CORPNM, PROVIDER.LONG_NAME PROVNM, SYC_REFCD.FDESC||' ('||SYC_REFCD.REFCD||')' QUERYCATG, CORPORATE_BRANCH.LONG_NAME BRANNM, EST_QUERY.QUERYGRP FROM EST_QUERY, EST_QUERYACT, SYC_REFCD, PAYOR, CORPORATE, CORPORATE_BRANCH , PROVIDER WHERE EST_QUERY
.LASTACTNO=EST_QUERYACT.ACTNO(+) AND EST_QUERY.QUERYCATG=SYC_REFCD.REFCD AND SYC_REFCD.MODID='ES' AND SYC_REFCD.REFGRP='QUERYCATG' AND EST_QUERY.PAYORCD= PAYOR.PAYOR_CODE(+) AND EST_QUERY.CORPCD= CORPORATE.CORP_CODE(+) AND EST_QUERY.PROVIDERCD= PROVIDER.PROVIDER_CODE(+) AND CORPORATE.CORP_CODE=CORPORATE_BRANCH.CORP_CODE(+) AND EST_QUERY.AUTHLVL <= :1 AND (EST_QUERY.QUERYBY LIKE :2 OR EST_QUERY.CARDNO IN (SELECT CDB.CARD_NO FROM CARD CDA, CARD CDB WHERE CDA.MEMBER_CONTROL_NO = CDB.MEMBER_CONTROL_NO AND CDA.CARD_NO = :3) OR EST_QUERY.POLICYNO=:4 OR EST_QUERY.ICNO=:5 OR EST_QUERY.CLAIMSID=:6) AND (EST_QUERY.QUERYSTS='O' OR EST_QUERY.QUERYSTS='I' OR EST_QUERY.QUERYSTS='C') ORDER BY EST_QUERY.QUERYNO |
| bj36v6y404m29 | SELECT USER_CODE, TM_CLAIMCAT, CORP_CODE, PAYOR_CODE, PROVIDER_CODE, PROVIDER_TYPE, SHORT_NAME, LONG_NAME, ADDRESS, POSTCODE, CITY, STATE, COUNTRY, TEL_NO1, TEL_NO2, ADMIN_NAME, FAX_NO, EMAIL, EDI_ADDRESS, ACTIVE_FLAG, BUSINESS_HOUR1, BUSINESS_HOUR2, EDI_CLAIMS, COMM_CODE, INVOICE_FORMAT, PARTICIPATE_FLAG, BANK_ID, BANK_CODE, BANK_AC_NO, LASTEDIT_DATE, MERCHANT_CODE, BANK_AC_NAME, REMARKS, BANK_NAME, BANK_ADDRESS, BANK_STATE, BANK_POSCODE, BANK_CITY, TEST_DATE, TRAINING_BY, HARD_COPY, TRAINING, TEST_CARD, ACTIVATION_DATE, CANCELLATION_DATE, BILLING_ADDRESS, BILLING_POSTCODE, BILLING_CITY, BILLING_STATE, DBCD, DELIVERY_MODE, PROVIDER_REFNO, ENGLISH_NAME, ENGLISH_ADDR, DISCRT, PANEL_STARTDT, PANEL_ENDDT, DIY_NOTE, SELFPAID_COLLECTION, CURRCD, PAYMENT_MODE, PAYMENT_FREQUENCY, PAYMENT_DAY, PROVIDER_CAT, COVERAGE_PROVIDED, PROVIDER_SPECIALITY, PROVIDER_LEVEL, NO_OF_BED, MAPURL, FEE_CATG, SOCIAL_MEDICAL_PANEL, ISSUE_INVOICE_UPON_DISCHARGE, PANEL_CONTRACTING, BILL_CONSUMABLE, GSTNO, BANK_BRANCH_CODE, WEBSITE, PROVIDER_TYPE_DISP, DETAILS_DISP, ENGLISH_DETAILS_DISP, CRCD, SITEID, INSERT_BY, INSERT_DATE, DIST FROM PROVIDER WHERE PROVIDER_CODE=:1 |
| c8khjbn635s3c | select s.synonym_name object_name, o.object_type
from all_synonyms s,
sys.all_objects o
where s.owner in ('PUBLIC', user)
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')
|
| c8qnahpvm40ja | SELECT CLAIMS_STATUS, CLAIMS_STATUS_DESC, ACTIVE_FLAG, LASTEDIT_DATE, USER_CODE, BENCHMARK, ENGLISH_DESC, INSERT_BY, INSERT_DATE FROM CLAIMS_STATUS WHERE CLAIMS_STATUS=:1 |
| cdq6ubrnwxh3d | UPDATE ESP_USRPERF SET TOTCNT00 = NVL(:B46 , 0), TOTCNT01 = NVL(:B45 , 0), TOTCNT02 = NVL(:B44 , 0), TOTCNT03 = NVL(:B43 , 0), TOTCNT04 = NVL(:B42 , 0), TOTCNT05 = NVL(:B41 , 0), TOTCNT06 = NVL(:B40 , 0), TOTCNT07 = NVL(:B39 , 0), TOTCNT08 = NVL(:B38 , 0), TOTCNT09 = NVL(:B37 , 0), TOTCNT10 = NVL(:B36 , 0), TOTCNT18 = NVL(:B35 , 0), TOTCNT20 = NVL(:B34 , 0), TOTCNT24 = NVL(:B33 , 0), TOTCNT25 = NVL(:B32 , 0), TOTCNT30 = NVL(:B31 , 0), TOTCNT39 = NVL(:B30 , 0), TOTCNT42 = NVL(:B29 , 0), TOTCNT47 = NVL(:B28 , 0), TOTCNT48 = NVL(:B27 , 0), TOTCNT49 = NVL(:B26 , 0), TOTCNT50 = NVL(:B25 , 0), TOTCNT52 = NVL(:B24 , 0), TOTCNT55 = NVL(:B23 , 0), TOTCNT56 = NVL(:B22 , 0), TOTCNT5605 = NVL(:B21 , 0), TOTCNT5610 = NVL(:B20 , 0), TOTCNT5615 = NVL(:B19 , 0), TOTCNT5620 = NVL(:B18 , 0), TOTCNT5625 = NVL(:B17 , 0), TOTCNT5630 = NVL(:B16 , 0), TOTCNT57 = NVL(:B15 , 0), TOTCNT58 = NVL(:B14 , 0), TOTCNT60 = NVL(:B13 , 0), TOTCNT61 = NVL(:B12 , 0), TOTCNT64 = NVL(:B11 , 0), TOTCNT67 = NVL(:B10 , 0), TOTCNT70 = NVL(:B9 , 0), TOTCNT80 = NVL(:B8 , 0), TOTCNT83 = NVL(:B7 , 0), TOTCNTUD = NVL(:B6 , 0), TOTCNTUC = NVL(:B5 , 0), TOTCNTBA = NVL(:B4 , 0) WHERE TRXDT = TRUNC(:B3 ) AND PAYORCD = :B2 AND USRID = RTRIM(:B1 ) |
| cgdumf61kpkfj |
INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "MCSMASTER"."CLAIMS_CSHOS_PREPAID_VIEW" SELECT c.claims_id, c.provider_id, c.provider_name, c.processed_flag issue_invoice_upon_discharge, c.export40 selfpaid_collection,
c.payor_code, c.corporate_code, o.long_name corp_name, p.long_name||'('||c.centre_code||')'centre_code , c.employee_name, c.new_ic, c.card_no, c.patient_name, c.coverage_id,
c.primary_diagnosis, d.description diagnosis_description, c.admission_date, c.dischargeable_date, c.claims_status, r.claims_status last_claims_status, r.defercd payment_pending_reason,
c.service_date docrcv_date, c.taxinv_receive_date, c.docsubmit_date close_date, c.currcd_orig, c.due_total_orig, c.amt_discount_orig,
c.due_total,
(CASE
WHEN c.claims_status IN ('22', '43') THEN
0
ELSE
c.paid_to_claimant
END) PAID_TO_CLAIMANT,
(CASE
WHEN c.claims_status IN ('22', '43') THEN
c.due_total
ELSE
c.paid_by_claimant
END) PAID_BY_CLAIMANT,
c.b4adjust_due_total, c.b4adjust_paid_by_claimant, c.b4adjust_paid_to_claimant,
c.patient_prepaid,
(CASE
WHEN NVL(c.export40, 'P') = 'P' AND c.claims_status IN ('22', '43') THEN
0
WHEN NVL(c.export40, 'P') = 'P' THEN
c.paid_to_claimant
ELSE
--((NVL(c.due_total_orig, 0) - NVL(c.amt_discount_orig, 0) - NVL(c.due_total_gstamt_orig, 0) - NVL(c.due_total_vatamt_orig, 0)) * c.currrt_orig) - NVL(c.patient_prepaid * c.currrt_orig, 0)
NVL(c.due_to
tal, 0) - NVL(c.patient_prepaid * c.currrt_orig, 0)
END) pay_to_provider, provider_payment_due_date, pv_no, cheque_date, prepaid_provider_amount,
(CASE
WHEN c.pv_no IS NULL AND c.provider_payment_due_date IS NOT NULL THEN
c.provider_payment_due_date - TRUNC(SYSDATE)
ELSE
NULL
END) PAYMENT_VAIDITY,
(CASE
WHEN c.provider_payment_due_date IS NULL THEN
1
ELSE
0
END) OVERDUE_UNKNOWN_DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) > 7 THEN
1
ELSE
0
END) OVERDUE_LT_7DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN 0 AND 7 THEN
1
ELSE
0
END) OVERDUE_LE_0DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -7 AND -1 THEN
1
ELSE
0
END) OVERDUE_GT_0DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -14 AND -8 THEN
1
ELSE
0
END) OVERDUE_GT_7DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -30 AND -15 THEN
1
ELSE
0
END) OVERDUE_GT_14DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -60 AND -31 THEN
1
ELSE
0
END) OVERDUE_GT_30DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -90 AND -61 THEN
1
ELSE
0
END) OVERDUE_GT_60DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) < -90 THEN
1
ELSE
0
END) OVERDUE_GT_90DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) <= 7 THEN
1
ELSE
0
EN
D) ADMISSION_LE_7DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN 8 AND 14 THEN
1
ELSE
0
END) ADMISSION_LE_14DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN 15 AND 21 THEN
1
ELSE
0
END) ADMISSION_LE_21DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN 22 AND 30 THEN
1
ELSE
0
END) ADMISSION_LE_30AYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN 31 AND 60 THEN
1
ELSE
0
END) ADMISSION_LE_60DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN 61 AND 90 THEN
1
ELSE
0
END) ADMISSION_LE_90DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) > 90 THEN
1
ELSE
0
END) ADMISSION_GT_90DAYS,
c.admission_remark,
c.remarks assessment_remark,
c.review_remark,
r.payor_remarks approved_remarks,
r.transaction_date,
c.mrn
FROM claims c, rsvamt_tracking r, corporate o, diagnosis d, payor_centre p
WHERE c.claims_id = r.claims_id
AND c.last_claims_status_date = r.transaction_date
AND c.claims_status IN ('40', '22')
AND c.claim_type IN ('E', 'M')
AND c.service_date IS NOT NULL
--AND c.balance_total != 0
AND c.corporate_code = o.corp_code
AND o.cashless_payment = 'T'
AND c.primary_diagnosis = d.icd_code(+)
AND c.payor_code = p.payor_code(+)
AND c.centre_code = p.centre_code(+)
UNION
SELECT c.claims_id, c.provider_id, c.provider_name, c.processed_flag issue_invoice_upon_discharge, c.export40 selfpaid_collecti
on,
c.payor_code, c.corporate_code, o.long_name corp_name, p.long_name||'('||c.centre_code||')'centre_code , c.employee_name, c.new_ic, c.card_no, c.patient_name, c.coverage_id,
c.primary_diagnosis, d.description diagnosis_description, c.admission_date, c.dischargeable_date, c.claims_status, r.claims_status last_claims_status, r.defercd payment_pending_reason,
c.service_date docrcv_date, c.taxinv_receive_date, c.docsubmit_date close_date, c.currcd_orig, c.due_total_orig, c.amt_discount_orig,
c.due_total,
(CASE
WHEN c.claims_status IN ('22', '43') THEN
0
ELSE
c.paid_to_claimant
END) PAID_TO_CLAIMANT,
(CASE
WHEN c.claims_status IN ('22', '43') THEN
c.due_total
ELSE
c.paid_by_claimant
END) PAID_BY_CLAIMANT,
c.b4adjust_due_total, c.b4adjust_paid_by_claimant, c.b4adjust_paid_to_claimant,
c.patient_prepaid,
(CASE
WHEN NVL(c.export40, 'P') = 'P' AND c.claims_status IN ('22', '43') THEN
0
WHEN NVL(c.export40, 'P') = 'P' THEN
c.paid_to_claimant
ELSE
--((NVL(c.due_total_orig, 0) - NVL(c.amt_discount_orig, 0) - NVL(c.due_total_gstamt_orig, 0) - NVL(c.due_total_vatamt_orig, 0) * c.currrt_orig)) - NVL(c.patient_prepaid * c.currrt_orig, 0)
NVL(c.due_total, 0) - NVL(c.patient_prepaid * c.currrt_orig, 0)
END) pay_to_provider, provider_payment_due_date, pv_no, cheque_date, prepaid_provider_amount,
(CASE
WHEN c.pv_no IS NULL AND c.provider_payment_due_date
IS NOT NULL THEN
c.provider_payment_due_date - TRUNC(SYSDATE)
ELSE
NULL
END) PAYMENT_VAIDITY,
(CASE
WHEN c.provider_payment_due_date IS NULL THEN
1
ELSE
0
END) OVERDUE_UNKNOWN_DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) > 7 THEN
1
ELSE
0
END) OVERDUE_LT_7DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN 0 AND 7 THEN
1
ELSE
0
END) OVERDUE_LE_0DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -7 AND -1 THEN
1
ELSE
0
END) OVERDUE_GT_0DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -14 AND -8 THEN
1
ELSE
0
END) OVERDUE_GT_7DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -30 AND -15 THEN
1
ELSE
0
END) OVERDUE_GT_14DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -60 AND -31 THEN
1
ELSE
0
END) OVERDUE_GT_30DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) BETWEEN -90 AND -61 THEN
1
ELSE
0
END) OVERDUE_GT_60DAYS,
(CASE
WHEN c.provider_payment_due_date - TRUNC(SYSDATE) < -90 THEN
1
ELSE
0
END) OVERDUE_GT_90DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) <= 7 THEN
1
ELSE
0
END) ADMISSION_LE_7DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN 8 AND 14 THEN
1
ELSE
0
END) ADMISSION_LE_14DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN 15 A
ND 21 THEN
1
ELSE
0
END) ADMISSION_LE_21DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN 22 AND 30 THEN
1
ELSE
0
END) ADMISSION_LE_30AYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN 31 AND 60 THEN
1
ELSE
0
END) ADMISSION_LE_60DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) BETWEEN 61 AND 90 THEN
1
ELSE
0
END) ADMISSION_LE_90DAYS,
(CASE
WHEN TRUNC(SYSDATE) - TRUNC(c.admission_date) > 90 THEN
1
ELSE
0
END) ADMISSION_GT_90DAYS,
c.admission_remark,
c.remarks assessment_remark,
c.review_remark,
r.payor_remarks approved_remarks,
r.transaction_date,
c.mrn
FROM claims_action a, claims c, rsvamt_tracking r, corporate o, diagnosis d, payor_centre p
WHERE a.claims_status = '56'
AND a.reason_code IN ('05', '10', '15', '20', '25', '30')
AND a.claims_id = c.claims_id
AND c.claims_id = r.claims_id
AND c.last_claims_status_date = r.transaction_date
AND c.claims_status IN ('40', '22')
AND c.claim_type IN ('E', 'M')
--AND c.balance_total != 0
AND c.corporate_code = o.corp_code
AND o.cashless_payment = 'T'
AND c.primary_diagnosis = d.icd_code(+)
AND c.payor_code = p.payor_code(+)
AND c.centre_code = p.centre_code(+)
|
| cxjqbfn0d3yqq | SELECT COUNT(*) FROM SYS.DBA_PROPAGATION |
| cz6cksu3ja38u | BEGIN syaddeventlog(:1, :2, :3, :4, :5, :6, :7, :8, :9); END; |
| d0ps7cb2upbcm |
SELECT /*+ INDEX(OP_CLAIMS.C CLAIMS_IDX3 ADMISSION_DATE_IDX)*/ CLAIMS_ID, CLAIMS_NO, CLAIM_TYPE, TRANSMISSION_DATE, ADMISSION_TYPE, BRANCH, ADMISSION_DATE, DISCHARGEABLE_DATE, DOCRCV_DATE, CLAIMS_REC_DATE, CLAIMS_STATUS, PAYOR_CODE, AGENT_CODE, AGENCY_CODE, CENTRE_CODE, CORPORATE_CODE, DEPARTMENT, PRODUCT_CODE, PLAN_ID, POLICY_NO, POLICY_YEAR, POLICY_START_DATE, PLAN_START_DATE, PLAN_END_DATE, PROVIDER_ID, PROVIDER_TYPE, PANEL_PROVIDER, PATIENT_PAYOR_MEMBER_ID, CARD_NO, ORIGBILL_DESPATCH_DATE, NEW_IC, RECORD_NO, SUB_RECORD_NO, PATIENT_NAME, DATE_OF_BIRTH, AGE, GENDER, PATIENT_TYPE, EMPLOYEE_PAYOR_MEMBER_ID, EMPLOYEE_NAME, RELATION, PRIMARY_DIAGNOSIS, AUTHORIZATION_CODE, DUE_TOTAL, DECODE(CLAIMS_STATUS, '22', 0, '43', 0, PAID_TO_CLAIMANT) AS PAID_TO_CLAIMANT, DECODE(CLAIMS_STATUS, '22', DUE_TOTAL, '43', DUE_TOTAL, PAID_BY_CLAIMANT) AS PAID_BY_CLAIMANT, MC_TAKEN_DAY, DECISION_REASON_CODE, DEFERMENT_REASON_CODE, APPROVED_BY, CLAIM_OPEN_DATE, CLAIM_CLOSE_DATE, PAYMENT_PENDING_REASON, PREMIUM_PAID_DATE, PREMIUM_GRACE_DATE, ADMISSION_IN_PREMIUM_GRACEPD, SYSTRC, ICLAIMID, ICLAIMREGDT, APPROVED_REMARKS, TRANSACTION_DATE, ASSESSMENT_REMARK, TRIM(PAYOR_NAME)||' ('||TRIM(PAYOR_CODE)||')' PAYOR_NAME, TRIM(PROVIDER_NAME)||' ('||TRIM(PROVIDER_ID)||')' PROVIDER_NAME, TRIM(DIAGNOSIS_DESCRIPTION)||' ('||TRIM(PRIMARY_DIAGNOSIS)||')' DIAGNOSIS_DESCRIPTION, TRIM(CORPORATE_NAME)||' ('||TRIM(CORPORATE_CODE)||')' CORPORATE_NAME, T
RIM(CLAIMS_STATUS_DESC)||' ('||TRIM(CLAIMS_STATUS)||')' CLAIMS_STATUS_DESC, TRIM(COVERAGE_DESCRIPTION)||' ('||TRIM(COVERAGE_ID)||')' COVERAGE_DESCRIPTION, B4ADJUST_DUE_TOTAL, B4ADJUST_PAID_TO_CLAIMANT, B4ADJUST_PAID_BY_CLAIMANT, CHEQUE_DATE, TO_CHAR(DOCRCV_DATE, 'YYMM') AS DOCRCVDT_YM, TO_CHAR(DOCRCV_DATE, 'YYMMDD') AS DOCRCVDT_YMD, TO_CHAR(CLAIM_CLOSE_DATE, 'YYMM') AS CLOSEDT_YM, TO_CHAR(TRANSACTION_DATE, 'YYMM') AS TIMESTAMP_YM, TRIM(CASE WHEN PAYOR_CODE IN('GBGI005', 'GBGI007') THEN TO_CHAR(PLAN_COV_DESC_ENG) ELSE TO_CHAR(PLAN_COV_DESC) END)||' ('||TRIM(COVERAGE_ID)||')' PLAN_COV_DESC, POLICY_START_YEAR, TO_CHAR(TRANSACTION_DATE, 'YYMMDD') AS TIMESTAMP_YMD FROM OP_CLAIMS WHERE ADMISSION_DATE >= :PARA0 AND ADMISSION_DATE < :PARA1 + 1 AND PAYOR_CODE IN ('AETNA') AND CORPORATE_CODE IN ('AETNA2012') AND PANEL_PROVIDER = 'Y' AND CLAIM_TYPE IN ('E', 'M') ORDER BY DISCHARGEABLE_DATE ASC |
| d5uz9k7utxukt |
select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time), a.obj#, decode(bitand(a.flags, 16384), 0, 0, 1), a.sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q UNION ALL select j.job, 0, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (:1 = 1) and (j.field1 is null or j.field1 = 0) and j.job not in (select v.id2 from v$lock v where v.type = 'JQ')) a where bitand(a.job_status, 3) = 1 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and a.instance_id is NULL and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) = (select min(decode(bitand(c.flags, 16384), 0,
c.next_run_date, c.last_enabled_time)) from (select r.flags flags, r.next_run_date next_run_date, r.job_status job_status, r.class_oid class_oid, r.last_enabled_time last_enabled_time, r.instance_id instance_id from sys.scheduler$_job r UNION ALL select s.flags, s.next_run_date, s.job_status, s.class_oid, s.last_enabled_time, s.instance_id from sys.scheduler$_lightweight_job s UNION ALL select 0, from_tz(cast(k.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(k.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL from sys.job$ k where (:2 = 1) and (k.field1 is null or k.field1 = 0) and k.job not in (select w.id2 from v$lock w where w.type = 'JQ')) c where bitand(c.job_status, 3) = 1 and ((bitand(c.flags, 134217728 + 268435456) = 0) or (bitand(c.job_status, 1024) <> 0)) and bitand(c.flags, 4096) = 0 and c.instance_id is NULL and (c.class_oid is null or (c.class_oid is not null and c.class_oid in (select d.obj# from sys.scheduler$_class d where d.affinity is null)))) |
| dyuuvpftk5q6r |
INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "MCSMASTER"."CLAIMS_SELFPAIDOS_VIEW" SELECT CANCELLATION_DATE,
claims_id,
provider_id,
provider_name,
claim_type,
claims_status,
admission_date,
dischargeable_date,
claims_rec_date,
service_date,
payor_code,
centre_code,
corporate_code,
plan_id,
plan_start_date,
plan_end_date,
policy_no,
new_ic,
patient_name,
primary_diagnosis,
icd_description,
due_total,
patient_prepaid,
approved_by,
paid_to_claimant,
paid_by_claimant,
os_aging,
selfpaid_difference,
selfpaid_by_member,
selfpaid_rcptno,
selfpaid_collectdt,
selfpaid_by_payor,
selfpaid_by_provider,
selfpaid_by_tpa,
selfpaid_balance,
selfpaid_amount,
selfpaid_acknowledge_date,
terminal_id,
subsidiary_code,
card_no,
corporate_name,
patient_payor_member_id,
employee_name,
coverage_description,
diagnosis_description,
b4adjust_due_total,
b4adjust_paid_by_claimant,
b4adjust_paid_to_claimant,
assessment_remark,
claim_close_date,
claims_process_status,
last_transaction_status,
last_transaction_reason,
export40,
selfp
aid_collection,
email,
tel_mobile,
employee_id,
member_control_no,
action_category,
transaction_date,
public_remark,
private_remarks,
(CASE
WHEN approved_remarks_58 IS NULL THEN approved_remarks_5630
ELSE approved_remarks_58
END)
approved_remarks,
collection_final_decision,
FOLLOWUP_COUNT,
FOLLOWUP_DATE_1ST,
FOLLOWUP_DATE_2ND,
FOLLOWUP_DATE_3RD,
FOLLOWUP_DATE_LAST,
PAYMENT_RECEIVED
FROM CLAIMS_SELFPAID_VIEW
|
| fa9h9b8quxkb7 | UPDATE MMM_MEM SET UPDBY=:1, UPDDT=:2, RECSTS=:3, MEMTYP=:4, FULLNM=:5, SCREENNAME=:6, NAT=:7, ICNO=:8, DOB=:9, GENDER=:10, RELIGION=:11, MARSTS=:12, TELNO=:13, FAXNO=:14, MOBILENO=:15, EMAIL=:16, LOGINID=:17, PASSWD=:18, PASSWDLASTCHG=:19, LASTLOGIN=:20, ADDR1=:21, ADDR2=:22, POSTCD=:23, CITY=:24, STATECD=:25, CTRYCD=:26, OCCUPATION=:27, INTERESTS=:28 WHERE MEMID=:29 |
| ffud8tf6mk9st | UPDATE PLANMAST SET EFFECTIVE_DATE=:1, TERMINATION_DATE=:2, ACTIVE_FLAG=:3, SHORT_NAME=:4, LONG_NAME=:5, PROCESS_TERM_DATE=:6, NETWORK_CODE=:7, GROUP_NAME=:8, UNIT_RATE=:9, RESERVE_AMT=:10, PAYOR_CODE=:11, LASTEDIT_DATE=:12, USER_CODE=:13, REMARKS=:14, ASSIGNED_CODE=:15, ENGLISH_NAME=:16, MEMBER_ENTITLED=:17, CASHLESS_FACILITY=:18, REIMBURSEMENT_RESERVE_AMT=:19, RESTRICTED_COUNTRY=:20, COVER_ALL_EMERGENCY=:21, CASHLESS_FACILITY_MONTH=:22, NCB_MONTH=:23, NCB_PLAN_CODE=:24, MOBILE_NOTE=:MOBILE_NOTE, MOBILE_ENGLISH_NOTE=:MOBILE_ENGLISH_NOTE, MOBILE_EXCLUSION=:25, MOBILE_ENGLISH_EXCLUSION=:26, PRORATE_CURRENT_LIMIT_FORMULA=:27, BENEFIT_DISPLAY_FOR_MEMBER=:28, RESTRICTED_COUNTRY_DESC=:29, SERVICE_LIST=:30, SERVICE_FEE=:31, VISIT_RESTRICTED_PROVIDER_ONLY=:32, PLAN_STATUS=:33, POLICY_NO=:34, POLICY_YEAR=:35, LAST_TRACKING_SNO=:36, ADDCOINSR_FORMULA=:37, AGGCOINSR_FORMULA=:38, INSERT_BY =:39, INSERT_DATE=:40 , DISABILITY_DURATION_FROM_DATE=:41 WHERE PLAN_CODE=:42 AND CORP_CODE=:43 |
| fvhst37f8f06v |
/* OracleOEM */
select capture_name streams_name, 'capture' streams_type , (available_message_create_time-capture_message_create_time)*86400 latency,
nvl(total_messages_enqueued, 0) total_messages from gv$streams_capture
union all
select dba_propagation.propagation_name streams_name, 'propagation' streams_type, last_lcr_latency streams_latency , total_msgs total_messages from gv$propagation_sender, dba_propagation
where source_queue_owner=queue_schema and source_queue_name=queue_name and dblink='"'||destination_queue_owner ||'"' ||'.'||'"' ||destination_queue_name||'"@'||destination_dblink
union all
SELECT distinct apc.apply_name as STREAMS_NAME,
'apply' as STREAMS_TYPE,
CASE WHEN aps.state != 'IDLE' THEN
nvl((aps.apply_time - aps.create_time)*86400, -1)
WHEN apc.state != 'IDLE' THEN
nvl((apc.apply_time - apc.create_time)*86400, -1)
WHEN apr.state != 'IDLE' THEN
nvl((apr.apply_time - apr.create_time)*86400, -1)
ELSE 0
END as STREAMS_LATENCY,
nvl(aps.TOTAL_MESSAGES_APPLIED, 0) as TOTAL_MESSAGES
FROM ( SELECT apply_name,
state,
apply_time,
applied_message_create_time as create_time,
total_messages_applied
FROM ( SELECT apply_name,
state,
apply
_time,
applied_message_create_time,
MAX(applied_message_create_time)
OVER (PARTITION BY apply_name)
as max_create_time,
SUM(total_messages_applied)
OVER (PARTITION BY apply_name)
as total_messages_applied
FROM gv$streams_apply_server )
WHERE MAX_CREATE_TIME||'X' =
APPLIED_MESSAGE_CREATE_TIME||'X' ) aps,
( SELECT apply_name,
state,
lwm_time as apply_time,
lwm_message_create_time as create_time
FROM gv$streams_apply_coordinator ) apc,
( SELECT apply_name,
state,
dequeue_time as apply_time,
dequeued_message_create_time as create_time
FROM gv$streams_apply_reader ) apr
WHERE apc.apply_name = apr.apply_name AND
apr.apply_name = aps.apply_name
|
| g3wrkmxkxzhf2 | select cols, audit$, textlength, intcols, property, flags, rowid from view$ where obj#=:1 |
| gnr5npcp3fvbb |
SELECT REFERREDPHYSICIAN, REFERREDPHYSICIANSPECIALTY, REFERREDOPFORMNO, CLAIMS_ID, CARD_NO, PAYOR_CODE, PHYSICIAN_ID, AUTHORIZATION_CODE, CLAIM_NO, PROVIDER_ID, PROVIDER_TYPE, DOCTOR_NAME1, DOCTOR_NAME2, DOCTOR_NAME3, PATIENT_NAME, SERVICE_DATE, RECORD_NO, SUB_RECORD_NO, CORPORATE_CODE, SUBSIDIARY_CODE, BRANCH_CODE, PRIMARY_DIAGNOSIS, MC_TAKEN_DAY, CLAIM_TYPE, PLAN_ID, COVERAGE_ID, ADMISSION_DATE, DISCHARGEABLE_DATE, TRANSMISSION_DATE, CLAIMS_REC_DATE, DAYS_IN_HOSPITAL, COVERAGE_DAYS, NON_COVERAGE_DAYS, ADMISSION_TYPE, PATIENT_PREPAID, INS_PREPAID, DUE_TOTAL, PAID_TOTAL, BALANCE_TOTAL, PAID_BY_CLAIMANT, PAID_TO_CLAIMANT, REJECTION_CODE, CLAIMS_STATUS, COMMISSION_FLAG, APPROVAL, APPROVED_BY, REFERRAL, INVOICE_ID, REMARKS, TRIM(DISABILITY_NO) AS DISABILITY_NO, HOSP_INVOICE_NO, REMARKS50, REMARKS60, REMARKS70, REMARKS80, PROCESSED_FLAG, EXPORT40, EXPORT80, CHEQUE_NO, EXPORT90, CLAIMS_PROCESS_STATUS, CLAIMS_REF_ID, TERMINAL_ID, TERMINAL_TYPE, AVG_LOS, AVG_BILLS, BF_LIMIT, SECONDARY_DIAGNOSIS, CHEQUE_DATE, PROVIDER_NAME, PANEL_PROVIDER, DEDUCTIBLE, DEPARTMENT, EMPLOYEE_NAME, POLICY_NO, NEW_IC, AGENT_CODE, AGENCY_CODE, BROKER_CODE, AGENT_TEAM, OFFLINE_REASON, DOCRCV_BY, REVIEW_BY, REVIEW_DATE, SYSTRC, DOCSUBMIT_BY, DOCSUBMIT_DATE, CHEQUE_SENDTO, CHEQUE_TYPE, DELIVERY_TYPE, PAYLINK_CODE, PAYMENT_DESCRIPTION, PAYEE_NAME, ADDR1, ADDR2, ADDR3, ADDR4, POSTCODE, COUNTRY, AUTOPAY, DOCRCV_CE
NTRE, THIRD_DIAGNOSIS, POLICY_YEAR, CPT_CODE1, CPT_CODE2, CPT_CODE3, CPT_CODE4, CPT_CODE5, PAST_DIAGNOSIS1, PAST_DIAGNOSIS1_DUR, PAST_DIAGNOSIS2, PAST_DIAGNOSIS2_DUR, BODY_PART1, BODY_PART2, BODY_PART3, REFERBY_PHYSICIAN, WARNMSG, ERRMSG, AGENT_UNIT, ADVANCE_PAYMENT, AGENT_HPNO, CURRCD, CURRRT, ENGLISH_NAME, EST_LOS, EST_BILLS, SURGICAL_DATE, CURRCD_ORIG, CURRRT_ORIG, DUE_TOTAL_ORIG, BANKACCNO, LIABILITY_AMT, SELFPAID_COLLECTDT, SELFPAID_UPDBY, SELFPAID_UPDDT, SELFPAID_REM, INTERFACE_CLAIM_NO, PATIENT_HPNO, ACCIDENT_DATE, SURGICAL, ACCIDENTAL, EMERGENCY, NOTIFICATION_DATE, DIAGNOSIS_REMARK, CPT_REMARK, CHEQUE_REMARK, REMINDER, COINSRCAP, PRIVATE_REMARK, PREGNANT_MONTH, OUTPATIENT_TREATMENT, ADMISSION_REFERRAL, CLAIMS_RELATED, PAYEE_ICNO, POLICY_STATUS, SMOKER, THIRD_PARTY_POLICY, POLICY_ENDORSEMENT, MEMBER_ENDORSEMENT, PV_NO, REJECTION_NOTE, COINSR_BY_CLAIMANT, ORIGIN_CODE, PREMIUM_PAID_DATE, INTERFACE_CLAIM_NO2, POLICY_ENDORSEMENT_CODE, ADMISSION_REMARK, ADMISSION_PRIVATE_REMARK, REVIEW_REMARK, PLAN_START_DATE, PLAN_END_DATE, POLICY_STATUS_CHANGE_DATE, MEMBER_STATUS, POLICY_START_DATE, MNRB_RISK, FOURTH_DIAGNOSIS, FIFTH_DIAGNOSIS, INTERFACE_CLAIM_NO3, CHEQUE_DESPATCH_BY, CHEQUE_DESPATCH_DATE, SCALEDOWNCAP, SCALEDOWN_BY_CLAIMANT, PATIENT_EMAIL, AGENT_EMAIL, PREAUTH_BENEFIT, CENTRE_CODE, SELFPAID_COLLECTAMT, B4ADJUST_DUE_TOTAL_ORIG, B4ADJUST_DUE_TOTAL, B4ADJUST_PAID_TO_CLAIMANT, B4ADJUST_
PAID_BY_CLAIMANT, AMT_SETTLE_BY_PAYOR, AMT_SETTLE_BY_TPA, AMT_SETTLE_BY_PAYOR_DBNNO, AMT_SETTLE_BY_TPA_DBNNO, SELFPAID_RCPTNO, SELFPAID_CRNNO, HOSP_INVOICE_AMT_ORIG, PREMIUM_GRACE_DATE, MEMBER_PV_NO, MEMBER_CHEQUE_NO, MEMBER_CHEQUE_DATE, HOSP_INVOICE_TYPE, PREAUTH_REQUIRED_TRIGGER, EBANK_BATCHNO, EBANK_DATE, EBANK_RESPONSE, BATCH_NO, BATCH_DATE, CLAIMS_SNO, CLIENT_ID, GSTRT, GSTAMT_ORIG, UNIT, COST_CENTER, SERVICE_FEE, VATRT, VATAMT_ORIG, WHTRT, WHTAMT_ORIG, LAST_TRANSACTION_DATE, DESIGNATION, MC_START_DATE, MC_END_DATE, PACKAGE_CODE, PACKAGE_DESC, PACKAGE_FEE, LEGAL_ENTITY, OFFICE_CODE, SUBSIDIARY, DIVISION, SUBDEPARTMENT, EMPLOYMENT_LOCATION, EMPLOYMENT_REGION, EMPLOYMENT_CATEGORY, EMPLOYMENT_DATE, AMT_DISCOUNT_ORIG, AMT_DISCOUNT_MEMBER_ORIG, OCCUPATION, LAST_CLAIMS_STATUS_DATE, SERVICE_FEE_FORMULA, SERVICE_FEE_FORMULA_RATE, SERVICE_FEE_GSTRT, SERVICE_FEE_VATRT, SERVICE_FEE_GSTAMT, SERVICE_FEE_VATAMT, PAYOR_SERVICE_FEE, PAYOR_SERVICE_FEE_GSTRT, PAYOR_SERVICE_FEE_VATRT, PAYOR_SERVICE_FEE_GSTAMT, PAYOR_SERVICE_FEE_VATAMT, PAYOR_SERVICE_FEE_INVOICE_NO, MEMBER_CONTROL_NO, DUE_TOTAL_GSTAMT_ORIG, DUE_TOTAL_VATAMT_ORIG, REFERRAL_PROVIDER_ID, CPF_PREPAID, CURRCD_PAYOR, CURRRT_PAYOR, XBORDER, MERCHANT_CODE, SELFPAID_BY_MEMBER, SELFPAID_BY_PAYOR, SELFPAID_BY_PROVIDER, SELFPAID_BY_TPA, EST_LOS_ICU, USER_CODE, LASTEDIT_DATE, ASSIGNED_CODE, BIRTH_DATE, GENDER, CARDSITEID, PROVSITEID, TAXINV_RECEIVE_DATE,
ORIGBILL_DESPATCH_DATE, PREPAID_PROVIDER_AMOUNT, PROVIDER_PAYMENT_DUE_DATE, PROVIDER_CRTCD, CLAIMSLIST_RECEIVE_DATE, LAST_TRANSACTION_STATUS, LAST_TRANSACTION_REASON, INS_PREPAID_CRCD, ADMISSION_REASON, CAUSE_AND_PATHOLOGY, POSSIBILITY_RELAPSE, UNDERLYING_MEDICAL_COND, PROGNOSIS, DISCHARGE_MEDICATION, FOLLOWUP_INSTRUCTION, OTHER_THERAPEUTIC_PROCEDURE, MRN FROM CLAIMS WHERE CLAIMS_ID=:1 AND PAYOR_CODE IN (SELECT RPAD(STNCD, 7, ' ') FROM SYM_USRSTN WHERE USRID = :2 AND STNTYP='PY') |
| gtr8rw7p2h5xy | SELECT event#, sql_id, sql_plan_hash_value, sql_opcode, session_id, session_serial#, module, action, client_id, DECODE(wait_time, 0, 'W', 'C'), 1, time_waited, service_hash, user_id, program, sample_time, p1, p2, p3, current_file#, current_obj#, current_block#, qc_session_id, qc_instance_id, plsql_object_id, plsql_subprogram_id, qc_session_serial# FROM v$active_session_history WHERE sample_time > :1 AND sample_time <= :2 |
| gypm4x1bznubg |
SELECT EST_QUERY.QUERYNO, EST_QUERY.INSBY, EST_QUERY.INSDT, EST_QUERY.UPDBY, EST_QUERY.UPDDT, EST_QUERY.QUERYDT, EST_QUERY.QUERYTYP, EST_QUERY.QUERYGRP, EST_QUERY.QUERYMODE, EST_QUERY.QUERYSTS, EST_QUERY.QUERYBY, EST_QUERY.RCVBY, EST_QUERY.AUTHLVL, EST_QUERY.DETAILS, EST_QUERY.CARDNO, EST_QUERY.ICNO, EST_QUERY.POLICYNO, EST_QUERY.CORPCD, EST_QUERY.PAYORCD, EST_QUERY.PROVIDERCD, EST_QUERY.TELNO, EST_QUERY.HPNO, EST_QUERY.LASTACTNO, EST_QUERY.CLAIMSID, EST_QUERY.QUERYLVL, EST_QUERY.ACKSENDBY, EST_QUERY.ACKSENDDT, EST_QUERY.CLOSEBY, EST_QUERY.CLOSEDT, EST_QUERY.QUERYCATG, EST_QUERY.BEFENQ, EST_QUERY.CALLERREL, EST_QUERY.PATIENTREL, EST_QUERY.PATIENTNM, EST_QUERY.PATIENTDOB, EST_QUERY.PATIENTICNO, EST_QUERY.PATIENTTELNO, EST_QUERY.PATIENTHPNO, EST_QUERY.PATIENTEMAIL, EST_QUERY.PATIENTFAXNO, EST_QUERY.PATIENTADDR, EST_QUERY.PATIENTCITY, EST_QUERY.PATIENTPOSTCD, EST_QUERY.PATIENTCTRYCD, EST_QUERY.PATIENTSTATECD, EST_QUERY.TRAVELFRDT, EST_QUERY.TRAVELTODT, EST_QUERY.TRAVELORIGLOC, EST_QUERY.PATIENTPHYSNM, EST_QUERY.PATIENTPHYSTELNO, EST_QUERY.PROVREFNO1, EST_QUERY.PROVRATING1, EST_QUERY.PROVREFNO2, EST_QUERY.PROVRATING2, EST_QUERY.PROVREFNO3, EST_QUERY.PROVRATING3, NVL(EST_QUERY.PROVNM, PROVIDER.LONG_NAME)PROVNM, EST_QUERY.PHYSNM, EST_QUERY.PROVTELNO, EST_QUERY.PROVHPNO, EST_QUERY.PROVEMAIL, EST_QUERY.PROVFAXNO, EST_QUERY.PROVCITY, EST_QUERY.PROVPOSTCD, EST_QUERY.PROVCTRYCD, EST_QUERY.PROVSTATECD, EST_QUERY.MEDICALCOMPLAINT, EST_QUERY.RESIDENCE, EST_QUERY.SPEAKTOMEDICALSTAFF, EST_
QUERY.TRANSPORTREQ, EST_QUERY.PREFERPHYS, EST_QUERY.SAWPHYSNM, EST_QUERY.SAWPHYSTELNO, EST_QUERY.SAWPHYSLOC, EST_QUERY.SAWPHYSNMREQFAX, EST_QUERY.DEATHDT, EST_QUERY.PATIENTCURRLOC, EST_QUERY.PATIENTGENDER, EST_QUERY.PATIENTBIRTHPLC, EST_QUERY.PATIENTNAT, EST_QUERY.PATIENTRACE, EST_QUERY.PATIENTMARSTS, EST_QUERY.PATIENTVETERAN, EST_QUERY.SPOUSENM, EST_QUERY.OCCUPATION, EST_QUERY.BIZTYP, EST_QUERY.EDULVL, EST_QUERY.PATIENTFATHERNM, EST_QUERY.PATIENTMOTHERNM, EST_QUERY.DISPOSEREMAINS, EST_QUERY.DISPOSEDT, EST_QUERY.SENDFNRNM, EST_QUERY.SENDFNRADDR, EST_QUERY.SENDFNRCITY, EST_QUERY.SENDFNRPOSTCD, EST_QUERY.SENDFNRCTRYCD, EST_QUERY.SENDFNRSTATECD, EST_QUERY.SENDFNRTELNO, EST_QUERY.SENDFNRFAXNO, EST_QUERY.SENDFNRCONTACT, EST_QUERY.RCVFNRNM, EST_QUERY.RCVFNRADDR, EST_QUERY.RCVFNRCITY, EST_QUERY.RCVFNRPOSTCD, EST_QUERY.RCVFNRCTRYCD, EST_QUERY.RCVFNRSTATECD, EST_QUERY.RCVFNRTELNO, EST_QUERY.RCVFNRFAXNO, EST_QUERY.RCVFNRCONTACT, EST_QUERYACT.ACTNO, EST_QUERYACT.INSBY, EST_QUERYACT.INSDT, EST_QUERYACT.UPDBY, EST_QUERYACT.UPDDT, EST_QUERYACT.QUERYNO, EST_QUERYACT.QUERYSTS, EST_QUERYACT.ASGDT, EST_QUERYACT.ASGBY, EST_QUERYACT.ASGTO, EST_QUERYACT.ASGREM, EST_QUERYACT.ACTDT, EST_QUERYACT.ACTREM , PAYOR.LONG_NAME PAYORNM, CORPORATE.LONG_NAME CORPNM, PROVIDER.LONG_NAME PROVNM, SYC_REFCD.FDESC||' ('||SYC_REFCD.REFCD||')' QUERYCATG, CORPORATE_BRANCH.LONG_NAME BRANNM, EST_QUERY.QUERYGRP FROM EST_QUERY, EST_QUERYACT, SYC_REFCD, PAYOR, CORPORATE, CORPORATE_BRANCH , PROVIDER WHERE EST_QUERY
.LASTACTNO=EST_QUERYACT.ACTNO(+) AND EST_QUERY.QUERYCATG=SYC_REFCD.REFCD AND SYC_REFCD.MODID='ES' AND SYC_REFCD.REFGRP='QUERYCATG' AND EST_QUERY.PAYORCD= PAYOR.PAYOR_CODE(+) AND EST_QUERY.CORPCD= CORPORATE.CORP_CODE(+) AND EST_QUERY.PROVIDERCD= PROVIDER.PROVIDER_CODE(+) AND CORPORATE.CORP_CODE=CORPORATE_BRANCH.CORP_CODE(+) AND EST_QUERY.AUTHLVL <= :1 AND EST_QUERY.QUERYGRP IN ('MB', 'MA', 'MS') AND (EST_QUERY.QUERYBY LIKE :2 OR EST_QUERY.CARDNO IN (SELECT CDB.CARD_NO FROM CARD CDA, CARD CDB WHERE CDA.MEMBER_CONTROL_NO = CDB.MEMBER_CONTROL_NO AND CDA.CARD_NO = :3) OR EST_QUERY.POLICYNO=:4 OR EST_QUERY.ICNO=:5 OR EST_QUERY.CLAIMSID=:6) AND (EST_QUERY.QUERYSTS='O' OR EST_QUERY.QUERYSTS='I' OR EST_QUERY.QUERYSTS='C') AND EST_QUERY.QUERYCATG != 'E' ORDER BY EST_QUERY.QUERYNO |