ZX_JURISDICTIONS_VL

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID TAX_JURISDICTION_ID TAX_JURISDICTION_CODE EFFECTIVE_FROM EFFECTIVE_TO TAX_REGIME_CODE REP_TAX_AUTHORITY_ID COLL_TAX_AUTHORITY_ID ZONE_GEOGRAPHY_ID TAX DEFAULT_JURISDICTION_FLAG DEFAULT_FLG_EFFECTIVE_FROM DEFAULT_FLG_EFFECTIVE_TO INNER_CITY_JURISDICTION_FLAG PRECEDENCE_LEVEL ALLOW_TAX_REGISTRATIONS_FLAG OBJECT_VERSION_NUMBER TAX_ACCT_SRC_JURISDICT_ID TAX_EXMPT_SRC_JURISDICT_ID RECORD_TYPE_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APP_NAME PROGRAM_NAME PROGRAM_LOGIN_ID ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE_CATEGORY TAX_JURISDICTION_NAME WHT_BUCKET_LEVEL_FLAG VALIDATION_TYPE VALIDATION_LEVEL UNIQUENESS_VALIDATION_LEVEL THRSHLD_SCHEDULE_GRP_LVL_FLAG

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.TAX_JURISDICTION_ID, B.TAX_JURISDICTION_CODE, B.EFFECTIVE_FROM, B.EFFECTIVE_TO, B.TAX_REGIME_CODE, B.REP_TAX_AUTHORITY_ID, B.COLL_TAX_AUTHORITY_ID, B.ZONE_GEOGRAPHY_ID, B.TAX, B.DEFAULT_JURISDICTION_FLAG, B.DEFAULT_FLG_EFFECTIVE_FROM, B.DEFAULT_FLG_EFFECTIVE_TO, B.INNER_CITY_JURISDICTION_FLAG, B.PRECEDENCE_LEVEL, B.ALLOW_TAX_REGISTRATIONS_FLAG, B.OBJECT_VERSION_NUMBER, B.TAX_ACCT_SRC_JURISDICT_ID, B.TAX_EXMPT_SRC_JURISDICT_ID, B.RECORD_TYPE_CODE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.REQUEST_ID, B.PROGRAM_APP_NAME, B.PROGRAM_NAME, B.PROGRAM_LOGIN_ID, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, B.ATTRIBUTE_CATEGORY, T.TAX_JURISDICTION_NAME, B.WHT_BUCKET_LEVEL_FLAG, B.VALIDATION_TYPE, B.VALIDATION_LEVEL, B.UNIQUENESS_VALIDATION_LEVEL, B.THRSHLD_SCHEDULE_GRP_LVL_FLAG FROM ZX_JURISDICTIONS_TL T, ZX_JURISDICTIONS_B B WHERE B.TAX_JURISDICTION_ID = T.TAX_JURISDICTION_ID AND T.LANGUAGE = USERENV('LANG')