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

VIEW: APPS.XTR_TAX_BROKERAGE_SETUP_V

Object Details
Object Name: XTR_TAX_BROKERAGE_SETUP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_TAX_BROKERAGE_SETUP_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
DEDUCTION_TYPE VARCHAR2 (1) Yes
REFERENCE_CODE VARCHAR2 (7) Yes
RATE_GROUP VARCHAR2 (7) Yes
CALC_TYPE VARCHAR2 (30) Yes
DESCRIPTION VARCHAR2 (30)
PAYEE VARCHAR2 (7) Yes
NOMINAL_ANNUAL_TAX_BREAK NUMBER

UPDATED_BY VARCHAR2 (30)
UPDATED_ON DATE

DEAL_TYPE VARCHAR2 (7) Yes
AUDIT_INDICATOR VARCHAR2 (1)
AUTHORISED VARCHAR2 (1) Yes
CREATED_BY VARCHAR2 (30) Yes
CREATED_ON DATE
Yes
TAX_ROUNDING_RULE VARCHAR2 (1)
TAX_ROUNDING_PRECISION VARCHAR2 (20)
TAX_SETTLE_METHOD VARCHAR2 (15)
Query Text

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


SELECT DEDUCTION_TYPE
,      REFERENCE_CODE
,      RATE_GROUP
,      CALC_TYPE
,      DESCRIPTION
,      PAYEE
,      NOMINAL_ANNUAL_TAX_BREAK
,      UPDATED_BY
,      UPDATED_ON
,      DEAL_TYPE
,      AUDIT_INDICATOR
,      AUTHORISED
,      CREATED_BY
,      CREATED_ON
,      TAX_ROUNDING_RULE
,      TAX_ROUNDING_PRECISION
,      TAX_SETTLE_METHOD
FROM APPS.XTR_TAX_BROKERAGE_SETUP_V;

Dependencies

[top of page]

APPS.XTR_TAX_BROKERAGE_SETUP_V references the following:

SchemaAPPS
SynonymXTR_TAX_BROKERAGE_SETUP
APPS.XTR_TAX_BROKERAGE_SETUP_V is referenced by following:

SchemaAPPS
Package BodyXTR_FPS2_P - show dependent code
Package BodyXTR_FX_TRANSFERS_PKG - show dependent code
Package BodyXTR_NI_TRANSFERS_PKG - show dependent code
PL/SQL PackageXTR_NI_TRANSFERS_PKG - show dependent code