View: ZX_REC_NREC_DIST_QUOTE_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ZX_REC_NREC_DIST_QUOTE_V

View Text

( 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"
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"
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 ) )