AP_TERMS_VAL_V

Details

• Schema: FUSION

• Object owner: AP

• Object type: VIEW

Columns

Name
NAME DESCRIPTION TERM_ID

Query

SQL_Statement
SELECT AT.NAME NAME , AT.DESCRIPTION DESCRIPTION , AT.TERM_ID TERM_ID FROM AP_TERMS_TL AT, AP_TERMS_B B WHERE B.TERM_ID = AT.TERM_ID AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(B.START_DATE_ACTIVE, SYSDATE - 1)) AND TRUNC(NVL(B.END_DATE_ACTIVE, SYSDATE + 1)) AND AT.LANGUAGE = userenv('LANG')