VIEW: APPS.AP_LC_INVOICE_TYPES_DB_V

Source

View Text - Preformatted

SELECT LOOKUP_CODE , DISPLAYED_FIELD , DESCRIPTION FROM AP_LOOKUP_CODES WHERE LOOKUP_TYPE = 'INVOICE TYPE' AND LOOKUP_CODE NOT IN ('QUICKDEFAULT','QUICKMATCH','INTEREST','PREPAYMENT','ADJUSTMENT','PO PRICE ADJUST') AND SYSDATE < NVL(INACTIVE_DATE, SYSDATE+1)

View Text - HTML Formatted

SELECT LOOKUP_CODE
, DISPLAYED_FIELD
, DESCRIPTION
FROM AP_LOOKUP_CODES
WHERE LOOKUP_TYPE = 'INVOICE TYPE'
AND LOOKUP_CODE NOT IN ('QUICKDEFAULT'
, 'QUICKMATCH'
, 'INTEREST'
, 'PREPAYMENT'
, 'ADJUSTMENT'
, 'PO PRICE ADJUST')
AND SYSDATE < NVL(INACTIVE_DATE
, SYSDATE+1)