[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 |