ZX_ACCOUNT_RATES_NEW_V

Details

• Schema: FUSION

• Object owner: ZX

• Object type: VIEW

Columns

Name

LEDGER_ID LEDGER_NAME TAX_CURRENCY_CODE TAX_PRECISION TAX_MAU CALCULATION_LEVEL_CODE ALLOW_ROUNDING_OVERRIDE_FLAG RECORD_TYPE_CODE TAX_CLASS TAX_REGIME_CODE CONTENT_OWNER_ID CONTENT_OWNER_NAME TAX TAX_STATUS_CODE TAX_RATE_CODE ROUNDING_RULE_CODE AMT_INCL_TAX_FLAG 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, lgr.name ledger_name, zxar.tax_currency_code, zxar.tax_precision, zxar.tax_mau, zxar.calculation_level_code, zxar.allow_rounding_override_flag, zxar.record_type_code, zxar.tax_class, zxar.tax_regime_code, zxar.content_owner_id, ptp.party_name content_owner_name, zxar.tax, zxar.tax_status_code, zxar.tax_rate_code, zxar.rounding_rule_code, zxar.amt_incl_tax_flag, 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, account_segment_value FROM zx_account_rates zxar, gl_ledgers lgr, zx_first_party_orgs_all_v ptp WHERE lgr.ledger_id = zxar.ledger_id AND account_segment_value IS NULL AND zxar.content_owner_id = ptp.party_tax_profile_id AND zxar.ROWID IN (SELECT Min(zxar.ROWID) FROM zx_account_rates zxar, gl_ledgers lgr, zx_first_party_orgs_all_v ptp WHERE lgr.ledger_id = zxar.ledger_id AND account_segment_value IS NULL AND zxar.content_owner_id = ptp.party_tax_profile_id GROUP BY zxar.ledger_id)