VIEW: APPS.OKL_I_POLICIES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'