[Home] [Help]
View: AP_LC_INVOICE_TYPES_V
View Text
SELECT LOOKUP_CODE
, DISPLAYED_FIELD
, DESCRIPTION
FROM AP_LOOKUP_CODES
WHERE LOOKUP_TYPE = 'INVOICE TYPE'
AND LOOKUP_CODE NOT IN ('INTEREST'
, 'QUICKMATCH'
, 'QUICKDEFAULT'
, 'ADJUSTMENT'
, 'PO PRICE ADJUST' )
AND SYSDATE < NVL(INACTIVE_DATE
, SYSDATE+1)
Columns
Name |
LOOKUP_CODE |
DISPLAYED_FIELD |
DESCRIPTION |