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.

[Home] [Help]

VIEW: PN.PN_SYSTEM_SETUP_OPTIONS#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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