Fri Jun 13 page 1 Current SQL Minutes SID USERNAME ADDRESS SQL_TEXT Passed ---------- ------------ ---------------- -------------------------------------------------------------------------------- ---------- 353 CDSVZWACC 000000039F6C2E30 SELECT TXN.EVENTID, TXN.CARRIERID, TXN.PRIMARY_CARRIER_NAME, TXN 1012.5 .ADS_NAME, TXN.SID, TXN.NEWSID, TXN.MANUFACTURER, TXN.MFG_PARTNO , TXN.MFG_PARTNAME, TXN.PC_PARTNO, TXN.PC_PARTNAME, TXN.ITEM_NAM E, TXN.LOCAL_TIME, TXN.GMT, TXN.TYPE, TXN.METHOD, TXN.BASIS, TXN .VALUE, TXN.PRICE, TXN.LANGUAGE, TXN.API, TXN.CURRENCY, TXN.DAP, TXN.ADJUSTMENT_REASON, TXN.ADJUSTMENT_DESCRIPTION, TXN.ADJUSTME NT_DAP, TXN.ADJUSTMENT_PRICE, TXN.ADJUSTMENT_EVENTID, TXN.RESTRI CT_FLAG, TXN.ADS_TYPE, TXN.PREPAID_FLAG, TXN.QCINC_FLAG, TXN.EXT _COUNT, TXN.DAP_CURRENCY, TXN.VERSION, TXN.STATUS, TXN.ITEMID, T XN.PLATFORMID, TXN.BILLING_LEVEL, TXN.PC_DISPLAY_NAME, TXN.MFG_D ISPLAY_NAME, TXN.ITEM_LIST_NAME, TXN.COMPLETE_FLAG, TXN.HWID, TX N.BILL_FLAG, TXN.LD, TXN.CAN, TXN.PROCESS_DATA, TXN.PRICE_TYPE, TXN.PRICE_TYPE_NAME, TXN.TXN_SOURCE_NAME, TXN.DATE_RECEIVED, TXN .ERRORCODE, TXN.DYNAMIC_ERRORMSG, TXN.SUBSTART_BILLDATE, TXN.SUB END_BILLDATE, TXN.CUSTOMERID, TXN.CUSTOMERTYPE, TXN.SOURCE_TYPE, TXN.APPTYPE, TXN.SUBTYPE, TXN.BGID, TXN.PRIV_LEVEL, TXN.NODE_ID , TXN.ITEM_TYPE, TXN.MIME_TYPE, TXN.DATE_CREATED, TXN.CREATED_BY , TXN.DATE_MODIFIED, TXN.MODIFIED_BY FROM TXN WHERE TXN.PRIMARY_ CARRIER_NAME='Verizon' AND rownum <= 500 AND date_created > sys date-90 AND TXN.SID='310004402029071' ORDER BY TXN.DATE_CREATED DESC ------------------------------------------------------------------------------------ Minutes SID USERNAME ADDRESS SQL_TEXT Passed ---------- ------------ ---------------- -------------------------------------------------------------------------------- ---------- 1444 CDSVZWACC 00000003BED859A8 SELECT TXN.EVENTID, TXN.CARRIERID, TXN.PRIMARY_CARRIER_NAME, TXN 1301.43 .ADS_NAME, TXN.SID, TXN.NEWSID, TXN.MANUFACTURER, TXN.MFG_PARTNO , TXN.MFG_PARTNAME, TXN.PC_PARTNO, TXN.PC_PARTNAME, TXN.ITEM_NAM E, TXN.LOCAL_TIME, TXN.GMT, TXN.TYPE, TXN.METHOD, TXN.BASIS, TXN .VALUE, TXN.PRICE, TXN.LANGUAGE, TXN.API, TXN.CURRENCY, TXN.DAP, TXN.ADJUSTMENT_REASON, TXN.ADJUSTMENT_DESCRIPTION, TXN.ADJUSTME NT_DAP, TXN.ADJUSTMENT_PRICE, TXN.ADJUSTMENT_EVENTID, TXN.RESTRI CT_FLAG, TXN.ADS_TYPE, TXN.PREPAID_FLAG, TXN.QCINC_FLAG, TXN.EXT _COUNT, TXN.DAP_CURRENCY, TXN.VERSION, TXN.STATUS, TXN.ITEMID, T XN.PLATFORMID, TXN.BILLING_LEVEL, TXN.PC_DISPLAY_NAME, TXN.MFG_D ISPLAY_NAME, TXN.ITEM_LIST_NAME, TXN.COMPLETE_FLAG, TXN.HWID, TX N.BILL_FLAG, TXN.LD, TXN.CAN, TXN.PROCESS_DATA, TXN.PRICE_TYPE, TXN.PRICE_TYPE_NAME, TXN.TXN_SOURCE_NAME, TXN.DATE_RECEIVED, TXN .ERRORCODE, TXN.DYNAMIC_ERRORMSG, TXN.SUBSTART_BILLDATE, TXN.SUB END_BILLDATE, TXN.CUSTOMERID, TXN.CUSTOMERTYPE, TXN.SOURCE_TYPE, TXN.APPTYPE, TXN.SUBTYPE, TXN.BGID, TXN.PRIV_LEVEL, TXN.NODE_ID , TXN.ITEM_TYPE, TXN.MIME_TYPE, TXN.DATE_CREATED, TXN.CREATED_BY , TXN.DATE_MODIFIED, TXN.MODIFIED_BY FROM TXN WHERE TXN.PRIMARY_ CARRIER_NAME='Verizon' AND rownum <= 500 AND date_created > sys date-90 AND TXN.SID='310003012825722' ORDER BY TXN.DATE_CREATED DESC ===================================================================================================================== Minutes SID USERNAME ADDRESS SQL_TEXT Passed ---------- ------------ ---------------- -------------------------------------------------------------------------------- ---------- 493 CDSVZWACC 00000003B27386E0 SELECT TXN.EVENTID, TXN.CARRIERID, TXN.PRIMARY_CARRIER_NAME, TXN 1276.82 .ADS_NAME, TXN.SID, TXN.NEWSID, TXN.MANUFACTURER, TXN.MFG_PARTNO , TXN.MFG_PARTNAME, TXN.PC_PARTNO, TXN.PC_PARTNAME, TXN.ITEM_NAM E, TXN.LOCAL_TIME, TXN.GMT, TXN.TYPE, TXN.METHOD, TXN.BASIS, TXN .VALUE, TXN.PRICE, TXN.LANGUAGE, TXN.API, TXN.CURRENCY, TXN.DAP, TXN.ADJUSTMENT_REASON, TXN.ADJUSTMENT_DESCRIPTION, TXN.ADJUSTME NT_DAP, TXN.ADJUSTMENT_PRICE, TXN.ADJUSTMENT_EVENTID, TXN.RESTRI CT_FLAG, TXN.ADS_TYPE, TXN.PREPAID_FLAG, TXN.QCINC_FLAG, TXN.EXT _COUNT, TXN.DAP_CURRENCY, TXN.VERSION, TXN.STATUS, TXN.ITEMID, T XN.PLATFORMID, TXN.BILLING_LEVEL, TXN.PC_DISPLAY_NAME, TXN.MFG_D ISPLAY_NAME, TXN.ITEM_LIST_NAME, TXN.COMPLETE_FLAG, TXN.HWID, TX N.BILL_FLAG, TXN.LD, TXN.CAN, TXN.PROCESS_DATA, TXN.PRICE_TYPE, TXN.PRICE_TYPE_NAME, TXN.TXN_SOURCE_NAME, TXN.DATE_RECEIVED, TXN .ERRORCODE, TXN.DYNAMIC_ERRORMSG, TXN.SUBSTART_BILLDATE, TXN.SUB END_BILLDATE, TXN.CUSTOMERID, TXN.CUSTOMERTYPE, TXN.SOURCE_TYPE, TXN.APPTYPE, TXN.SUBTYPE, TXN.BGID, TXN.PRIV_LEVEL, TXN.NODE_ID , TXN.ITEM_TYPE, TXN.MIME_TYPE, TXN.DATE_CREATED, TXN.CREATED_BY , TXN.DATE_MODIFIED, TXN.MODIFIED_BY FROM TXN WHERE TXN.PRIMARY_ CARRIER_NAME='Verizon' AND rownum <= 500 AND date_created > sys date-90 AND TXN.SID='310008654669917' ORDER BY TXN.DATE_CREATED DESC ====================================================================================================================================== Minutes SID USERNAME ADDRESS SQL_TEXT Passed ---------- ------------ ---------------- -------------------------------------------------------------------------------- ---------- 927 CDSVZWACC 00000003BED859A8 SELECT TXN.EVENTID, TXN.CARRIERID, TXN.PRIMARY_CARRIER_NAME, TXN 1300.72 .ADS_NAME, TXN.SID, TXN.NEWSID, TXN.MANUFACTURER, TXN.MFG_PARTNO , TXN.MFG_PARTNAME, TXN.PC_PARTNO, TXN.PC_PARTNAME, TXN.ITEM_NAM E, TXN.LOCAL_TIME, TXN.GMT, TXN.TYPE, TXN.METHOD, TXN.BASIS, TXN .VALUE, TXN.PRICE, TXN.LANGUAGE, TXN.API, TXN.CURRENCY, TXN.DAP, TXN.ADJUSTMENT_REASON, TXN.ADJUSTMENT_DESCRIPTION, TXN.ADJUSTME NT_DAP, TXN.ADJUSTMENT_PRICE, TXN.ADJUSTMENT_EVENTID, TXN.RESTRI CT_FLAG, TXN.ADS_TYPE, TXN.PREPAID_FLAG, TXN.QCINC_FLAG, TXN.EXT _COUNT, TXN.DAP_CURRENCY, TXN.VERSION, TXN.STATUS, TXN.ITEMID, T XN.PLATFORMID, TXN.BILLING_LEVEL, TXN.PC_DISPLAY_NAME, TXN.MFG_D ISPLAY_NAME, TXN.ITEM_LIST_NAME, TXN.COMPLETE_FLAG, TXN.HWID, TX N.BILL_FLAG, TXN.LD, TXN.CAN, TXN.PROCESS_DATA, TXN.PRICE_TYPE, TXN.PRICE_TYPE_NAME, TXN.TXN_SOURCE_NAME, TXN.DATE_RECEIVED, TXN .ERRORCODE, TXN.DYNAMIC_ERRORMSG, TXN.SUBSTART_BILLDATE, TXN.SUB END_BILLDATE, TXN.CUSTOMERID, TXN.CUSTOMERTYPE, TXN.SOURCE_TYPE, TXN.APPTYPE, TXN.SUBTYPE, TXN.BGID, TXN.PRIV_LEVEL, TXN.NODE_ID , TXN.ITEM_TYPE, TXN.MIME_TYPE, TXN.DATE_CREATED, TXN.CREATED_BY , TXN.DATE_MODIFIED, TXN.MODIFIED_BY FROM TXN WHERE TXN.PRIMARY_ CARRIER_NAME='Verizon' AND rownum <= 500 AND date_created > sys date-90 AND TXN.SID='310003012825722' ORDER BY TXN.DATE_CREATED DESC 21 rows selected. ====================================================================================================================================== Current SQL Minutes SID USERNAME ADDRESS SQL_TEXT Passed ---------- ------------ ---------------- -------------------------------------------------------------------------------- ---------- 1638 CDSVZWACC 00000003B27386E0 SELECT TXN.EVENTID, TXN.CARRIERID, TXN.PRIMARY_CARRIER_NAME, TXN 1279.27 .ADS_NAME, TXN.SID, TXN.NEWSID, TXN.MANUFACTURER, TXN.MFG_PARTNO , TXN.MFG_PARTNAME, TXN.PC_PARTNO, TXN.PC_PARTNAME, TXN.ITEM_NAM E, TXN.LOCAL_TIME, TXN.GMT, TXN.TYPE, TXN.METHOD, TXN.BASIS, TXN .VALUE, TXN.PRICE, TXN.LANGUAGE, TXN.API, TXN.CURRENCY, TXN.DAP, TXN.ADJUSTMENT_REASON, TXN.ADJUSTMENT_DESCRIPTION, TXN.ADJUSTME NT_DAP, TXN.ADJUSTMENT_PRICE, TXN.ADJUSTMENT_EVENTID, TXN.RESTRI CT_FLAG, TXN.ADS_TYPE, TXN.PREPAID_FLAG, TXN.QCINC_FLAG, TXN.EXT _COUNT, TXN.DAP_CURRENCY, TXN.VERSION, TXN.STATUS, TXN.ITEMID, T XN.PLATFORMID, TXN.BILLING_LEVEL, TXN.PC_DISPLAY_NAME, TXN.MFG_D ISPLAY_NAME, TXN.ITEM_LIST_NAME, TXN.COMPLETE_FLAG, TXN.HWID, TX N.BILL_FLAG, TXN.LD, TXN.CAN, TXN.PROCESS_DATA, TXN.PRICE_TYPE, TXN.PRICE_TYPE_NAME, TXN.TXN_SOURCE_NAME, TXN.DATE_RECEIVED, TXN .ERRORCODE, TXN.DYNAMIC_ERRORMSG, TXN.SUBSTART_BILLDATE, TXN.SUB END_BILLDATE, TXN.CUSTOMERID, TXN.CUSTOMERTYPE, TXN.SOURCE_TYPE, TXN.APPTYPE, TXN.SUBTYPE, TXN.BGID, TXN.PRIV_LEVEL, TXN.NODE_ID , TXN.ITEM_TYPE, TXN.MIME_TYPE, TXN.DATE_CREATED, TXN.CREATED_BY , TXN.DATE_MODIFIED, TXN.MODIFIED_BY FROM TXN WHERE TXN.PRIMARY_ CARRIER_NAME='Verizon' AND rownum <= 500 AND date_created > sys date-90 AND TXN.SID='310008654669917' ORDER BY TXN.DATE_CREATED DESC ====================================================================================================================================== Current SQL Minutes SID USERNAME ADDRESS SQL_TEXT Passed ---------- ------------ ---------------- -------------------------------------------------------------------------------- ---------- 465 CDSVZWACC 00000003BED859A8 SELECT TXN.EVENTID, TXN.CARRIERID, TXN.PRIMARY_CARRIER_NAME, TXN 1301.63 .ADS_NAME, TXN.SID, TXN.NEWSID, TXN.MANUFACTURER, TXN.MFG_PARTNO , TXN.MFG_PARTNAME, TXN.PC_PARTNO, TXN.PC_PARTNAME, TXN.ITEM_NAM E, TXN.LOCAL_TIME, TXN.GMT, TXN.TYPE, TXN.METHOD, TXN.BASIS, TXN .VALUE, TXN.PRICE, TXN.LANGUAGE, TXN.API, TXN.CURRENCY, TXN.DAP, TXN.ADJUSTMENT_REASON, TXN.ADJUSTMENT_DESCRIPTION, TXN.ADJUSTME NT_DAP, TXN.ADJUSTMENT_PRICE, TXN.ADJUSTMENT_EVENTID, TXN.RESTRI CT_FLAG, TXN.ADS_TYPE, TXN.PREPAID_FLAG, TXN.QCINC_FLAG, TXN.EXT _COUNT, TXN.DAP_CURRENCY, TXN.VERSION, TXN.STATUS, TXN.ITEMID, T XN.PLATFORMID, TXN.BILLING_LEVEL, TXN.PC_DISPLAY_NAME, TXN.MFG_D ISPLAY_NAME, TXN.ITEM_LIST_NAME, TXN.COMPLETE_FLAG, TXN.HWID, TX N.BILL_FLAG, TXN.LD, TXN.CAN, TXN.PROCESS_DATA, TXN.PRICE_TYPE, TXN.PRICE_TYPE_NAME, TXN.TXN_SOURCE_NAME, TXN.DATE_RECEIVED, TXN .ERRORCODE, TXN.DYNAMIC_ERRORMSG, TXN.SUBSTART_BILLDATE, TXN.SUB END_BILLDATE, TXN.CUSTOMERID, TXN.CUSTOMERTYPE, TXN.SOURCE_TYPE, TXN.APPTYPE, TXN.SUBTYPE, TXN.BGID, TXN.PRIV_LEVEL, TXN.NODE_ID , TXN.ITEM_TYPE, TXN.MIME_TYPE, TXN.DATE_CREATED, TXN.CREATED_BY , TXN.DATE_MODIFIED, TXN.MODIFIED_BY FROM TXN WHERE TXN.PRIMARY_ CARRIER_NAME='Verizon' AND rownum <= 500 AND date_created > sys date-90 AND TXN.SID='310003012825722' ORDER BY TXN.DATE_CREATED DESC ======================================================================================================================================