View: PN_INSURANCE_REQUIREMNTS_V

Product:	PN - Property Manager
Description:
Implementation/DBA Data:	APPS.PN_INSURANCE_REQUIREMNTS_V

View Text

SELECT INS.ROWID ROW_ID
, INS.INSURANCE_REQUIREMENT_ID INSURANCE_REQUIREMENT_ID
, INS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, INS.LAST_UPDATED_BY LAST_UPDATED_BY
, INS.CREATION_DATE CREATION_DATE
, INS.CREATED_BY CREATED_BY
, INS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INS.INSURANCE_TYPE_LOOKUP_CODE INSURANCE_TYPE_LOOKUP_CODE
, INS.LEASE_ID LEASE_ID
, INS.LEASE_CHANGE_ID LEASE_CHANGE_ID
, INS.POLICY_START_DATE POLICY_START_DATE
, INS.POLICY_EXPIRATION_DATE POLICY_EXPIRATION_DATE
, INS.INSURER_NAME INSURER_NAME
, INS.POLICY_NUMBER POLICY_NUMBER
, INS.INSURED_AMOUNT INSURED_AMOUNT
, INS.REQUIRED_AMOUNT REQUIRED_AMOUNT
, INS.STATUS STATUS
, INS.INSURANCE_COMMENTS INSURANCE_COMMENTS
, INS.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, INS.ATTRIBUTE1 ATTRIBUTE1
, INS.ATTRIBUTE2 ATTRIBUTE2
, INS.ATTRIBUTE3 ATTRIBUTE3
, INS.ATTRIBUTE4 ATTRIBUTE4
, INS.ATTRIBUTE5 ATTRIBUTE5
, INS.ATTRIBUTE6 ATTRIBUTE6
, INS.ATTRIBUTE7 ATTRIBUTE7
, INS.ATTRIBUTE8 ATTRIBUTE8
, INS.ATTRIBUTE9 ATTRIBUTE9
, INS.ATTRIBUTE10 ATTRIBUTE10
, INS.ATTRIBUTE11 ATTRIBUTE11
, INS.ATTRIBUTE12 ATTRIBUTE12
, INS.ATTRIBUTE13 ATTRIBUTE13
, INS.ATTRIBUTE14 ATTRIBUTE14
, INS.ATTRIBUTE15 ATTRIBUTE15
, LOOK.MEANING INSURANCE_TYPE
, INS.ORG_ID ORG_ID
FROM FND_LOOKUPS LOOK
, PN_INSURANCE_REQUIREMENTS INS
WHERE LOOK.LOOKUP_TYPE = 'PN_INSURANCE_TYPE'
AND LOOK.LOOKUP_CODE = INS.INSURANCE_TYPE_LOOKUP_CODE

Columns