View: AP_LC_INVOICE_TYPES_DB_V

Product:	AP - Payables
Description:	(Release 10SC Only)
Implementation/DBA Data:	APPS.AP_LC_INVOICE_TYPES_DB_V

View Text

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)

Columns