Skip to content

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

VIEW: PN.PN_RENT_INCREASE_DETAIL_ITF#

Object Details
Object Name: PN_RENT_INCREASE_DETAIL_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

PAYMENT_PURPOSE_MEANING VARCHAR2 (80)
PAYMENT_TERM_TYPE_MEANING VARCHAR2 (80)
FREQUENCY_MEANING VARCHAR2 (80)
START_DATE DATE

END_DATE DATE

VENDOR_NAME VARCHAR2 (80)
VENDOR_SITE_CODE VARCHAR2 (30)
TARGET_DATE DATE

ACTUAL_AMOUNT NUMBER

ESTIMATED_AMOUNT NUMBER

CURRENCY_CODE VARCHAR2 (15)
RATE NUMBER

CUSTOMER_NAME VARCHAR2 (50)
CUSTOMER_BILL_SITE VARCHAR2 (50)
NORMALIZE VARCHAR2 (1)
LOCATION_CODE VARCHAR2 (30)
LOCATION_TYPE_LOOKUP_CODE VARCHAR2 (30)
SCHEDULE_DAY NUMBER (15)
CUSTOMER_SHIP_SITE VARCHAR2 (50)
AP_AR_TERM_NAME VARCHAR2 (15)
CUST_TRX_TYPE_NAME VARCHAR2 (30)
PROJECT_NUMBER VARCHAR2 (30)
TASK_NUMBER VARCHAR2 (20)
ORGANIZATION_NAME VARCHAR2 (240)
EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_ITEM_DATE DATE

INV_RULE_NAME VARCHAR2 (100)
ACCOUNT_RULE_NAME VARCHAR2 (100)
SALESREP_NAME VARCHAR2 (240)
PAYTERM_STATUS VARCHAR2 (30)
APPROVED_BY_NAME VARCHAR2 (100)
PO_NUMBER VARCHAR2 (100)
PAYMENT_METHOD VARCHAR2 (100)
SUPPLIER_NUMBER VARCHAR2 (100)
CUSTOMER_NUMBER VARCHAR2 (100)
ANNUAL NUMBER

AREA NUMBER

ANNUAL_AREA NUMBER

TAX_CODE VARCHAR2 (100)
TAX_GROUP VARCHAR2 (100)
TAX_INCLUDED VARCHAR2 (1)
INDEX_TERM_INDICATOR 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

INCLUDE_IN_VAR_RENT VARCHAR2 (80)
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
,      PAYMENT_PURPOSE_MEANING
,      PAYMENT_TERM_TYPE_MEANING
,      FREQUENCY_MEANING
,      START_DATE
,      END_DATE
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      TARGET_DATE
,      ACTUAL_AMOUNT
,      ESTIMATED_AMOUNT
,      CURRENCY_CODE
,      RATE
,      CUSTOMER_NAME
,      CUSTOMER_BILL_SITE
,      NORMALIZE
,      LOCATION_CODE
,      LOCATION_TYPE_LOOKUP_CODE
,      SCHEDULE_DAY
,      CUSTOMER_SHIP_SITE
,      AP_AR_TERM_NAME
,      CUST_TRX_TYPE_NAME
,      PROJECT_NUMBER
,      TASK_NUMBER
,      ORGANIZATION_NAME
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      INV_RULE_NAME
,      ACCOUNT_RULE_NAME
,      SALESREP_NAME
,      PAYTERM_STATUS
,      APPROVED_BY_NAME
,      PO_NUMBER
,      PAYMENT_METHOD
,      SUPPLIER_NUMBER
,      CUSTOMER_NUMBER
,      ANNUAL
,      AREA
,      ANNUAL_AREA
,      TAX_CODE
,      TAX_GROUP
,      TAX_INCLUDED
,      INDEX_TERM_INDICATOR
,      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
,      INCLUDE_IN_VAR_RENT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
FROM PN.PN_RENT_INCREASE_DETAIL_ITF#;

Dependencies

[top of page]

PN.PN_RENT_INCREASE_DETAIL_ITF# references the following:

SchemaPN
TablePN_RENT_INCREASE_DETAIL_ITF
PN.PN_RENT_INCREASE_DETAIL_ITF# is referenced by following:

SchemaAPPS
SynonymPN_RENT_INCREASE_DETAIL_ITF