[Home] [Help]
View: OKX_FREIGHT_V
Product: | OKX - Contracts Integration |
Description: | Freight codes |
Implementation/DBA Data: |
APPS.OKX_FREIGHT_V
|
View Text
SELECT OFR.FREIGHT_CODE ID1
, OFR.ORGANIZATION_ID ID2
, OFR.FREIGHT_CODE_TL NAME
, OFR.DESCRIPTION DESCRIPTION
, DECODE(SIGN(NVL(OFR.DISABLE_DATE - 1
, SYSDATE) - SYSDATE)
, -1
, 'I'
, 'A') STATUS
, SYSDATE - 20000 START_DATE_ACTIVE
, DECODE(OFR.DISABLE_DATE
, NULL
, NULL
, TRUNC(OFR.DISABLE_DATE) - 1) END_DATE_ACTIVE
, OFR.ORGANIZATION_ID ORGANIZATION_ID
FROM ORG_FREIGHT_TL OFR
WHERE OFR.LANGUAGE = USERENV('LANG')
Columns
Name |
ID1 |
ID2 |
NAME |
DESCRIPTION |
STATUS |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
ORGANIZATION_ID |