eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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
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:

PN: PN_RENT_INCREASE_SUMMARY_ITF

PN.PN_RENT_INCREASE_SUMMARY_ITF# is referenced by following:

APPS: PN_RENT_INCREASE_SUMMARY_ITF