[Home] [Help]
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
Name |
ID1 |
ID2 |
NAME |
DESCRIPTION |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
B_STATUS |
STATUS |