Product: | OKL - Lease and Finance Management |
---|---|
Description: | Insurance policies and quotes |
Implementation/DBA Data: | APPS.OKL_INS_POLICIES_V |
SELECT IPYB.ROWID ROW_ID
, IPYB.ID ID
, IPYB.LEASE_APPLICATION_ID LEASE_APPLICATION_ID
, IPYB.IPY_TYPE IPY_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
, IPYB.PREMIUM PREMIUM
, IPYB.COVERED_AMOUNT COVERED_AMOUNT
, IPYB.DEDUCTIBLE DEDUCTIBLE
, IPYB.ADJUSTMENT
, IPYB.PAYMENT_FREQUENCY PAYMENT_FREQUENCY
, IPYB.CRX_CODE CRX_CODE
, IPYB.IPF_CODE IPF_CODE
, 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
, IPYB. INSURANCE_FACTOR INSURANCE_FACTOR
, IPYB.FACTOR_CODE FACTOR_CODE
, 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.TERRITORY_CODE TERRITORY_CODE
, 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
, IPYB.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM OKL_INS_POLICIES_B IPYB
, OKL_INS_POLICIES_TL IPYT
WHERE IPYB.ID = IPYT.ID
AND IPYT.LANGUAGE = USERENV('LANG')