[Home] [Help] [Dependency Information]
Object Name: | PN_RENT_INCREASE_SUMMARY_ITF# |
---|---|
Object Type: | VIEW |
Owner: | PN |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (50) | ||
LEASE_NUM | VARCHAR2 | (30) | ||
PAYMENT_TERM_PRORATION_RULE | NUMBER | |||
ABSTRACTED_BY_USER_NAME | VARCHAR2 | (100) | ||
LEASE_CLASS_MEANING | VARCHAR2 | (80) | ||
LEASE_COMMENCEMENT_DATE | DATE | |||
LEASE_TERMINATION_DATE | DATE | |||
LEASE_EXECUTION_DATE | DATE | |||
LEASE_EXTENSION_END_DATE | DATE | |||
LOCATION_CODE | VARCHAR2 | (30) | ||
INDEX_NAME | VARCHAR2 | (30) | ||
IL_COMMENCEMENT_DATE | DATE | |||
IL_TERMINATION_DATE | DATE | |||
INDEX_LEASE_NUMBER | VARCHAR2 | (100) | ||
IL_ASSESSMENT_DATE | DATE | |||
ASSESSMENT_INTERVAL | NUMBER | |||
SPREAD_FREQUENCY_MEANING | VARCHAR2 | (80) | ||
BASIS_PERCENT_DEFAULT | NUMBER | |||
INITIAL_BASIS | NUMBER | |||
BASE_INDEX | NUMBER | |||
INDEX_FINDER_METHOD | VARCHAR2 | (80) | ||
INDEX_FINDER_MONTHS | NUMBER | |||
NEGATIVE_RENT_TYPE_MEANING | VARCHAR2 | (80) | ||
INCREASE_ON_MEANING | VARCHAR2 | (80) | ||
BASIS_TYPE | VARCHAR2 | (30) | ||
REFERENCE_PERIOD_MEANING | VARCHAR2 | (80) | ||
BASE_YEAR | DATE | |||
ILP_ASSESSMENT_DATE | DATE | |||
BASIS_START_DATE | DATE | |||
BASIS_END_DATE | DATE | |||
INDEX_FINDER_DATE | DATE | |||
CURRENT_BASIS | NUMBER | |||
RELATIONSHIP_MEANING | VARCHAR2 | (80) | ||
INDEX_PERCENT_CHANGE | NUMBER | |||
BASIS_PERCENT_CHANGE | NUMBER | |||
CURRENT_INDEX_LINE_VALUE | NUMBER | |||
PREVIOUS_INDEX_LINE_VALUE | NUMBER | |||
UNCONSTRAINT_RENT_DUE | NUMBER | |||
CONSTRAINT_RENT_DUE | NUMBER | |||
CARRY_FORWARD_AMOUNT | NUMBER | |||
CARRY_FORWARD_PERCENT | NUMBER | |||
CONSTRAINT_APPLIED_AMOUNT | NUMBER | |||
CONSTRAINT_APPLIED_PERCENT | NUMBER | |||
OPEN_CARRY_FORWARD_AMOUNT | NUMBER | |||
OPEN_CARRY_FORWARD_PERCENT | NUMBER | |||
APP_CARRY_FORWARD_AMOUNT | NUMBER | |||
APP_CARRY_FORWARD_PERCENT | NUMBER | |||
OLD_RENT | NUMBER | |||
NEW_RENT | NUMBER | |||
CHANGE_RENT | NUMBER | |||
CONSTRAINT_PRORATION | VARCHAR2 | (80) | ||
INDEX_MULTIPLIER | NUMBER | |||
UNADJUSTED_INDEX_CHANGE | NUMBER | |||
ADJUSTED_INDEX_CHANGE_PERCENT | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT NAME
, LEASE_NUM
, PAYMENT_TERM_PRORATION_RULE
, ABSTRACTED_BY_USER_NAME
, LEASE_CLASS_MEANING
, LEASE_COMMENCEMENT_DATE
, LEASE_TERMINATION_DATE
, LEASE_EXECUTION_DATE
, LEASE_EXTENSION_END_DATE
, LOCATION_CODE
, INDEX_NAME
, IL_COMMENCEMENT_DATE
, IL_TERMINATION_DATE
, INDEX_LEASE_NUMBER
, IL_ASSESSMENT_DATE
, ASSESSMENT_INTERVAL
, SPREAD_FREQUENCY_MEANING
, BASIS_PERCENT_DEFAULT
, INITIAL_BASIS
, BASE_INDEX
, INDEX_FINDER_METHOD
, INDEX_FINDER_MONTHS
, NEGATIVE_RENT_TYPE_MEANING
, INCREASE_ON_MEANING
, BASIS_TYPE
, REFERENCE_PERIOD_MEANING
, BASE_YEAR
, ILP_ASSESSMENT_DATE
, BASIS_START_DATE
, BASIS_END_DATE
, INDEX_FINDER_DATE
, CURRENT_BASIS
, RELATIONSHIP_MEANING
, INDEX_PERCENT_CHANGE
, BASIS_PERCENT_CHANGE
, CURRENT_INDEX_LINE_VALUE
, PREVIOUS_INDEX_LINE_VALUE
, UNCONSTRAINT_RENT_DUE
, CONSTRAINT_RENT_DUE
, CARRY_FORWARD_AMOUNT
, CARRY_FORWARD_PERCENT
, CONSTRAINT_APPLIED_AMOUNT
, CONSTRAINT_APPLIED_PERCENT
, OPEN_CARRY_FORWARD_AMOUNT
, OPEN_CARRY_FORWARD_PERCENT
, APP_CARRY_FORWARD_AMOUNT
, APP_CARRY_FORWARD_PERCENT
, OLD_RENT
, NEW_RENT
, CHANGE_RENT
, CONSTRAINT_PRORATION
, INDEX_MULTIPLIER
, UNADJUSTED_INDEX_CHANGE
, ADJUSTED_INDEX_CHANGE_PERCENT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
FROM PN.PN_RENT_INCREASE_SUMMARY_ITF#;
|
|
|