AP_PAY_ASP_EXTRACT_V

Details

• Schema: FUSION

• Object owner: AP

• Object type: VIEW

Columns

Name

ASP_PAY_ROUNDING_ERROR_CCID ASP_PAY_GAIN_CCID ASP_PAY_LOSS_CCID ASP_PAY_DISC_TAKEN_CCID ASP_PAY_FEDERAL_ID_NUM ASP_PAY_INTEREST_CCID ASP_PAY_RATE_VAR_GAIN_CCID ASP_PAY_RATE_VAR_LOSS_CCID ASP_PAY_PREPAY_TAX_DIFF_CCID ASP_PAY_GBL_ATTRB_CATEGORY ASP_PAY_GLOBAL_ATTRIBUTE_1 ASP_PAY_GLOBAL_ATTRIBUTE_2 ASP_PAY_GLOBAL_ATTRIBUTE_3 ASP_PAY_GLOBAL_ATTRIBUTE_4 ASP_PAY_GLOBAL_ATTRIBUTE_5 ASP_PAY_GLOBAL_ATTRIBUTE_6 ASP_PAY_GLOBAL_ATTRIBUTE_7 ASP_PAY_GLOBAL_ATTRIBUTE_8 ASP_PAY_GLOBAL_ATTRIBUTE_9 ASP_PAY_GLOBAL_ATTRIBUTE_10 ASP_PAY_GLOBAL_ATTRIBUTE_11 ASP_PAY_GLOBAL_ATTRIBUTE_12 ASP_PAY_GLOBAL_ATTRIBUTE_13 ASP_PAY_GLOBAL_ATTRIBUTE_14 ASP_PAY_GLOBAL_ATTRIBUTE_15 ASP_PAY_GLOBAL_ATTRIBUTE_16 ASP_PAY_GLOBAL_ATTRIBUTE_17 ASP_PAY_GLOBAL_ATTRIBUTE_18 ASP_PAY_GLOBAL_ATTRIBUTE_19 ASP_PAY_GLOBAL_ATTRIBUTE_20 ASP_PAY_GBL_ATTRB_NUM_1 ASP_PAY_GBL_ATTRB_NUM_2 ASP_PAY_GBL_ATTRB_NUM_3 ASP_PAY_GBL_ATTRB_NUM_4 ASP_PAY_GBL_ATTRB_NUM_5 ASP_PAY_GBL_ATTRB_DATE1 ASP_PAY_GBL_ATTRB_DATE2 ASP_PAY_GBL_ATTRB_DATE3 ASP_PAY_GBL_ATTRB_DATE4 ASP_PAY_GBL_ATTRB_DATE5 ASP_PAY_DISCOUNT_DIST_METHOD ASP_PAY_GAIN_LOSS_CALC_LEVEL ASP_PAY_AUTO_OFFSETS_VALUE ASP_PAY_PRORATE_ACROSS_DISTS ASP_PAY_BUILD_PP_ACCTS_FLAG ASP_PAY_WHEN_TO_ACCOUNT_PMT ASP_PAY_WHEN_TO_ACCT_GAIN_LOSS ASP_PAY_ORG_ID ASP_PAY_SET_OF_BOOKS_ID ASP_PAY_AWT_AT_PMT_TIME ASP_PAY_LEDGER_CURRENCY ASP_PAY_AWT_INCLUDE_DISC_AMT ASP_PAY_AWT_INCLUDE_TAX_AMT ASP_PAY_FD_PMT_LIAB_RELIEF FSP_PAY_DISC_TAKEN_CCID FSP_PAY_FUTURE_DATED_PMT_CCID FSP_PAY_RETAINAGE_ACCOUNT ASP_PAY_AUTO_OFFSET_FLAG PAY_ENCUMBRANCE_TYPE_ID

Query

SQL_Statement

SELECT GL.rounding_code_combination_id ASP_PAY_Rounding_Error_CCID ,FSP.gain_code_combination_id ASP_PAY_Gain_CCID ,FSP.loss_code_combination_id ASP_PAY_Loss_CCID ,FSP.DISC_TAKEN_CODE_COMBINATION_ID ASP_PAY_Disc_Taken_CCID ,ASP.FEDERAL_IDENTIFICATION_NUM ASP_PAY_Federal_Id_Num ,ASP.INTEREST_CODE_COMBINATION_ID ASP_PAY_Interest_CCID ,FSP.RATE_VAR_GAIN_CCID ASP_PAY_Rate_Var_Gain_CCID ,FSP.RATE_VAR_LOSS_CCID ASP_PAY_Rate_Var_Loss_CCID ,FSP.PREPAY_TAX_DIFF_CCID ASP_PAY_Prepay_Tax_Diff_CCID ,ASP.GLOBAL_ATTRIBUTE_CATEGORY ASP_PAY_Gbl_Attrb_Category ,ASP.GLOBAL_ATTRIBUTE1 ASP_PAY_Global_Attribute_1 ,ASP.GLOBAL_ATTRIBUTE2 ASP_PAY_Global_Attribute_2 ,ASP.GLOBAL_ATTRIBUTE3 ASP_PAY_Global_Attribute_3 ,ASP.GLOBAL_ATTRIBUTE4 ASP_PAY_Global_Attribute_4 ,ASP.GLOBAL_ATTRIBUTE5 ASP_PAY_Global_Attribute_5 ,ASP.GLOBAL_ATTRIBUTE6 ASP_PAY_Global_Attribute_6 ,ASP.GLOBAL_ATTRIBUTE7 ASP_PAY_Global_Attribute_7 ,ASP.GLOBAL_ATTRIBUTE8 ASP_PAY_Global_Attribute_8 ,ASP.GLOBAL_ATTRIBUTE9 ASP_PAY_Global_Attribute_9 ,ASP.GLOBAL_ATTRIBUTE10 ASP_PAY_Global_Attribute_10 ,ASP.GLOBAL_ATTRIBUTE11 ASP_PAY_Global_Attribute_11 ,ASP.GLOBAL_ATTRIBUTE12 ASP_PAY_Global_Attribute_12 ,ASP.GLOBAL_ATTRIBUTE13 ASP_PAY_Global_Attribute_13 ,ASP.GLOBAL_ATTRIBUTE14 ASP_PAY_Global_Attribute_14 ,ASP.GLOBAL_ATTRIBUTE15 ASP_PAY_Global_Attribute_15 ,ASP.GLOBAL_ATTRIBUTE16 ASP_PAY_Global_Attribute_16 ,ASP.GLOBAL_ATTRIBUTE17 ASP_PAY_Global_Attribute_17 ,ASP.GLOBAL_ATTRIBUTE18 ASP_PAY_Global_Attribute_18 ,ASP.GLOBAL_ATTRIBUTE19 ASP_PAY_Global_Attribute_19 ,ASP.GLOBAL_ATTRIBUTE20 ASP_PAY_Global_Attribute_20 ,ASP.GLOBAL_ATTRIBUTE_NUMBER1 ASP_PAY_Gbl_Attrb_Num_1 ,ASP.GLOBAL_ATTRIBUTE_NUMBER2 ASP_PAY_Gbl_Attrb_Num_2 ,ASP.GLOBAL_ATTRIBUTE_NUMBER3 ASP_PAY_Gbl_Attrb_Num_3 ,ASP.GLOBAL_ATTRIBUTE_NUMBER4 ASP_PAY_Gbl_Attrb_Num_4 ,ASP.GLOBAL_ATTRIBUTE_NUMBER5 ASP_PAY_Gbl_Attrb_Num_5 ,ASP.GLOBAL_ATTRIBUTE_DATE1 ASP_PAY_Gbl_Attrb_Date1 ,ASP.GLOBAL_ATTRIBUTE_DATE2 ASP_PAY_Gbl_Attrb_Date2 ,ASP.GLOBAL_ATTRIBUTE_DATE3 ASP_PAY_Gbl_Attrb_Date3 ,ASP.GLOBAL_ATTRIBUTE_DATE4 ASP_PAY_Gbl_Attrb_Date4 ,ASP.GLOBAL_ATTRIBUTE_DATE5 ASP_PAY_Gbl_Attrb_Date5 ,nvl(ASP.discount_distribution_method, 'SYSTEM') ASP_PAY_discount_dist_method ,ASP.gain_loss_calc_level ASP_PAY_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_PAY_auto_offsets_value ,nvl(ASP.prorate_int_inv_across_dists ,'N') ASP_PAY_prorate_across_dists ,nvl(ASP.build_prepayment_accounts_flag,'N') ASP_PAY_build_pp_accts_flag ,decode(ASP.when_to_account_pmt, 'BOTH', 'ALWAYS_ALWAYS', 'CLEARING ONLY', 'CLEAR_CLEAR', 'PAYMENT ONLY', 'ISSUE_ISSUE', 'ALWAYS_ALWAYS') ASP_PAY_when_to_account_pmt ,decode(ASP.when_to_account_pmt, 'CLEARING ONLY','CLEAR ONLY', 'BOTH','ISSUE AND CLEAR','ISSUE AND CLEAR' ) ASP_PAY_when_to_acct_gain_loss ,ASP.org_id ASP_PAY_org_id ,ASP.set_of_books_id ASP_PAY_set_of_books_id ,null ASP_PAY_AWT_at_pmt_time ,ASP.base_currency_code ASP_PAY_Ledger_Currency ,null ASP_PAY_AWT_Include_Disc_Amt ,null ASP_PAY_AWT_Include_Tax_Amt ,nvl(ASP.FUTURE_DATED_PMT_LIAB_RELIEF, 'MATURITY') ASP_PAY_FD_Pmt_Liab_Relief ,FSP.disc_taken_code_combination_id FSP_PAY_Disc_Taken_CCID ,FSP.future_dated_payment_ccid FSP_PAY_Future_Dated_Pmt_CCID ,FSP.RETAINAGE_CODE_COMBINATION_ID FSP_PAY_retainage_account ,NVL(FSP.automatic_offsets_flag,'N') ASP_PAY_AUTO_OFFSET_FLAG ,GLET.encumbrance_type_id PAY_ENCUMBRANCE_TYPE_ID FROM AP_SYSTEM_PARAMETERS_ALL ASP, FINANCIALS_SYSTEM_PARAMS_ALL FSP, GL_LEDGERS GL, GL_ENCUMBRANCE_TYPES_B GLET /*Bug 31067780*/ WHERE ASP.org_id = FSP.org_id AND GL.ledger_id = FSP.set_of_books_id AND GLET.encumbrance_type_code='ORA_Invoice' AND GLET.enabled_flag='Y'