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_RECON_ALL

Object Details

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

PN_OPEX_RECON_ALL stores reconciliation overview information for operating expenses

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PN_OPEX_RECON_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RECON_ID
PN_OPEX_RECON_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AGREEMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RECON_ID	NUMBER		Yes	Identifier of this reconciliation
AGREEMENT_ID	NUMBER		Yes	Identifier of the agreement with which this reconciliation is associated
AGREEMENT_NAME	VARCHAR2	(90)		Name of the agreement with which this reconciliation is associated
AGREEMENT_NUM	VARCHAR2	(90)		Number of the agreement with which this reconciliation is associated
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)
FEE_PCT	NUMBER			The percentage of administration fee to be applied to the reconciliation
TAXABLE_FLAG	VARCHAR2	(1)		Flag indicating if tax is to be applied
ADMIN_FEE_FLAG	VARCHAR2	(1)		Flag indicating if the reconciliation is subject to administration fees
CAP_MIN_FLAG	VARCHAR2	(1)		Flag indicating if the reconciliation is subject to constraints
GROSS_UP_FLAG	VARCHAR2	(1)		Flag indicating if expenses are to be grossed up to adjust for less than full occupancy.
FY_CONSTR_APPLY_TO_CODE	VARCHAR2	(30)		Code indicating how the first year constraint is to be applied to the reconciliation: (LT=total landlord expense, TS= tenants pro rata share)
FY_CONSTR_UNIT_CODE	VARCHAR2	(30)		Code specifying the units for first year constraints: (AMT=amount, APA=amount per area)
FY_CONSTR_PRORATE_FLAG	VARCHAR2	(1)		Flag indicating if constraints are to be prorated for the reconciliation
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_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_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 subsequent year cap amount
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			This column stores the Subsequent Year's Caps Index finder month for an Opex Agreement.
SY_MIN_LIMIT_CODE	VARCHAR2	(30)		Code specifying the rate type to be used for determining 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 for calculating the subsequent year minimum amount using the fixed percent rate type
SY_MIN_INDEX_ID	NUMBER			Identifier of the index to be used for calculating subsequent year minimum
SY_MIN_INDEX_FINDER_MONTH	NUMBER			This column stores the Subsequent Year's minimum Index finder month for an Opex Agreement.
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)
PRORATA_BASIS_TYPE_CODE	VARCHAR2	(30)		Code specifying the pro rata basis type(FP=Fixed Percent, GLA=Gross Leasable Area, PSS=Pro Rata Share of Sales, OA=Occupied Area, OAF=Occupied Area with floor
PERIOD_START_DT	DATE		Yes	The start date of the reconciliation period
PERIOD_END_DT	DATE		Yes	The end date of the reconciliation period
ST_RECV_DT	DATE		Yes	The date of receipt of reconciliation statement from landlord
ST_AMT_DUE	NUMBER			Reconciliation amount due as specified in the landlord statement
RECON_PERFORM_DT	DATE		Yes	Date when reconciliation was performed
RESP_PERSON_ID	NUMBER			Identifier of the person responsible for the reconciliation
REVISION_NAME	VARCHAR2	(50)	Yes	Reconciliation revision name
REVISION_NUMBER	NUMBER		Yes	Reconciliation revision number
AUDIT_ST_CODE	VARCHAR2	(30)		Code specifying reconciliation audit status
AUDITOR	VARCHAR2	(50)		Name of the person performing the audit
AUDITOR_TYPE	VARCHAR2	(1)		Code specifying auditor type: (I=internal, E=external)
STATUS_CODE	VARCHAR2	(30)		Code specifying the reconciliation status
CURRENT_FLAG	VARCHAR2	(1)		Flag indicating if this is the current reconciliation for this period
ADJ_TEN_CHARGE_ST	NUMBER			Adjustment amount for total tenant charge as specified in the landlord statement
ADJ_TEN_CHARGE_EXP	NUMBER			Expected adjustment amount for total tenant charge
ADJ_RECON_AMT_ST	NUMBER			Adjustment amount for the reconciliation as specified in the landlord statement
ADJ_RECON_AMT_EXP	NUMBER			Expected adjustment amount for the reconciliation
TEN_SHR_SUB_CAP	NUMBER			The tenant share subject to constraints
TEN_SHR_AFT_CAP	NUMBER			The tenant share after constraints are applied
TEN_TOT_CHARGE	NUMBER			Total tenant charge
SAVINGS_CREDIT	NUMBER			The total landlord savings carried forward from past shortfalls between actual operating expenses and cap
OVERRUN_CREDIT	NUMBER			The total landlord overruns carried forward from past overages between actual operating expenses and cap
PAY_TRM_AMT	NUMBER			Payment Term Amount.
AMT_DUE_ST	NUMBER			Calculated amount due as per the landlord statement
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 RECON_ID
,      AGREEMENT_ID
,      AGREEMENT_NAME
,      AGREEMENT_NUM
,      CAP_APPLIED_CODE
,      FEE_PCT
,      TAXABLE_FLAG
,      ADMIN_FEE_FLAG
,      CAP_MIN_FLAG
,      GROSS_UP_FLAG
,      FY_CONSTR_APPLY_TO_CODE
,      FY_CONSTR_UNIT_CODE
,      FY_CONSTR_PRORATE_FLAG
,      FY_CONSTR_MAX
,      FY_CONSTR_MIN
,      SY_CAP_APPLY_TO_CODE
,      SY_CAP_LIMIT_CODE
,      SY_CAP_COMPARE_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
,      STOP_TYPE_CODE
,      STOP_AMT
,      STOP_AMT_TYPE_CODE
,      PRORATA_BASIS_TYPE_CODE
,      PERIOD_START_DT
,      PERIOD_END_DT
,      ST_RECV_DT
,      ST_AMT_DUE
,      RECON_PERFORM_DT
,      RESP_PERSON_ID
,      REVISION_NAME
,      REVISION_NUMBER
,      AUDIT_ST_CODE
,      AUDITOR
,      AUDITOR_TYPE
,      STATUS_CODE
,      CURRENT_FLAG
,      ADJ_TEN_CHARGE_ST
,      ADJ_TEN_CHARGE_EXP
,      ADJ_RECON_AMT_ST
,      ADJ_RECON_AMT_EXP
,      TEN_SHR_SUB_CAP
,      TEN_SHR_AFT_CAP
,      TEN_TOT_CHARGE
,      SAVINGS_CREDIT
,      OVERRUN_CREDIT
,      PAY_TRM_AMT
,      AMT_DUE_ST
,      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_RECON_ALL;

Dependencies

[top of page]

PN.PN_OPEX_RECON_ALL does not reference any database object

PN.PN_OPEX_RECON_ALL is referenced by following:

PN: PN_OPEX_RECON_ALL#