FND Design Data [Home] [Help]

View: WSH_FREIGHT_CARRIERS_ACTIVE_V

Product: WSH - Shipping Execution
Description:
Implementation/DBA Data: ViewAPPS.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