VIEW: APPS.FA_INS_LINES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'