View: OKL_BPD_DEF_INV_LINE_TYPE_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_BPD_DEF_INV_LINE_TYPE_UV

View Text

SELECT ILT.NAME
, ILT.ID
, INF.ID
FROM OKL_INVOICE_FORMATS_B INF
, OKL_INVOICE_TYPES_V ITY
, OKL_INVC_LINE_TYPES_V ILT
WHERE ITY.INF_ID = INF.ID
AND ILT.ITY_ID = ITY.ID
AND ILT.ID NOT IN ( SELECT A.ILT_ID FROM OKL_INVC_FRMT_STRMS_V A WHERE A.INF_ID = INF.ID )

Columns