Product: | AP - Payables |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -99 )
, AP.INVOICE_CURRENCY_CODE
, AP.PAYMENT_CURRENCY_CODE
, AP.LAST_UPDATE_DATE
, AP.LAST_UPDATED_BY
, AP.PAYMENT_METHOD_LOOKUP_CODE
, AP.USER_DEFINED_VENDOR_NUM_CODE
, AP.VENDOR_NUM_START_NUM
, AP.SHIP_TO_LOCATION_ID
, AP.BILL_TO_LOCATION_ID
, AP.SHIP_VIA_LOOKUP_CODE
, AP.FOB_LOOKUP_CODE
, AP.TERMS_ID
, AP.ALWAYS_TAKE_DISC_FLAG
, AP.PAY_DATE_BASIS_LOOKUP_CODE
, AP.ACCTS_PAY_CODE_COMBINATION_ID
, AP.PREPAY_CODE_COMBINATION_ID
, AP.DISC_TAKEN_CODE_COMBINATION_ID
, AP.FUTURE_PERIOD_LIMIT
, AP.RESERVE_AT_COMPLETION_FLAG
, AP.RES_ENCUMB_CODE_COMBINATION_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, AP.MANUAL_VENDOR_NUM_TYPE
, AP.INVENTORY_ORGANIZATION_ID
, AP.LAST_UPDATE_LOGIN
, AP.CREATION_DATE
, AP.CREATED_BY
, AP.FREIGHT_TERMS_LOOKUP_CODE
, AP.RFQ_ONLY_SITE_FLAG
, AP.RECEIPT_ACCEPTANCE_DAYS
, AP.BUSINESS_GROUP_ID
, AP.EXPENSE_CHECK_ADDRESS_FLAG
, AP.TERMS_DATE_BASIS
, AP.USE_POSITIONS_FLAG
, AP.RATE_VAR_CODE_COMBINATION_ID
, AP.HOLD_UNMATCHED_INVOICES_FLAG
, AP.EXCLUSIVE_PAYMENT_FLAG
, AP.REVISION_SORT_ORDERING
, AP.VAT_REGISTRATION_NUM
, AP.VAT_COUNTRY_CODE
, AP.RATE_VAR_GAIN_CCID
, AP.RATE_VAR_LOSS_CCID
, AP.ORG_ID
, AP.BANK_CHARGE_BEARER
, AP.VAT_CODE
, AP.MATCH_OPTION
, AP.NON_RECOVERABLE_TAX_FLAG
, AP.TAX_ROUNDING_RULE
, AP.PRECISION
, AP.MINIMUM_ACCOUNTABLE_UNIT
, AP.DEFAULT_RECOVERY_RATE
, AP.CASH_BASIS_ENC_NR_TAX
, AP.FUTURE_DATED_PAYMENT_CCID
, AP.EXPENSE_CLEARING_CCID
, AP.MISC_CHARGE_CCID
, AP.GLOBAL_ATTRIBUTE_CATEGORY
, AP.GLOBAL_ATTRIBUTE1
, AP.GLOBAL_ATTRIBUTE2
, AP.GLOBAL_ATTRIBUTE3
, AP.GLOBAL_ATTRIBUTE4
, AP.GLOBAL_ATTRIBUTE5
, AP.GLOBAL_ATTRIBUTE6
, AP.GLOBAL_ATTRIBUTE7
, AP.GLOBAL_ATTRIBUTE8
, AP.GLOBAL_ATTRIBUTE9
, AP.GLOBAL_ATTRIBUTE10
, AP.GLOBAL_ATTRIBUTE11
, AP.GLOBAL_ATTRIBUTE12
, AP.GLOBAL_ATTRIBUTE13
, AP.GLOBAL_ATTRIBUTE14
, AP.GLOBAL_ATTRIBUTE15
, AP.GLOBAL_ATTRIBUTE16
, AP.GLOBAL_ATTRIBUTE17
, AP.GLOBAL_ATTRIBUTE18
, AP.GLOBAL_ATTRIBUTE19
, AP.GLOBAL_ATTRIBUTE20
FROM FINANCIALS_SYSTEM_PARAMS_ALL AP