ZX_MCO_LV_TAXES

Details

Schema: FUSION
Object owner: FND
Object type: VIEW

Columns

Name
ROW_ID TAX_ID TAX CONTENT_OWNER_ID EFFECTIVE_FROM EFFECTIVE_TO TAX_REGIME_CODE TAX_TYPE_CODE ALLOW_MANUAL_ENTRY_FLAG ALLOW_TAX_OVERRIDE_FLAG MIN_TXBL_BSIS_THRSHLD MAX_TXBL_BSIS_THRSHLD MIN_TAX_RATE_THRSHLD MAX_TAX_RATE_THRSHLD MIN_TAX_AMT_THRSHLD MAX_TAX_AMT_THRSHLD COMPOUNDING_PRECEDENCE PERIOD_SET_NAME EXCHANGE_RATE_TYPE TAX_CURRENCY_CODE REP_TAX_AUTHORITY_ID COLL_TAX_AUTHORITY_ID TAX_PRECISION MINIMUM_ACCOUNTABLE_UNIT ROUNDING_RULE_CODE TAX_STATUS_RULE_FLAG TAX_RATE_RULE_FLAG DEF_PLACE_OF_SUPPLY_TYPE_CODE PLACE_OF_SUPPLY_RULE_FLAG DIRECT_RATE_RULE_FLAG APPLICABILITY_RULE_FLAG TAX_CALC_RULE_FLAG TXBL_BSIS_THRSHLD_FLAG TAX_RATE_THRSHLD_FLAG TAX_AMT_THRSHLD_FLAG TAXABLE_BASIS_RULE_FLAG DEF_INCLUSIVE_TAX_FLAG THRSHLD_GROUPING_LVL_CODE THRSHLD_CHK_TMPLT_CODE HAS_OTHER_JURISDICTIONS_FLAG ALLOW_EXEMPTIONS_FLAG ALLOW_EXCEPTIONS_FLAG ALLOW_RECOVERABILITY_FLAG DEF_TAX_CALC_FORMULA TAX_INCLUSIVE_OVERRIDE_FLAG DEF_TAXABLE_BASIS_FORMULA DEF_REGISTR_PARTY_TYPE_CODE REGISTRATION_TYPE_RULE_FLAG REPORTING_ONLY_FLAG AUTO_PRVN_FLAG LIVE_FOR_PROCESSING_FLAG HAS_DETAIL_TB_THRSHLD_FLAG HAS_TAX_DET_DATE_RULE_FLAG HAS_EXCH_RATE_DATE_RULE_FLAG HAS_TAX_POINT_DATE_RULE_FLAG PRINT_ON_INVOICE_FLAG USE_LEGAL_MSG_FLAG CALC_ONLY_FLAG PRIMARY_RECOVERY_TYPE_CODE PRIMARY_REC_TYPE_RULE_FLAG SECONDARY_RECOVERY_TYPE_CODE SECONDARY_REC_TYPE_RULE_FLAG PRIMARY_REC_RATE_DET_RULE_FLAG SEC_REC_RATE_DET_RULE_FLAG OFFSET_TAX_FLAG RECOVERY_RATE_OVERRIDE_FLAG ZONE_GEOGRAPHY_TYPE REGN_NUM_SAME_AS_LE_FLAG DEF_REC_SETTLEMENT_OPTION_CODE PARENT_GEOGRAPHY_TYPE PARENT_GEOGRAPHY_ID ALLOW_MASS_CREATE_FLAG APPLIED_AMT_HANDLING_FLAG SOURCE_TAX_FLAG DEF_PRIMARY_REC_RATE_CODE DEF_SECONDARY_REC_RATE_CODE ALLOW_DUP_REGN_NUM_FLAG TAX_ACCOUNT_SOURCE_TAX TAX_ACCOUNT_CREATE_METHOD_CODE TAX_EXMPT_SOURCE_TAX TAX_EXMPT_CR_METHOD_CODE OVERRIDE_GEOGRAPHY_TYPE LIVE_FOR_APPLICABILITY_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APP_NAME PROGRAM_NAME PROGRAM_LOGIN_ID RECORD_TYPE_CODE ALLOW_ROUNDING_OVERRIDE_FLAG SPECIAL_INCLUSIVE_TAX_FLAG ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE_CATEGORY TAX_FULL_NAME APPLICABLE_BY_DEFAULT_FLAG PARTY_NAME PARTY_TYPE_CODE BU_ID VIEW_OPTIONS_CODE WHT_BUCKET_LEVEL_FLAG PROCESS_WHT_FLAG WHT_CALC_POINT_FLAG VALIDATION_TYPE VALIDATION_LEVEL UNIQUENESS_VALIDATION_LEVEL TAX_EXCPT_CREATE_METHOD_CODE TAX_EXCPT_SOURCE_TAX

Name

ROW_ID

TAX_ID

TAX

CONTENT_OWNER_ID

EFFECTIVE_FROM

EFFECTIVE_TO

TAX_REGIME_CODE

TAX_TYPE_CODE

ALLOW_MANUAL_ENTRY_FLAG

ALLOW_TAX_OVERRIDE_FLAG

MIN_TXBL_BSIS_THRSHLD

MAX_TXBL_BSIS_THRSHLD

MIN_TAX_RATE_THRSHLD

MAX_TAX_RATE_THRSHLD

MIN_TAX_AMT_THRSHLD

MAX_TAX_AMT_THRSHLD

COMPOUNDING_PRECEDENCE

PERIOD_SET_NAME

EXCHANGE_RATE_TYPE

TAX_CURRENCY_CODE

REP_TAX_AUTHORITY_ID

COLL_TAX_AUTHORITY_ID

TAX_PRECISION

MINIMUM_ACCOUNTABLE_UNIT

ROUNDING_RULE_CODE

TAX_STATUS_RULE_FLAG

TAX_RATE_RULE_FLAG

DEF_PLACE_OF_SUPPLY_TYPE_CODE

PLACE_OF_SUPPLY_RULE_FLAG

DIRECT_RATE_RULE_FLAG

APPLICABILITY_RULE_FLAG

TAX_CALC_RULE_FLAG

TXBL_BSIS_THRSHLD_FLAG

TAX_RATE_THRSHLD_FLAG

TAX_AMT_THRSHLD_FLAG

TAXABLE_BASIS_RULE_FLAG

DEF_INCLUSIVE_TAX_FLAG

THRSHLD_GROUPING_LVL_CODE

THRSHLD_CHK_TMPLT_CODE

HAS_OTHER_JURISDICTIONS_FLAG

ALLOW_EXEMPTIONS_FLAG

ALLOW_EXCEPTIONS_FLAG

ALLOW_RECOVERABILITY_FLAG

DEF_TAX_CALC_FORMULA

TAX_INCLUSIVE_OVERRIDE_FLAG

DEF_TAXABLE_BASIS_FORMULA

DEF_REGISTR_PARTY_TYPE_CODE

REGISTRATION_TYPE_RULE_FLAG

REPORTING_ONLY_FLAG

AUTO_PRVN_FLAG

LIVE_FOR_PROCESSING_FLAG

HAS_DETAIL_TB_THRSHLD_FLAG

HAS_TAX_DET_DATE_RULE_FLAG

HAS_EXCH_RATE_DATE_RULE_FLAG

HAS_TAX_POINT_DATE_RULE_FLAG

PRINT_ON_INVOICE_FLAG

USE_LEGAL_MSG_FLAG

CALC_ONLY_FLAG

PRIMARY_RECOVERY_TYPE_CODE

PRIMARY_REC_TYPE_RULE_FLAG

SECONDARY_RECOVERY_TYPE_CODE

SECONDARY_REC_TYPE_RULE_FLAG

PRIMARY_REC_RATE_DET_RULE_FLAG

SEC_REC_RATE_DET_RULE_FLAG

OFFSET_TAX_FLAG

RECOVERY_RATE_OVERRIDE_FLAG

ZONE_GEOGRAPHY_TYPE

REGN_NUM_SAME_AS_LE_FLAG

DEF_REC_SETTLEMENT_OPTION_CODE

PARENT_GEOGRAPHY_TYPE

PARENT_GEOGRAPHY_ID

ALLOW_MASS_CREATE_FLAG

APPLIED_AMT_HANDLING_FLAG

SOURCE_TAX_FLAG

DEF_PRIMARY_REC_RATE_CODE

DEF_SECONDARY_REC_RATE_CODE

ALLOW_DUP_REGN_NUM_FLAG

TAX_ACCOUNT_SOURCE_TAX

TAX_ACCOUNT_CREATE_METHOD_CODE

TAX_EXMPT_SOURCE_TAX

TAX_EXMPT_CR_METHOD_CODE

OVERRIDE_GEOGRAPHY_TYPE

LIVE_FOR_APPLICABILITY_FLAG

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

REQUEST_ID

PROGRAM_APP_NAME

PROGRAM_NAME

PROGRAM_LOGIN_ID

RECORD_TYPE_CODE

ALLOW_ROUNDING_OVERRIDE_FLAG

SPECIAL_INCLUSIVE_TAX_FLAG

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE_CATEGORY

TAX_FULL_NAME

APPLICABLE_BY_DEFAULT_FLAG

PARTY_NAME

PARTY_TYPE_CODE

BU_ID

VIEW_OPTIONS_CODE

WHT_BUCKET_LEVEL_FLAG

PROCESS_WHT_FLAG

WHT_CALC_POINT_FLAG

VALIDATION_TYPE

VALIDATION_LEVEL

UNIQUENESS_VALIDATION_LEVEL

TAX_EXCPT_CREATE_METHOD_CODE

TAX_EXCPT_SOURCE_TAX

Query

SQL_Statement
SELECT DISTINCT ZTB.ROWID AS ROW_ID, ZTB.TAX_ID, ZTB.TAX, ZSD.FIRST_PTY_ORG_ID CONTENT_OWNER_ID, ZTB.EFFECTIVE_FROM, ZTB.EFFECTIVE_TO, ZTB.TAX_REGIME_CODE, ZTB.TAX_TYPE_CODE, ZTB.ALLOW_MANUAL_ENTRY_FLAG, ZTB.ALLOW_TAX_OVERRIDE_FLAG, ZTB.MIN_TXBL_BSIS_THRSHLD, ZTB.MAX_TXBL_BSIS_THRSHLD, ZTB.MIN_TAX_RATE_THRSHLD, ZTB.MAX_TAX_RATE_THRSHLD, ZTB.MIN_TAX_AMT_THRSHLD, ZTB.MAX_TAX_AMT_THRSHLD, ZTB.COMPOUNDING_PRECEDENCE, ZTB.PERIOD_SET_NAME, ZTB.EXCHANGE_RATE_TYPE, ZTB.TAX_CURRENCY_CODE, ZTB.REP_TAX_AUTHORITY_ID, ZTB.COLL_TAX_AUTHORITY_ID, ZTB.TAX_PRECISION, ZTB.MINIMUM_ACCOUNTABLE_UNIT, ZTB.ROUNDING_RULE_CODE, ZTB.TAX_STATUS_RULE_FLAG, ZTB.TAX_RATE_RULE_FLAG, ZTB.DEF_PLACE_OF_SUPPLY_TYPE_CODE, ZTB.PLACE_OF_SUPPLY_RULE_FLAG, ZTB.DIRECT_RATE_RULE_FLAG, ZTB.APPLICABILITY_RULE_FLAG, ZTB.TAX_CALC_RULE_FLAG, ZTB.TXBL_BSIS_THRSHLD_FLAG, ZTB.TAX_RATE_THRSHLD_FLAG, ZTB.TAX_AMT_THRSHLD_FLAG, ZTB.TAXABLE_BASIS_RULE_FLAG, ZTB.DEF_INCLUSIVE_TAX_FLAG, ZTB.THRSHLD_GROUPING_LVL_CODE, ZTB.THRSHLD_CHK_TMPLT_CODE, ZTB.HAS_OTHER_JURISDICTIONS_FLAG, ZTB.ALLOW_EXEMPTIONS_FLAG, ZTB.ALLOW_EXCEPTIONS_FLAG, ZTB.ALLOW_RECOVERABILITY_FLAG, ZTB.DEF_TAX_CALC_FORMULA, ZTB.TAX_INCLUSIVE_OVERRIDE_FLAG, ZTB.DEF_TAXABLE_BASIS_FORMULA, ZTB.DEF_REGISTR_PARTY_TYPE_CODE, ZTB.REGISTRATION_TYPE_RULE_FLAG, ZTB.REPORTING_ONLY_FLAG, ZTB.AUTO_PRVN_FLAG, ZTB.LIVE_FOR_PROCESSING_FLAG, ZTB.HAS_DETAIL_TB_THRSHLD_FLAG, ZTB.HAS_TAX_DET_DATE_RULE_FLAG, ZTB.HAS_EXCH_RATE_DATE_RULE_FLAG, ZTB.HAS_TAX_POINT_DATE_RULE_FLAG, ZTB.PRINT_ON_INVOICE_FLAG, ZTB.USE_LEGAL_MSG_FLAG, ZTB.CALC_ONLY_FLAG, ZTB.PRIMARY_RECOVERY_TYPE_CODE, ZTB.PRIMARY_REC_TYPE_RULE_FLAG, ZTB.SECONDARY_RECOVERY_TYPE_CODE, ZTB.SECONDARY_REC_TYPE_RULE_FLAG, ZTB.PRIMARY_REC_RATE_DET_RULE_FLAG, ZTB.SEC_REC_RATE_DET_RULE_FLAG, ZTB.OFFSET_TAX_FLAG, ZTB.RECOVERY_RATE_OVERRIDE_FLAG, ZTB.ZONE_GEOGRAPHY_TYPE, ZTB.REGN_NUM_SAME_AS_LE_FLAG, ZTB.DEF_REC_SETTLEMENT_OPTION_CODE, ZTB.PARENT_GEOGRAPHY_TYPE, ZTB.PARENT_GEOGRAPHY_ID, ZTB.ALLOW_MASS_CREATE_FLAG, ZTB.APPLIED_AMT_HANDLING_FLAG, ZTB.SOURCE_TAX_FLAG, ZTB.DEF_PRIMARY_REC_RATE_CODE, ZTB.DEF_SECONDARY_REC_RATE_CODE, ZTB.ALLOW_DUP_REGN_NUM_FLAG, ZTB.TAX_ACCOUNT_SOURCE_TAX, ZTB.TAX_ACCOUNT_CREATE_METHOD_CODE, ZTB.TAX_EXMPT_SOURCE_TAX, ZTB.TAX_EXMPT_CR_METHOD_CODE, ZTB.OVERRIDE_GEOGRAPHY_TYPE, ZTB.LIVE_FOR_APPLICABILITY_FLAG, ZTB.CREATED_BY, ZTB.CREATION_DATE, ZTB.LAST_UPDATED_BY, ZTB.LAST_UPDATE_DATE, ZTB.LAST_UPDATE_LOGIN, ZTB.REQUEST_ID, ZTB.PROGRAM_APP_NAME, ZTB.PROGRAM_NAME, ZTB.PROGRAM_LOGIN_ID, ZTB.RECORD_TYPE_CODE, ZTB.ALLOW_ROUNDING_OVERRIDE_FLAG, ZTB.SPECIAL_INCLUSIVE_TAX_FLAG, ZTB.ATTRIBUTE1, ZTB.ATTRIBUTE2, ZTB.ATTRIBUTE3, ZTB.ATTRIBUTE4, ZTB.ATTRIBUTE5, ZTB.ATTRIBUTE6, ZTB.ATTRIBUTE7, ZTB.ATTRIBUTE8, ZTB.ATTRIBUTE9, ZTB.ATTRIBUTE10, ZTB.ATTRIBUTE11, ZTB.ATTRIBUTE12, ZTB.ATTRIBUTE13, ZTB.ATTRIBUTE14, ZTB.ATTRIBUTE15, ZTB.ATTRIBUTE_CATEGORY, ZTT.TAX_FULL_NAME, ZTB.APPLICABLE_BY_DEFAULT_FLAG, ZFPOMV.PARTY_NAME, ZFPOMV.PARTY_TYPE_CODE, ZFPOMV.BU_ID, ZSD.VIEW_OPTIONS_CODE, ZTB.WHT_BUCKET_LEVEL_FLAG, ZTB.PROCESS_WHT_FLAG, ZTB.WHT_CALC_POINT_FLAG, ZTB.VALIDATION_TYPE, ZTB.VALIDATION_LEVEL, ZTB.UNIQUENESS_VALIDATION_LEVEL, ZTB.TAX_EXCPT_CREATE_METHOD_CODE, ZTB.TAX_EXCPT_SOURCE_TAX FROM ZX_TAXES_B ZTB, ZX_TAXES_TL ZTT, ZX_SUBSCRIPTION_DETAILS ZSD, ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV WHERE ZTT.TAX_ID = ZTB.TAX_ID AND ZTT.LANGUAGE = USERENV('LANG') AND ZSD.PARENT_FIRST_PTY_ORG_ID = ZTB.CONTENT_OWNER_ID AND ZSD.TAX_REGIME_CODE = ZTB.TAX_REGIME_CODE AND ZFPOMV.PARTY_TAX_PROFILE_ID = ZSD.FIRST_PTY_ORG_ID AND ZSD.VIEW_OPTIONS_CODE IN ('VFC','VFR') AND ((ZSD.FIRST_PTY_ORG_ID = -99 AND ZX_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS') = 'Y' ) OR (ZSD.FIRST_PTY_ORG_ID <> -99)) AND ZTB.LIVE_FOR_APPLICABILITY_FLAG = 'Y' ORDER BY ZSD.VIEW_OPTIONS_CODE

SQL_Statement

SELECT DISTINCT ZTB.ROWID AS ROW_ID,

ZTB.TAX_ID,

ZTB.TAX,

ZSD.FIRST_PTY_ORG_ID CONTENT_OWNER_ID,

ZTB.EFFECTIVE_FROM,

ZTB.EFFECTIVE_TO,

ZTB.TAX_REGIME_CODE,

ZTB.TAX_TYPE_CODE,

ZTB.ALLOW_MANUAL_ENTRY_FLAG,

ZTB.ALLOW_TAX_OVERRIDE_FLAG,

ZTB.MIN_TXBL_BSIS_THRSHLD,

ZTB.MAX_TXBL_BSIS_THRSHLD,

ZTB.MIN_TAX_RATE_THRSHLD,

ZTB.MAX_TAX_RATE_THRSHLD,

ZTB.MIN_TAX_AMT_THRSHLD,

ZTB.MAX_TAX_AMT_THRSHLD,

ZTB.COMPOUNDING_PRECEDENCE,

ZTB.PERIOD_SET_NAME,

ZTB.EXCHANGE_RATE_TYPE,

ZTB.TAX_CURRENCY_CODE,

ZTB.REP_TAX_AUTHORITY_ID,

ZTB.COLL_TAX_AUTHORITY_ID,

ZTB.TAX_PRECISION,

ZTB.MINIMUM_ACCOUNTABLE_UNIT,

ZTB.ROUNDING_RULE_CODE,

ZTB.TAX_STATUS_RULE_FLAG,

ZTB.TAX_RATE_RULE_FLAG,

ZTB.DEF_PLACE_OF_SUPPLY_TYPE_CODE,

ZTB.PLACE_OF_SUPPLY_RULE_FLAG,

ZTB.DIRECT_RATE_RULE_FLAG,

ZTB.APPLICABILITY_RULE_FLAG,

ZTB.TAX_CALC_RULE_FLAG,

ZTB.TXBL_BSIS_THRSHLD_FLAG,

ZTB.TAX_RATE_THRSHLD_FLAG,

ZTB.TAX_AMT_THRSHLD_FLAG,

ZTB.TAXABLE_BASIS_RULE_FLAG,

ZTB.DEF_INCLUSIVE_TAX_FLAG,

ZTB.THRSHLD_GROUPING_LVL_CODE,

ZTB.THRSHLD_CHK_TMPLT_CODE,

ZTB.HAS_OTHER_JURISDICTIONS_FLAG,

ZTB.ALLOW_EXEMPTIONS_FLAG,

ZTB.ALLOW_EXCEPTIONS_FLAG,

ZTB.ALLOW_RECOVERABILITY_FLAG,

ZTB.DEF_TAX_CALC_FORMULA,

ZTB.TAX_INCLUSIVE_OVERRIDE_FLAG,

ZTB.DEF_TAXABLE_BASIS_FORMULA,

ZTB.DEF_REGISTR_PARTY_TYPE_CODE,

ZTB.REGISTRATION_TYPE_RULE_FLAG,

ZTB.REPORTING_ONLY_FLAG,

ZTB.AUTO_PRVN_FLAG,

ZTB.LIVE_FOR_PROCESSING_FLAG,

ZTB.HAS_DETAIL_TB_THRSHLD_FLAG,

ZTB.HAS_TAX_DET_DATE_RULE_FLAG,

ZTB.HAS_EXCH_RATE_DATE_RULE_FLAG,

ZTB.HAS_TAX_POINT_DATE_RULE_FLAG,

ZTB.PRINT_ON_INVOICE_FLAG,

ZTB.USE_LEGAL_MSG_FLAG,

ZTB.CALC_ONLY_FLAG,

ZTB.PRIMARY_RECOVERY_TYPE_CODE,

ZTB.PRIMARY_REC_TYPE_RULE_FLAG,

ZTB.SECONDARY_RECOVERY_TYPE_CODE,

ZTB.SECONDARY_REC_TYPE_RULE_FLAG,

ZTB.PRIMARY_REC_RATE_DET_RULE_FLAG,

ZTB.SEC_REC_RATE_DET_RULE_FLAG,

ZTB.OFFSET_TAX_FLAG,

ZTB.RECOVERY_RATE_OVERRIDE_FLAG,

ZTB.ZONE_GEOGRAPHY_TYPE,

ZTB.REGN_NUM_SAME_AS_LE_FLAG,

ZTB.DEF_REC_SETTLEMENT_OPTION_CODE,

ZTB.PARENT_GEOGRAPHY_TYPE,

ZTB.PARENT_GEOGRAPHY_ID,

ZTB.ALLOW_MASS_CREATE_FLAG,

ZTB.APPLIED_AMT_HANDLING_FLAG,

ZTB.SOURCE_TAX_FLAG,

ZTB.DEF_PRIMARY_REC_RATE_CODE,

ZTB.DEF_SECONDARY_REC_RATE_CODE,

ZTB.ALLOW_DUP_REGN_NUM_FLAG,

ZTB.TAX_ACCOUNT_SOURCE_TAX,

ZTB.TAX_ACCOUNT_CREATE_METHOD_CODE,

ZTB.TAX_EXMPT_SOURCE_TAX,

ZTB.TAX_EXMPT_CR_METHOD_CODE,

ZTB.OVERRIDE_GEOGRAPHY_TYPE,

ZTB.LIVE_FOR_APPLICABILITY_FLAG,

ZTB.CREATED_BY,

ZTB.CREATION_DATE,

ZTB.LAST_UPDATED_BY,

ZTB.LAST_UPDATE_DATE,

ZTB.LAST_UPDATE_LOGIN,

ZTB.REQUEST_ID,

ZTB.PROGRAM_APP_NAME,

ZTB.PROGRAM_NAME,

ZTB.PROGRAM_LOGIN_ID,

ZTB.RECORD_TYPE_CODE,

ZTB.ALLOW_ROUNDING_OVERRIDE_FLAG,

ZTB.SPECIAL_INCLUSIVE_TAX_FLAG,

ZTB.ATTRIBUTE1,

ZTB.ATTRIBUTE2,

ZTB.ATTRIBUTE3,

ZTB.ATTRIBUTE4,

ZTB.ATTRIBUTE5,

ZTB.ATTRIBUTE6,

ZTB.ATTRIBUTE7,

ZTB.ATTRIBUTE8,

ZTB.ATTRIBUTE9,

ZTB.ATTRIBUTE10,

ZTB.ATTRIBUTE11,

ZTB.ATTRIBUTE12,

ZTB.ATTRIBUTE13,

ZTB.ATTRIBUTE14,

ZTB.ATTRIBUTE15,

ZTB.ATTRIBUTE_CATEGORY,

ZTT.TAX_FULL_NAME,

ZTB.APPLICABLE_BY_DEFAULT_FLAG,

ZFPOMV.PARTY_NAME,

ZFPOMV.PARTY_TYPE_CODE,

ZFPOMV.BU_ID,

ZSD.VIEW_OPTIONS_CODE,

ZTB.WHT_BUCKET_LEVEL_FLAG,

ZTB.PROCESS_WHT_FLAG,

ZTB.WHT_CALC_POINT_FLAG,

ZTB.VALIDATION_TYPE,

ZTB.VALIDATION_LEVEL,

ZTB.UNIQUENESS_VALIDATION_LEVEL,

ZTB.TAX_EXCPT_CREATE_METHOD_CODE,

ZTB.TAX_EXCPT_SOURCE_TAX

FROM ZX_TAXES_B ZTB,

ZX_TAXES_TL ZTT,

ZX_SUBSCRIPTION_DETAILS ZSD,

ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV

WHERE ZTT.TAX_ID = ZTB.TAX_ID

AND ZTT.LANGUAGE = USERENV('LANG')

AND ZSD.PARENT_FIRST_PTY_ORG_ID = ZTB.CONTENT_OWNER_ID

AND ZSD.TAX_REGIME_CODE = ZTB.TAX_REGIME_CODE

AND ZFPOMV.PARTY_TAX_PROFILE_ID = ZSD.FIRST_PTY_ORG_ID

AND ZSD.VIEW_OPTIONS_CODE IN ('VFC','VFR')

AND ((ZSD.FIRST_PTY_ORG_ID = -99

AND ZX_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS') = 'Y'

) OR (ZSD.FIRST_PTY_ORG_ID <> -99))

AND ZTB.LIVE_FOR_APPLICABILITY_FLAG = 'Y'

ORDER BY ZSD.VIEW_OPTIONS_CODE