ZX_REC_NREC_DIST_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID REC_NREC_TAX_DIST_ID APPLICATION_ID ENTITY_CODE EVENT_CLASS_CODE EVENT_TYPE_CODE TRX_ID TRX_NUMBER TRX_LINE_ID TRX_LINE_NUMBER TAX_LINE_ID TAX_LINE_NUMBER TRX_LINE_DIST_ID TRX_LEVEL_TYPE ITEM_DIST_NUMBER REC_NREC_TAX_DIST_NUMBER REC_NREC_RATE RECOVERABLE_FLAG REC_NREC_TAX_AMT TAX_EVENT_CLASS_CODE TAX_EVENT_TYPE_CODE CONTENT_OWNER_ID TAX_REGIME_ID TAX_REGIME_CODE TAX_REGIME_NAME TAX_ID TAX TAX_FULL_NAME TAX_STATUS_ID TAX_STATUS_CODE TAX_STATUS_NAME TAX_RATE_ID TAX_RATE_CODE TAX_RATE_NAME TAX_RATE INCLUSIVE_FLAG RECOVERY_TYPE_ID RECOVERY_TYPE_CODE RECOVERY_RATE_ID RECOVERY_RATE_CODE REC_TYPE_RULE_FLAG NEW_REC_RATE_CODE_FLAG REVERSE_FLAG HISTORICAL_FLAG REVERSED_TAX_DIST_ID REC_NREC_TAX_AMT_TAX_CURR REC_NREC_TAX_AMT_FUNCL_CURR INTENDED_USE PROJECT_ID TASK_ID AWARD_ID EXPENDITURE_TYPE EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ITEM_DATE REC_RATE_DET_RULE_FLAG LEDGER_ID SUMMARY_TAX_LINE_ID RECORD_TYPE_CODE CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_RATE TAX_CURRENCY_CONVERSION_DATE TAX_CURRENCY_CONVERSION_TYPE TAX_CURRENCY_CONVERSION_RATE TRX_CURRENCY_CODE TAX_CURRENCY_CODE TRX_LINE_DIST_QTY REF_DOC_TRX_LINE_DIST_QTY PRICE_DIFF QTY_DIFF PER_TRX_CURR_UNIT_NR_AMT REF_PER_TRX_CURR_UNIT_NR_AMT REF_DOC_CURR_CONV_RATE UNIT_PRICE REF_DOC_UNIT_PRICE PER_UNIT_NREC_TAX_AMT REF_DOC_PER_UNIT_NREC_TAX_AMT RATE_TAX_FACTOR TAX_APPORTIONMENT_FLAG TRX_LINE_DIST_AMT TRX_LINE_DIST_TAX_AMT ORIG_REC_NREC_RATE ORIG_REC_RATE_CODE ORIG_REC_NREC_TAX_AMT ORIG_REC_NREC_TAX_AMT_TAX_CURR ACCOUNT_CCID ACCOUNT_STRING UNROUNDED_REC_NREC_TAX_AMT APPLICABILITY_RESULT_ID REC_RATE_RESULT_ID BACKWARD_COMPATIBILITY_FLAG OVERRIDDEN_FLAG SELF_ASSESSED_FLAG FREEZE_FLAG POSTING_FLAG GL_DATE REF_DOC_APPLICATION_ID REF_DOC_ENTITY_CODE REF_DOC_EVENT_CLASS_CODE REF_DOC_TRX_ID REF_DOC_LINE_ID REF_DOC_DIST_ID REF_DOC_TRX_LEVEL_TYPE MINIMUM_ACCOUNTABLE_UNIT PRECISION ROUNDING_RULE_CODE TAXABLE_AMT TAXABLE_AMT_TAX_CURR TAXABLE_AMT_FUNCL_CURR TAX_ONLY_LINE_FLAG UNROUNDED_TAXABLE_AMT LEGAL_ENTITY_ID PRD_TAX_AMT PRD_TAX_AMT_TAX_CURR PRD_TAX_AMT_FUNCL_CURR PRD_TOTAL_TAX_AMT PRD_TOTAL_TAX_AMT_TAX_CURR PRD_TOTAL_TAX_AMT_FUNCL_CURR APPLIED_FROM_TAX_DIST_ID APPLIED_TO_DOC_CURR_CONV_RATE ADJUSTED_DOC_TAX_DIST_ID FUNC_CURR_ROUNDING_ADJUSTMENT TAX_APPORTIONMENT_LINE_NUMBER LAST_MANUAL_ENTRY REF_DOC_TAX_DIST_ID MRC_TAX_DIST_FLAG MRC_LINK_TO_TAX_DIST_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 ORIG_AP_CHRG_DIST_NUM ORIG_AP_CHRG_DIST_ID ORIG_AP_TAX_DIST_NUM ORIG_AP_TAX_DIST_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN TAX_POINT_BASIS TAX_POINT_DATE REPORTABLE_FLAG LEGAL_REPORTING_STATUS

Query

SQL_Statement

SELECT ZR.ROWID ROW_ID, ZR.REC_NREC_TAX_DIST_ID, ZR.APPLICATION_ID, ZR.ENTITY_CODE, ZR.EVENT_CLASS_CODE, ZR.EVENT_TYPE_CODE, ZR.TRX_ID, ZR.TRX_NUMBER, ZR.TRX_LINE_ID, ZR.TRX_LINE_NUMBER, ZR.TAX_LINE_ID, ZR.TAX_LINE_NUMBER, ZR.TRX_LINE_DIST_ID, ZR.TRX_LEVEL_TYPE, ZR.ITEM_DIST_NUMBER, ZR.REC_NREC_TAX_DIST_NUMBER, ZR.REC_NREC_RATE, ZR.RECOVERABLE_FLAG, ZR.REC_NREC_TAX_AMT, ZR.TAX_EVENT_CLASS_CODE, ZR.TAX_EVENT_TYPE_CODE, ZR.CONTENT_OWNER_ID, ZR.TAX_REGIME_ID, ZR.TAX_REGIME_CODE, TR.TAX_REGIME_NAME, ZR.TAX_ID, ZR.TAX, TX.TAX_FULL_NAME, ZR.TAX_STATUS_ID, ZR.TAX_STATUS_CODE, TS.TAX_STATUS_NAME, ZR.TAX_RATE_ID, ZR.TAX_RATE_CODE, TRT.TAX_RATE_NAME, ZR.TAX_RATE, ZR.INCLUSIVE_FLAG, ZR.RECOVERY_TYPE_ID, ZR.RECOVERY_TYPE_CODE, ZR.RECOVERY_RATE_ID, ZR.RECOVERY_RATE_CODE, ZR.REC_TYPE_RULE_FLAG, ZR.NEW_REC_RATE_CODE_FLAG, ZR.REVERSE_FLAG, ZR.HISTORICAL_FLAG, ZR.REVERSED_TAX_DIST_ID, ZR.REC_NREC_TAX_AMT_TAX_CURR, ZR.REC_NREC_TAX_AMT_FUNCL_CURR, ZR.INTENDED_USE, ZR.PROJECT_ID, ZR.TASK_ID, ZR.AWARD_ID, ZR.EXPENDITURE_TYPE, ZR.EXPENDITURE_ORGANIZATION_ID, ZR.EXPENDITURE_ITEM_DATE, ZR.REC_RATE_DET_RULE_FLAG, ZR.LEDGER_ID, ZR.SUMMARY_TAX_LINE_ID, ZR.RECORD_TYPE_CODE, ZR.CURRENCY_CONVERSION_DATE, ZR.CURRENCY_CONVERSION_TYPE, ZR.CURRENCY_CONVERSION_RATE, ZR.TAX_CURRENCY_CONVERSION_DATE, ZR.TAX_CURRENCY_CONVERSION_TYPE, ZR.TAX_CURRENCY_CONVERSION_RATE, ZR.TRX_CURRENCY_CODE, ZR.TAX_CURRENCY_CODE, ZR.TRX_LINE_DIST_QTY, ZR.REF_DOC_TRX_LINE_DIST_QTY, ZR.PRICE_DIFF, ZR.QTY_DIFF, ZR.PER_TRX_CURR_UNIT_NR_AMT, ZR.REF_PER_TRX_CURR_UNIT_NR_AMT, ZR.REF_DOC_CURR_CONV_RATE, ZR.UNIT_PRICE, ZR.REF_DOC_UNIT_PRICE, ZR.PER_UNIT_NREC_TAX_AMT, ZR.REF_DOC_PER_UNIT_NREC_TAX_AMT, ZR.RATE_TAX_FACTOR, ZR.TAX_APPORTIONMENT_FLAG, ZR.TRX_LINE_DIST_AMT, ZR.TRX_LINE_DIST_TAX_AMT, ZR.ORIG_REC_NREC_RATE, ZR.ORIG_REC_RATE_CODE, ZR.ORIG_REC_NREC_TAX_AMT, ZR.ORIG_REC_NREC_TAX_AMT_TAX_CURR, ZR.ACCOUNT_CCID, ZR.ACCOUNT_STRING, ZR.UNROUNDED_REC_NREC_TAX_AMT, ZR.APPLICABILITY_RESULT_ID, ZR.REC_RATE_RESULT_ID, ZR.BACKWARD_COMPATIBILITY_FLAG, ZR.OVERRIDDEN_FLAG, ZR.SELF_ASSESSED_FLAG, ZR.FREEZE_FLAG, ZR.POSTING_FLAG, ZR.GL_DATE, ZR.REF_DOC_APPLICATION_ID, ZR.REF_DOC_ENTITY_CODE, ZR.REF_DOC_EVENT_CLASS_CODE, ZR.REF_DOC_TRX_ID, ZR.REF_DOC_LINE_ID, ZR.REF_DOC_DIST_ID, ZR.REF_DOC_TRX_LEVEL_TYPE, ZR.MINIMUM_ACCOUNTABLE_UNIT, ZR.PRECISION, ZR.ROUNDING_RULE_CODE, ZR.TAXABLE_AMT, ZR.TAXABLE_AMT_TAX_CURR, ZR.TAXABLE_AMT_FUNCL_CURR, ZR.TAX_ONLY_LINE_FLAG, ZR.UNROUNDED_TAXABLE_AMT, ZR.LEGAL_ENTITY_ID, ZR.PRD_TAX_AMT, ZR.PRD_TAX_AMT_TAX_CURR, ZR.PRD_TAX_AMT_FUNCL_CURR, ZR.PRD_TOTAL_TAX_AMT, ZR.PRD_TOTAL_TAX_AMT_TAX_CURR, ZR.PRD_TOTAL_TAX_AMT_FUNCL_CURR, ZR.APPLIED_FROM_TAX_DIST_ID, ZR.APPLIED_TO_DOC_CURR_CONV_RATE, ZR.ADJUSTED_DOC_TAX_DIST_ID, ZR.FUNC_CURR_ROUNDING_ADJUSTMENT, ZR.TAX_APPORTIONMENT_LINE_NUMBER, ZR.LAST_MANUAL_ENTRY, ZR.REF_DOC_TAX_DIST_ID, ZR.MRC_TAX_DIST_FLAG, ZR.MRC_LINK_TO_TAX_DIST_ID, ZR.ATTRIBUTE_CATEGORY, ZR.ATTRIBUTE1, ZR.ATTRIBUTE2, ZR.ATTRIBUTE3, ZR.ATTRIBUTE4, ZR.ATTRIBUTE5, ZR.ATTRIBUTE6, ZR.ATTRIBUTE7, ZR.ATTRIBUTE8, ZR.ATTRIBUTE9, ZR.ATTRIBUTE10, ZR.ATTRIBUTE11, ZR.ATTRIBUTE12, ZR.ATTRIBUTE13, ZR.ATTRIBUTE14, ZR.ATTRIBUTE15, ZR.GLOBAL_ATTRIBUTE_CATEGORY, ZR.GLOBAL_ATTRIBUTE1, ZR.GLOBAL_ATTRIBUTE2, ZR.GLOBAL_ATTRIBUTE3, ZR.GLOBAL_ATTRIBUTE4, ZR.GLOBAL_ATTRIBUTE5, ZR.GLOBAL_ATTRIBUTE6, ZR.GLOBAL_ATTRIBUTE7, ZR.GLOBAL_ATTRIBUTE8, ZR.GLOBAL_ATTRIBUTE9, ZR.GLOBAL_ATTRIBUTE10, ZR.GLOBAL_ATTRIBUTE11, ZR.GLOBAL_ATTRIBUTE12, ZR.GLOBAL_ATTRIBUTE13, ZR.GLOBAL_ATTRIBUTE14, ZR.GLOBAL_ATTRIBUTE15, ZR.GLOBAL_ATTRIBUTE16, ZR.GLOBAL_ATTRIBUTE17, ZR.GLOBAL_ATTRIBUTE18, ZR.GLOBAL_ATTRIBUTE19, ZR.GLOBAL_ATTRIBUTE20, ZR.ORIG_AP_CHRG_DIST_NUM, ZR.ORIG_AP_CHRG_DIST_ID, ZR.ORIG_AP_TAX_DIST_NUM, ZR.ORIG_AP_TAX_DIST_ID, ZR.OBJECT_VERSION_NUMBER, ZR.CREATED_BY, ZR.CREATION_DATE, ZR.LAST_UPDATED_BY, ZR.LAST_UPDATE_DATE, ZR.LAST_UPDATE_LOGIN, ZR.TAX_POINT_BASIS, ZR.TAX_POINT_DATE, ZR.REPORTABLE_FLAG, ZR.LEGAL_REPORTING_STATUS FROM ZX_REC_NREC_DIST ZR, ZX_REGIMES_TL TR, ZX_TAXES_TL TX, ZX_RATES_TL TRT, ZX_STATUS_TL TS WHERE ZR.TAX_REGIME_ID = TR.TAX_REGIME_ID(+) AND ZR.TAX_ID = TX.TAX_ID(+) AND ZR.TAX_STATUS_ID = TS.TAX_STATUS_ID(+) AND ZR.TAX_RATE_ID = TRT.TAX_RATE_ID(+) AND TR.LANGUAGE = userenv('LANG') AND TX.LANGUAGE = userenv('LANG') AND TRT.LANGUAGE = userenv('LANG') AND TS.LANGUAGE = userenv('LANG')