[Home] [Help]
View: OKX_RECEIVABLES_TERMS_V
View Text
SELECT B.TERM_ID ID1
, '#' ID2
, B.CREDIT_CHECK_FLAG CREDIT_CHECK_FLAG
, B.START_DATE_ACTIVE START_DATE_ACTIVE
, B.END_DATE_ACTIVE END_DATE_ACTIVE
, T.DESCRIPTION DESCRIPTION
, T.NAME NAME
, B.IN_USE IN_USE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(B.START_DATE_ACTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(B.END_DATE_ACTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
FROM RA_TERMS_B B
, RA_TERMS_TL T
WHERE B.TERM_ID = T.TERM_ID
AND T.LANGUAGE = USERENV('LANG')
Columns
Name |
ID1 |
ID2 |
CREDIT_CHECK_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
DESCRIPTION |
NAME |
IN_USE |
STATUS |