[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: |
APPS.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 |