View: OKX_PAYABLES_TERMS_V

Product:	OKX - Contracts Integration
Description:	Supplier payment term definitions
Implementation/DBA Data:	APPS.OKX_PAYABLES_TERMS_V

View Text

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

Columns