VIEW: APPS.OKL_BPD_DEF_INV_LINE_TYPE_UV

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )