VIEW: APPS.FA_INS_POLICIES_V

Source

View Text - Preformatted

SELECT POL.ROWID ROW_ID , POL.ASSET_POLICY_ID , POL.ASSET_ID , POL.BOOK_TYPE_CODE , POL.POLICY_NUMBER , MPOL.VENDOR_SITE_ID , MPOL.VENDOR_ID , MPOL.CALCULATION_METHOD , POL.BASE_INSURANCE_VALUE , POL.BASE_INDEX_DATE , POL.CURRENT_INSURANCE_VALUE , POL.LAST_INDEXATION_ID , POL.INSURED_AMOUNT , POL.CURRENT_PRICE_INDEX_ID , POL.LAST_PRICE_INDEX_VALUE , POL.VALUE_BEFORE_RETIREMENT , POL.LAST_UPDATE_DATE , POL.LAST_UPDATED_BY , POL.LAST_UPDATE_LOGIN , POL.CREATION_DATE , POL.CREATED_BY , POV.VENDOR_NAME INSURANCE_COMPANY , PVS.VENDOR_SITE_CODE , FAX.PRICE_INDEX_NAME INSURANCE_INDEX , ARP_ADDR_PKG.FORMAT_ADDRESS( PVS.ADDRESS_STYLE, PVS.ADDRESS_LINE1, PVS.ADDRESS_LINE2, PVS.ADDRESS_LINE3, PVS.ADDRESS_LINE4, PVS.CITY, PVS.COUNTY, PVS.STATE, PVS.PROVINCE, PVS.ZIP, TERR.TERRITORY_SHORT_NAME) ADDRESS , POL.LAST_INDEXATION_DATE , PVS.ORG_ID , POL.SWISS_BUILDING , POL.ATTRIBUTE_CATEGORY , POL.ATTRIBUTE1 , POL.ATTRIBUTE2 , POL.ATTRIBUTE3 , POL.ATTRIBUTE4 , POL.ATTRIBUTE5 , POL.ATTRIBUTE6 , POL.ATTRIBUTE7 , POL.ATTRIBUTE8 , POL.ATTRIBUTE9 , POL.ATTRIBUTE10 , POL.ATTRIBUTE11 , POL.ATTRIBUTE12 , POL.ATTRIBUTE13 , POL.ATTRIBUTE14 , POL.ATTRIBUTE15 , POL.ATTRIBUTE16 , POL.ATTRIBUTE17 , POL.ATTRIBUTE18 , POL.ATTRIBUTE19 , POL.ATTRIBUTE20 FROM PO_VENDOR_SITES_ALL PVS, PO_VENDORS POV, FA_INS_MST_POLS MPOL, FA_PRICE_INDEXES FAX, FA_INS_POLICIES POL, FND_TERRITORIES_VL TERR WHERE PVS.VENDOR_ID = POV.VENDOR_ID AND POV.VENDOR_ID = MPOL.VENDOR_ID AND MPOL.ASSET_POLICY_ID=POL.ASSET_POLICY_ID AND PVS.VENDOR_SITE_ID = MPOL.VENDOR_SITE_ID AND PVS.COUNTRY = TERR.TERRITORY_CODE (+) AND FAX.PRICE_INDEX_ID(+) = POL.CURRENT_PRICE_INDEX_ID

View Text - HTML Formatted

SELECT POL.ROWID ROW_ID
, POL.ASSET_POLICY_ID
, POL.ASSET_ID
, POL.BOOK_TYPE_CODE
, POL.POLICY_NUMBER
, MPOL.VENDOR_SITE_ID
, MPOL.VENDOR_ID
, MPOL.CALCULATION_METHOD
, POL.BASE_INSURANCE_VALUE
, POL.BASE_INDEX_DATE
, POL.CURRENT_INSURANCE_VALUE
, POL.LAST_INDEXATION_ID
, POL.INSURED_AMOUNT
, POL.CURRENT_PRICE_INDEX_ID
, POL.LAST_PRICE_INDEX_VALUE
, POL.VALUE_BEFORE_RETIREMENT
, POL.LAST_UPDATE_DATE
, POL.LAST_UPDATED_BY
, POL.LAST_UPDATE_LOGIN
, POL.CREATION_DATE
, POL.CREATED_BY
, POV.VENDOR_NAME INSURANCE_COMPANY
, PVS.VENDOR_SITE_CODE
, FAX.PRICE_INDEX_NAME INSURANCE_INDEX
, ARP_ADDR_PKG.FORMAT_ADDRESS( PVS.ADDRESS_STYLE
, PVS.ADDRESS_LINE1
, PVS.ADDRESS_LINE2
, PVS.ADDRESS_LINE3
, PVS.ADDRESS_LINE4
, PVS.CITY
, PVS.COUNTY
, PVS.STATE
, PVS.PROVINCE
, PVS.ZIP
, TERR.TERRITORY_SHORT_NAME) ADDRESS
, POL.LAST_INDEXATION_DATE
, PVS.ORG_ID
, POL.SWISS_BUILDING
, POL.ATTRIBUTE_CATEGORY
, POL.ATTRIBUTE1
, POL.ATTRIBUTE2
, POL.ATTRIBUTE3
, POL.ATTRIBUTE4
, POL.ATTRIBUTE5
, POL.ATTRIBUTE6
, POL.ATTRIBUTE7
, POL.ATTRIBUTE8
, POL.ATTRIBUTE9
, POL.ATTRIBUTE10
, POL.ATTRIBUTE11
, POL.ATTRIBUTE12
, POL.ATTRIBUTE13
, POL.ATTRIBUTE14
, POL.ATTRIBUTE15
, POL.ATTRIBUTE16
, POL.ATTRIBUTE17
, POL.ATTRIBUTE18
, POL.ATTRIBUTE19
, POL.ATTRIBUTE20
FROM PO_VENDOR_SITES_ALL PVS
, PO_VENDORS POV
, FA_INS_MST_POLS MPOL
, FA_PRICE_INDEXES FAX
, FA_INS_POLICIES POL
, FND_TERRITORIES_VL TERR
WHERE PVS.VENDOR_ID = POV.VENDOR_ID
AND POV.VENDOR_ID = MPOL.VENDOR_ID
AND MPOL.ASSET_POLICY_ID=POL.ASSET_POLICY_ID
AND PVS.VENDOR_SITE_ID = MPOL.VENDOR_SITE_ID
AND PVS.COUNTRY = TERR.TERRITORY_CODE (+)
AND FAX.PRICE_INDEX_ID(+) = POL.CURRENT_PRICE_INDEX_ID