View: AP_LC_INVOICE_TYPES_V

Product:	AP - Payables
Description:	(Release 10SC Only)
Implementation/DBA Data:	APPS.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