[Home] [Help] [Dependency Information]

VIEW: PN.PN_SYSTEM_SETUP_OPTIONS#

Object Details

[View Source]

Columns

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

APPS

PN_SYSTEM_SETUP_OPTIONS