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]

TABLE: ZX.ZX_DISTCCID_DET_FACTS_GT

Object Details

Object Name:	ZX_DISTCCID_DET_FACTS_GT
Object Type:	TABLE
Owner:	ZX
Subobject Name:
Status:	VALID

Temporary Table Details

ZX.ZX_DISTCCID_DET_FACTS_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length	Mandatory
INTERNAL_ORGANIZATION_ID	NUMBER		Yes
TAX_REGIME_ID	NUMBER		Yes
TAX_ID	NUMBER		Yes
TAX_JURISDICTION_ID	NUMBER		Yes
TAX_STATUS_ID	NUMBER		Yes
GL_DATE	DATE		Yes
TAX_RATE_ID	NUMBER		Yes
REC_RATE_ID	NUMBER		Yes
SELF_ASSESSED_FLAG	VARCHAR2	(1)	Yes
RECOVERABLE_FLAG	VARCHAR2	(1)	Yes
REVENUE_EXPENSE_CCID	NUMBER		Yes
REC_NREC_CCID	NUMBER
TAX_LIAB_CCID	NUMBER

Query Text

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


SELECT INTERNAL_ORGANIZATION_ID
,      TAX_REGIME_ID
,      TAX_ID
,      TAX_JURISDICTION_ID
,      TAX_STATUS_ID
,      GL_DATE
,      TAX_RATE_ID
,      REC_RATE_ID
,      SELF_ASSESSED_FLAG
,      RECOVERABLE_FLAG
,      REVENUE_EXPENSE_CCID
,      REC_NREC_CCID
,      TAX_LIAB_CCID
FROM ZX.ZX_DISTCCID_DET_FACTS_GT;

Dependencies

[top of page]

ZX.ZX_DISTCCID_DET_FACTS_GT does not reference any database object

ZX.ZX_DISTCCID_DET_FACTS_GT is referenced by following:

APPS: ZX_DISTCCID_DET_FACTS_GT