Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: PN.PN_RENT_INCREASE_SUMMARY_ITF#

Object Details
Object Name: PN_RENT_INCREASE_SUMMARY_ITF#
Object Type: VIEW
Owner: PN
Subobject Name:
Status: VALID

[View Source]

Columns
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

Query Text

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#;

Dependencies

[top of page]

PN.PN_RENT_INCREASE_SUMMARY_ITF# references the following:

SchemaPN
TablePN_RENT_INCREASE_SUMMARY_ITF
PN.PN_RENT_INCREASE_SUMMARY_ITF# is referenced by following:

SchemaAPPS
SynonymPN_RENT_INCREASE_SUMMARY_ITF