VIEW: PN.PN_INDEX_LEASES_ALL#

Source

View Text - Preformatted

select INDEX_LEASE_ID INDEX_LEASE_ID, LEASE_ID LEASE_ID, INDEX_ID INDEX_ID, COMMENCEMENT_DATE COMMENCEMENT_DATE, TERMINATION_DATE TERMINATION_DATE, INDEX_LEASE_NUMBER INDEX_LEASE_NUMBER, LOCATION_ID LOCATION_ID, TERM_TEMPLATE_ID TERM_TEMPLATE_ID, ABSTRACTED_BY ABSTRACTED_BY, ASSESSMENT_DATE ASSESSMENT_DATE, ASSESSMENT_INTERVAL ASSESSMENT_INTERVAL, SPREAD_FREQUENCY SPREAD_FREQUENCY, RELATIONSHIP_DEFAULT RELATIONSHIP_DEFAULT, BASIS_PERCENT_DEFAULT BASIS_PERCENT_DEFAULT, INITIAL_BASIS INITIAL_BASIS, BASE_INDEX BASE_INDEX, BASE_INDEX_LINE_ID BASE_INDEX_LINE_ID, INDEX_FINDER_METHOD INDEX_FINDER_METHOD, INDEX_FINDER_MONTHS INDEX_FINDER_MONTHS, NEGATIVE_RENT_TYPE NEGATIVE_RENT_TYPE, INCREASE_ON INCREASE_ON, BASIS_TYPE BASIS_TYPE, REFERENCE_PERIOD REFERENCE_PERIOD, BASE_YEAR BASE_YEAR, LEASED_AREA LEASED_AREA, ROUNDING_FLAG ROUNDING_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, AGREEMENT_CATEGORY AGREEMENT_CATEGORY, AGREEMENT_ATTRIBUTE1 AGREEMENT_ATTRIBUTE1, AGREEMENT_ATTRIBUTE2 AGREEMENT_ATTRIBUTE2, AGREEMENT_ATTRIBUTE3 AGREEMENT_ATTRIBUTE3, AGREEMENT_ATTRIBUTE4 AGREEMENT_ATTRIBUTE4, AGREEMENT_ATTRIBUTE5 AGREEMENT_ATTRIBUTE5, AGREEMENT_ATTRIBUTE6 AGREEMENT_ATTRIBUTE6, AGREEMENT_ATTRIBUTE7 AGREEMENT_ATTRIBUTE7, AGREEMENT_ATTRIBUTE8 AGREEMENT_ATTRIBUTE8, AGREEMENT_ATTRIBUTE9 AGREEMENT_ATTRIBUTE9, AGREEMENT_ATTRIBUTE10 AGREEMENT_ATTRIBUTE10, AGREEMENT_ATTRIBUTE11 AGREEMENT_ATTRIBUTE11, AGREEMENT_ATTRIBUTE12 AGREEMENT_ATTRIBUTE12, AGREEMENT_ATTRIBUTE13 AGREEMENT_ATTRIBUTE13, AGREEMENT_ATTRIBUTE14 AGREEMENT_ATTRIBUTE14, AGREEMENT_ATTRIBUTE15 AGREEMENT_ATTRIBUTE15, ORG_ID ORG_ID, AGGREGATION_FLAG AGGREGATION_FLAG, GROSS_FLAG GROSS_FLAG, CURRENCY_CODE CURRENCY_CODE, CARRY_FORWARD_FLAG CARRY_FORWARD_FLAG, RETAIN_INITIAL_BASIS_FLAG RETAIN_INITIAL_BASIS_FLAG, INDEX_MULTIPLIER INDEX_MULTIPLIER, CONSTRAINT_PRORATION CONSTRAINT_PRORATION, VR_NBP_FLAG VR_NBP_FLAG, PRORATION_RULE PRORATION_RULE, PRORATION_PERIOD_START_DATE PRORATION_PERIOD_START_DATE from "PN"."PN_INDEX_LEASES_ALL"

View Text - HTML Formatted

SELECT INDEX_LEASE_ID INDEX_LEASE_ID
, LEASE_ID LEASE_ID
, INDEX_ID INDEX_ID
, COMMENCEMENT_DATE COMMENCEMENT_DATE
, TERMINATION_DATE TERMINATION_DATE
, INDEX_LEASE_NUMBER INDEX_LEASE_NUMBER
, LOCATION_ID LOCATION_ID
, TERM_TEMPLATE_ID TERM_TEMPLATE_ID
, ABSTRACTED_BY ABSTRACTED_BY
, ASSESSMENT_DATE ASSESSMENT_DATE
, ASSESSMENT_INTERVAL ASSESSMENT_INTERVAL
, SPREAD_FREQUENCY SPREAD_FREQUENCY
, RELATIONSHIP_DEFAULT RELATIONSHIP_DEFAULT
, BASIS_PERCENT_DEFAULT BASIS_PERCENT_DEFAULT
, INITIAL_BASIS INITIAL_BASIS
, BASE_INDEX BASE_INDEX
, BASE_INDEX_LINE_ID BASE_INDEX_LINE_ID
, INDEX_FINDER_METHOD INDEX_FINDER_METHOD
, INDEX_FINDER_MONTHS INDEX_FINDER_MONTHS
, NEGATIVE_RENT_TYPE NEGATIVE_RENT_TYPE
, INCREASE_ON INCREASE_ON
, BASIS_TYPE BASIS_TYPE
, REFERENCE_PERIOD REFERENCE_PERIOD
, BASE_YEAR BASE_YEAR
, LEASED_AREA LEASED_AREA
, ROUNDING_FLAG ROUNDING_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, AGREEMENT_CATEGORY AGREEMENT_CATEGORY
, AGREEMENT_ATTRIBUTE1 AGREEMENT_ATTRIBUTE1
, AGREEMENT_ATTRIBUTE2 AGREEMENT_ATTRIBUTE2
, AGREEMENT_ATTRIBUTE3 AGREEMENT_ATTRIBUTE3
, AGREEMENT_ATTRIBUTE4 AGREEMENT_ATTRIBUTE4
, AGREEMENT_ATTRIBUTE5 AGREEMENT_ATTRIBUTE5
, AGREEMENT_ATTRIBUTE6 AGREEMENT_ATTRIBUTE6
, AGREEMENT_ATTRIBUTE7 AGREEMENT_ATTRIBUTE7
, AGREEMENT_ATTRIBUTE8 AGREEMENT_ATTRIBUTE8
, AGREEMENT_ATTRIBUTE9 AGREEMENT_ATTRIBUTE9
, AGREEMENT_ATTRIBUTE10 AGREEMENT_ATTRIBUTE10
, AGREEMENT_ATTRIBUTE11 AGREEMENT_ATTRIBUTE11
, AGREEMENT_ATTRIBUTE12 AGREEMENT_ATTRIBUTE12
, AGREEMENT_ATTRIBUTE13 AGREEMENT_ATTRIBUTE13
, AGREEMENT_ATTRIBUTE14 AGREEMENT_ATTRIBUTE14
, AGREEMENT_ATTRIBUTE15 AGREEMENT_ATTRIBUTE15
, ORG_ID ORG_ID
, AGGREGATION_FLAG AGGREGATION_FLAG
, GROSS_FLAG GROSS_FLAG
, CURRENCY_CODE CURRENCY_CODE
, CARRY_FORWARD_FLAG CARRY_FORWARD_FLAG
, RETAIN_INITIAL_BASIS_FLAG RETAIN_INITIAL_BASIS_FLAG
, INDEX_MULTIPLIER INDEX_MULTIPLIER
, CONSTRAINT_PRORATION CONSTRAINT_PRORATION
, VR_NBP_FLAG VR_NBP_FLAG
, PRORATION_RULE PRORATION_RULE
, PRORATION_PERIOD_START_DATE PRORATION_PERIOD_START_DATE
FROM "PN"."PN_INDEX_LEASES_ALL"