FND Design Data [Home] [Help]

View: SO_FREIGHT_CARRIERS_ACTIVE_V

Product: OE - Order Entry
Description:
Implementation/DBA Data: ViewAPPS.SO_FREIGHT_CARRIERS_ACTIVE_V
View Text

SELECT NVL(DESCRIPTION
, FREIGHT_CODE_TL) FREIGHT_CARRIER
, FREIGHT_CODE
, 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