[Home] [Help] [Dependency Information]

VIEW: APPS.ZX_MCO_LV_TAXES_V

Object Details

Object Name:	ZX_MCO_LV_TAXES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.ZX_MCO_LV_TAXES_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT 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_APPLICATION_ID
,      PROGRAM_ID
,      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
,      VIEW_OPTIONS_CODE
FROM APPS.ZX_MCO_LV_TAXES_V;

Dependencies

[top of page]

APPS

FND_GLOBAL - show dependent code

FND_PROFILE - show dependent code

ZX_FIRST_PARTY_ORGS_MOAC_V

ZX_SUBSCRIPTION_DETAILS

ZX_TAXES_B

ZX_TAXES_TL

APPS

ZX_PTP_IMPORT - show dependent code