@info

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>

 

Leave a Reply