eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_INS_PY_UV

Source

View Text - Preformatted


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.ADDRESS1 ||',' ||INPR.ADDRESS2||','||INPR.ADDRESS3||','||INPR.ADDRESS4||','||INPR.CITY||','||INPR.POSTAL_CODE||','||INPR.STATE||','||INPR.COUNTRY||','||INPR.PROVINCE||','||INPR.COUNTY PARTY_ADDRESS , null PARTY_SITE_ID, null AGENT_NAME, null AGENT_ADDRESS , to_number(null) AGNT_SITE_ID FROM OKL_INS_POLICIES_B IPYB,OKL_INS_POLICIES_TL IPYT,FND_LOOKUPS FLPT,HZ_PARTIES INPR WHERE IPYB.ID = IPYT.ID AND IPYB.IPY_TYPE = FLPT.LOOKUP_CODE AND IPYB.ISU_ID = INPR.PARTY_ID AND INPR.CATEGORY_CODE = 'INSURER' AND FLPT.LOOKUP_TYPE = 'OKL_INSURANCE_TYPE' AND IPYT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

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.ADDRESS1 ||'
, ' ||INPR.ADDRESS2||'
, '||INPR.ADDRESS3||'
, '||INPR.ADDRESS4||'
, '||INPR.CITY||'
, '||INPR.POSTAL_CODE||'
, '||INPR.STATE||'
, '||INPR.COUNTRY||'
, '||INPR.PROVINCE||'
, '||INPR.COUNTY PARTY_ADDRESS
, NULL PARTY_SITE_ID
, NULL AGENT_NAME
, NULL AGENT_ADDRESS
, TO_NUMBER(NULL) AGNT_SITE_ID
FROM OKL_INS_POLICIES_B IPYB
, OKL_INS_POLICIES_TL IPYT
, FND_LOOKUPS FLPT
, HZ_PARTIES INPR
WHERE IPYB.ID = IPYT.ID
AND IPYB.IPY_TYPE = FLPT.LOOKUP_CODE
AND IPYB.ISU_ID = INPR.PARTY_ID
AND INPR.CATEGORY_CODE = 'INSURER'
AND FLPT.LOOKUP_TYPE = 'OKL_INSURANCE_TYPE'
AND IPYT.LANGUAGE = USERENV('LANG')