[Home] [Help]
View: ZX_ACCOUNT_RATES_MIG_V
View Text
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