DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.ZX_TAXES_VL

Object Details
Object Name: ZX_TAXES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFND.ZX_TAXES_VL
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TAX_ID NUMBER (15) Yes
TAX VARCHAR2 (30) Yes
CONTENT_OWNER_ID NUMBER (15) Yes
EFFECTIVE_FROM DATE

EFFECTIVE_TO DATE

TAX_REGIME_CODE VARCHAR2 (30) Yes
TAX_TYPE_CODE VARCHAR2 (30)
ALLOW_MANUAL_ENTRY_FLAG VARCHAR2 (1)
ALLOW_TAX_OVERRIDE_FLAG VARCHAR2 (1)
MIN_TXBL_BSIS_THRSHLD NUMBER

MAX_TXBL_BSIS_THRSHLD NUMBER

MIN_TAX_RATE_THRSHLD NUMBER

MAX_TAX_RATE_THRSHLD NUMBER

MIN_TAX_AMT_THRSHLD NUMBER

MAX_TAX_AMT_THRSHLD NUMBER

COMPOUNDING_PRECEDENCE NUMBER

PERIOD_SET_NAME VARCHAR2 (15)
EXCHANGE_RATE_TYPE VARCHAR2 (30)
TAX_CURRENCY_CODE VARCHAR2 (15)
REP_TAX_AUTHORITY_ID NUMBER (15)
COLL_TAX_AUTHORITY_ID NUMBER (15)
TAX_PRECISION NUMBER

MINIMUM_ACCOUNTABLE_UNIT NUMBER

ROUNDING_RULE_CODE VARCHAR2 (30)
TAX_STATUS_RULE_FLAG VARCHAR2 (1)
TAX_RATE_RULE_FLAG VARCHAR2 (1)
DEF_PLACE_OF_SUPPLY_TYPE_CODE VARCHAR2 (30)
PLACE_OF_SUPPLY_RULE_FLAG VARCHAR2 (1)
DIRECT_RATE_RULE_FLAG VARCHAR2 (1)
APPLICABILITY_RULE_FLAG VARCHAR2 (1)
TAX_CALC_RULE_FLAG VARCHAR2 (1)
TXBL_BSIS_THRSHLD_FLAG VARCHAR2 (1)
TAX_RATE_THRSHLD_FLAG VARCHAR2 (1)
TAX_AMT_THRSHLD_FLAG VARCHAR2 (1)
TAXABLE_BASIS_RULE_FLAG VARCHAR2 (1)
DEF_INCLUSIVE_TAX_FLAG VARCHAR2 (1)
THRSHLD_GROUPING_LVL_CODE VARCHAR2 (30)
THRSHLD_CHK_TMPLT_CODE VARCHAR2 (30)
HAS_OTHER_JURISDICTIONS_FLAG VARCHAR2 (1)
ALLOW_EXEMPTIONS_FLAG VARCHAR2 (1)
ALLOW_EXCEPTIONS_FLAG VARCHAR2 (1)
ALLOW_RECOVERABILITY_FLAG VARCHAR2 (1)
DEF_TAX_CALC_FORMULA VARCHAR2 (30)
TAX_INCLUSIVE_OVERRIDE_FLAG VARCHAR2 (1)
DEF_TAXABLE_BASIS_FORMULA VARCHAR2 (30)
DEF_REGISTR_PARTY_TYPE_CODE VARCHAR2 (30)
REGISTRATION_TYPE_RULE_FLAG VARCHAR2 (1)
REPORTING_ONLY_FLAG VARCHAR2 (1)
AUTO_PRVN_FLAG VARCHAR2 (1)
LIVE_FOR_PROCESSING_FLAG VARCHAR2 (1)
HAS_DETAIL_TB_THRSHLD_FLAG VARCHAR2 (1)
HAS_TAX_DET_DATE_RULE_FLAG VARCHAR2 (1)
HAS_EXCH_RATE_DATE_RULE_FLAG VARCHAR2 (1)
HAS_TAX_POINT_DATE_RULE_FLAG VARCHAR2 (1)
PRINT_ON_INVOICE_FLAG VARCHAR2 (1)
USE_LEGAL_MSG_FLAG VARCHAR2 (1)
CALC_ONLY_FLAG VARCHAR2 (1)
PRIMARY_RECOVERY_TYPE_CODE VARCHAR2 (30)
PRIMARY_REC_TYPE_RULE_FLAG VARCHAR2 (1)
SECONDARY_RECOVERY_TYPE_CODE VARCHAR2 (30)
SECONDARY_REC_TYPE_RULE_FLAG VARCHAR2 (1)
PRIMARY_REC_RATE_DET_RULE_FLAG VARCHAR2 (1)
SEC_REC_RATE_DET_RULE_FLAG VARCHAR2 (1)
OFFSET_TAX_FLAG VARCHAR2 (1)
RECOVERY_RATE_OVERRIDE_FLAG VARCHAR2 (1)
ZONE_GEOGRAPHY_TYPE VARCHAR2 (30)
REGN_NUM_SAME_AS_LE_FLAG VARCHAR2 (1)
DEF_REC_SETTLEMENT_OPTION_CODE VARCHAR2 (30)
PARENT_GEOGRAPHY_TYPE VARCHAR2 (30)
PARENT_GEOGRAPHY_ID NUMBER (15)
ALLOW_MASS_CREATE_FLAG VARCHAR2 (1)
APPLIED_AMT_HANDLING_FLAG VARCHAR2 (1)
SOURCE_TAX_FLAG VARCHAR2 (1)
DEF_PRIMARY_REC_RATE_CODE VARCHAR2 (50)
DEF_SECONDARY_REC_RATE_CODE VARCHAR2 (50)
ALLOW_DUP_REGN_NUM_FLAG VARCHAR2 (1)
TAX_ACCOUNT_SOURCE_TAX VARCHAR2 (30)
TAX_ACCOUNT_CREATE_METHOD_CODE VARCHAR2 (30)
TAX_EXMPT_SOURCE_TAX VARCHAR2 (30)
TAX_EXMPT_CR_METHOD_CODE VARCHAR2 (30)
OVERRIDE_GEOGRAPHY_TYPE VARCHAR2 (30)
LIVE_FOR_APPLICABILITY_FLAG VARCHAR2 (1)
OBJECT_VERSION_NUMBER NUMBER
Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_LOGIN_ID NUMBER

RECORD_TYPE_CODE VARCHAR2 (30)
ALLOW_ROUNDING_OVERRIDE_FLAG VARCHAR2 (1)
SPECIAL_INCLUSIVE_TAX_FLAG VARCHAR2 (1)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
TAX_FULL_NAME VARCHAR2 (80)
APPLICABLE_BY_DEFAULT_FLAG VARCHAR2 (1)
LEGAL_REPORTING_STATUS_DEF_VAL VARCHAR2 (15)
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
,      OBJECT_VERSION_NUMBER
,      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
,      LEGAL_REPORTING_STATUS_DEF_VAL
FROM APPS.ZX_TAXES_VL;

Dependencies

[top of page]

APPS.ZX_TAXES_VL references the following:

SchemaAPPS
SynonymZX_TAXES_B
SynonymZX_TAXES_TL
APPS.ZX_TAXES_VL is referenced by following:

SchemaAPPS
Package BodyAR_BPA_UTILS_PKG - show dependent code
ViewASO_TAX_DETAILS_V
Package BodyJE_ZZ_AUDIT_AP_PKG - show dependent code
SynonymZX_MCO_TAXES
Package BodyZX_PTP_IMPORT - show dependent code
ViewZX_SIM_RULES_VL
ViewZX_SIM_RULE_RESULTS_V