VIEW: APPS.OKL_INS_POLICIES_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')