View: ZX_SCO_TAXES_B_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ZX_SCO_TAXES_B_V

View Text

SELECT A.ROWID ROW_ID
, A.TAX_ID
, A.TAX
, A.CONTENT_OWNER_ID
, A.EFFECTIVE_FROM
, A.EFFECTIVE_TO
, A.TAX_REGIME_CODE
, A.TAX_TYPE_CODE
, A.ALLOW_MANUAL_ENTRY_FLAG
, A.ALLOW_TAX_OVERRIDE_FLAG
, A.MIN_TXBL_BSIS_THRSHLD
, A.MAX_TXBL_BSIS_THRSHLD
, A.MIN_TAX_RATE_THRSHLD
, A.MAX_TAX_RATE_THRSHLD
, A.MIN_TAX_AMT_THRSHLD
, A.MAX_TAX_AMT_THRSHLD
, A.COMPOUNDING_PRECEDENCE
, A.PERIOD_SET_NAME
, A.EXCHANGE_RATE_TYPE
, A.TAX_CURRENCY_CODE
, A.REP_TAX_AUTHORITY_ID
, A.COLL_TAX_AUTHORITY_ID
, A.TAX_PRECISION
, A.MINIMUM_ACCOUNTABLE_UNIT
, A.ROUNDING_RULE_CODE
, A.TAX_STATUS_RULE_FLAG
, A.TAX_RATE_RULE_FLAG
, A.DEF_PLACE_OF_SUPPLY_TYPE_CODE
, A.PLACE_OF_SUPPLY_RULE_FLAG
, A.DIRECT_RATE_RULE_FLAG
, A.APPLICABILITY_RULE_FLAG
, A.TAX_CALC_RULE_FLAG
, A.TXBL_BSIS_THRSHLD_FLAG
, A.TAX_RATE_THRSHLD_FLAG
, A.TAX_AMT_THRSHLD_FLAG
, A.TAXABLE_BASIS_RULE_FLAG
, A.DEF_INCLUSIVE_TAX_FLAG
, A.THRSHLD_GROUPING_LVL_CODE
, A.THRSHLD_CHK_TMPLT_CODE
, A.HAS_OTHER_JURISDICTIONS_FLAG
, A.ALLOW_EXEMPTIONS_FLAG
, A.ALLOW_EXCEPTIONS_FLAG
, A.ALLOW_RECOVERABILITY_FLAG
, A.DEF_TAX_CALC_FORMULA
, A.TAX_INCLUSIVE_OVERRIDE_FLAG
, A.DEF_TAXABLE_BASIS_FORMULA
, A.DEF_REGISTR_PARTY_TYPE_CODE
, A.REGISTRATION_TYPE_RULE_FLAG
, A.REPORTING_ONLY_FLAG
, A.AUTO_PRVN_FLAG
, A.LIVE_FOR_PROCESSING_FLAG
, A.HAS_DETAIL_TB_THRSHLD_FLAG
, A.HAS_TAX_DET_DATE_RULE_FLAG
, A.HAS_EXCH_RATE_DATE_RULE_FLAG
, A.HAS_TAX_POINT_DATE_RULE_FLAG
, A.PRINT_ON_INVOICE_FLAG
, A.USE_LEGAL_MSG_FLAG
, A.CALC_ONLY_FLAG
, A.PRIMARY_RECOVERY_TYPE_CODE
, A.PRIMARY_REC_TYPE_RULE_FLAG
, A.SECONDARY_RECOVERY_TYPE_CODE
, A.SECONDARY_REC_TYPE_RULE_FLAG
, A.PRIMARY_REC_RATE_DET_RULE_FLAG
, A.SEC_REC_RATE_DET_RULE_FLAG
, A.OFFSET_TAX_FLAG
, A.RECOVERY_RATE_OVERRIDE_FLAG
, A.ZONE_GEOGRAPHY_TYPE
, A.REGN_NUM_SAME_AS_LE_FLAG
, A.DEF_REC_SETTLEMENT_OPTION_CODE
, A.PARENT_GEOGRAPHY_TYPE
, A.PARENT_GEOGRAPHY_ID
, A.ALLOW_MASS_CREATE_FLAG
, A.APPLIED_AMT_HANDLING_FLAG
, A.SOURCE_TAX_FLAG
, A.DEF_PRIMARY_REC_RATE_CODE
, A.DEF_SECONDARY_REC_RATE_CODE
, A.ALLOW_DUP_REGN_NUM_FLAG
, A.TAX_ACCOUNT_SOURCE_TAX
, A.TAX_ACCOUNT_CREATE_METHOD_CODE
, A.TAX_EXMPT_SOURCE_TAX
, A.TAX_EXMPT_CR_METHOD_CODE
, A.OVERRIDE_GEOGRAPHY_TYPE
, A.LIVE_FOR_APPLICABILITY_FLAG
, A.OBJECT_VERSION_NUMBER
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_LOGIN_ID
, A.RECORD_TYPE_CODE
, A.ALLOW_ROUNDING_OVERRIDE_FLAG
, A.SPECIAL_INCLUSIVE_TAX_FLAG
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.ATTRIBUTE_CATEGORY
, SD.VIEW_OPTIONS_CODE SUBSCRIPTION_LEVEL_CODE
, SD.FIRST_PTY_ORG_ID SDCO_ID
, SD.EFFECTIVE_FROM SDEFF_FROM
, SD.EFFECTIVE_TO SDEFF_TO
, A.APPLICABLE_BY_DEFAULT_FLAG
, A.LEGAL_REPORTING_STATUS_DEF_VAL
FROM ZX_TAXES_B A
, ZX_SUBSCRIPTION_DETAILS SD WHERE A.TAX_REGIME_CODE = SD.TAX_REGIME_CODE
AND A.CONTENT_OWNER_ID = SD.PARENT_FIRST_PTY_ORG_ID
AND SD.VIEW_OPTIONS_CODE <> 'VFD' ORDER BY SD.VIEW_OPTIONS_CODE