1
2018-10-13
1

<< Back to Classifieds Listing

Driver - National Dedicated Truck Driver - Class A CDL - Greensboro NC

SELECT DISTINCT SUBSTR(ODSS.DRIVER_GID,5) AS DRV_NUM ,SUBSTR(ODIP.INVOLVED_PARTY_CONTACT_GID,5) AS DBL_ID ,OISR.SHIPMENT_REFNUM_VALUE AS REQ_START ,OISR2.SHIPMENT_REFNUM_VALUE AS REQ_END ,OIS.I_TRANSACTION_NO AS TE_NUM ,OIS.INSERT_DATE AS INSERT_DATE ,ODCE.EVENT_START_TIME ,ROUND((TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'))*24,2) AS FULL_DUR ,CASE WHEN (TRUNC(TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS')) < SYSDATE) THEN 'TRUE' ELSE 'FALSE' END AS START_DATE_IN_PAST ,CASE WHEN OISR.SHIPMENT_REFNUM_VALUE BETWEEN '2016-12-23 17:00:00' AND '2016-12-26 17:00:00' THEN CASE WHEN TO_DATE(ODCE.EVENT_START_TIME) - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') < 5 AND TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(ODCE.EVENT_START_TIME) < 5 AND CAL_EVENT_TYPE_GID IN ('SNI.TL HOMERUN','SNI.TL TAH','SNI.DRIVER PAID TIME OFF','SNI.TL MISSED TAH','SNI.TL GTAH','SNI.TIME AT HOME') THEN 'TRUE' ELSE 'FALSE' END ELSE CASE WHEN TO_DATE(ODCE.EVENT_START_TIME) - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') < 5 AND TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(ODCE.EVENT_START_TIME) < 5 AND CAL_EVENT_TYPE_GID IN ('SNI.TL HOMERUN','SNI.TL TAH','SNI.DRIVER PAID TIME OFF','SNI.TL MISSED TAH','SNI.TL GTAH','SNI.TIME AT HOME') THEN 'TRUE' ELSE 'FALSE' END END AS EVENT_EXISTS ,CASE WHEN OISR.SHIPMENT_REFNUM_VALUE BETWEEN '2016-12-23 17:00:00' AND '2016-12-26 17:00:00' THEN CASE WHEN (TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'))*24 > 63.00 OR TO_CHAR(TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') NOT IN ('6','7') OR TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'HH24:MI') > '08:01' THEN 'TRUE' ELSE 'FALSE' END ELSE CASE WHEN (TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'))*24 > 63.00 OR TO_CHAR(TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') NOT IN ('6','7') OR (TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') = '1' AND TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'HH24:MI') > '11:01') OR (TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') = '2' AND TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'HH24:MI') > '08:01') THEN 'TRUE' ELSE 'FALSE' END END AS OVER_42_HOURS ,CASE WHEN TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') > (SYSDATE + 3.0416) THEN 'FALSE' ELSE 'TRUE' END AS INSUFFICIENT_NOTICE FROM ODS.O_DRIVER_SPECIAL_SERVICE ODSS INNER JOIN ODS.XO_O_DRIVER XOD ON ODSS.DRIVER_GID = XOD.DRV_GID INNER JOIN ODS.O_DRIVER OD ON ODSS.DRIVER_GID = OD.DRIVER_GID INNER JOIN ODS.O_LOCATION OL ON OD.SIGHTING_LOCATION_GID = OL.LOCATION_GID INNER JOIN ODS.O_DRIVER_REMARK ODR ON ODSS.DRIVER_GID = ODR.DRIVER_GID INNER JOIN ODS.O_DRIVER_REFNUM ODREF ON ODSS.DRIVER_GID = ODREF.DRIVER_GID AND ODREF.DRIVER_REFNUM_QUAL_GID = 'SNI.COST ALLOCATION BUSINESS UNIT CODE' INNER JOIN ODS.O_DRIVER_INV_PARTY ODIP ON ODSS.DRIVER_GID = ODIP.DRIVER_GID AND ODIP.INVOLVED_PARTY_QUAL_GID = 'SNI.DRIVER MANAGER' INNER JOIN ODS.O_IE_SHIPMENTSTATUS OIS ON ODSS.DRIVER_GID = OIS.DRIVER_GID INNER JOIN ODS.O_IE_SHIPMENT_REFNUM OISR ON OIS.I_TRANSACTION_NO = OISR.I_TRANSACTION_NO AND OISR.SHIPMENT_REFNUM_QUAL_GID = 'SNI.TAH START DTTM' INNER JOIN ODS.O_IE_SHIPMENT_REFNUM OISR2 ON OIS.I_TRANSACTION_NO = OISR2.I_TRANSACTION_NO AND OISR2.SHIPMENT_REFNUM_QUAL_GID = 'SNI.TAH END DTTM' INNER JOIN ODS.O_DRIVER_CALENDAR_EVENT ODCE ON ODSS.DRIVER_GID = ODCE.DRIVER_GID WHERE XOD.EXE_SUB_TYP_CD <> 'IC CHOICE' AND XOD.LOB_CD = 'LOB_VAN TL' AND OD.END_DATE IS NULL AND XOD.DRV_DIV_NAM <> 'NOT ASSIGNED' AND (ODR.REMARK_QUAL_GID = 'SNI.WORK CONFIGURATION' OR ODR.REMARK_QUAL_GID = 'SNI.SEGMENT CODE') AND ODREF.DRIVER_REFNUM_VALUE IN ('19622','19624','19646','19648','19672','19674','19652','19654','19412','19414','19432','19434','19722','19715','19422','19424','19562','19578','19580','19564','19542','19544','19572','19574','19502','19504','19512','19514','19532','19534','19442','19444','19552','19554') AND ODR.REMARK_TEXT = '5.5 X 1.5' AND OIS.STATUS_CODE_GID = 'SNI.DRIVER TIME AT HOME' AND OIS.OB_REFNUM_VALUE LIKE 'TAH % REQUIRES APPROVAL' AND OIS.INSERT_DATE > (SYSDATE - 7) UNION SELECT DISTINCT SUBSTR(ODSS.DRIVER_GID,5) AS DRV_NUM ,SUBSTR(ODIP.INVOLVED_PARTY_CONTACT_GID,5) AS DBL_ID ,OISR.SHIPMENT_REFNUM_VALUE AS REQ_START ,OISR2.SHIPMENT_REFNUM_VALUE AS REQ_END ,OIS.I_TRANSACTION_NO AS TE_NUM ,OIS.INSERT_DATE AS INSERT_DATE ,ODCE.EVENT_START_TIME ,ROUND((TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'))*24,2) AS FULL_DUR ,CASE WHEN (TRUNC(TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS')) < SYSDATE) THEN 'TRUE' ELSE 'FALSE' END AS START_DATE_IN_PAST ,CASE WHEN OISR.SHIPMENT_REFNUM_VALUE BETWEEN '2016-12-23 17:00:00' AND '2016-12-26 17:00:00' THEN CASE WHEN TO_DATE(ODCE.EVENT_START_TIME) - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') < 5 AND TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(ODCE.EVENT_START_TIME) < 5 AND CAL_EVENT_TYPE_GID IN ('SNI.TL HOMERUN','SNI.TL TAH','SNI.DRIVER PAID TIME OFF','SNI.TL MISSED TAH','SNI.TL GTAH','SNI.TIME AT HOME') THEN 'TRUE' ELSE 'FALSE' END ELSE CASE WHEN TO_DATE(ODCE.EVENT_START_TIME) - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') < 5 AND TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(ODCE.EVENT_START_TIME) < 5 AND CAL_EVENT_TYPE_GID IN ('SNI.TL HOMERUN','SNI.TL TAH','SNI.DRIVER PAID TIME OFF','SNI.TL MISSED TAH','SNI.TL GTAH','SNI.TIME AT HOME') THEN 'TRUE' ELSE 'FALSE' END END AS EVENT_EXISTS ,CASE WHEN OISR.SHIPMENT_REFNUM_VALUE BETWEEN '2016-12-23 17:00:00' AND '2016-12-26 17:00:00' THEN CASE WHEN (TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'))*24 > 63.00 OR TO_CHAR(TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') NOT IN ('6','7') OR TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'HH24:MI') > '08:01' THEN 'TRUE' ELSE 'FALSE' END ELSE CASE WHEN (TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'))*24 > 63.17 OR TO_CHAR(TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') NOT IN ('5','6','7') OR TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') NOT IN ('1','2') OR TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'HH24:MI') > '08:01' THEN 'TRUE' ELSE 'FALSE' END END AS OVER_42_HOURS ,CASE WHEN TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') > (SYSDATE + 3.0416) THEN 'FALSE' ELSE 'TRUE' END AS INSUFFICIENT_NOTICE FROM ODS.O_DRIVER_SPECIAL_SERVICE ODSS INNER JOIN ODS.XO_O_DRIVER XOD ON ODSS.DRIVER_GID = XOD.DRV_GID INNER JOIN ODS.O_DRIVER OD ON ODSS.DRIVER_GID = OD.DRIVER_GID INNER JOIN ODS.O_LOCATION OL ON OD.SIGHTING_LOCATION_GID = OL.LOCATION_GID INNER JOIN ODS.O_DRIVER_REMARK ODR ON ODSS.DRIVER_GID = ODR.DRIVER_GID INNER JOIN ODS.O_DRIVER_REFNUM ODREF ON ODSS.DRIVER_GID = ODREF.DRIVER_GID AND ODREF.DRIVER_REFNUM_QUAL_GID = 'SNI.COST ALLOCATION BUSINESS UNIT CODE' INNER JOIN ODS.O_DRIVER_INV_PARTY ODIP ON ODSS.DRIVER_GID = ODIP.DRIVER_GID AND ODIP.INVOLVED_PARTY_QUAL_GID = 'SNI.DRIVER MANAGER' INNER JOIN ODS.O_IE_SHIPMENTSTATUS OIS ON ODSS.DRIVER_GID = OIS.DRIVER_GID INNER JOIN ODS.O_IE_SHIPMENT_REFNUM OISR ON OIS.I_TRANSACTION_NO = OISR.I_TRANSACTION_NO AND OISR.SHIPMENT_REFNUM_QUAL_GID = 'SNI.TAH START DTTM' INNER JOIN ODS.O_IE_SHIPMENT_REFNUM OISR2 ON OIS.I_TRANSACTION_NO = OISR2.I_TRANSACTION_NO AND OISR2.SHIPMENT_REFNUM_QUAL_GID = 'SNI.TAH END DTTM' INNER JOIN ODS.O_DRIVER_CALENDAR_EVENT ODCE ON ODSS.DRIVER_GID = ODCE.DRIVER_GID WHERE XOD.EXE_SUB_TYP_CD <> 'IC CHOICE' AND XOD.LOB_CD = 'LOB_VAN TL' AND OD.END_DATE IS NULL AND XOD.DRV_DIV_NAM <> 'NOT ASSIGNED' AND (ODR.REMARK_QUAL_GID = 'SNI.WORK CONFIGURATION' OR ODR.REMARK_QUAL_GID = 'SNI.SEGMENT CODE') AND ODREF.DRIVER_REFNUM_VALUE IN ('19672','19674','19652','19654','19412','19414','19722','19715','19562','19578','19580','19564','19512','19514','19532','19534','19432','19434','19422','19424','19542','19544','19572','19574','19502','19504','19442','19444','19622','19624','19646','19648','19552','19554') AND ODR.REMARK_TEXT = '5 X 2' AND OIS.STATUS_CODE_GID = 'SNI.DRIVER TIME AT HOME' AND OIS.OB_REFNUM_VALUE LIKE 'TAH % REQUIRES APPROVAL' AND OIS.INSERT_DATE > (SYSDATE - 7) UNION SELECT DISTINCT SUBSTR(ODSS.DRIVER_GID,5) AS DRV_NUM ,SUBSTR(ODIP.INVOLVED_PARTY_CONTACT_GID,5) AS DBL_ID ,OISR.SHIPMENT_REFNUM_VALUE AS REQ_START ,OISR2.SHIPMENT_REFNUM_VALUE AS REQ_END ,OIS.I_TRANSACTION_NO AS TE_NUM ,OIS.INSERT_DATE AS INSERT_DATE ,ODCE.EVENT_START_TIME ,ROUND((TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'))*24,2) AS FULL_DUR ,CASE WHEN (TRUNC(TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS')) < SYSDATE) THEN 'TRUE' ELSE 'FALSE' END AS START_DATE_IN_PAST ,CASE WHEN OISR.SHIPMENT_REFNUM_VALUE BETWEEN '2016-12-23 17:00:00' AND '2016-12-26 17:00:00' THEN CASE WHEN TO_DATE(ODCE.EVENT_START_TIME) - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') < 5 AND TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(ODCE.EVENT_START_TIME) < 5 AND CAL_EVENT_TYPE_GID IN ('SNI.TL HOMERUN','SNI.TL TAH','SNI.DRIVER PAID TIME OFF','SNI.TL MISSED TAH','SNI.TL GTAH','SNI.TIME AT HOME') THEN 'TRUE' ELSE 'FALSE' END ELSE CASE WHEN TO_DATE(ODCE.EVENT_START_TIME) - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') < 5 AND TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(ODCE.EVENT_START_TIME) < 5 AND CAL_EVENT_TYPE_GID IN ('SNI.TL HOMERUN','SNI.TL TAH','SNI.DRIVER PAID TIME OFF','SNI.TL MISSED TAH','SNI.TL GTAH','SNI.TIME AT HOME') THEN 'TRUE' ELSE 'FALSE' END END AS EVENT_EXISTS ,CASE WHEN OISR.SHIPMENT_REFNUM_VALUE BETWEEN '2016-12-23 17:00:00' AND '2016-12-26 17:00:00' THEN CASE WHEN (TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'))*24 > 63.00 OR TO_CHAR(TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') NOT IN ('6','7') OR TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'HH24:MI') > '08:01' THEN 'TRUE' ELSE 'FALSE' END ELSE CASE WHEN (TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'))*24 > 63.17 THEN 'TRUE' ELSE 'FALSE' END END AS OVER_42_HOURS ,CASE WHEN TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') > (SYSDATE + 3.0416) THEN 'FALSE' ELSE 'TRUE' END AS INSUFFICIENT_NOTICE FROM ODS.O_DRIVER_SPECIAL_SERVICE ODSS INNER JOIN ODS.XO_O_DRIVER XOD ON ODSS.DRIVER_GID = XOD.DRV_GID INNER JOIN ODS.O_DRIVER OD ON ODSS.DRIVER_GID = OD.DRIVER_GID INNER JOIN ODS.O_LOCATION OL ON OD.SIGHTING_LOCATION_GID = OL.LOCATION_GID INNER JOIN ODS.O_DRIVER_REMARK ODR ON ODSS.DRIVER_GID = ODR.DRIVER_GID INNER JOIN ODS.O_DRIVER_REFNUM ODREF ON ODSS.DRIVER_GID = ODREF.DRIVER_GID AND ODREF.DRIVER_REFNUM_QUAL_GID = 'SNI.COST ALLOCATION BUSINESS UNIT CODE' INNER JOIN ODS.O_DRIVER_INV_PARTY ODIP ON ODSS.DRIVER_GID = ODIP.DRIVER_GID AND ODIP.INVOLVED_PARTY_QUAL_GID = 'SNI.DRIVER MANAGER' INNER JOIN ODS.O_IE_SHIPMENTSTATUS OIS ON ODSS.DRIVER_GID = OIS.DRIVER_GID INNER JOIN ODS.O_IE_SHIPMENT_REFNUM OISR ON OIS.I_TRANSACTION_NO = OISR.I_TRANSACTION_NO AND OISR.SHIPMENT_REFNUM_QUAL_GID = 'SNI.TAH START DTTM' INNER JOIN ODS.O_IE_SHIPMENT_REFNUM OISR2 ON OIS.I_TRANSACTION_NO = OISR2.I_TRANSACTION_NO AND OISR2.SHIPMENT_REFNUM_QUAL_GID = 'SNI.TAH END DTTM' INNER JOIN ODS.O_DRIVER_CALENDAR_EVENT ODCE ON ODSS.DRIVER_GID = ODCE.DRIVER_GID WHERE XOD.EXE_SUB_TYP_CD <> 'IC CHOICE' AND XOD.LOB_CD = 'LOB_VAN TL' AND OD.END_DATE IS NULL AND XOD.DRV_DIV_NAM <> 'NOT ASSIGNED' AND (ODR.REMARK_QUAL_GID = 'SNI.WORK CONFIGURATION' OR ODR.REMARK_QUAL_GID = 'SNI.SEGMENT CODE') AND ODREF.DRIVER_REFNUM_VALUE IN ('19622','19624','19646','19648','19672','19674','19652','19654','19412','19414','19722','19715','19562','19578','19580','19564','19512','19514','19532','19534','19622','19624','19646','19648','19552','19554') AND ODR.REMARK_TEXT = '7 X 2' AND OIS.STATUS_CODE_GID = 'SNI.DRIVER TIME AT HOME' AND OIS.OB_REFNUM_VALUE LIKE 'TAH % REQUIRES APPROVAL' AND OIS.INSERT_DATE > (SYSDATE - 7) UNION SELECT DISTINCT SUBSTR(ODSS.DRIVER_GID,5) AS DRV_NUM ,SUBSTR(ODIP.INVOLVED_PARTY_CONTACT_GID,5) AS DBL_ID ,OISR.SHIPMENT_REFNUM_VALUE AS REQ_START ,OISR2.SHIPMENT_REFNUM_VALUE AS REQ_END ,OIS.I_TRANSACTION_NO AS TE_NUM ,OIS.INSERT_DATE AS INSERT_DATE ,ODCE.EVENT_START_TIME ,ROUND((TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'))*24,2) AS FULL_DUR ,CASE WHEN (TRUNC(TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS')) < SYSDATE) THEN 'TRUE' ELSE 'FALSE' END AS START_DATE_IN_PAST ,CASE WHEN OISR.SHIPMENT_REFNUM_VALUE BETWEEN '2016-12-23 17:00:00' AND '2016-12-26 17:00:00' THEN CASE WHEN TO_DATE(ODCE.EVENT_START_TIME) - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') < 5 AND TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(ODCE.EVENT_START_TIME) < 5 AND CAL_EVENT_TYPE_GID IN ('SNI.TL HOMERUN','SNI.TL TAH','SNI.DRIVER PAID TIME OFF','SNI.TL MISSED TAH','SNI.TL GTAH','SNI.TIME AT HOME') THEN 'TRUE' ELSE 'FALSE' END ELSE CASE WHEN TO_DATE(ODCE.EVENT_START_TIME) - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') < 9 AND TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(ODCE.EVENT_START_TIME) < 9 AND CAL_EVENT_TYPE_GID IN ('SNI.TL HOMERUN','SNI.TL TAH','SNI.DRIVER PAID TIME OFF','SNI.TL MISSED TAH','SNI.TL GTAH','SNI.TIME AT HOME') THEN 'TRUE' ELSE 'FALSE' END END AS EVENT_EXISTS ,CASE WHEN OISR.SHIPMENT_REFNUM_VALUE BETWEEN '2016-12-23 17:00:00' AND '2016-12-26 17:00:00' THEN CASE WHEN (TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'))*24 > 63.00 OR TO_CHAR(TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') NOT IN ('6','7') OR TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'HH24:MI') > '08:01' THEN 'TRUE' ELSE 'FALSE' END ELSE CASE WHEN (TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'))*24 > 87.17 OR TO_CHAR(TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') NOT IN ('5','6') OR TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') NOT IN ('1','2') OR TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'HH24:MI') > '08:01' THEN 'TRUE' ELSE 'FALSE' END END AS OVER_42_HOURS ,CASE WHEN TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') > (SYSDATE + 3.0416) THEN 'FALSE' ELSE 'TRUE' END AS INSUFFICIENT_NOTICE FROM ODS.O_DRIVER_SPECIAL_SERVICE ODSS INNER JOIN ODS.XO_O_DRIVER XOD ON ODSS.DRIVER_GID = XOD.DRV_GID INNER JOIN ODS.O_DRIVER OD ON ODSS.DRIVER_GID = OD.DRIVER_GID INNER JOIN ODS.O_LOCATION OL ON OD.SIGHTING_LOCATION_GID = OL.LOCATION_GID INNER JOIN ODS.O_DRIVER_REMARK ODR ON ODSS.DRIVER_GID = ODR.DRIVER_GID INNER JOIN ODS.O_DRIVER_REFNUM ODREF ON ODSS.DRIVER_GID = ODREF.DRIVER_GID AND ODREF.DRIVER_REFNUM_QUAL_GID = 'SNI.COST ALLOCATION BUSINESS UNIT CODE' INNER JOIN ODS.O_DRIVER_INV_PARTY ODIP ON ODSS.DRIVER_GID = ODIP.DRIVER_GID AND ODIP.INVOLVED_PARTY_QUAL_GID = 'SNI.DRIVER MANAGER' INNER JOIN ODS.O_IE_SHIPMENTSTATUS OIS ON ODSS.DRIVER_GID = OIS.DRIVER_GID INNER JOIN ODS.O_IE_SHIPMENT_REFNUM OISR ON OIS.I_TRANSACTION_NO = OISR.I_TRANSACTION_NO AND OISR.SHIPMENT_REFNUM_QUAL_GID = 'SNI.TAH START DTTM' INNER JOIN ODS.O_IE_SHIPMENT_REFNUM OISR2 ON OIS.I_TRANSACTION_NO = OISR2.I_TRANSACTION_NO AND OISR2.SHIPMENT_REFNUM_QUAL_GID = 'SNI.TAH END DTTM' INNER JOIN ODS.O_DRIVER_CALENDAR_EVENT ODCE ON ODSS.DRIVER_GID = ODCE.DRIVER_GID WHERE XOD.EXE_SUB_TYP_CD <> 'IC CHOICE' AND XOD.LOB_CD = 'LOB_VAN TL' AND OD.END_DATE IS NULL AND XOD.DRV_DIV_NAM <> 'NOT ASSIGNED' AND (ODR.REMARK_QUAL_GID = 'SNI.WORK CONFIGURATION' OR ODR.REMARK_QUAL_GID = 'SNI.SEGMENT CODE') AND ODREF.DRIVER_REFNUM_VALUE IN ('19542','19544','19572','19574','19502','19504','19622','19624','19646','19648','19552','19554','19672','19674','19652','19654','19722','19715','19562','19578','19580','19564','19512','19514','19532','19534','19432','19434','19422','19424') AND ODR.REMARK_TEXT IN ('12 X 2 11 X 3','11 X 3','12 X 2','14 X 3') AND OIS.STATUS_CODE_GID = 'SNI.DRIVER TIME AT HOME' AND OIS.OB_REFNUM_VALUE LIKE 'TAH % REQUIRES APPROVAL' AND OIS.INSERT_DATE > (SYSDATE - 7) UNION SELECT DISTINCT SUBSTR(ODSS.DRIVER_GID,5) AS DRV_NUM ,SUBSTR(ODIP.INVOLVED_PARTY_CONTACT_GID,5) AS DBL_ID ,OISR.SHIPMENT_REFNUM_VALUE AS REQ_START ,OISR2.SHIPMENT_REFNUM_VALUE AS REQ_END ,OIS.I_TRANSACTION_NO AS TE_NUM ,OIS.INSERT_DATE AS INSERT_DATE ,ODCE.EVENT_START_TIME ,ROUND((TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'))*24,2) AS FULL_DUR ,CASE WHEN (TRUNC(TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS')) < SYSDATE) THEN 'TRUE' ELSE 'FALSE' END AS START_DATE_IN_PAST ,CASE WHEN OISR.SHIPMENT_REFNUM_VALUE BETWEEN '2016-12-23 17:00:00' AND '2016-12-26 17:00:00' THEN CASE WHEN TO_DATE(ODCE.EVENT_START_TIME) - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') < 5 AND TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(ODCE.EVENT_START_TIME) < 5 AND CAL_EVENT_TYPE_GID IN ('SNI.TL HOMERUN','SNI.TL TAH','SNI.DRIVER PAID TIME OFF','SNI.TL MISSED TAH','SNI.TL GTAH','SNI.TIME AT HOME') THEN 'TRUE' ELSE 'FALSE' END ELSE CASE WHEN TO_DATE(ODCE.EVENT_START_TIME) - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') < 9 AND TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(ODCE.EVENT_START_TIME) < 9 AND CAL_EVENT_TYPE_GID IN ('SNI.TL HOMERUN','SNI.TL TAH','SNI.DRIVER PAID TIME OFF','SNI.TL MISSED TAH','SNI.TL GTAH','SNI.TIME AT HOME') THEN 'TRUE' ELSE 'FALSE' END END AS EVENT_EXISTS ,CASE WHEN OISR.SHIPMENT_REFNUM_VALUE BETWEEN '2016-12-23 17:00:00' AND '2016-12-26 17:00:00' THEN CASE WHEN (TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'))*24 > 63.00 OR TO_CHAR(TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') NOT IN ('6','7') OR TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'HH24:MI') > '08:01' THEN 'TRUE' ELSE 'FALSE' END ELSE CASE WHEN (TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'))*24 > 87.17 OR TO_CHAR(TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') NOT IN ('5','6') OR TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') NOT IN ('1','2','3') OR TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'HH24:MI') > '08:01' OR (TO_CHAR(TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') = '5' AND TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') NOT IN ('1','2','7')) THEN 'TRUE' ELSE 'FALSE' END END AS OVER_42_HOURS ,CASE WHEN TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') > (SYSDATE + 3.0416) THEN 'FALSE' ELSE 'TRUE' END AS INSUFFICIENT_NOTICE FROM ODS.O_DRIVER_SPECIAL_SERVICE ODSS INNER JOIN ODS.XO_O_DRIVER XOD ON ODSS.DRIVER_GID = XOD.DRV_GID INNER JOIN ODS.O_DRIVER OD ON ODSS.DRIVER_GID = OD.DRIVER_GID INNER JOIN ODS.O_LOCATION OL ON OD.SIGHTING_LOCATION_GID = OL.LOCATION_GID INNER JOIN ODS.O_DRIVER_REMARK ODR ON ODSS.DRIVER_GID = ODR.DRIVER_GID INNER JOIN ODS.O_DRIVER_REFNUM ODREF ON ODSS.DRIVER_GID = ODREF.DRIVER_GID AND ODREF.DRIVER_REFNUM_QUAL_GID = 'SNI.COST ALLOCATION BUSINESS UNIT CODE' INNER JOIN ODS.O_DRIVER_INV_PARTY ODIP ON ODSS.DRIVER_GID = ODIP.DRIVER_GID AND ODIP.INVOLVED_PARTY_QUAL_GID = 'SNI.DRIVER MANAGER' INNER JOIN ODS.O_IE_SHIPMENTSTATUS OIS ON ODSS.DRIVER_GID = OIS.DRIVER_GID INNER JOIN ODS.O_IE_SHIPMENT_REFNUM OISR ON OIS.I_TRANSACTION_NO = OISR.I_TRANSACTION_NO AND OISR.SHIPMENT_REFNUM_QUAL_GID = 'SNI.TAH START DTTM' INNER JOIN ODS.O_IE_SHIPMENT_REFNUM OISR2 ON OIS.I_TRANSACTION_NO = OISR2.I_TRANSACTION_NO AND OISR2.SHIPMENT_REFNUM_QUAL_GID = 'SNI.TAH END DTTM' INNER JOIN ODS.O_DRIVER_CALENDAR_EVENT ODCE ON ODSS.DRIVER_GID = ODCE.DRIVER_GID WHERE XOD.EXE_SUB_TYP_CD <> 'IC CHOICE' AND XOD.LOB_CD = 'LOB_VAN TL' AND OD.END_DATE IS NULL AND XOD.DRV_DIV_NAM <> 'NOT ASSIGNED' AND (ODR.REMARK_QUAL_GID = 'SNI.WORK CONFIGURATION' OR ODR.REMARK_QUAL_GID = 'SNI.SEGMENT CODE') AND ODREF.DRIVER_REFNUM_VALUE IN ('19412','19414') AND ODR.REMARK_TEXT = ('12 X 2 11 X 3') AND OIS.STATUS_CODE_GID = 'SNI.DRIVER TIME AT HOME' AND OIS.OB_REFNUM_VALUE LIKE 'TAH % REQUIRES APPROVAL' AND OIS.INSERT_DATE > (SYSDATE - 7) UNION SELECT DISTINCT SUBSTR(ODSS.DRIVER_GID,5) AS DRV_NUM ,SUBSTR(ODIP.INVOLVED_PARTY_CONTACT_GID,5) AS DBL_ID ,OISR.SHIPMENT_REFNUM_VALUE AS REQ_START ,OISR2.SHIPMENT_REFNUM_VALUE AS REQ_END ,OIS.I_TRANSACTION_NO AS TE_NUM ,OIS.INSERT_DATE AS INSERT_DATE ,ODCE.EVENT_START_TIME ,ROUND((TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'))*24,2) AS FULL_DUR ,CASE WHEN (TRUNC(TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS')) < SYSDATE) THEN 'TRUE' ELSE 'FALSE' END AS START_DATE_IN_PAST ,CASE WHEN OISR.SHIPMENT_REFNUM_VALUE BETWEEN '2016-12-23 17:00:00' AND '2016-12-26 17:00:00' THEN CASE WHEN TO_DATE(ODCE.EVENT_START_TIME) - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') < 5 AND TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(ODCE.EVENT_START_TIME) < 5 AND CAL_EVENT_TYPE_GID IN ('SNI.TL HOMERUN','SNI.TL TAH','SNI.DRIVER PAID TIME OFF','SNI.TL MISSED TAH','SNI.TL GTAH','SNI.TIME AT HOME') THEN 'TRUE' ELSE 'FALSE' END ELSE CASE WHEN TO_DATE(ODCE.EVENT_START_TIME) - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') < 9 AND TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(ODCE.EVENT_START_TIME) < 9 AND CAL_EVENT_TYPE_GID IN ('SNI.TL HOMERUN','SNI.TL TAH','SNI.DRIVER PAID TIME OFF','SNI.TL MISSED TAH','SNI.TL GTAH','SNI.TIME AT HOME') THEN 'TRUE' ELSE 'FALSE' END END AS EVENT_EXISTS ,CASE WHEN OISR.SHIPMENT_REFNUM_VALUE BETWEEN '2016-12-23 17:00:00' AND '2016-12-26 17:00:00' THEN CASE WHEN (TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'))*24 > 63.00 OR TO_CHAR(TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') NOT IN ('6','7') OR TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'HH24:MI') > '08:01' THEN 'TRUE' ELSE 'FALSE' END ELSE CASE WHEN (TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') - TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'))*24 > 87.17 OR TO_CHAR(TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') NOT IN ('5','6') OR TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'D') NOT IN ('1','2','3') OR TO_CHAR(TO_DATE(OISR2.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS'), 'HH24:MI') > '08:01' THEN 'TRUE' ELSE 'FALSE' END END AS OVER_42_HOURS ,CASE WHEN TO_DATE(OISR.SHIPMENT_REFNUM_VALUE,'YYYY-MM-DD HH24:MI:SS') > (SYSDATE + 3.0416)/* Adding 3.0416 to represent 3 days and 1 hour */ THEN 'FALSE' ELSE 'TRUE' END AS INSUFFICIENT_NOTICE FROM ODS.O_DRIVER_SPECIAL_SERVICE ODSS INNER JOIN ODS.XO_O_DRIVER XOD ON ODSS.DRIVER_GID = XOD.DRV_GID INNER JOIN ODS.O_DRIVER OD ON ODSS.DRIVER_GID = OD.DRIVER_GID INNER JOIN ODS.O_LOCATION OL ON OD.SIGHTING_LOCATION_GID = OL.LOCATION_GID INNER JOIN ODS.O_DRIVER_REMARK ODR ON ODSS.DRIVER_GID = ODR.DRIVER_GID INNER JOIN ODS.O_DRIVER_REFNUM ODREF ON ODSS.DRIVER_GID = ODREF.DRIVER_GID AND ODREF.DRIVER_REFNUM_QUAL_GID = 'SNI.COST ALLOCATION BUSINESS UNIT CODE' INNER JOIN ODS.O_DRIVER_INV_PARTY ODIP ON ODSS.DRIVER_GID = ODIP.DRIVER_GID AND ODIP.INVOLVED_PARTY_QUAL_GID = 'SNI.DRIVER MANAGER' INNER JOIN ODS.O_IE_SHIPMENTSTATUS OIS ON ODSS.DRIVER_GID = OIS.DRIVER_GID INNER JOIN ODS.O_IE_SHIPMENT_REFNUM OISR ON OIS.I_TRANSACTION_NO = OISR.I_TRANSACTION_NO AND OISR.SHIPMENT_REFNUM_QUAL_GID = 'SNI.TAH START DTTM' INNER JOIN ODS.O_IE_SHIPMENT_REFNUM OISR2 ON OIS.I_TRANSACTION_NO = OISR2.I_TRANSACTION_NO AND OISR2.SHIPMENT_REFNUM_QUAL_GID = 'SNI.TAH END DTTM' INNER JOIN ODS.O_DRIVER_CALENDAR_EVENT ODCE ON ODSS.DRIVER_GID = ODCE.DRIVER_GID WHERE 1=1 AND XOD.EXE_SUB_TYP_CD <> 'IC CHOICE' AND XOD.LOB_CD = 'LOB_VAN TL' AND OD.END_DATE IS NULL AND XOD.DRV_DIV_NAM <> 'NOT ASSIGNED' AND (ODR.REMARK_QUAL_GID = 'SNI.WORK CONFIGURATION' OR ODR.REMARK_QUAL_GID = 'SNI.SEGMENT CODE') AND ODREF.DRIVER_REFNUM_VALUE IN ('19412','19414') AND ODR.REMARK_TEXT = ('11 X 3') AND OIS.STATUS_CODE_GID = 'SNI.DRIVER TIME AT HOME' AND OIS.OB_REFNUM_VALUE LIKE 'TAH % REQUIRES APPROVAL' AND OIS.INSERT_DATE > (SYSDATE - 7)

PI104350841

Job Overview:

Location Greensboro NC
Driver Types Company Driver
Trailer Types Dry Van
Pay Info Full-Time
Hiring States NC

Carrier Overview:

Carrier Schneider
Address 3101 S. Packerland Drive, Green Bay, WI, 54306
Phone 800-447-7433
Other Jobs by Company