ZX_ACCOUNT_RATES_MIG_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

LEDGER_ID TAX_CLASS CONTENT_OWNER_ID TAX_REGIME_CODE TAX TAX_STATUS_CODE TAX_RATE_CODE ROUNDING_RULE_CODE AMT_INCL_TAX_FLAG RECORD_TYPE_CODE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ACCOUNT_SEGMENT_VALUE

Query

SQL_Statement

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