eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ZX_REC_NREC_DIST_QUOTE_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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