View: OKL_BPD_ASSIGN_FORMATS_UV

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

View Text

SELECT FRMT.ID INF_ID
, FRMT.NAME FORMAT_NAME
, STRMS.ID STY_ID
, STRMS.NAME STREAM_NAME
, FLV.MEANING STREAM_PURPOSE_MEANING
FROM OKL_INVOICE_FORMATS_V FRMT
, OKL_STRM_TYPE_V STRMS
, FND_LOOKUPS FLV
WHERE FLV.LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
AND FLV.LOOKUP_CODE = STRMS.STREAM_TYPE_PURPOSE
AND FLV.ENABLED_FLAG = 'Y'
AND TRUNC(NVL(FLV.START_DATE_ACTIVE
, SYSDATE)) <= TRUNC(SYSDATE)
AND TRUNC(NVL(FLV.END_DATE_ACTIVE
, SYSDATE)) >= TRUNC(SYSDATE)

Columns