eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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
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:

APPS: AP_TAX_CODES_ALL; FND_NUMBER - show dependent code

APPS.AP_TAX_CODES_ALL1_DFV is not referenced by any database object