[Home] [Help]
View: 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
Name |
ID1 |
ID2 |
ORG_ID |
NAME |
DESCRIPTION |
STATUS |
START_DATE_ACTIVE |
END_DATE_ACTIVE |