VIEW: APPS.OKX_FREIGHT_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')