View: PN_TENANCIES_V

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

View Text

SELECT TEN.ROWID ROW_ID
, TEN.TENANCY_ID TENANCY_ID
, TEN.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TEN.LAST_UPDATED_BY LAST_UPDATED_BY
, TEN.CREATION_DATE CREATION_DATE
, TEN.CREATED_BY CREATED_BY
, TEN.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TEN.LOCATION_ID LOCATION_ID
, TEN.LEASE_ID LEASE_ID
, TEN.LEASE_CHANGE_ID LEASE_CHANGE_ID
, TEN.TENANCY_USAGE_LOOKUP_CODE TENANCY_USAGE_LOOKUP_CODE
, TENLOOK.MEANING TENANCY_USAGE_TYPE
, TEN.PRIMARY_FLAG PRIMARY_FLAG
, TEN.ESTIMATED_OCCUPANCY_DATE ESTIMATED_OCCUPANCY_DATE
, TEN.OCCUPANCY_DATE OCCUPANCY_DATE
, TEN.EXPIRATION_DATE EXPIRATION_DATE
, TEN.ASSIGNABLE_FLAG ASSIGNABLE_FLAG
, TEN.SUBLEASEABLE_FLAG SUBLEASEABLE_FLAG
, TEN.TENANTS_PROPORTIONATE_SHARE TENANTS_PROPORTIONATE_SHARE
, TEN.STATUS STATUS
, TEN.RECOVERY_TYPE_CODE RECOVERY_TYPE_CODE
, RECTYPE.MEANING RECOVERY_TYPE
, TEN.RECOVERY_SPACE_STD_CODE RECOVERY_SPACE_STD_CODE
, RECSSTD.MEANING RECOVERY_SPACE_STD
, TEN.FIN_OBLIG_END_DATE FIN_OBLIG_END_DATE
, TEN.CUSTOMER_ID CUSTOMER_ID
, TEN.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, HZP.PARTY_NAME CUSTOMER_NAME
, HCA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, HCSU.LOCATION CUSTOMER_SITE_USE
, TEN.LEASE_RENTABLE_AREA LEASE_RENTABLE_AREA
, TEN.LEASE_USABLE_AREA LEASE_USABLE_AREA
, TEN.LEASE_ASSIGNABLE_AREA LEASE_ASSIGNABLE_AREA
, TEN.LEASE_LOAD_FACTOR LEASE_LOAD_FACTOR
, TEN.LOCATION_RENTABLE_AREA LOCATION_RENTABLE_AREA
, TEN.LOCATION_USABLE_AREA LOCATION_USABLE_AREA
, TEN.LOCATION_ASSIGNABLE_AREA LOCATION_ASSIGNABLE_AREA
, TEN.LOCATION_LOAD_FACTOR LOCATION_LOAD_FACTOR
, TEN.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TEN.ATTRIBUTE1 ATTRIBUTE1
, TEN.ATTRIBUTE2 ATTRIBUTE2
, TEN.ATTRIBUTE3 ATTRIBUTE3
, TEN.ATTRIBUTE4 ATTRIBUTE4
, TEN.ATTRIBUTE5 ATTRIBUTE5
, TEN.ATTRIBUTE6 ATTRIBUTE6
, TEN.ATTRIBUTE7 ATTRIBUTE7
, TEN.ATTRIBUTE8 ATTRIBUTE8
, TEN.ATTRIBUTE9 ATTRIBUTE9
, TEN.ATTRIBUTE10 ATTRIBUTE10
, TEN.ATTRIBUTE11 ATTRIBUTE11
, TEN.ATTRIBUTE12 ATTRIBUTE12
, TEN.ATTRIBUTE13 ATTRIBUTE13
, TEN.ATTRIBUTE14 ATTRIBUTE14
, TEN.ATTRIBUTE15 ATTRIBUTE15
, TEN.ORG_ID ORG_ID
FROM FND_LOOKUPS TENLOOK
, FND_LOOKUPS RECSSTD
, FND_LOOKUPS RECTYPE
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HCA
, HZ_CUST_SITE_USES_ALL HCSU
, PN_TENANCIES TEN
WHERE TENLOOK.LOOKUP_TYPE = 'PN_TENANCY_USAGE_TYPE'
AND TENLOOK.LOOKUP_CODE = TEN.TENANCY_USAGE_LOOKUP_CODE
AND RECTYPE.LOOKUP_TYPE(+) = 'PN_RECOVERY_TYPE'
AND RECTYPE.LOOKUP_CODE(+) = TEN.RECOVERY_TYPE_CODE
AND RECSSTD.LOOKUP_TYPE(+) = 'PN_RECOVERY_SPACE_STD_TYPE'
AND RECSSTD.LOOKUP_CODE(+) = TEN.RECOVERY_SPACE_STD_CODE
AND HCA.CUST_ACCOUNT_ID(+) = TEN.CUSTOMER_ID
AND HZP.PARTY_ID (+) = HCA.PARTY_ID
AND HCSU.SITE_USE_ID (+) = TEN.CUSTOMER_SITE_USE_ID

Columns