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