View: OKL_BPD_ASSIGN_FORMAT_V

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_BPD_ASSIGN_FORMAT_V

View Text

SELECT FORMAT.FORMAT_NAME
, FORMAT.INF_ID
, INVC_TYPE.NAME
, LINE_TYPE.NAME
, FORMAT.STREAM_NAME
, FORMAT.STREAM_PURPOSE_MEANING
, DECODE(FRMT_STRMS.INF_ID
, NULL
, 'UNASSIGNED'
, 'ASSIGNED')
FROM OKL_INVC_LINE_TYPES_V LINE_TYPE
, OKL_INVOICE_TYPES_V INVC_TYPE
, OKL_BPD_ASSIGN_FORMATS_UV FORMAT
, OKL_INVC_FRMT_STRMS_V FRMT_STRMS
WHERE FRMT_STRMS.INF_ID(+) = FORMAT.INF_ID
AND FRMT_STRMS.STY_ID(+) = FORMAT.STY_ID
AND INVC_TYPE.ID(+) = LINE_TYPE.ITY_ID
AND FRMT_STRMS.ILT_ID = LINE_TYPE.ID(+) ORDER BY FORMAT.FORMAT_NAME
, DECODE(FRMT_STRMS.STY_ID
, NULL
, 'UNASSIGNED'
, 'ASSIGNED')

Columns