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_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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