This script will list all fnd_globals, current set of books, ar_system_parameters and other parameter info – in other words: all you need to know about what your apps initialize did.
Heres the dump list:
- AR_SYSTEM_PARAMETERS
- OE_SYS_PARAMS_UPG
- AP_SYSTEM_PARAMETERS
- CE_SYSTEM_PARAMETERS
- CS_SYSTEM_PARAMETERS
- PO_SYSTEM_PARAMETERS
- FINANCIALS_SYSTEM_PARAMETERS
Syntax: @info (requires the dump.sql)
SQL> @info
-----------------------------------------------------------
INFO by sql4oracle.com
-----------------------------------------------------------
updated: 20-jan-2010 / Thomas Lundqvist
info date: 20-jan-2010 23:13:08 ———————————————————– database version: ———————————————————– Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bi PL/SQL Release 10.2.0.4.0 – Production CORE 10.2.0.4.0 Production TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 – Productio NLSRTL Version 10.2.0.4.0 – Production
connect APPS@DEV ----------------------------------------------------------- FND_GLOBAL ----------------------------------------------------------- fnd_global.USER_ID......................: 8854 fnd_global.USER_NAME....................: XXTLQ fnd_global.RESP_ID......................: 53365 fnd_global.RESP_NAME....................: XX01 Order Management Super User fnd_global.APPLICATION_NAME.............: Order Management fnd_global.APPLICATION_SHORT_NAME.......: ONT fnd_global.RESP_APPL_ID.................: 660 fnd_global.BASE_LANGUAGE................: US fnd_global.CONC_LOGIN_ID................: -1 fnd_global.CONC_PRIORITY_REQUEST........: fnd_global.CONC_PROCESS_ID..............: -1 fnd_global.CONC_PROGRAM_ID..............: -1 fnd_global.CONC_QUEUE_ID................: -1 fnd_global.CONC_REQUEST_ID..............: -1 fnd_global.CURRENT_LANGUAGE.............: US fnd_global.CUSTOMER_ID..................: -1 fnd_global.EMPLOYEE_ID..................: 14117 fnd_global.FORM_APPL_ID.................: -1 fnd_global.FORM_ID......................: -1 fnd_global.GET_SESSION_CONTEXT..........: 1 fnd_global.LANGUAGE_COUNT...............: 1 fnd_global.LOGIN_ID.....................: -1 fnd_global.NEWLINE......................: fnd_global.NLS_DATE_FORMAT..............: DD-MON-RR fnd_global.NLS_DATE_LANGUAGE............: AMERICAN fnd_global.NLS_LANGUAGE.................: AMERICAN fnd_global.NLS_NUMERIC_CHARACTERS.......: ., fnd_global.NLS_SORT.....................: BINARY fnd_global.NLS_TERRITORY................: AMERICA fnd_global.ORG_ID.......................: 1216 fnd_global.ORG_NAME.....................: XX00 fnd_global.PARTY_ID.....................: 107602 fnd_global.PER_BUSINESS_GROUP_ID........: 1215 fnd_global.PER_SECURITY_PROFILE_ID......: 302 fnd_global.PROG_APPL_ID.................: -1 fnd_global.QUEUE_APPL_ID................: -1 fnd_global.RT_TEST_ID...................: -1 fnd_global.SECURITY_GROUP_ID............: 0 fnd_global.SERVER_ID....................: -1 fnd_global.SESSION_ID...................: 67012810 fnd_global.SUPPLIER_ID..................: -1 fnd_global.TAB..........................: USERENV('CLIENT_INFO')..................: 1216
----------------------------------------------------------- GL_SET_OF_BOOKS ----------------------------------------------------------- Current set of books id.................: 223 Current Set of books name...............: XXX Inc.
----------------------------------------------------------- AR_SYSTEM_PARAMETERS ----------------------------------------------------------- DEFAULT_GROUPING_RULE_ID................: -1 SALESREP_REQUIRED_FLAG..................: N ATTRIBUTE11.............................: ATTRIBUTE12.............................: ATTRIBUTE13.............................: ATTRIBUTE14.............................: ATTRIBUTE15.............................: AUTO_REC_INVOICES_PER_COMMIT............: 100 AUTO_REC_RECEIPTS_PER_COMMIT............: 100 PAY_UNRELATED_INVOICES_FLAG.............: N PRINT_HOME_COUNTRY_FLAG.................: N LOCATION_TAX_ACCOUNT....................: 106478 FROM_POSTAL_CODE........................: 00000 TO_POSTAL_CODE..........................: 99999-9999 TAX_REGISTRATION_NUMBER.................: POPULATE_GL_SEGMENTS_FLAG...............: Y UNALLOCATED_REVENUE_CCID................: ORG_ID..................................: 1216 ATTRIBUTE9..............................: ATTRIBUTE10.............................: CALC_DISCOUNT_ON_LINES_FLAG.............: L CHANGE_PRINTED_INVOICE_FLAG.............: Y CODE_COMBINATION_ID_LOSS................: 106477 CREATE_RECIPROCAL_FLAG..................: N DEFAULT_COUNTRY.........................: JP DEFAULT_TERRITORY.......................: SALES GENERATE_CUSTOMER_NUMBER................: Y INVOICE_DELETION_FLAG...................: Y LOCATION_STRUCTURE_ID...................: 1 SITE_REQUIRED_FLAG......................: Y TAX_ALLOW_COMPOUND_FLAG.................: N TAX_INVOICE_PRINT.......................: TOTAL ONLY TAX_METHOD..............................: VAT TAX_USE_CUSTOMER_EXEMPT_FLAG............: Y TAX_USE_CUST_EXC_RATE_FLAG..............: Y TAX_USE_LOC_EXC_RATE_FLAG...............: Y TAX_USE_PRODUCT_EXEMPT_FLAG.............: Y TAX_USE_PROD_EXC_RATE_FLAG..............: Y TAX_USE_SITE_EXC_RATE_FLAG..............: Y AI_LOG_FILE_MESSAGE_LEVEL...............: 1 AI_MAX_MEMORY_IN_BYTES..................: 3000000 AI_ACCT_FLEX_KEY_LEFT_PROMPT............: ACCT AI_MTL_ITEMS_KEY_LEFT_PROMPT............: AI_TERRITORY_KEY_LEFT_PROMPT............: Segment1 AI_PURGE_INTERFACE_TABLES_FLAG..........: Y AI_ACTIVATE_SQL_TRACE_FLAG..............: N SET_OF_BOOKS_ID.........................: 223 CREATED_BY..............................: -1 CREATION_DATE...........................: 04-MAY-00 LAST_UPDATED_BY.........................: 8899 LAST_UPDATE_DATE........................: 19-FEB-09 LAST_UPDATE_LOGIN.......................: 12431722 ACCOUNTING_METHOD.......................: ACCRUAL ACCRUE_INTEREST.........................: Y UNEARNED_DISCOUNT.......................: N PARTIAL_DISCOUNT_FLAG...................: Y PRINT_REMIT_TO..........................: N DEFAULT_CB_DUE_DATE.....................: DUE_DATE AUTO_SITE_NUMBERING.....................: N CASH_BASIS_SET_OF_BOOKS_ID..............: CODE_COMBINATION_ID_GAIN................: 106476 AUTOCASH_HIERARCHY_ID...................: 1000 RUN_GL_JOURNAL_IMPORT_FLAG..............: Y CER_SPLIT_AMOUNT........................: 1000 CER_DSO_DAYS............................: 90 POSTING_DAYS_PER_CYCLE..................: 17 ADDRESS_VALIDATION......................: NOVAL ATTRIBUTE1..............................: ATTRIBUTE2..............................: ATTRIBUTE_CATEGORY......................: ATTRIBUTE3..............................: ATTRIBUTE4..............................: ATTRIBUTE5..............................: ATTRIBUTE6..............................: ATTRIBUTE7..............................: ATTRIBUTE8..............................: TAX_CODE................................: Excl. Standard TAX_CURRENCY_CODE.......................: XXX TAX_HEADER_LEVEL_FLAG...................: N TAX_MINIMUM_ACCOUNTABLE_UNIT............: TAX_PRECISION...........................: 0 TAX_ROUNDING_RULE.......................: NEAREST GLOBAL_ATTRIBUTE1.......................: GLOBAL_ATTRIBUTE2.......................: GLOBAL_ATTRIBUTE3.......................: GLOBAL_ATTRIBUTE4.......................: GLOBAL_ATTRIBUTE5.......................: GLOBAL_ATTRIBUTE6.......................: GLOBAL_ATTRIBUTE7.......................: GLOBAL_ATTRIBUTE8.......................: GLOBAL_ATTRIBUTE9.......................: GLOBAL_ATTRIBUTE10......................: GLOBAL_ATTRIBUTE11......................: GLOBAL_ATTRIBUTE12......................: GLOBAL_ATTRIBUTE13......................: GLOBAL_ATTRIBUTE14......................: GLOBAL_ATTRIBUTE15......................: GLOBAL_ATTRIBUTE16......................: GLOBAL_ATTRIBUTE17......................: GLOBAL_ATTRIBUTE18......................: GLOBAL_ATTRIBUTE19......................: GLOBAL_ATTRIBUTE20......................: GLOBAL_ATTRIBUTE_CATEGORY...............: TAX_ROUNDING_ALLOW_OVERRIDE.............: N RULE_SET_ID.............................: 3 TAX_USE_ACCOUNT_EXC_RATE_FLAG...........: N TAX_USE_SYSTEM_EXC_RATE_FLAG............: Y TAX_HIER_SITE_EXC_RATE..................: 1 TAX_HIER_CUST_EXC_RATE..................: 2 TAX_HIER_PROD_EXC_RATE..................: 3 TAX_HIER_ACCOUNT_EXC_RATE...............: TAX_HIER_SYSTEM_EXC_RATE................: 4 TAX_ENFORCE_ACCOUNT_FLAG................: N TAX_DATABASE_VIEW_SET...................: O INCLUSIVE_TAX_USED......................: N CODE_COMBINATION_ID_ROUND...............: 106479 TRX_HEADER_LEVEL_ROUNDING...............: N TRX_HEADER_ROUND_CCID...................: FINCHRG_RECEIVABLES_TRX_ID..............: SALES_TAX_GEOCODE.......................: BILLS_RECEIVABLE_ENABLED_FLAG...........: TA_INSTALLED_FLAG.......................: N REV_TRANSFER_CLEAR_CCID.................: SALES_CREDIT_PCT_LIMIT..................: MAX_WRTOFF_AMOUNT.......................: 9999999 IREC_CC_RECEIPT_METHOD_ID...............: SHOW_BILLING_NUMBER_FLAG................: Y CROSS_CURRENCY_RATE_TYPE................: DOCUMENT_SEQ_GEN_LEVEL..................: WHEN_TRX_COMMITTED CALC_TAX_ON_CREDIT_MEMO_FLAG............: N IREC_BA_RECEIPT_METHOD_ID...............: PAYMENT_THRESHOLD.......................: STANDARD_REFUND.........................: CREDIT_CLASSIFICATION1..................: CREDIT_CLASSIFICATION2..................: CREDIT_CLASSIFICATION3..................: UNMTCH_CLAIM_CREATION_FLAG..............: MATCHED_CLAIM_CREATION_FLAG.............: MATCHED_CLAIM_EXCL_CM_FLAG..............: MIN_WRTOFF_AMOUNT.......................: -999999 MIN_REFUND_AMOUNT.......................:
----------------------------------------------------------- OE_SYS_PARAMS_UPG ----------------------------------------------------------- ROW_ID..................................: AABHxHAEaAAAXQeAAI ORG_ID..................................: 1216 ORGANIZATION_NAME.......................: XX00 CREATION_DATE...........................: 31-OCT-08 CREATED_BY..............................: 21504 LAST_UPDATE_DATE........................: 31-OCT-08 LAST_UPDATED_BY.........................: 21504 LAST_UPDATE_LOGIN.......................: 11804818 MASTER_ORGANIZATION_ID..................: 1378 MASTER_ORGANIZATION_NAME................: XX: XXX Inc. CUSTOMER_RELATIONSHIPS_FLAG.............: Y AUDIT_TRAIL_ENABLE_FLAG.................: B COMPUTE_MARGIN_FLAG.....................: FREIGHT_RATING_ENABLED_FLAG.............: FTE_SHIP_METHOD_ENABLED_FLAG............: CONTEXT.................................: ATTRIBUTE1..............................: ATTRIBUTE2..............................: ATTRIBUTE3..............................: ATTRIBUTE4..............................: ATTRIBUTE5..............................: ATTRIBUTE6..............................: ATTRIBUTE7..............................: ATTRIBUTE8..............................: ATTRIBUTE9..............................: ATTRIBUTE10.............................: ATTRIBUTE11.............................: ATTRIBUTE12.............................: ATTRIBUTE13.............................: ATTRIBUTE14.............................: ATTRIBUTE15.............................:
----------------------------------------------------------- AP_SYSTEM_PARAMETERS ----------------------------------------------------------- EXPENSE_REPORT_ID.......................: LAST_UPDATE_DATE........................: 06-MAR-09 LAST_UPDATED_BY.........................: 8899 SET_OF_BOOKS_ID.........................: 223 BASE_CURRENCY_CODE......................: XXX RECALC_PAY_SCHEDULE_FLAG................: Y AUTO_CALCULATE_INTEREST_FLAG............: N INVOICE_CURRENCY_CODE...................: XXX PAYMENT_CURRENCY_CODE...................: XXX INVOICE_NET_GROSS_FLAG..................: BANK_ACCOUNT_ID.........................: CHECK_OVERFLOW_LOOKUP_CODE..............: VOID EXCEPT LAST BATCH_CONTROL_FLAG......................: TERMS_ID................................: ALWAYS_TAKE_DISC_FLAG...................: N PAY_DATE_BASIS_LOOKUP_CODE..............: ACCTS_PAY_CODE_COMBINATION_ID...........: 106507 SALES_TAX_CODE_COMBINATION_ID...........: DISC_LOST_CODE_COMBINATION_ID...........: DISC_TAKEN_CODE_COMBINATION_ID..........: 106509 HOLD_GAIN_CODE_COMBINATION_ID...........: TRANS_GAIN_CODE_COMBINATION_ID..........: APPLY_ADVANCES_DEFAULT..................: N ADD_DAYS_SETTLEMENT_DATE................: COST_OF_MONEY...........................: DAYS_BETWEEN_CHECK_CYCLES...............: FEDERAL_IDENTIFICATION_NUM..............: LOCATION_ID.............................: CREATE_EMPLOYEE_VENDOR_FLAG.............: Y EMPLOYEE_TERMS_ID.......................: 10000 EMPLOYEE_PAY_GROUP_LOOKUP_CODE..........: EMPLOYEE_PAYMENT_PRIORITY...............: 1 PREPAY_CODE_COMBINATION_ID..............: 106508 CONFIRM_DATE_AS_INV_NUM_FLAG............: Y UPDATE_PAY_SITE_FLAG....................: N DEFAULT_EXCHANGE_RATE_TYPE..............: Corporate GAIN_CODE_COMBINATION_ID................: 106476 LOSS_CODE_COMBINATION_ID................: 106477 MAKE_RATE_MANDATORY_FLAG................: Y MULTI_CURRENCY_FLAG.....................: Y GL_DATE_FROM_RECEIPT_FLAG...............: I DISC_IS_INV_LESS_TAX_FLAG...............: Y MATCH_ON_TAX_FLAG.......................: ACCOUNTING_METHOD_OPTION................: Accrual EXPENSE_POST_OPTION.....................: DISCOUNT_TAKEN_POST_OPTION..............: GAIN_LOSS_POST_OPTION...................: CASH_POST_OPTION........................: FUTURE_PAY_POST_OPTION..................: DATE_FORMAT_LOOKUP_CODE.................: MMDDYY REPLACE_CHECK_FLAG......................: N ONLINE_PRINT_FLAG.......................: N EFT_USER_NUMBER.........................: MAX_OUTLAY..............................: VENDOR_PAY_GROUP_LOOKUP_CODE............: REQUIRE_TAX_ENTRY_FLAG..................: N APPROVALS_OPTION........................: BOTH POST_DATED_PAYMENTS_FLAG................: Y SECONDARY_ACCOUNTING_METHOD.............: SECONDARY_SET_OF_BOOKS_ID...............: TAKE_VAT_BEFORE_DISCOUNT_FLAG...........: INTEREST_TOLERANCE_AMOUNT...............: INTEREST_CODE_COMBINATION_ID............: TERMS_DATE_BASIS........................: Invoice ALLOW_FUTURE_PAY_FLAG...................: N AUTO_TAX_CALC_FLAG......................: L AUTOMATIC_OFFSETS_FLAG..................: N LIABILITY_POST_LOOKUP_CODE..............: INTEREST_ACCTS_PAY_CCID.................: LIABILITY_POST_OPTION...................: DISCOUNT_DISTRIBUTION_METHOD............: RATE_VAR_CODE_COMBINATION_ID............: COMBINED_FILING_FLAG....................: N INCOME_TAX_REGION.......................: INCOME_TAX_REGION_FLAG..................: HOLD_UNMATCHED_INVOICES_FLAG............: N ALLOW_DIST_MATCH_FLAG...................: N ALLOW_FINAL_MATCH_FLAG..................: Y ALLOW_FLEX_OVERRIDE_FLAG................: N ALLOW_PAID_INVOICE_ADJUST...............: Y USSGL_TRANSACTION_CODE..................: USSGL_TRX_CODE_CONTEXT..................: INV_DOC_CATEGORY_OVERRIDE...............: N PAY_DOC_CATEGORY_OVERRIDE...............: Y VENDOR_AUTO_INT_DEFAULT.................: SUMMARY_JOURNALS_DEFAULT................: N RATE_VAR_GAIN_CCID......................: 106509 RATE_VAR_LOSS_CCID......................: 106476 TRANSFER_DESC_FLEX_FLAG.................: N ALLOW_AWT_FLAG..........................: Y DEFAULT_AWT_GROUP_ID....................: ALLOW_AWT_OVERRIDE......................: N CREATE_AWT_DISTS_TYPE...................: PAYMENT CREATE_AWT_INVOICES_TYPE................: NEVER AWT_INCLUDE_DISCOUNT_AMT................: N AWT_INCLUDE_TAX_AMT.....................: N ORG_ID..................................: 1216 RECON_ACCOUNTING_FLAG...................: N AUTO_CREATE_FREIGHT_FLAG................: N FREIGHT_CODE_COMBINATION_ID.............: GLOBAL_ATTRIBUTE_CATEGORY...............: GLOBAL_ATTRIBUTE1.......................: GLOBAL_ATTRIBUTE2.......................: GLOBAL_ATTRIBUTE3.......................: GLOBAL_ATTRIBUTE4.......................: GLOBAL_ATTRIBUTE5.......................: GLOBAL_ATTRIBUTE6.......................: GLOBAL_ATTRIBUTE7.......................: GLOBAL_ATTRIBUTE8.......................: GLOBAL_ATTRIBUTE9.......................: GLOBAL_ATTRIBUTE10......................: GLOBAL_ATTRIBUTE11......................: GLOBAL_ATTRIBUTE12......................: GLOBAL_ATTRIBUTE13......................: GLOBAL_ATTRIBUTE14......................: GLOBAL_ATTRIBUTE15......................: GLOBAL_ATTRIBUTE16......................: GLOBAL_ATTRIBUTE17......................: GLOBAL_ATTRIBUTE18......................: GLOBAL_ATTRIBUTE19......................: GLOBAL_ATTRIBUTE20......................: ALLOW_SUPPLIER_BANK_OVERRIDE............: N USE_MULTIPLE_SUPPLIER_BANKS.............: N AUTO_TAX_CALC_OVERRIDE..................: Y AMOUNT_INCLUDES_TAX_FLAG................: Y AMOUNT_INCLUDES_TAX_OVERRIDE............: Y VAT_CODE................................: Standard USE_BANK_CHARGE_FLAG....................: N BANK_CHARGE_BEARER......................: ROUNDING_ERROR_CCID.....................: 106479 ROUNDING_ERROR_POST_OPTION..............: TAX_FROM_PO_FLAG........................: Y TAX_FROM_VENDOR_SITE_FLAG...............: Y TAX_FROM_VENDOR_FLAG....................: TAX_FROM_ACCOUNT_FLAG...................: Y TAX_FROM_SYSTEM_FLAG....................: Y TAX_FROM_INV_HEADER_FLAG................: Y TAX_FROM_TEMPLATE_FLAG..................: N TAX_HIER_PO_SHIPMENT....................: 3 TAX_HIER_VENDOR.........................: TAX_HIER_VENDOR_SITE....................: 4 TAX_HIER_ACCOUNT........................: 1 TAX_HIER_SYSTEM.........................: 5 TAX_HIER_INVOICE........................: 2 TAX_HIER_TEMPLATE.......................: ENFORCE_TAX_FROM_ACCOUNT................: MRC_BASE_CURRENCY_CODE..................: MRC_SECONDARY_SET_OF_BOOKS_ID...........: MATCH_OPTION............................: GAIN_LOSS_CALC_LEVEL....................: PAYMENT LINE WHEN_TO_ACCOUNT_PMT.....................: ALWAYS WHEN_TO_ACCOUNT_GAIN_LOSS...............: FUTURE_DATED_PMT_ACCT_SOURCE............: BANK ACCOUNT FUTURE_DATED_PMT_LIAB_RELIEF............: ISSUE GL_TRANSFER_ALLOW_OVERRIDE..............: GL_TRANSFER_PROCESS_DAYS................: GL_TRANSFER_MODE........................: GL_TRANSFER_SUBMIT_JOURNAL_IMP..........: Y INCLUDE_REPORTING_SOB...................: PREPAYMENT_TERMS_ID.....................: CALC_USER_XRATE.........................: SORT_BY_ALTERNATE_FIELD.................: APPROVAL_WORKFLOW_FLAG..................: N ALLOW_FORCE_APPROVAL_FLAG...............: N VALIDATE_BEFORE_APPROVAL_FLAG...........: N XML_PAYMENTS_AUTO_CONFIRM_FLAG..........: PRORATE_INT_INV_ACROSS_DISTS............: BUILD_PREPAYMENT_ACCOUNTS_FLAG..........: ENABLE_1099_ON_AWT_FLAG.................: STOP_PREPAY_ACROSS_BAL_FLAG.............: AUTOMATIC_OFFSETS_CHANGE_FLAG...........: TOLERANCE_ID............................: TAX_TOLERANCE...........................: TAX_TOL_AMT_RANGE.......................: SERVICES_TOLERANCE_ID...................:
----------------------------------------------------------- CE_SYSTEM_PARAMETERS ----------------------------------------------------------- ----------------------------------------------------------- CS_SYSTEM_PARAMETERS ----------------------------------------------------------- ----------------------------------------------------------- PO_SYSTEM_PARAMETERS ----------------------------------------------------------- PO_DOCUMENT_PRINT_FLAG..................: RFQ_DOCUMENT_REPORT_ID..................: RFQ_DOCUMENT_PRINT_FLAG.................: LINE_TYPE_ID............................: 1 RECEIVING_FLAG..........................: N ALLOW_ITEM_DESC_UPDATE_FLAG.............: Y DISPOSITION_WARNING_FLAG................: Y ENFORCE_FULL_LOT_QUANTITIES.............: ADVISORY SECURITY_POSITION_STRUCTURE_ID..........: MIN_RELEASE_AMOUNT......................: PRICE_TYPE_LOOKUP_CODE..................: FIXED NOTIFICATION_WARNING_DELAY..............: PRICE_BREAK_LOOKUP_CODE.................: CUMULATIVE INVOICE_CLOSE_CODE......................: RECEIVE_CLOSE_CODE......................: RECEIVED INVOICE_CLOSE_TOLERANCE.................: 5 RECEIVE_CLOSE_TOLERANCE.................: 0 CANCEL_REQS_ON_PO_CANCEL_FLAG...........: O REQUEST_ID..............................: PROGRAM_APPLICATION_ID..................: PROGRAM_ID..............................: PROGRAM_UPDATE_DATE.....................: REQIMPORT_GROUP_BY_CODE.................: ALL EXPENSE_ACCRUAL_CODE....................: RECEIPT INVENTORY_ACCRUAL_CODE..................: RECEIPT ORDER_TYPE_ID...........................: ORDER_SOURCE_ID.........................: 10 SALESREP_ID.............................: TERM_ID.................................: ORG_ID..................................: 1216 LAST_UPDATE_DATE........................: 10-NOV-09 LAST_UPDATED_BY.........................: 12100 LAST_UPDATE_LOGIN.......................: 14138392 CREATION_DATE...........................: 03-NOV-08 CREATED_BY..............................: 21504 ACCRUED_CODE_COMBINATION_ID.............: 112046 PRICE_CHANGE_ALLOWANCE..................: 0 REQ_CAN_AUTHORIZE.......................: INSPECTION_REQUIRED_FLAG................: N ENFORCE_PRICE_CHANGE_ALLOWANCE..........: N DEFAULT_RATE_TYPE.......................: Corporate TAXABLE_FLAG............................: N USER_DEFINED_RECEIPT_NUM_CODE...........: MANUAL MANUAL_RECEIPT_NUM_TYPE.................: ALPHANUMERIC USER_DEFINED_QUOTE_NUM_CODE.............: AUTOMATIC MANUAL_QUOTE_NUM_TYPE...................: NUMERIC USER_DEFINED_RFQ_NUM_CODE...............: AUTOMATIC MANUAL_RFQ_NUM_TYPE.....................: NUMERIC USER_DEFINED_PO_NUM_CODE................: AUTOMATIC MANUAL_PO_NUM_TYPE......................: NUMERIC USER_DEFINED_REQ_NUM_CODE...............: AUTOMATIC MANUAL_REQ_NUM_TYPE.....................: NUMERIC DEFAULT_QUOTE_WARNING_DELAY.............: ENFORCE_BUYER_AUTHORITY_FLAG............: ENFORCE_BUYER_NAME_FLAG.................: N ENFORCE_VENDOR_HOLD_FLAG................: N NOTIFY_IF_BLANKET_FLAG..................: N RFQ_REQUIRED_FLAG.......................: N PO_DOCUMENT_REPORT_ID...................: NEXT_APPROVER_LOOKUP_CODE...............: GLOBAL_ATTRIBUTE_CATEGORY...............: GLOBAL_ATTRIBUTE1.......................: GLOBAL_ATTRIBUTE2.......................: GLOBAL_ATTRIBUTE3.......................: GLOBAL_ATTRIBUTE4.......................: GLOBAL_ATTRIBUTE5.......................: GLOBAL_ATTRIBUTE6.......................: GLOBAL_ATTRIBUTE7.......................: GLOBAL_ATTRIBUTE8.......................: GLOBAL_ATTRIBUTE9.......................: GLOBAL_ATTRIBUTE10......................: GLOBAL_ATTRIBUTE11......................: GLOBAL_ATTRIBUTE12......................: GLOBAL_ATTRIBUTE13......................: GLOBAL_ATTRIBUTE14......................: GLOBAL_ATTRIBUTE15......................: GLOBAL_ATTRIBUTE16......................: GLOBAL_ATTRIBUTE17......................: GLOBAL_ATTRIBUTE18......................: GLOBAL_ATTRIBUTE19......................: GLOBAL_ATTRIBUTE20......................: TAX_FROM_SHIP_TO_LOC_FLAG...............: N TAX_FROM_ITEM_FLAG......................: N TAX_FROM_VENDOR_FLAG....................: Y TAX_FROM_VENDOR_SITE_FLAG...............: Y TAX_FROM_SYSTEM_FLAG....................: Y TAX_HIER_SHIP_TO_LOC....................: TAX_HIER_ITEM...........................: TAX_HIER_VENDOR.........................: 2 TAX_HIER_VENDOR_SITE....................: 1 TAX_HIER_SYSTEM.........................: 3 CREATE_DEBIT_MEMO_FLAG..................: ENFORCE_PRICE_CHANGE_AMOUNT.............: N PRICE_CHANGE_AMOUNT.....................: AUTO_OFFSET_METHOD......................: PO_OUTPUT_FORMAT........................: PDF BUYING_COMPANY_IDENTIFIER...............: GAPLESS_INV_NUM_FLAG....................:
----------------------------------------------------------- FINANCIALS_SYSTEM_PARAMETERS ----------------------------------------------------------- LAST_UPDATE_DATE........................: 10-FEB-09 LAST_UPDATED_BY.........................: 8899 SET_OF_BOOKS_ID.........................: 223 PAYMENT_METHOD_LOOKUP_CODE..............: WIRE USER_DEFINED_VENDOR_NUM_CODE............: AUTOMATIC VENDOR_NUM_START_NUM....................: SHIP_TO_LOCATION_ID.....................: 137039 BILL_TO_LOCATION_ID.....................: 131492 SHIP_VIA_LOOKUP_CODE....................: FOB_LOOKUP_CODE.........................: TERMS_ID................................: ALWAYS_TAKE_DISC_FLAG...................: N PAY_DATE_BASIS_LOOKUP_CODE..............: INVOICE_CURRENCY_CODE...................: XXX PAYMENT_CURRENCY_CODE...................: XXX ACCTS_PAY_CODE_COMBINATION_ID...........: 106507 PREPAY_CODE_COMBINATION_ID..............: 106508 DISC_TAKEN_CODE_COMBINATION_ID..........: 106509 FUTURE_PERIOD_LIMIT.....................: 1 RESERVE_AT_COMPLETION_FLAG..............: N RES_ENCUMB_CODE_COMBINATION_ID..........: REQ_ENCUMBRANCE_FLAG....................: N REQ_ENCUMBRANCE_TYPE_ID.................: PURCH_ENCUMBRANCE_FLAG..................: N PURCH_ENCUMBRANCE_TYPE_ID...............: INV_ENCUMBRANCE_TYPE_ID.................: MANUAL_VENDOR_NUM_TYPE..................: NUMERIC INVENTORY_ORGANIZATION_ID...............: 1378 LAST_UPDATE_LOGIN.......................: 12375827 CREATION_DATE...........................: 07-AUG-08 CREATED_BY..............................: 1138 FREIGHT_TERMS_LOOKUP_CODE...............: RFQ_ONLY_SITE_FLAG......................: N RECEIPT_ACCEPTANCE_DAYS.................: BUSINESS_GROUP_ID.......................: 1215 EXPENSE_CHECK_ADDRESS_FLAG..............: O TERMS_DATE_BASIS........................: Invoice USE_POSITIONS_FLAG......................: N RATE_VAR_CODE_COMBINATION_ID............: HOLD_UNMATCHED_INVOICES_FLAG............: N EXCLUSIVE_PAYMENT_FLAG..................: N REVISION_SORT_ORDERING..................: VAT_REGISTRATION_NUM....................: VAT_COUNTRY_CODE........................: RATE_VAR_GAIN_CCID......................: 106509 RATE_VAR_LOSS_CCID......................: 106476 ORG_ID..................................: 1216 BANK_CHARGE_BEARER......................: VAT_CODE................................: Standard MATCH_OPTION............................: P NON_RECOVERABLE_TAX_FLAG................: Y TAX_ROUNDING_RULE.......................: N PRECISION...............................: 0 MINIMUM_ACCOUNTABLE_UNIT................: DEFAULT_RECOVERY_RATE...................: 100 CASH_BASIS_ENC_NR_TAX...................: EXCLUDE RECOVERABLE TAX FUTURE_DATED_PAYMENT_CCID...............: EXPENSE_CLEARING_CCID...................: MISC_CHARGE_CCID........................: GLOBAL_ATTRIBUTE_CATEGORY...............: GLOBAL_ATTRIBUTE1.......................: GLOBAL_ATTRIBUTE2.......................: GLOBAL_ATTRIBUTE3.......................: GLOBAL_ATTRIBUTE4.......................: GLOBAL_ATTRIBUTE5.......................: GLOBAL_ATTRIBUTE6.......................: GLOBAL_ATTRIBUTE7.......................: GLOBAL_ATTRIBUTE8.......................: GLOBAL_ATTRIBUTE9.......................: GLOBAL_ATTRIBUTE10......................: GLOBAL_ATTRIBUTE11......................: GLOBAL_ATTRIBUTE12......................: GLOBAL_ATTRIBUTE13......................: GLOBAL_ATTRIBUTE14......................: GLOBAL_ATTRIBUTE15......................: GLOBAL_ATTRIBUTE16......................: GLOBAL_ATTRIBUTE17......................: GLOBAL_ATTRIBUTE18......................: GLOBAL_ATTRIBUTE19......................: GLOBAL_ATTRIBUTE20......................:
SQL>