Product: | OFA - Assets |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FA_INS_POLICIES_V |
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