View: AP_SYSTEM_PARAMETERS_EXTRACT_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.AP_SYSTEM_PARAMETERS_EXTRACT_V

View Text

SELECT ASP.ROUNDING_ERROR_CCID ASP_ROUNDING_ERROR_CCID
, ASP.GAIN_CODE_COMBINATION_ID ASP_GAIN_CCID
, ASP.LOSS_CODE_COMBINATION_ID ASP_LOSS_CCID
, FSP.INV_ENCUMBRANCE_TYPE_ID FSP_INV_ENCUMBRANCE_TYPE_ID
, ASP.DISC_LOST_CODE_COMBINATION_ID ASP_DISC_LOST_CCID
, ASP.DISC_TAKEN_CODE_COMBINATION_ID ASP_DISC_TAKEN_CCID
, ASP.HOLD_GAIN_CODE_COMBINATION_ID ASP_HOLD_GAIN_CCID
, ASP.FEDERAL_IDENTIFICATION_NUM ASP_FEDERAL_ID_NUM
, ASP.INTEREST_CODE_COMBINATION_ID ASP_INTEREST_CCID
, ASP.RATE_VAR_GAIN_CCID ASP_RATE_VAR_GAIN_CCID
, ASP.RATE_VAR_LOSS_CCID ASP_RATE_VAR_LOSS_CCID
, ASP.PREPAY_TAX_DIFF_CCID ASP_PREPAY_TAX_DIFF_CCID
, ASP.GLOBAL_ATTRIBUTE_CATEGORY ASP_GLOBAL_ATTRIBUTE_CATEGORY
, ASP.GLOBAL_ATTRIBUTE1 ASP_GLOBAL_ATTRIBUTE_1
, ASP.GLOBAL_ATTRIBUTE2 ASP_GLOBAL_ATTRIBUTE_2
, ASP.GLOBAL_ATTRIBUTE3 ASP_GLOBAL_ATTRIBUTE_3
, ASP.GLOBAL_ATTRIBUTE4 ASP_GLOBAL_ATTRIBUTE_4
, ASP.GLOBAL_ATTRIBUTE5 ASP_GLOBAL_ATTRIBUTE_5
, ASP.GLOBAL_ATTRIBUTE6 ASP_GLOBAL_ATTRIBUTE_6
, ASP.GLOBAL_ATTRIBUTE7 ASP_GLOBAL_ATTRIBUTE_7
, ASP.GLOBAL_ATTRIBUTE8 ASP_GLOBAL_ATTRIBUTE_8
, ASP.GLOBAL_ATTRIBUTE9 ASP_GLOBAL_ATTRIBUTE_9
, ASP.GLOBAL_ATTRIBUTE10 ASP_GLOBAL_ATTRIBUTE_10
, ASP.GLOBAL_ATTRIBUTE11 ASP_GLOBAL_ATTRIBUTE_11
, ASP.GLOBAL_ATTRIBUTE12 ASP_GLOBAL_ATTRIBUTE_12
, ASP.GLOBAL_ATTRIBUTE13 ASP_GLOBAL_ATTRIBUTE_13
, ASP.GLOBAL_ATTRIBUTE14 ASP_GLOBAL_ATTRIBUTE_14
, ASP.GLOBAL_ATTRIBUTE15 ASP_GLOBAL_ATTRIBUTE_15
, ASP.GLOBAL_ATTRIBUTE16 ASP_GLOBAL_ATTRIBUTE_16
, ASP.GLOBAL_ATTRIBUTE17 ASP_GLOBAL_ATTRIBUTE_17
, ASP.GLOBAL_ATTRIBUTE18 ASP_GLOBAL_ATTRIBUTE_18
, ASP.GLOBAL_ATTRIBUTE19 ASP_GLOBAL_ATTRIBUTE_19
, ASP.GLOBAL_ATTRIBUTE20 ASP_GLOBAL_ATTRIBUTE_20
, NVL(ASP.DISCOUNT_DISTRIBUTION_METHOD
, 'SYSTEM') ASP_DISCOUNT_DIST_METHOD
, ASP.FUTURE_DATED_PMT_ACCT_SOURCE ASP_FD_PMT_ACCT_SOURCE
, ASP.GAIN_LOSS_CALC_LEVEL ASP_GAIN_LOSS_CALC_LEVEL
, DECODE (ASP.AUTOMATIC_OFFSETS_FLAG
, 'Y'
, DECODE( ASP.LIABILITY_POST_LOOKUP_CODE
, 'ACCOUNT_SEGMENT_VALUE'
, 'ACCOUNT_SEGMENT_VALUE'
, 'BALANCING_SEGMENT'
, 'BALANCING_SEGMENT'
, 'NONE')
, 'NONE') ASP_AUTOMATIC_OFFSETS_VALUE
, NVL(ASP.PRORATE_INT_INV_ACROSS_DISTS
, 'N') ASP_PRORATE_INT_ACROSS_DISTS
, NVL(ASP.BUILD_PREPAYMENT_ACCOUNTS_FLAG
, 'N') ASP_BUILD_PREPAY_ACCOUNTS_FLAG
, DECODE (ASP.WHEN_TO_ACCOUNT_PMT
, 'CLEARING ONLY'
, 'CLEAR_CLEAR'
, 'ALWAYS'
, DECODE (ASP.RECON_ACCOUNTING_FLAG
, 'N'
, 'ISSUE_ISSUE'
, 'Y'
, DECODE( NVL(ASP.WHEN_TO_ACCOUNT_GAIN_LOSS
, 'ALWAYS')
, 'CLEARING ONLY'
, 'ALWAYS_CLEAR'
, 'ALWAYS'
, 'ALWAYS_ALWAYS'))
, 'ALWAYS_ALWAYS') ASP_WHEN_TO_ACCOUNT_PMT
, DECODE(ASP.WHEN_TO_ACCOUNT_GAIN_LOSS
, 'CLEARING ONLY'
, 'CLEAR ONLY'
, 'ALWAYS'
, DECODE(ASP.RECON_ACCOUNTING_FLAG
, 'Y'
, 'ISSUE
AND CLEAR'
, 'N'
, 'ISSUE'
, 'ISSUE
AND CLEAR')
, 'ISSUE
AND CLEAR') ASP_WHEN_TO_ACCOUNT_GAIN_LOSS
, ASP.ORG_ID ASP_ORG_ID
, ASP.SET_OF_BOOKS_ID ASP_SET_OF_BOOKS_ID
, DECODE(ASP.CREATE_AWT_DISTS_TYPE
, 'PAYMENT'
, 'Y'
, 'N') AWT_AT_PMT_TIME
, ASP.BASE_CURRENCY_CODE LEDGER_CURRENCY
, NVL(ASP.AWT_INCLUDE_DISCOUNT_AMT
, 'N') ASP_AWT_INCLUDE_DISCOUNT_AMT
, NVL(ASP.AWT_INCLUDE_TAX_AMT
, 'N') ASP_AWT_INLUDE_TAX_AMT
, NVL(ASP.FUTURE_DATED_PMT_LIAB_RELIEF
, 'MATURITY') ASP_FD_PMT_LIAB_RELIEF
, FSP.DISC_TAKEN_CODE_COMBINATION_ID FSP_DISC_TAKEN_CCID
, FSP.FUTURE_DATED_PAYMENT_CCID FSP_FUTURE_DATED_PAYMENT_CCID
, NVL(FSP.PURCH_ENCUMBRANCE_FLAG
, 'N') FSP_PURCH_ENCUMBRANCE_FLAG
, NVL(FSP.RESERVE_AT_COMPLETION_FLAG
, 'N') FSP_RESERVE_AT_COMPLETION_FLAG
, NVL(FSP.REQ_ENCUMBRANCE_FLAG
, 'N') FSP_REQ_ENCUMBRANCE_FLAG
, FSP.RETAINAGE_CODE_COMBINATION_ID FSP_RETAINAGE_ACCOUNT
, NVL(ASP.AUTOMATIC_OFFSETS_FLAG
, 'N') ASP_AUTO_OFFSET_FLAG
FROM AP_SYSTEM_PARAMETERS_ALL ASP
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
WHERE ASP.ORG_ID = FSP.ORG_ID