DBA Data[Home] [Help]

VIEW: APPS.OKX_PAYABLES_TERMS_V

Source

View Text - Preformatted

SELECT PT.TERM_ID ID1, '#' ID2, PT.NAME NAME, PT.DESCRIPTION DESCRIPTION, PT.START_DATE_ACTIVE START_DATE_ACTIVE, PT.END_DATE_ACTIVE END_DATE_ACTIVE, PT.ENABLED_FLAG B_STATUS, DECODE(PT.ENABLED_FLAG,'Y','A','I') STATUS FROM AP_TERMS_TL PT WHERE PT.LANGUAGE = USERENV('LANG')
View Text - HTML Formatted

SELECT PT.TERM_ID ID1
, '#' ID2
, PT.NAME NAME
, PT.DESCRIPTION DESCRIPTION
, PT.START_DATE_ACTIVE START_DATE_ACTIVE
, PT.END_DATE_ACTIVE END_DATE_ACTIVE
, PT.ENABLED_FLAG B_STATUS
, DECODE(PT.ENABLED_FLAG
, 'Y'
, 'A'
, 'I') STATUS
FROM AP_TERMS_TL PT
WHERE PT.LANGUAGE = USERENV('LANG')