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_SYSTEM_SETUP_OPTIONS

Object Details

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

PN_SYSTEM_SETUP_OPTIONS holds setup options at the operating unit level. It retains information such as the operating unit's set of books and the accounting option.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PN_SYSTEM_SETUP_OPTIONS_U1	NORMAL	UNIQUE	APPS_TS_SEED	PROFILE_ID
PN_SYSTEM_SETUP_OPTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROFILE_ID	NUMBER	(15)	Yes	Uniquely identifies the profile options row
ORG_ID	NUMBER	(15)		Organization identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of books as defined in GL
ACCOUNTING_OPTION	VARCHAR2	(30)	Yes	Accounting option
DEFAULT_CURRENCY_CONV_TYPE	VARCHAR2	(30)		Default currency conversion type as defined in GL
SPACE_ASSIGN_SYSDATE_OPTN	VARCHAR2	(1)	Yes	Use SYSDATE to record space assignment
MULTIPLE_TENANCY_LEASE	VARCHAR2	(1)	Yes	Multiple leases can concurrently refer to the same location
AUTO_SPACE_DISTRIBUTION	VARCHAR2	(1)	Yes	Automatic Space Distribution option
AUTO_COMP_NUM_GEN	VARCHAR2	(1)	Yes	Automatic Company Number Generation option
AUTO_LEASE_NUM_GEN	VARCHAR2	(1)	Yes	Automatic Lease Number Generation option
AUTO_INDEX_NUM_GEN	VARCHAR2	(1)	Yes	Automatic Rent Increase Number Generation option
AUTO_VAR_RENT_NUM_GEN	VARCHAR2	(1)	Yes	Automatic Variable Rent Number Generation option
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LOCATION_CODE_SEPARATOR	VARCHAR2	(2)		The separator used while defining the Location Codes
AUTO_REC_AGR_NUM_FLAG	VARCHAR2	(1)	Yes	Automatic Recovery Agreement Number Generation option
AUTO_REC_EXP_NUM_FLAG	VARCHAR2	(1)	Yes	Automatic Recovery Expense Number Generation option
AUTO_REC_ARCL_NUM_FLAG	VARCHAR2	(1)	Yes	Automatic Recovery Area Class Number Generation option
AUTO_REC_EXPCL_NUM_FLAG	VARCHAR2	(1)	Yes	Automatic Recovery Expense Class Number Generation option
CONS_REC_AGRTERMS_FLAG	VARCHAR2	(1)	Yes	Consolidate Recovery Agreement Terms option
DEFAULT_LOCN_AREA_FLAG	VARCHAR2	(1)	Yes	Default location area for leases.
GROUPING_RULE_ID	NUMBER			Associates the grouping rule name in PN_PAY_GROUP_RULES_ALL with the setup option.
GL_TRANSFER_MODE	VARCHAR2	(30)		The mode by which accounting information is transferred to General Ledger.
SUBMIT_JOURNAL_IMPORT_FLAG	VARCHAR2	(1)		Flag to indicate whether the Submit the Journal Import concurrent program is called automatically once data is transferred to General Ledger.
LEGACY_DATA_CUTOFF_DATE	DATE			The cutoff date to switch from a legacy system to Oracle Property Manager
EXTEND_INDEXRENT_TERM_FLAG	VARCHAR2	(1)	Yes	Extend index rent terms when leases are extended
SYSDATE_FOR_ADJ_FLAG	VARCHAR2	(1)		Indicates if the adjustments will be created in the month of the system date.
SYSDATE_AS_TRX_DATE_FLAG	VARCHAR2	(1)		Indicates if the system date will be used as the transaction date for the adjustment items.
RENORM_ADJ_ACC_ALL_DRAFT_FLAG	VARCHAR2	(1)		Indicates if the renormalization will be done across all the available draft schedules.
CONSOLIDATE_ADJ_ITEMS_FLAG	VARCHAR2	(1)		Indicates if the adjustments should be consolidated into one item.
DEFAULT_USER_VIEW_CODE	VARCHAR2	(30)		Default user view. The value can be either Tenant or Landlord.
CALC_ANNUALIZED_BASIS_CODE	VARCHAR2	(30)		Determines the terms to be considered for calculating the annualized basis amount in Index Rent agreements.
ALLOW_TENANCY_OVERLAP_FLAG	VARCHAR2	(1)	Yes	Allow overlapping tenancies for the same location in a lease
RECALC_IR_ON_ACC_CHG_FLAG	VARCHAR2	(1)	Yes	Recalculate rent increase agreements for changes to account attributes
SMALLEST_TERM_AMOUNT	NUMBER			The threshold amount required for a term to be created.
INCL_TERMS_BY_DEFAULT_FLAG	VARCHAR2	(1)	Yes	Flag indicating if rent increase terms are to be included by default.

Query Text

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


SELECT PROFILE_ID
,      ORG_ID
,      SET_OF_BOOKS_ID
,      ACCOUNTING_OPTION
,      DEFAULT_CURRENCY_CONV_TYPE
,      SPACE_ASSIGN_SYSDATE_OPTN
,      MULTIPLE_TENANCY_LEASE
,      AUTO_SPACE_DISTRIBUTION
,      AUTO_COMP_NUM_GEN
,      AUTO_LEASE_NUM_GEN
,      AUTO_INDEX_NUM_GEN
,      AUTO_VAR_RENT_NUM_GEN
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LOCATION_CODE_SEPARATOR
,      AUTO_REC_AGR_NUM_FLAG
,      AUTO_REC_EXP_NUM_FLAG
,      AUTO_REC_ARCL_NUM_FLAG
,      AUTO_REC_EXPCL_NUM_FLAG
,      CONS_REC_AGRTERMS_FLAG
,      DEFAULT_LOCN_AREA_FLAG
,      GROUPING_RULE_ID
,      GL_TRANSFER_MODE
,      SUBMIT_JOURNAL_IMPORT_FLAG
,      LEGACY_DATA_CUTOFF_DATE
,      EXTEND_INDEXRENT_TERM_FLAG
,      SYSDATE_FOR_ADJ_FLAG
,      SYSDATE_AS_TRX_DATE_FLAG
,      RENORM_ADJ_ACC_ALL_DRAFT_FLAG
,      CONSOLIDATE_ADJ_ITEMS_FLAG
,      DEFAULT_USER_VIEW_CODE
,      CALC_ANNUALIZED_BASIS_CODE
,      ALLOW_TENANCY_OVERLAP_FLAG
,      RECALC_IR_ON_ACC_CHG_FLAG
,      SMALLEST_TERM_AMOUNT
,      INCL_TERMS_BY_DEFAULT_FLAG
FROM PN.PN_SYSTEM_SETUP_OPTIONS;

Dependencies

[top of page]

PN.PN_SYSTEM_SETUP_OPTIONS does not reference any database object

PN.PN_SYSTEM_SETUP_OPTIONS is referenced by following:

APPS: PN_SYSTEM_SETUP_OPTIONS