Skip to content

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

VIEW: APPS.AP_TAX_CODES_ALL1_DFV

Object Details
Object Name: AP_TAX_CODES_ALL1_DFV
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CONTEXT_VALUE VARCHAR2 (150)
LOCATION VARCHAR2 (150)
WITHHOLDING_TAX_TYPE VARCHAR2 (150)
WITHHOLDING_CERTIFICATE_TYPE VARCHAR2 (150)
DOMESTIC_INCOME_CATEGORY VARCHAR2 (150)
FOREIGN_INCOME_CATEGORY VARCHAR2 (150)
RECOGNIZED_EXPENSE NUMBER

NOMINAL_TAX_RATE NUMBER

MINIMUM_WITHHELD_AMOUNT NUMBER

WITHHOLDING_TYPE VARCHAR2 (150)
TAX_AUTHORITY_CATEGORY VARCHAR2 (150)
FOREIGN_RATE_INDICATOR VARCHAR2 (150)
ZONE VARCHAR2 (150)
ITEM_LINE_TYPE_APPLICABILITY VARCHAR2 (150)
FREIGHT_LINE_TYPE_APPL VARCHAR2 (150)
MISCELLANEOUS_LINE_TYPE_APPL VARCHAR2 (150)
TAX_LINE_TYPE_APPLICABILITY VARCHAR2 (150)
MINIMUM_TAXABLE_BASE_AMOUNT NUMBER

ADJUSTMENT_MINIMUM_BASE VARCHAR2 (150)
CUMULATIVE_PAYMENT_APPLICABLE VARCHAR2 (150)
TAX_INCLUSIVE VARCHAR2 (150)
SUPP_CONDITION_CODE VARCHAR2 (150)
DEFAULT_TYPE VARCHAR2 (150)
VALIDATE_FULL VARCHAR2 (150)
TAX_RECOVERABLE_ACCT VARCHAR2 (150)
WHT_TAX_TYPE VARCHAR2 (150)
CHILE_TAX_CATEGORY VARCHAR2 (150)
INCOME_TAX_RATE NUMBER

FIRST_TAX_TYPE VARCHAR2 (150)
SECOND_TAX_TYPE VARCHAR2 (150)
MUNICIPAL_TAX_TYPES VARCHAR2 (150)
REDUCTION_PERCENTAGE NUMBER

REPORTED_TAX_RATE NUMBER

CONCATENATED_SEGMENTS VARCHAR2 (2415)
Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      LOCATION
,      WITHHOLDING_TAX_TYPE
,      WITHHOLDING_CERTIFICATE_TYPE
,      DOMESTIC_INCOME_CATEGORY
,      FOREIGN_INCOME_CATEGORY
,      RECOGNIZED_EXPENSE
,      NOMINAL_TAX_RATE
,      MINIMUM_WITHHELD_AMOUNT
,      WITHHOLDING_TYPE
,      TAX_AUTHORITY_CATEGORY
,      FOREIGN_RATE_INDICATOR
,      ZONE
,      ITEM_LINE_TYPE_APPLICABILITY
,      FREIGHT_LINE_TYPE_APPL
,      MISCELLANEOUS_LINE_TYPE_APPL
,      TAX_LINE_TYPE_APPLICABILITY
,      MINIMUM_TAXABLE_BASE_AMOUNT
,      ADJUSTMENT_MINIMUM_BASE
,      CUMULATIVE_PAYMENT_APPLICABLE
,      TAX_INCLUSIVE
,      SUPP_CONDITION_CODE
,      DEFAULT_TYPE
,      VALIDATE_FULL
,      TAX_RECOVERABLE_ACCT
,      WHT_TAX_TYPE
,      CHILE_TAX_CATEGORY
,      INCOME_TAX_RATE
,      FIRST_TAX_TYPE
,      SECOND_TAX_TYPE
,      MUNICIPAL_TAX_TYPES
,      REDUCTION_PERCENTAGE
,      REPORTED_TAX_RATE
,      CONCATENATED_SEGMENTS
FROM APPS.AP_TAX_CODES_ALL1_DFV;

Dependencies

[top of page]

APPS.AP_TAX_CODES_ALL1_DFV references the following:

SchemaAPPS
SynonymAP_TAX_CODES_ALL
PL/SQL PackageFND_NUMBER - show dependent code

APPS.AP_TAX_CODES_ALL1_DFV is not referenced by any database object