View: OKL_I_POLICIES_V

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

View Text

SELECT IPY.ID ID1
, '#' ID2
, IPY.ORG_ID ORG_ID
, FNL.MEANING POLICY_TYPE
, NULL DESCRIPTION
, DECODE(NVL(IPY.DATE_TO
, NULL)
, NULL
, 'A'
, DECODE(SIGN(MONTHS_BETWEEN(IPY.DATE_TO
, SYSDATE))
, 1
, 'A'
, 'I')) STATUS
, IPY.DATE_FROM START_DATE_ACTIVE
, IPY.DATE_TO END_DATE_ACTIVE
FROM OKL_INS_POLICIES_B IPY
, FND_LOOKUPS FNL
WHERE IPY.IPY_TYPE = FNL.LOOKUP_CODE
AND FNL.LOOKUP_TYPE = 'OKL_INSURANCE_TYPE'
AND IPY.QUOTE_YN = 'N'

Columns