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_ACCOUNT_RATES_MIG_V

Source

View Text - Preformatted


SELECT 	zxar.ledger_id,
	zxar.tax_class,
	zxar.content_owner_id,
	zxar.tax_regime_code,
	zxar.tax,
	zxar.tax_status_code,
	zxar.tax_rate_code,
	zxar.rounding_rule_code,
	zxar.amt_incl_tax_flag,
	zxar.record_type_code,
	zxar.creation_date, zxar.created_by, zxar.last_update_date, zxar.last_updated_by, zxar.last_update_login,
	zxar.attribute_category,
	zxar.attribute1, zxar.attribute2, zxar.attribute3, zxar.attribute4, zxar.attribute5,
	zxar.attribute6, zxar.attribute7, zxar.attribute8, zxar.attribute9, zxar.attribute10,
	zxar.attribute11, zxar.attribute12, zxar.attribute13, zxar.attribute14, zxar.attribute15,
	zxar.account_segment_value
  FROM 	zx_account_rates zxar
 WHERE	record_type_code = 'MIGRATED'
   AND	account_segment_value IS NULL

View Text - HTML Formatted

SELECT ZXAR.LEDGER_ID
, ZXAR.TAX_CLASS
, ZXAR.CONTENT_OWNER_ID
, ZXAR.TAX_REGIME_CODE
, ZXAR.TAX
, ZXAR.TAX_STATUS_CODE
, ZXAR.TAX_RATE_CODE
, ZXAR.ROUNDING_RULE_CODE
, ZXAR.AMT_INCL_TAX_FLAG
, ZXAR.RECORD_TYPE_CODE
, ZXAR.CREATION_DATE
, ZXAR.CREATED_BY
, ZXAR.LAST_UPDATE_DATE
, ZXAR.LAST_UPDATED_BY
, ZXAR.LAST_UPDATE_LOGIN
, ZXAR.ATTRIBUTE_CATEGORY
, ZXAR.ATTRIBUTE1
, ZXAR.ATTRIBUTE2
, ZXAR.ATTRIBUTE3
, ZXAR.ATTRIBUTE4
, ZXAR.ATTRIBUTE5
, ZXAR.ATTRIBUTE6
, ZXAR.ATTRIBUTE7
, ZXAR.ATTRIBUTE8
, ZXAR.ATTRIBUTE9
, ZXAR.ATTRIBUTE10
, ZXAR.ATTRIBUTE11
, ZXAR.ATTRIBUTE12
, ZXAR.ATTRIBUTE13
, ZXAR.ATTRIBUTE14
, ZXAR.ATTRIBUTE15
, ZXAR.ACCOUNT_SEGMENT_VALUE
FROM ZX_ACCOUNT_RATES ZXAR WHERE RECORD_TYPE_CODE = 'MIGRATED' AND ACCOUNT_SEGMENT_VALUE IS NULL