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.

VIEW: APPS.AR_SYSTEM_PARAMETERS_MRC_V

Source

View Text - Preformatted


SELECT DEFAULT_GROUPING_RULE_ID ,SALESREP_REQUIRED_FLAG ,ATTRIBUTE11 ,ATTRIBUTE12 ,ATTRIBUTE13 ,ATTRIBUTE14 ,ATTRIBUTE15 ,AUTO_REC_INVOICES_PER_COMMIT ,AUTO_REC_RECEIPTS_PER_COMMIT ,PAY_UNRELATED_INVOICES_FLAG ,PRINT_HOME_COUNTRY_FLAG ,LOCATION_TAX_ACCOUNT ,FROM_POSTAL_CODE ,TO_POSTAL_CODE ,TAX_REGISTRATION_NUMBER ,POPULATE_GL_SEGMENTS_FLAG ,UNALLOCATED_REVENUE_CCID ,ORG_ID ,ATTRIBUTE9 ,ATTRIBUTE10 ,CALC_DISCOUNT_ON_LINES_FLAG ,CHANGE_PRINTED_INVOICE_FLAG ,CODE_COMBINATION_ID_LOSS ,CREATE_RECIPROCAL_FLAG ,DEFAULT_COUNTRY ,DEFAULT_TERRITORY ,GENERATE_CUSTOMER_NUMBER ,INVOICE_DELETION_FLAG ,LOCATION_STRUCTURE_ID ,SITE_REQUIRED_FLAG ,TAX_ALLOW_COMPOUND_FLAG ,TAX_INVOICE_PRINT ,TAX_METHOD ,TAX_USE_CUSTOMER_EXEMPT_FLAG ,TAX_USE_CUST_EXC_RATE_FLAG ,TAX_USE_LOC_EXC_RATE_FLAG ,TAX_USE_PRODUCT_EXEMPT_FLAG ,TAX_USE_PROD_EXC_RATE_FLAG ,TAX_USE_SITE_EXC_RATE_FLAG ,AI_LOG_FILE_MESSAGE_LEVEL ,AI_MAX_MEMORY_IN_BYTES ,AI_ACCT_FLEX_KEY_LEFT_PROMPT ,AI_MTL_ITEMS_KEY_LEFT_PROMPT ,AI_TERRITORY_KEY_LEFT_PROMPT ,AI_PURGE_INTERFACE_TABLES_FLAG ,AI_ACTIVATE_SQL_TRACE_FLAG ,NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),45,10)),-99) ,CREATED_BY ,CREATION_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_DATE ,LAST_UPDATE_LOGIN ,ACCOUNTING_METHOD ,ACCRUE_INTEREST ,UNEARNED_DISCOUNT ,PARTIAL_DISCOUNT_FLAG ,PRINT_REMIT_TO ,DEFAULT_CB_DUE_DATE ,AUTO_SITE_NUMBERING ,CASH_BASIS_SET_OF_BOOKS_ID ,CODE_COMBINATION_ID_GAIN ,AUTOCASH_HIERARCHY_ID ,RUN_GL_JOURNAL_IMPORT_FLAG ,CER_SPLIT_AMOUNT ,CER_DSO_DAYS ,POSTING_DAYS_PER_CYCLE ,ADDRESS_VALIDATION ,ATTRIBUTE1 ,ATTRIBUTE2 ,ATTRIBUTE_CATEGORY ,ATTRIBUTE3 ,ATTRIBUTE4 ,ATTRIBUTE5 ,ATTRIBUTE6 ,ATTRIBUTE7 ,ATTRIBUTE8 ,TAX_CODE ,TAX_CURRENCY_CODE ,TAX_HEADER_LEVEL_FLAG ,TAX_MINIMUM_ACCOUNTABLE_UNIT ,TAX_PRECISION ,TAX_ROUNDING_RULE ,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 ,RULE_SET_ID ,TAX_USE_ACCOUNT_EXC_RATE_FLAG ,TAX_USE_SYSTEM_EXC_RATE_FLAG ,TAX_HIER_SITE_EXC_RATE ,TAX_HIER_CUST_EXC_RATE ,TAX_HIER_PROD_EXC_RATE ,TAX_HIER_ACCOUNT_EXC_RATE ,TAX_HIER_SYSTEM_EXC_RATE ,TAX_ENFORCE_ACCOUNT_FLAG ,TAX_DATABASE_VIEW_SET ,INCLUSIVE_TAX_USED ,CODE_COMBINATION_ID_ROUND ,TRX_HEADER_LEVEL_ROUNDING ,TRX_HEADER_ROUND_CCID ,FINCHRG_RECEIVABLES_TRX_ID ,SALES_TAX_GEOCODE , BILLS_RECEIVABLE_ENABLED_FLAG ,TA_INSTALLED_FLAG , REV_TRANSFER_CLEAR_CCID , SALES_CREDIT_PCT_LIMIT , MAX_WRTOFF_AMOUNT , IREC_CC_RECEIPT_METHOD_ID , SHOW_BILLING_NUMBER_FLAG , CROSS_CURRENCY_RATE_TYPE , DOCUMENT_SEQ_GEN_LEVEL , CALC_TAX_ON_CREDIT_MEMO_FLAG ,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 ,min_refund_amount FROM AR_SYSTEM_PARAMETERS_ALL WHERE NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT DEFAULT_GROUPING_RULE_ID
, SALESREP_REQUIRED_FLAG
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, AUTO_REC_INVOICES_PER_COMMIT
, AUTO_REC_RECEIPTS_PER_COMMIT
, PAY_UNRELATED_INVOICES_FLAG
, PRINT_HOME_COUNTRY_FLAG
, LOCATION_TAX_ACCOUNT
, FROM_POSTAL_CODE
, TO_POSTAL_CODE
, TAX_REGISTRATION_NUMBER
, POPULATE_GL_SEGMENTS_FLAG
, UNALLOCATED_REVENUE_CCID
, ORG_ID
, ATTRIBUTE9
, ATTRIBUTE10
, CALC_DISCOUNT_ON_LINES_FLAG
, CHANGE_PRINTED_INVOICE_FLAG
, CODE_COMBINATION_ID_LOSS
, CREATE_RECIPROCAL_FLAG
, DEFAULT_COUNTRY
, DEFAULT_TERRITORY
, GENERATE_CUSTOMER_NUMBER
, INVOICE_DELETION_FLAG
, LOCATION_STRUCTURE_ID
, SITE_REQUIRED_FLAG
, TAX_ALLOW_COMPOUND_FLAG
, TAX_INVOICE_PRINT
, TAX_METHOD
, TAX_USE_CUSTOMER_EXEMPT_FLAG
, TAX_USE_CUST_EXC_RATE_FLAG
, TAX_USE_LOC_EXC_RATE_FLAG
, TAX_USE_PRODUCT_EXEMPT_FLAG
, TAX_USE_PROD_EXC_RATE_FLAG
, TAX_USE_SITE_EXC_RATE_FLAG
, AI_LOG_FILE_MESSAGE_LEVEL
, AI_MAX_MEMORY_IN_BYTES
, AI_ACCT_FLEX_KEY_LEFT_PROMPT
, AI_MTL_ITEMS_KEY_LEFT_PROMPT
, AI_TERRITORY_KEY_LEFT_PROMPT
, AI_PURGE_INTERFACE_TABLES_FLAG
, AI_ACTIVATE_SQL_TRACE_FLAG
, NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -99)
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ACCOUNTING_METHOD
, ACCRUE_INTEREST
, UNEARNED_DISCOUNT
, PARTIAL_DISCOUNT_FLAG
, PRINT_REMIT_TO
, DEFAULT_CB_DUE_DATE
, AUTO_SITE_NUMBERING
, CASH_BASIS_SET_OF_BOOKS_ID
, CODE_COMBINATION_ID_GAIN
, AUTOCASH_HIERARCHY_ID
, RUN_GL_JOURNAL_IMPORT_FLAG
, CER_SPLIT_AMOUNT
, CER_DSO_DAYS
, POSTING_DAYS_PER_CYCLE
, ADDRESS_VALIDATION
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE_CATEGORY
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, TAX_CODE
, TAX_CURRENCY_CODE
, TAX_HEADER_LEVEL_FLAG
, TAX_MINIMUM_ACCOUNTABLE_UNIT
, TAX_PRECISION
, TAX_ROUNDING_RULE
, 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
, RULE_SET_ID
, TAX_USE_ACCOUNT_EXC_RATE_FLAG
, TAX_USE_SYSTEM_EXC_RATE_FLAG
, TAX_HIER_SITE_EXC_RATE
, TAX_HIER_CUST_EXC_RATE
, TAX_HIER_PROD_EXC_RATE
, TAX_HIER_ACCOUNT_EXC_RATE
, TAX_HIER_SYSTEM_EXC_RATE
, TAX_ENFORCE_ACCOUNT_FLAG
, TAX_DATABASE_VIEW_SET
, INCLUSIVE_TAX_USED
, CODE_COMBINATION_ID_ROUND
, TRX_HEADER_LEVEL_ROUNDING
, TRX_HEADER_ROUND_CCID
, FINCHRG_RECEIVABLES_TRX_ID
, SALES_TAX_GEOCODE
, BILLS_RECEIVABLE_ENABLED_FLAG
, TA_INSTALLED_FLAG
, REV_TRANSFER_CLEAR_CCID
, SALES_CREDIT_PCT_LIMIT
, MAX_WRTOFF_AMOUNT
, IREC_CC_RECEIPT_METHOD_ID
, SHOW_BILLING_NUMBER_FLAG
, CROSS_CURRENCY_RATE_TYPE
, DOCUMENT_SEQ_GEN_LEVEL
, CALC_TAX_ON_CREDIT_MEMO_FLAG
, 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
, MIN_REFUND_AMOUNT
FROM AR_SYSTEM_PARAMETERS_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)