[Home] [Help]
View: FA_INS_MST_POLS_V
View Text
SELECT POL.ROWID ROW_ID
, POL.ASSET_POLICY_ID
, POL.POLICY_NUMBER
, POL.VENDOR_SITE_ID
, POL.VENDOR_ID
, POL.CALCULATION_METHOD
, 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
FROM PO_VENDOR_SITES_ALL PVS
, PO_VENDORS POV
, FA_INS_MST_POLS POL
, FND_TERRITORIES_VL TERR
WHERE PVS.VENDOR_ID = POV.VENDOR_ID
AND POV.VENDOR_ID = POL.VENDOR_ID
AND PVS.VENDOR_SITE_ID = POL.VENDOR_SITE_ID
AND PVS.COUNTRY = TERR.TERRITORY_CODE (+)
Columns
| Name |
| ROW_ID |
| ASSET_POLICY_ID |
| POLICY_NUMBER |
| VENDOR_SITE_ID |
| VENDOR_ID |
| CALCULATION_METHOD |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN |
| CREATION_DATE |
| CREATED_BY |
| INSURANCE_COMPANY |
| VENDOR_SITE_CODE |
APPS.FA_INS_MST_POLS_V