Product: | PN - Property Manager |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PN_INSUR_REQUIRE_HISTORY_V |
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.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
, TO_NUMBER (NULL) INSURANCE_HISTORY_ID
, TO_NUMBER (NULL) NEW_LEASE_CHANGE_ID
, 'Y' CURRENT_FLAG
FROM FND_LOOKUPS LOOK
, PN_INSURANCE_REQUIREMENTS INS
WHERE LOOK.LOOKUP_TYPE = 'PN_INSURANCE_TYPE'
AND LOOK.LOOKUP_CODE = INS.INSURANCE_TYPE_LOOKUP_CODE UNION ALL 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.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.INSURANCE_HISTORY_ID
, INS.NEW_LEASE_CHANGE_ID
, 'N' CURRENT_FLAG
FROM FND_LOOKUPS LOOK
, PN_INSUR_REQUIRE_HISTORY INS
WHERE LOOK.LOOKUP_TYPE = 'PN_INSURANCE_TYPE'
AND LOOK.LOOKUP_CODE = INS.INSURANCE_TYPE_LOOKUP_CODE