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

VIEW: ZX.ZX_TAX_RELATIONS_T#

Object Details
Object Name: ZX_TAX_RELATIONS_T#
Object Type: VIEW
Owner: ZX
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PARENT_TAX_CODE_ID NUMBER (15) Yes
PARENT_TAX_CODE VARCHAR2 (50) Yes
PARENT_REGIME_CODE VARCHAR2 (30) Yes
PARENT_PRECEDENCE VARCHAR2 (30)
CHILD_TAX_CODE_ID NUMBER (15)
CHILD_TAX_CODE VARCHAR2 (50)
CHILD_REGIME_CODE VARCHAR2 (30)
BRANCH_FLAG VARCHAR2 (30)
TAX_GROUP_ID NUMBER (15) Yes
CHILD_PRECEDENCE VARCHAR2 (30)
PARENT_TAXABLE_BASIS VARCHAR2 (30)
CHILD_TAXABLE_BASIS VARCHAR2 (30)
PARENT_TAX VARCHAR2 (50) Yes
CHILD_TAX VARCHAR2 (50)
TAX_GROUP_CODE VARCHAR2 (50)
CONTENT_OWNER_ID NUMBER (15) Yes
ORG_ID NUMBER (15) 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

Query Text

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


SELECT PARENT_TAX_CODE_ID
,      PARENT_TAX_CODE
,      PARENT_REGIME_CODE
,      PARENT_PRECEDENCE
,      CHILD_TAX_CODE_ID
,      CHILD_TAX_CODE
,      CHILD_REGIME_CODE
,      BRANCH_FLAG
,      TAX_GROUP_ID
,      CHILD_PRECEDENCE
,      PARENT_TAXABLE_BASIS
,      CHILD_TAXABLE_BASIS
,      PARENT_TAX
,      CHILD_TAX
,      TAX_GROUP_CODE
,      CONTENT_OWNER_ID
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
FROM ZX.ZX_TAX_RELATIONS_T#;

Dependencies

[top of page]

ZX.ZX_TAX_RELATIONS_T# references the following:

SchemaZX
TableZX_TAX_RELATIONS_T
ZX.ZX_TAX_RELATIONS_T# is referenced by following:

SchemaAPPS
SynonymZX_TAX_RELATIONS_T