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]

TABLE: PN.PN_OPEX_AGREEMENTS_ALL

Object Details

Object Name:	PN_OPEX_AGREEMENTS_ALL
Object Type:	TABLE
Owner:	PN
FND Design Data:	PN.PN_OPEX_AGREEMENTS_ALL
Subobject Name:
Status:	VALID

PN_OPEX_AGREEMENTS_ALL stores method and overview information for operating expense agreements.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PN_OPEX_AGR_AGREEMENT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AGREEMENT_ID
PN_OPEX_AGR_LEASE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEASE_ID
PN_OPEX_AGR_TENANCY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TENANCY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AGREEMENT_ID	NUMBER		Yes	Identifier of the agreement
LEASE_ID	NUMBER		Yes	Identifier of the lease with which the agreement is associated
TENANCY_ID	NUMBER		Yes	Identifier of the tenancy with which the agreement is associated
EXPENSE_CLAUSE	VARCHAR2	(30)	Yes	Description of the operating expense being recovered by the agreement
AGR_NAME	VARCHAR2	(90)	Yes	The unique name of the agreement. Default value is the lease name plus the expense name
AGR_NUM	VARCHAR2	(90)	Yes	The unique number of the agreement. System-generated value is the number of existing agreements plus 1, appended to the lease number.
AGR_START_DATE	DATE		Yes	The start date of the agreement
AGR_END_DATE	DATE		Yes	The end date of the agreement
AGR_STATUS_CODE	VARCHAR2	(30)	Yes	Code indicating agreement status
RECON_PAY_FREQ_CODE	VARCHAR2	(30)	Yes	Code specifying the reconciliation frequency for the agreement
EXP_YR_END_MON_CODE	VARCHAR2	(30)	Yes	Code specifying the last month of the expense year
CREDIT_AGAINST_CODE	VARCHAR2	(30)		Code specifying how credit is to be applied to tenant: (AA=all agreements, TA=this agreement, AP=all payments)
ADMIN_FEE_FLAG	VARCHAR2	(1)		Flag indicating if administration fee is to be applied
FEE_PCT	NUMBER			The percentage of administration fee to be applied
TAXABLE_FLAG	VARCHAR2	(1)		Flag indicating if tax is to be applied
CAP_MIN_FLAG	VARCHAR2	(1)		Flag indicating if constraints are to be applied
CAP_APPLIED_CODE	VARCHAR2	(30)		Code indicating how constraints are to be applied if administration fees are also being applied: (BF=before fee, AF=after fee)
STOP_TYPE_CODE	VARCHAR2	(30)		Code specifying the stop type: (F=fixed amount, B=base year, N=none)
STOP_AMT	NUMBER			The value of the stop amount
STOP_AMT_TYPE_CODE	VARCHAR2	(30)		Code specifying stop amount units: (TOT= total area. PUA=per unit area)
GROSS_UP_FLAG	VARCHAR2	(1)		Flag indicating if expenses are to be grossed up to adjust for less than full occupancy
BASE_YR_PCT	NUMBER			The percentage to be used to calculate the grossed up expense for the base year
SUBSEQUENT_YR_PCT	NUMBER			The percentage to be used to calculate the grossed up expense for subsequent years
PRORATA_BASIS_TYPE_CODE	VARCHAR2	(30)		Code indicating the type of basis to be used for pro rata calculations
PRORATA_AREA_UNIT_CODE	VARCHAR2	(30)		Code specifying the units used by the pro rata basis type
FY_CONSTR_UNIT_CODE	VARCHAR2	(30)		Code specifying the units for first year constraints: (AMT=amount, APA=amount per area)
FY_CONSTR_APPLY_TO_CODE	VARCHAR2	(30)		Code indicating how the first year constraint is to be applied: (LT=total landlord expense, TS= tenants pro rata share)
FY_CONSTR_PRORATE_FLAG	VARCHAR2	(1)		Flag indicating if constraints are to be prorated
FY_CONSTR_MAX	NUMBER			The maximum constraint value for the first year
FY_CONSTR_MIN	NUMBER			The minimum constraint value for the first year
SY_CAP_LIMIT_CODE	VARCHAR2	(30)		Code specifying the rate type to be used to determine the cap on expense increases
SY_CAP_COMPARE_TO_CODE	VARCHAR2	(30)		Code specifying the basis to which rates are to be applied to determine the cap amount
SY_CAP_APPLY_TO_CODE	VARCHAR2	(30)		Code indicating how the subsequent year cap is to be applied: (LT=total landlord expense, TS= tenants pro rata share)
SY_CAP_CARRY_FWD_CODE	VARCHAR2	(30)		Code specifying the rules for carrying forward expense overages or shortfalls: (LO=landlord overruns, LS=landlord savings, NN=none)
SY_CAP_PCT	NUMBER			The percentage to be used to calculate the subsequent year cap amount using the fixed percent rate type
SY_CAP_INDEX_ID	NUMBER			Identifier of the index to be used in calculating subsequent year cap
SY_CAP_INDEX_FINDER_MONTH	NUMBER			Month whose index value is to be used to calculate subsequent year cap
SY_MIN_LIMIT_CODE	VARCHAR2	(30)		Code specifying the rate type to be used to determine subsequent year minimum
SY_MIN_COMPARE_TO_CODE	VARCHAR2	(30)		Code specifying the basis to which rates are to be applied to determine the subsequent year minimum
SY_MIN_APPLY_TO_CODE	VARCHAR2	(30)		Code indicating how the subsequent year minimum is to be applied: (LT=total landlord expense, TS= tenants pro rata share)
SY_MIN_CARRY_FWD_CODE	VARCHAR2	(30)		Code specifying the rules for carrying forward expense overages or shortfalls: (LO=landlord overruns, LS=landlord savings, NN=none)
SY_MIN_PCT	NUMBER			The percentage to be used to calculate the subsequent year minimum amount using the fixed percent rate type
SY_MIN_INDEX_ID	NUMBER			Identifier of the index to be used in calculating subsequent year minimum
SY_MIN_INDEX_FINDER_MONTH	NUMBER			Month whose index value is to be used to calculate subsequent year minimum
EST_PAY_FREQ_CODE	VARCHAR2	(30)		Code specifying the frequency of estimated payments
EST_PAY_CURRENCY_CODE	VARCHAR2	(30)		Code specifying the currency for the estimated payment term
PAYMENT_TYPE_CODE	VARCHAR2	(30)		Code specifying the payment type
PAYMENT_PURPOSE_CODE	VARCHAR2	(30)		Code specifying the payment purpose
TERM_TEMPLATE_ID	NUMBER			Identifier of the term template associated with the agreement
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
LAST_UPDATE_DATE	DATE		Yes	Standard Who column.
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column.
CREATION_DATE	DATE		Yes	Standard Who column.
CREATED_BY	NUMBER		Yes	Standard Who column.
LAST_UPDATE_LOGIN	NUMBER			Standard Who column.
ORG_ID	NUMBER	(15)		Identifier of the operating unit

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AGREEMENT_ID
,      LEASE_ID
,      TENANCY_ID
,      EXPENSE_CLAUSE
,      AGR_NAME
,      AGR_NUM
,      AGR_START_DATE
,      AGR_END_DATE
,      AGR_STATUS_CODE
,      RECON_PAY_FREQ_CODE
,      EXP_YR_END_MON_CODE
,      CREDIT_AGAINST_CODE
,      ADMIN_FEE_FLAG
,      FEE_PCT
,      TAXABLE_FLAG
,      CAP_MIN_FLAG
,      CAP_APPLIED_CODE
,      STOP_TYPE_CODE
,      STOP_AMT
,      STOP_AMT_TYPE_CODE
,      GROSS_UP_FLAG
,      BASE_YR_PCT
,      SUBSEQUENT_YR_PCT
,      PRORATA_BASIS_TYPE_CODE
,      PRORATA_AREA_UNIT_CODE
,      FY_CONSTR_UNIT_CODE
,      FY_CONSTR_APPLY_TO_CODE
,      FY_CONSTR_PRORATE_FLAG
,      FY_CONSTR_MAX
,      FY_CONSTR_MIN
,      SY_CAP_LIMIT_CODE
,      SY_CAP_COMPARE_TO_CODE
,      SY_CAP_APPLY_TO_CODE
,      SY_CAP_CARRY_FWD_CODE
,      SY_CAP_PCT
,      SY_CAP_INDEX_ID
,      SY_CAP_INDEX_FINDER_MONTH
,      SY_MIN_LIMIT_CODE
,      SY_MIN_COMPARE_TO_CODE
,      SY_MIN_APPLY_TO_CODE
,      SY_MIN_CARRY_FWD_CODE
,      SY_MIN_PCT
,      SY_MIN_INDEX_ID
,      SY_MIN_INDEX_FINDER_MONTH
,      EST_PAY_FREQ_CODE
,      EST_PAY_CURRENCY_CODE
,      PAYMENT_TYPE_CODE
,      PAYMENT_PURPOSE_CODE
,      TERM_TEMPLATE_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM PN.PN_OPEX_AGREEMENTS_ALL;

Dependencies

[top of page]

PN.PN_OPEX_AGREEMENTS_ALL does not reference any database object

PN.PN_OPEX_AGREEMENTS_ALL is referenced by following:

APPS: PN_OPEX_AGREEMENTS; PN_OPEX_AGREEMENTS_ALL