[Home] [Help]
VIEW: APPS.OE_FRGHT_CARR_ACTIVE_V
Source
View Text - Preformatted
SELECT NVL(DESCRIPTION, FREIGHT_CODE) FREIGHT_CARRIER , FREIGHT_CODE , DESCRIPTION, ORGANIZATION_ID FROM ORG_FREIGHT WHERE TRUNC(SYSDATE) < TRUNC(NVL(DISABLE_DATE, SYSDATE+1))
View Text - HTML Formatted
SELECT NVL(DESCRIPTION
, FREIGHT_CODE) FREIGHT_CARRIER
, FREIGHT_CODE
, DESCRIPTION
, ORGANIZATION_ID
FROM ORG_FREIGHT
WHERE TRUNC(SYSDATE) < TRUNC(NVL(DISABLE_DATE
, SYSDATE+1))