View: OKL_INS_PY_UV

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

View Text

SELECT IPYB.ROWID ROW_ID
, IPYB.ID ID
, IPYB.IPY_TYPE IPY_TYPE
, FLPT.MEANING INSURANCE_TYPE
, IPYT.DESCRIPTION DESCRIPTION
, IPYT.ENDORSEMENT ENDORSEMENT
, IPYT.SFWT_FLAG SFWT_FLAG
, IPYT.CANCELLATION_COMMENT CANCELLATION_COMMENT
, IPYT.COMMENTS COMMENTS
, IPYB.NAME_OF_INSURED NAME_OF_INSURED
, IPYB.POLICY_NUMBER POLICY_NUMBER
, IPYB.CALCULATED_PREMIUM CALCULATED_PREMIUM
, IPYB.PREMIUM PREMIUM
, IPYB.COVERED_AMOUNT COVERED_AMOUNT
, IPYB.DEDUCTIBLE DEDUCTIBLE
, IPYB.ADJUSTMENT ADJUSTMENT
, IPYB.PAYMENT_FREQUENCY PAYMENT_FREQUENCY
, IPYB.IPF_CODE IPF_CODE
, DECODE(NVL(IPYB.DATE_TO
, NULL)
, NULL
, 'ACTIVE'
, DECODE(SIGN(MONTHS_BETWEEN(IPYB.DATE_TO
, SYSDATE))
, 1
, 'ACTIVE'
, 'INACTIVE')) STATUS
, IPYB.ISS_CODE ISS_CODE
, IPYB.IPE_CODE IPE_CODE
, IPYB.DATE_TO DATE_TO
, IPYB.DATE_FROM DATE_FROM
, IPYB.DATE_QUOTED DATE_QUOTED
, IPYB.DATE_PROOF_PROVIDED DATE_PROOF_PROVIDED
, IPYB.DATE_PROOF_REQUIRED DATE_PROOF_REQUIRED
, IPYB.CANCELLATION_DATE CANCELLATION_DATE
, IPYB.DATE_QUOTE_EXPIRY DATE_QUOTE_EXPIRY
, IPYB.ACTIVATION_DATE ACTIVATION_DATE
, IPYB.QUOTE_YN QUOTE_YN
, IPYB.ON_FILE_YN ON_FILE_YN
, IPYB.PRIVATE_LABEL_YN PRIVATE_LABEL_YN
, IPYB.AGENT_YN AGENT_YN
, IPYB.LESSOR_INSURED_YN LESSOR_INSURED_YN
, IPYB.LESSOR_PAYEE_YN LESSOR_PAYEE_YN
, IPYB.KHR_ID KHR_ID
, IPYB.KLE_ID KLE_ID
, IPYB.IPT_ID IPT_ID
, IPYB.IPY_ID IPY_ID
, IPYB.INT_ID INT_ID
, IPYB.ISU_ID ISU_ID
, ' ' INSURANCE_FACTOR
, IPYB.FACTOR_VALUE FACTOR_VALUE
, IPYB.AGENCY_NUMBER AGENCY_NUMBER
, IPYB.AGENCY_SITE_ID AGENCY_SITE_ID
, IPYB.SALES_REP_ID SALES_REP_ID
, IPYB.AGENT_SITE_ID AGENT_SITE_ID
, IPYB.ADJUSTED_BY_ID ADJUSTED_BY_ID
, IPYB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, IPYB.ATTRIBUTE1 ATTRIBUTE1
, IPYB.ATTRIBUTE2 ATTRIBUTE2
, IPYB.ATTRIBUTE3 ATTRIBUTE3
, IPYB.ATTRIBUTE4 ATTRIBUTE4
, IPYB.ATTRIBUTE5 ATTRIBUTE5
, IPYB.ATTRIBUTE6 ATTRIBUTE6
, IPYB.ATTRIBUTE7 ATTRIBUTE7
, IPYB.ATTRIBUTE8 ATTRIBUTE8
, IPYB.ATTRIBUTE9 ATTRIBUTE9
, IPYB.ATTRIBUTE10 ATTRIBUTE10
, IPYB.ATTRIBUTE11 ATTRIBUTE11
, IPYB.ATTRIBUTE12 ATTRIBUTE12
, IPYB.ATTRIBUTE13 ATTRIBUTE13
, IPYB.ATTRIBUTE14 ATTRIBUTE14
, IPYB.ATTRIBUTE15 ATTRIBUTE15
, IPYB.PROGRAM_ID PROGRAM_ID
, IPYB.ORG_ID ORG_ID
, IPYB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, IPYB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, IPYB.REQUEST_ID REQUEST_ID
, IPYB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IPYB.CREATED_BY CREATED_BY
, IPYB.CREATION_DATE CREATION_DATE
, IPYB.LAST_UPDATED_BY LAST_UPDATED_BY
, IPYB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IPYB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INPR.PARTY_NAME PARTY_NAME
, INPR.ADDRESS PARTY_ADDRESS
, INPR.SITE_ID PARTY_SITE_ID
, INAG.PARTY_NAME AGENT_NAME
, INAG.ADDRESS AGENT_ADDRESS
, INAG.AGENT_SITE_ID AGNT_SITE_ID
FROM OKL_INS_POLICIES_B IPYB
, OKL_INS_POLICIES_TL IPYT
, FND_LOOKUPS FLPT
, OKX_INSURER_V INPR
, OKX_INSURANCE_AGENT_V INAG
WHERE IPYB.ID = IPYT.ID
AND IPYB.ISU_ID = INPR.PARTY_ID
AND IPYB.INT_ID = INAG.PARTY_ID (+)
AND IPYB.IPY_TYPE = FLPT.LOOKUP_CODE
AND FLPT.LOOKUP_TYPE = 'OKL_INSURANCE_TYPE'
AND INPR.CATEGORY_CODE = 'INSURER'
AND IPYT.LANGUAGE = USERENV('LANG')

Columns