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.AP_SYSTEM_PARAMETERS_EXTRACT_V

Source

View Text - Preformatted


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
  ,NVL(ASP.INVRATE_FOR_PREPAY_TAX, 'N')          INVRATE_FOR_PREPAY_TAX   --bug11715802,11651946
   FROM AP_SYSTEM_PARAMETERS_ALL ASP,
        FINANCIALS_SYSTEM_PARAMS_ALL FSP
  WHERE ASP.org_id = FSP.org_id

View Text - HTML Formatted

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
, NVL(ASP.INVRATE_FOR_PREPAY_TAX
, 'N') INVRATE_FOR_PREPAY_TAX --BUG11715802
, 11651946
FROM AP_SYSTEM_PARAMETERS_ALL ASP
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
WHERE ASP.ORG_ID = FSP.ORG_ID