FND Design Data [Home] [Help]

View: ASO_I_FREIGHT_CODES_V

Product: ASO - Order Capture
Description: ASO_I_FREIGHT_CODES_V is based on view ORG_FREIGHT_VL. It is used to select the freight carrier and method from LOV
Implementation/DBA Data: ViewAPPS.ASO_I_FREIGHT_CODES_V
View Text

SELECT ORGANIZATION_ID
, FREIGHT_CODE
, DESCRIPTION
FROM ORG_FREIGHT_VL
WHERE TRUNC(SYSDATE) < TRUNC(NVL(DISABLE_DATE
, SYSDATE+1))

Columns

Name
ORGANIZATION_ID
FREIGHT_CODE
DESCRIPTION