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_SYSTEM_SETUP_OPTIONS#

Object Details

Object Name:	PN_SYSTEM_SETUP_OPTIONS#
Object Type:	VIEW
Owner:	PN
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PROFILE_ID	NUMBER	(15)	Yes
ORG_ID	NUMBER	(15)
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
ACCOUNTING_OPTION	VARCHAR2	(30)	Yes
DEFAULT_CURRENCY_CONV_TYPE	VARCHAR2	(30)
SPACE_ASSIGN_SYSDATE_OPTN	VARCHAR2	(1)	Yes
MULTIPLE_TENANCY_LEASE	VARCHAR2	(1)	Yes
AUTO_SPACE_DISTRIBUTION	VARCHAR2	(1)	Yes
AUTO_COMP_NUM_GEN	VARCHAR2	(1)	Yes
AUTO_LEASE_NUM_GEN	VARCHAR2	(1)	Yes
AUTO_INDEX_NUM_GEN	VARCHAR2	(1)	Yes
AUTO_VAR_RENT_NUM_GEN	VARCHAR2	(1)	Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATION_DATE	DATE		Yes
LAST_UPDATE_DATE	DATE		Yes
LOCATION_CODE_SEPARATOR	VARCHAR2	(2)
AUTO_REC_AGR_NUM_FLAG	VARCHAR2	(1)	Yes
AUTO_REC_EXP_NUM_FLAG	VARCHAR2	(1)	Yes
AUTO_REC_ARCL_NUM_FLAG	VARCHAR2	(1)	Yes
AUTO_REC_EXPCL_NUM_FLAG	VARCHAR2	(1)	Yes
CONS_REC_AGRTERMS_FLAG	VARCHAR2	(1)	Yes
DEFAULT_LOCN_AREA_FLAG	VARCHAR2	(1)	Yes
GROUPING_RULE_ID	NUMBER
GL_TRANSFER_MODE	VARCHAR2	(30)
SUBMIT_JOURNAL_IMPORT_FLAG	VARCHAR2	(1)
LEGACY_DATA_CUTOFF_DATE	DATE
EXTEND_INDEXRENT_TERM_FLAG	VARCHAR2	(1)	Yes
SYSDATE_FOR_ADJ_FLAG	VARCHAR2	(1)
SYSDATE_AS_TRX_DATE_FLAG	VARCHAR2	(1)
RENORM_ADJ_ACC_ALL_DRAFT_FLAG	VARCHAR2	(1)
CONSOLIDATE_ADJ_ITEMS_FLAG	VARCHAR2	(1)
DEFAULT_USER_VIEW_CODE	VARCHAR2	(30)
CALC_ANNUALIZED_BASIS_CODE	VARCHAR2	(30)
ALLOW_TENANCY_OVERLAP_FLAG	VARCHAR2	(1)	Yes
RECALC_IR_ON_ACC_CHG_FLAG	VARCHAR2	(1)	Yes
SMALLEST_TERM_AMOUNT	NUMBER
INCL_TERMS_BY_DEFAULT_FLAG	VARCHAR2	(1)	Yes

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# references the following:

PN: PN_SYSTEM_SETUP_OPTIONS

PN.PN_SYSTEM_SETUP_OPTIONS# is referenced by following:

APPS: PN_SYSTEM_SETUP_OPTIONS