VIEW: APPS.OKL_BPD_ASSIGN_FORMAT_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')