1. Tables and Views for Financials
  2. AP_SYSTEM_PARAMETERS_EXTRACT_V

AP_SYSTEM_PARAMETERS_EXTRACT_V

Details

  • Schema: FUSION

  • Object owner: AP

  • Object type: VIEW

Columns

Name

ASP_ROUNDING_ERROR_CCID

ASP_GAIN_CCID

ASP_LOSS_CCID

ASP_DISC_TAKEN_CCID

ASP_FEDERAL_ID_NUM

ASP_INTEREST_CCID

ASP_RATE_VAR_GAIN_CCID

ASP_RATE_VAR_LOSS_CCID

ASP_PREPAY_TAX_DIFF_CCID

ASP_GLOBAL_ATTRIBUTE_CATEGORY

ASP_GLOBAL_ATTRIBUTE_1

ASP_GLOBAL_ATTRIBUTE_2

ASP_GLOBAL_ATTRIBUTE_3

ASP_GLOBAL_ATTRIBUTE_4

ASP_GLOBAL_ATTRIBUTE_5

ASP_GLOBAL_ATTRIBUTE_6

ASP_GLOBAL_ATTRIBUTE_7

ASP_GLOBAL_ATTRIBUTE_8

ASP_GLOBAL_ATTRIBUTE_9

ASP_GLOBAL_ATTRIBUTE_10

ASP_GLOBAL_ATTRIBUTE_11

ASP_GLOBAL_ATTRIBUTE_12

ASP_GLOBAL_ATTRIBUTE_13

ASP_GLOBAL_ATTRIBUTE_14

ASP_GLOBAL_ATTRIBUTE_15

ASP_GLOBAL_ATTRIBUTE_16

ASP_GLOBAL_ATTRIBUTE_17

ASP_GLOBAL_ATTRIBUTE_18

ASP_GLOBAL_ATTRIBUTE_19

ASP_GLOBAL_ATTRIBUTE_20

ASP_GLOBAL_ATTRIBUTE_NUMBER_1

ASP_GLOBAL_ATTRIBUTE_NUMBER_2

ASP_GLOBAL_ATTRIBUTE_NUMBER_3

ASP_GLOBAL_ATTRIBUTE_NUMBER_4

ASP_GLOBAL_ATTRIBUTE_NUMBER_5

ASP_GLOBAL_ATTRIBUTE_DATE1

ASP_GLOBAL_ATTRIBUTE_DATE2

ASP_GLOBAL_ATTRIBUTE_DATE3

ASP_GLOBAL_ATTRIBUTE_DATE4

ASP_GLOBAL_ATTRIBUTE_DATE5

ASP_DISCOUNT_DIST_METHOD

ASP_GAIN_LOSS_CALC_LEVEL

ASP_AUTOMATIC_OFFSETS_VALUE

ASP_PRORATE_INT_ACROSS_DISTS

ASP_BUILD_PREPAY_ACCOUNTS_FLAG

ASP_WHEN_TO_ACCOUNT_PMT

ASP_WHEN_TO_ACCOUNT_GAIN_LOSS

ASP_ORG_ID

ASP_SET_OF_BOOKS_ID

LEDGER_CURRENCY

ASP_AWT_INCLUDE_DISCOUNT_AMT

ASP_AWT_INLUDE_TAX_AMT

ASP_FD_PMT_LIAB_RELIEF

FSP_DISC_TAKEN_CCID

FSP_FUTURE_DATED_PAYMENT_CCID

FSP_RETAINAGE_ACCOUNT

ASP_AUTO_OFFSET_FLAG

TR_FSP_GLOBAL_ATTRIBUTE_NUM3

TR_FSP_GLOBAL_ATTRIBUTE_NUM4

FSP_ACCTS_PAY_CODE_COMB_ID

FSP_MISC_CHARGE_CCID

FSP_RETAINAGE_CODE_COMB_ID

FSP_FREIGHT_CODE_COMB_ID

FSP_ONE_TIME_PAY_LIAB_CCID

FSP_ONE_TIME_PAY_EXP_CCID

FSP_UNCLAIMED_FUNDS_CCID

Query

SQL_Statement

SELECT

GL.rounding_code_combination_id ASP_Rounding_Error_CCID

,FSP.gain_code_combination_id ASP_Gain_CCID

,FSP.loss_code_combination_id ASP_Loss_CCID

,FSP.DISC_TAKEN_CODE_COMBINATION_ID ASP_Disc_Taken_CCID

,ASP.FEDERAL_IDENTIFICATION_NUM ASP_Federal_Id_Num

,ASP.INTEREST_CODE_COMBINATION_ID ASP_Interest_CCID

,FSP.RATE_VAR_GAIN_CCID ASP_Rate_Var_Gain_CCID

,FSP.RATE_VAR_LOSS_CCID ASP_Rate_Var_Loss_CCID

,FSP.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

,ASP.GLOBAL_ATTRIBUTE_NUMBER1 ASP_Global_Attribute_Number_1

,ASP.GLOBAL_ATTRIBUTE_NUMBER2 ASP_Global_Attribute_Number_2

,ASP.GLOBAL_ATTRIBUTE_NUMBER3 ASP_Global_Attribute_Number_3

,ASP.GLOBAL_ATTRIBUTE_NUMBER4 ASP_Global_Attribute_Number_4

,ASP.GLOBAL_ATTRIBUTE_NUMBER5 ASP_Global_Attribute_Number_5

,ASP.GLOBAL_ATTRIBUTE_DATE1 ASP_Global_Attribute_Date1

,ASP.GLOBAL_ATTRIBUTE_DATE2 ASP_Global_Attribute_Date2

,ASP.GLOBAL_ATTRIBUTE_DATE3 ASP_Global_Attribute_Date3

,ASP.GLOBAL_ATTRIBUTE_DATE4 ASP_Global_Attribute_Date4

,ASP.GLOBAL_ATTRIBUTE_DATE5 ASP_Global_Attribute_Date5

,nvl(ASP.discount_distribution_method, 'SYSTEM') ASP_discount_dist_method

,ASP.gain_loss_calc_level ASP_gain_loss_calc_level

,decode (FSP.automatic_offsets_flag,'Y', decode( FSP.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, 'BOTH', 'ALWAYS_ALWAYS',

'CLEARING ONLY', 'CLEAR_CLEAR',

'PAYMENT ONLY', 'ISSUE_ISSUE',

'ALWAYS_ALWAYS') ASP_when_to_account_pmt

,decode(ASP.when_to_account_pmt,

'CLEARING ONLY','CLEAR ONLY',

'BOTH','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

,ASP.base_currency_code Ledger_Currency

,null ASP_AWT_Include_Discount_Amt

,null 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

,FSP.RETAINAGE_CODE_COMBINATION_ID FSP_retainage_account

,NVL(FSP.automatic_offsets_flag,'N') ASP_AUTO_OFFSET_FLAG

,FSP.GLOBAL_ATTRIBUTE_NUMBER3 TR_FSP_Global_Attribute_Num3

,FSP.GLOBAL_ATTRIBUTE_NUMBER4 TR_FSP_Global_Attribute_Num4

,FSP.ACCTS_PAY_CODE_COMBINATION_ID FSP_ACCTS_PAY_CODE_COMB_ID

,FSP.MISC_CHARGE_CCID FSP_MISC_CHARGE_CCID

,FSP.RETAINAGE_CODE_COMBINATION_ID FSP_RETAINAGE_CODE_COMB_ID

,FSP.FREIGHT_CODE_COMBINATION_ID FSP_FREIGHT_CODE_COMB_ID

,FSP.ONE_TIME_PAY_LIAB_CCID FSP_ONE_TIME_PAY_LIAB_CCID

,FSP.ONE_TIME_PAY_EXPENSE_CCID FSP_ONE_TIME_PAY_EXP_CCID

,FSP.UNCLAIMED_FUNDS_CCID FSP_UNCLAIMED_FUNDS_CCID

FROM AP_SYSTEM_PARAMETERS_ALL ASP,

FINANCIALS_SYSTEM_PARAMS_ALL FSP,

GL_LEDGERS GL

WHERE ASP.org_id = FSP.org_id

AND GL.ledger_id = FSP.set_of_books_id