[Home] [Help]
View: WSH_FREIGHT_CARRIERS_ACTIVE_V
View Text
SELECT NVL(DESCRIPTION
, FREIGHT_CODE_TL) FREIGHT_CARRIER
, FREIGHT_CODE_TL
, DESCRIPTION
, ORGANIZATION_ID
FROM ORG_FREIGHT
WHERE TRUNC(SYSDATE) < TRUNC(NVL(DISABLE_DATE
, SYSDATE+1))
Columns
| Name |
| FREIGHT_CARRIER |
| FREIGHT_CODE_TL |
| DESCRIPTION |
| ORGANIZATION_ID |