View: FA_INS_LINES_V

Product:	OFA - Assets
Description:
Implementation/DBA Data:	APPS.FA_INS_LINES_V

View Text

SELECT JFL.ROWID ROW_ID
, JFL.ASSET_POLICY_ID
, JFL.VENDOR_ID
, JFL.POLICY_NUMBER
, JFL.ASSET_ID
, JFL.POLICY_LINE
, JFL.INSURANCE_CATEGORY
, JFL.HAZARD_CLASS
, JFL.COMMENTS
, JFL.LAST_UPDATE_DATE
, JFL.LAST_UPDATED_BY
, JFL.LAST_UPDATE_LOGIN
, JFL.CREATION_DATE
, JFL.CREATED_BY
, FUP.MEANING HAZARD_MEANING
, JFL.ATTRIBUTE_CATEGORY
, JFL.ATTRIBUTE1
, JFL.ATTRIBUTE2
, JFL.ATTRIBUTE3
, JFL.ATTRIBUTE4
, JFL.ATTRIBUTE5
, JFL.ATTRIBUTE6
, JFL.ATTRIBUTE7
, JFL.ATTRIBUTE8
, JFL.ATTRIBUTE9
, JFL.ATTRIBUTE10
, JFL.ATTRIBUTE11
, JFL.ATTRIBUTE12
, JFL.ATTRIBUTE13
, JFL.ATTRIBUTE14
, JFL.ATTRIBUTE15
, JFL.ATTRIBUTE16
, JFL.ATTRIBUTE17
, JFL.ATTRIBUTE18
, JFL.ATTRIBUTE19
, JFL.ATTRIBUTE20
FROM FND_LOOKUPS FUP
, FA_INS_LINES JFL
WHERE FUP.LOOKUP_CODE = JFL.HAZARD_CLASS
AND FUP.LOOKUP_TYPE = 'FA_INS_HAZARD'

Columns