View: AP_SYSTEM_PARAMETERS_MRC_V

View Text

SELECT EXPENSE_REPORT_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, MC.REPORTING_SET_OF_BOOKS_ID
, MC.REPORTING_CURRENCY_CODE
, RECALC_PAY_SCHEDULE_FLAG
, AUTO_CALCULATE_INTEREST_FLAG
, INVOICE_CURRENCY_CODE
, PAYMENT_CURRENCY_CODE
, INVOICE_NET_GROSS_FLAG
, BANK_ACCOUNT_ID
, CHECK_OVERFLOW_LOOKUP_CODE
, BATCH_CONTROL_FLAG
, TERMS_ID
, ALWAYS_TAKE_DISC_FLAG
, PAY_DATE_BASIS_LOOKUP_CODE
, ACCTS_PAY_CODE_COMBINATION_ID
, SALES_TAX_CODE_COMBINATION_ID
, DISC_LOST_CODE_COMBINATION_ID
, DISC_TAKEN_CODE_COMBINATION_ID
, HOLD_GAIN_CODE_COMBINATION_ID
, TRANS_GAIN_CODE_COMBINATION_ID
, APPLY_ADVANCES_DEFAULT
, ADD_DAYS_SETTLEMENT_DATE
, COST_OF_MONEY
, DAYS_BETWEEN_CHECK_CYCLES
, FEDERAL_IDENTIFICATION_NUM
, LOCATION_ID
, CREATE_EMPLOYEE_VENDOR_FLAG
, EMPLOYEE_TERMS_ID
, EMPLOYEE_PAY_GROUP_LOOKUP_CODE
, EMPLOYEE_PAYMENT_PRIORITY
, PREPAY_CODE_COMBINATION_ID
, CONFIRM_DATE_AS_INV_NUM_FLAG
, UPDATE_PAY_SITE_FLAG
, DEFAULT_EXCHANGE_RATE_TYPE
, GAIN_CODE_COMBINATION_ID
, LOSS_CODE_COMBINATION_ID
, MAKE_RATE_MANDATORY_FLAG
, 'Y'
, GL_DATE_FROM_RECEIPT_FLAG
, DISC_IS_INV_LESS_TAX_FLAG
, MATCH_ON_TAX_FLAG
, ACCOUNTING_METHOD_OPTION
, EXPENSE_POST_OPTION
, DISCOUNT_TAKEN_POST_OPTION
, GAIN_LOSS_POST_OPTION
, CASH_POST_OPTION
, FUTURE_PAY_POST_OPTION
, DATE_FORMAT_LOOKUP_CODE
, REPLACE_CHECK_FLAG
, ONLINE_PRINT_FLAG
, EFT_USER_NUMBER
, MAX_OUTLAY
, VENDOR_PAY_GROUP_LOOKUP_CODE
, REQUIRE_TAX_ENTRY_FLAG
, APPROVALS_OPTION
, POST_DATED_PAYMENTS_FLAG
, SECONDARY_ACCOUNTING_METHOD
, MC.AP_SECONDARY_SET_OF_BOOKS_ID
, TAKE_VAT_BEFORE_DISCOUNT_FLAG
, INTEREST_TOLERANCE_AMOUNT
, INTEREST_CODE_COMBINATION_ID
, TERMS_DATE_BASIS
, ALLOW_FUTURE_PAY_FLAG
, AUTO_TAX_CALC_FLAG
, 'N'
, LIABILITY_POST_LOOKUP_CODE
, INTEREST_ACCTS_PAY_CCID
, LIABILITY_POST_OPTION
, DISCOUNT_DISTRIBUTION_METHOD
, RATE_VAR_CODE_COMBINATION_ID
, COMBINED_FILING_FLAG
, INCOME_TAX_REGION
, INCOME_TAX_REGION_FLAG
, HOLD_UNMATCHED_INVOICES_FLAG
, ALLOW_DIST_MATCH_FLAG
, ALLOW_FINAL_MATCH_FLAG
, ALLOW_FLEX_OVERRIDE_FLAG
, ALLOW_PAID_INVOICE_ADJUST
, USSGL_TRANSACTION_CODE
, USSGL_TRX_CODE_CONTEXT
, INV_DOC_CATEGORY_OVERRIDE
, PAY_DOC_CATEGORY_OVERRIDE
, VENDOR_AUTO_INT_DEFAULT
, SUMMARY_JOURNALS_DEFAULT
, RATE_VAR_GAIN_CCID
, RATE_VAR_LOSS_CCID
, TRANSFER_DESC_FLEX_FLAG
, ALLOW_AWT_FLAG
, DEFAULT_AWT_GROUP_ID
, ALLOW_AWT_OVERRIDE
, CREATE_AWT_DISTS_TYPE
, CREATE_AWT_INVOICES_TYPE
, AWT_INCLUDE_DISCOUNT_AMT
, AWT_INCLUDE_TAX_AMT
, B.ORG_ID
, RECON_ACCOUNTING_FLAG
, AUTO_CREATE_FREIGHT_FLAG
, FREIGHT_CODE_COMBINATION_ID
, B.GLOBAL_ATTRIBUTE_CATEGORY
, B.GLOBAL_ATTRIBUTE1
, B.GLOBAL_ATTRIBUTE2
, B.GLOBAL_ATTRIBUTE3
, B.GLOBAL_ATTRIBUTE4
, B.GLOBAL_ATTRIBUTE5
, B.GLOBAL_ATTRIBUTE6
, B.GLOBAL_ATTRIBUTE7
, B.GLOBAL_ATTRIBUTE8
, B.GLOBAL_ATTRIBUTE9
, B.GLOBAL_ATTRIBUTE10
, B.GLOBAL_ATTRIBUTE11
, B.GLOBAL_ATTRIBUTE12
, B.GLOBAL_ATTRIBUTE13
, B.GLOBAL_ATTRIBUTE14
, B.GLOBAL_ATTRIBUTE15
, B.GLOBAL_ATTRIBUTE16
, B.GLOBAL_ATTRIBUTE17
, B.GLOBAL_ATTRIBUTE18
, B.GLOBAL_ATTRIBUTE19
, B.GLOBAL_ATTRIBUTE20
, ALLOW_SUPPLIER_BANK_OVERRIDE
, USE_MULTIPLE_SUPPLIER_BANKS
, AUTO_TAX_CALC_OVERRIDE
, AMOUNT_INCLUDES_TAX_FLAG
, AMOUNT_INCLUDES_TAX_OVERRIDE
, VAT_CODE
, USE_BANK_CHARGE_FLAG
, BANK_CHARGE_BEARER
, ROUNDING_ERROR_CCID
, ROUNDING_ERROR_POST_OPTION
, TAX_FROM_PO_FLAG
, TAX_FROM_VENDOR_SITE_FLAG
, TAX_FROM_VENDOR_FLAG
, TAX_FROM_ACCOUNT_FLAG
, TAX_FROM_SYSTEM_FLAG
, TAX_FROM_INV_HEADER_FLAG
, TAX_FROM_TEMPLATE_FLAG
, TAX_HIER_PO_SHIPMENT
, TAX_HIER_VENDOR
, TAX_HIER_VENDOR_SITE
, TAX_HIER_ACCOUNT
, TAX_HIER_SYSTEM
, TAX_HIER_INVOICE
, TAX_HIER_TEMPLATE
, ENFORCE_TAX_FROM_ACCOUNT
, MRC_BASE_CURRENCY_CODE
, MRC_SECONDARY_SET_OF_BOOKS_ID
, MATCH_OPTION
, GAIN_LOSS_CALC_LEVEL
, WHEN_TO_ACCOUNT_PMT
, WHEN_TO_ACCOUNT_GAIN_LOSS
, FUTURE_DATED_PMT_ACCT_SOURCE
, FUTURE_DATED_PMT_LIAB_RELIEF
, GL_TRANSFER_ALLOW_OVERRIDE
, GL_TRANSFER_PROCESS_DAYS
, GL_TRANSFER_MODE
, GL_TRANSFER_SUBMIT_JOURNAL_IMP
, INCLUDE_REPORTING_SOB
, PREPAYMENT_TERMS_ID
, CALC_USER_XRATE
, SORT_BY_ALTERNATE_FIELD
, APPROVAL_WORKFLOW_FLAG
, ALLOW_FORCE_APPROVAL_FLAG
, VALIDATE_BEFORE_APPROVAL_FLAG
, 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
FROM AP_SYSTEM_PARAMETERS_ALL B
, GL_MC_REPORTING_OPTIONS MC
WHERE MC.REPORTING_SET_OF_BOOKS_ID = NVL (TO_NUMBER (SUBSTRB (USERENV ('CLIENT_INFO')
, 45
, 10))
, -99)
AND MC.APPLICATION_ID = 200
AND MC.ENABLED_FLAG = 'Y'
AND B.SET_OF_BOOKS_ID = MC.PRIMARY_SET_OF_BOOKS_ID
AND B.ORG_ID = MC.ORG_ID
AND NVL(B.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)

Columns