1. Tables and Views for Financials
  2. ZX_REC_NREC_DIST_QUOTE_V

ZX_REC_NREC_DIST_QUOTE_V

Details

  • Schema: FUSION

  • Object owner: FND

  • Object type: VIEW

Columns

Name

REC_NREC_TAX_DIST_ID

APPLICATION_ID

ENTITY_CODE

EVENT_CLASS_CODE

EVENT_TYPE_CODE

TAX_EVENT_CLASS_CODE

TAX_EVENT_TYPE_CODE

TRX_ID

TRX_LINE_ID

TRX_LINE_NUMBER

TAX_LINE_ID

TAX_LINE_NUMBER

TRX_LINE_DIST_ID

ITEM_DIST_NUMBER

CONTENT_OWNER_ID

REC_NREC_TAX_DIST_NUMBER

TAX_REGIME_ID

TAX_REGIME_CODE

TAX_ID

TAX

TAX_STATUS_ID

TAX_STATUS_CODE

TAX_RATE_ID

TAX_RATE_CODE

TAX_RATE

INCLUSIVE_FLAG

RECOVERY_TYPE_ID

RECOVERY_TYPE_CODE

RECOVERY_RATE_ID

RECOVERY_RATE_CODE

REC_NREC_RATE

REC_TYPE_RULE_FLAG

NEW_REC_RATE_CODE_FLAG

RECOVERABLE_FLAG

REVERSE_FLAG

HISTORICAL_FLAG

REVERSED_TAX_DIST_ID

REC_NREC_TAX_AMT

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_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

UNROUNDED_REC_NREC_TAX_AMT

APPLICABILITY_RESULT_ID

REC_RATE_RESULT_ID

BACKWARD_COMPATIBILITY_FLAG

OVERRIDDEN_FLAG

SELF_ASSESSED_FLAG

FREEZE_FLAG

POSTING_FLAG

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

GL_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

LAST_UPDATE_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

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

ACCOUNT_CCID

ACCOUNT_STRING

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

ADJUSTED_DOC_TAX_DIST_ID

FUNC_CURR_ROUNDING_ADJUSTMENT

GLOBAL_ATTRIBUTE16

GLOBAL_ATTRIBUTE17

GLOBAL_ATTRIBUTE18

GLOBAL_ATTRIBUTE19

GLOBAL_ATTRIBUTE20

LAST_MANUAL_ENTRY

TAX_APPORTIONMENT_LINE_NUMBER

REF_DOC_TAX_DIST_ID

MRC_TAX_DIST_FLAG

MRC_LINK_TO_TAX_DIST_ID

TAX_APPORTIONMENT_FLAG

RATE_TAX_FACTOR

REF_DOC_PER_UNIT_NREC_TAX_AMT

PER_UNIT_NREC_TAX_AMT

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

APPLIED_TO_DOC_CURR_CONV_RATE

TRX_NUMBER

TRX_LEVEL_TYPE

REF_DOC_TRX_LEVEL_TYPE

OBJECT_VERSION_NUMBER

TAX_POINT_BASIS

TAX_POINT_DATE

REPORTABLE_FLAG

LEGAL_REPORTING_STATUS

Query

SQL_Statement

(

SELECT "REC_NREC_TAX_DIST_ID","APPLICATION_ID","ENTITY_CODE","EVENT_CLASS_CODE","EVENT_TYPE_CODE","TAX_EVENT_CLASS_CODE","TAX_EVENT_TYPE_CODE","TRX_ID","TRX_LINE_ID","TRX_LINE_NUMBER","TAX_LINE_ID","TAX_LINE_NUMBER","TRX_LINE_DIST_ID","ITEM_DIST_NUMBER","CONTENT_OWNER_ID","REC_NREC_TAX_DIST_NUMBER","TAX_REGIME_ID","TAX_REGIME_CODE","TAX_ID","TAX","TAX_STATUS_ID","TAX_STATUS_CODE","TAX_RATE_ID","TAX_RATE_CODE","TAX_RATE","INCLUSIVE_FLAG","RECOVERY_TYPE_ID","RECOVERY_TYPE_CODE","RECOVERY_RATE_ID","RECOVERY_RATE_CODE","REC_NREC_RATE","REC_TYPE_RULE_FLAG","NEW_REC_RATE_CODE_FLAG","RECOVERABLE_FLAG","REVERSE_FLAG","HISTORICAL_FLAG","REVERSED_TAX_DIST_ID","REC_NREC_TAX_AMT","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_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","UNROUNDED_REC_NREC_TAX_AMT","APPLICABILITY_RESULT_ID","REC_RATE_RESULT_ID","BACKWARD_COMPATIBILITY_FLAG","OVERRIDDEN_FLAG","SELF_ASSESSED_FLAG","FREEZE_FLAG","POSTING_FLAG","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","GL_DATE","CREATED_BY","CREATION_DATE","LAST_UPDATED_BY","LAST_UPDATE_LOGIN","LAST_UPDATE_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","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","ACCOUNT_CCID","ACCOUNT_STRING","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","ADJUSTED_DOC_TAX_DIST_ID","FUNC_CURR_ROUNDING_ADJUSTMENT","GLOBAL_ATTRIBUTE16","GLOBAL_ATTRIBUTE17","GLOBAL_ATTRIBUTE18","GLOBAL_ATTRIBUTE19","GLOBAL_ATTRIBUTE20","LAST_MANUAL_ENTRY","TAX_APPORTIONMENT_LINE_NUMBER","REF_DOC_TAX_DIST_ID","MRC_TAX_DIST_FLAG","MRC_LINK_TO_TAX_DIST_ID","TAX_APPORTIONMENT_FLAG","RATE_TAX_FACTOR","REF_DOC_PER_UNIT_NREC_TAX_AMT","PER_UNIT_NREC_TAX_AMT","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","APPLIED_TO_DOC_CURR_CONV_RATE","TRX_NUMBER","TRX_LEVEL_TYPE","REF_DOC_TRX_LEVEL_TYPE","OBJECT_VERSION_NUMBER","TAX_POINT_BASIS", "TAX_POINT_DATE", "REPORTABLE_FLAG", "LEGAL_REPORTING_STATUS" FROM ZX_REC_NREC_DIST_GT ZxRecNrecDistGt

UNION

SELECT "REC_NREC_TAX_DIST_ID","APPLICATION_ID","ENTITY_CODE","EVENT_CLASS_CODE","EVENT_TYPE_CODE","TAX_EVENT_CLASS_CODE","TAX_EVENT_TYPE_CODE","TRX_ID","TRX_LINE_ID","TRX_LINE_NUMBER","TAX_LINE_ID","TAX_LINE_NUMBER","TRX_LINE_DIST_ID","ITEM_DIST_NUMBER","CONTENT_OWNER_ID","REC_NREC_TAX_DIST_NUMBER","TAX_REGIME_ID","TAX_REGIME_CODE","TAX_ID","TAX","TAX_STATUS_ID","TAX_STATUS_CODE","TAX_RATE_ID","TAX_RATE_CODE","TAX_RATE","INCLUSIVE_FLAG","RECOVERY_TYPE_ID","RECOVERY_TYPE_CODE","RECOVERY_RATE_ID","RECOVERY_RATE_CODE","REC_NREC_RATE","REC_TYPE_RULE_FLAG","NEW_REC_RATE_CODE_FLAG","RECOVERABLE_FLAG","REVERSE_FLAG","HISTORICAL_FLAG","REVERSED_TAX_DIST_ID","REC_NREC_TAX_AMT","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_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","UNROUNDED_REC_NREC_TAX_AMT","APPLICABILITY_RESULT_ID","REC_RATE_RESULT_ID","BACKWARD_COMPATIBILITY_FLAG","OVERRIDDEN_FLAG","SELF_ASSESSED_FLAG","FREEZE_FLAG","POSTING_FLAG","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","GL_DATE","CREATED_BY","CREATION_DATE","LAST_UPDATED_BY","LAST_UPDATE_LOGIN","LAST_UPDATE_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","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","ACCOUNT_CCID","ACCOUNT_STRING","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","ADJUSTED_DOC_TAX_DIST_ID","FUNC_CURR_ROUNDING_ADJUSTMENT","GLOBAL_ATTRIBUTE16","GLOBAL_ATTRIBUTE17","GLOBAL_ATTRIBUTE18","GLOBAL_ATTRIBUTE19","GLOBAL_ATTRIBUTE20","LAST_MANUAL_ENTRY","TAX_APPORTIONMENT_LINE_NUMBER","REF_DOC_TAX_DIST_ID","MRC_TAX_DIST_FLAG","MRC_LINK_TO_TAX_DIST_ID","TAX_APPORTIONMENT_FLAG","RATE_TAX_FACTOR","REF_DOC_PER_UNIT_NREC_TAX_AMT","PER_UNIT_NREC_TAX_AMT","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","APPLIED_TO_DOC_CURR_CONV_RATE","TRX_NUMBER","TRX_LEVEL_TYPE","REF_DOC_TRX_LEVEL_TYPE","OBJECT_VERSION_NUMBER" ,"TAX_POINT_BASIS", "TAX_POINT_DATE", "REPORTABLE_FLAG", "LEGAL_REPORTING_STATUS" FROM ZX_REC_NREC_DIST ZxRecNrecDist

WHERE

(TRX_LINE_ID,TRX_LEVEL_TYPE) NOT IN

(SELECT ZxLinesDetFactors.TRX_LINE_ID,ZxLinesDetFactors.TRX_LEVEL_TYPE

FROM

ZX_LINES_DET_FACTORS ZxLinesDetFactors

WHERE

ZxLinesDetFactors.APPLICATION_ID = ZxRecNrecDist.APPLICATION_ID and

ZxLinesDetFactors.ENTITY_CODE = ZxRecNrecDist.ENTITY_CODE and

ZxLinesDetFactors.EVENT_CLASS_CODE = ZxRecNrecDist.EVENT_CLASS_CODE and

ZxLinesDetFactors.TRX_ID = ZxRecNrecDist.TRX_ID

)

)