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_TEST_API_GT

Object Details

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

Temporary Table Details

ZX.ZX_TEST_API_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$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
SUITE_NUMBER	VARCHAR2	(30)
CASE_NUMBER	VARCHAR2	(30)
TRX_ID	NUMBER
TRX_NUMBER	VARCHAR2	(150)
TRX_LINE_NUMBER	NUMBER
TRX_DATE	DATE
TRX_CURRENCY_CODE	VARCHAR2	(50)
SUMMARY_TAX_LINE_ID	NUMBER
TAX_LINE_ID	NUMBER
TAX_REGIME_CODE	VARCHAR2	(50)
TAX_JURISDICTION_ID	NUMBER
TAX	VARCHAR2	(30)
TAX_STATUS_CODE	VARCHAR2	(100)
TAX_RATE_ID	NUMBER
TAX_RATE_CODE	VARCHAR2	(100)
TAX_RATE	NUMBER
TAX_AMT	NUMBER
TAXABLE_AMT	NUMBER
REC_TAX_AMT	NUMBER
NREC_TAX_AMT	NUMBER
TAX_AMT_FUNCL_CURR	NUMBER
TOTAL_REC_TAX_AMT	NUMBER
TOTAL_NREC_TAX_AMT	NUMBER
TOTAL_REC_TAX_AMT_FUNCL_CURR	NUMBER
TOTAL_NREC_TAX_AMT_FUNCL_CURR	NUMBER
SELF_ASSESSED_FLAG	VARCHAR2	(1)
MANUALLY_ENTERED_FLAG	VARCHAR2	(1)
LINE_AMT_INCLUDES_TAX_FLAG	VARCHAR2	(1)
TAXABLE_AMT_FUNCL_CURR	NUMBER
REC_TAX_AMT_FUNCL_CURR	NUMBER
NREC_TAX_AMT_FUNCL_CURR	NUMBER
TAX_AMT_INCLUDED_FLAG	VARCHAR2	(1)
TAX_EXEMPTION_ID	NUMBER
EXEMPTION_RATE	NUMBER
EXEMPT_REASON_CODE	VARCHAR2	(100)
TAX_APPORTIONMENT_LINE_NUMBER	NUMBER
TAX_REGISTRATION_NUMBER	VARCHAR2	(50)
TAX_HOLD_CODE	VARCHAR2	(100)
TAX_HOLD_RELEASED_CODE	VARCHAR2	(100)
LINE_AMT	NUMBER
TAX_JURISDICTION_CODE	VARCHAR2	(100)
TAX_RATE_NAME	VARCHAR2	(100)
TAX_RATE_TYPE	VARCHAR2	(100)
TAX_DETERMINE_DATE	DATE
CANCEL_FLAG	VARCHAR2	(1)
EVENT_CLASS_CODE	VARCHAR2	(100)
EVENT_TYPE_CODE	VARCHAR2	(100)
ETAX_API	VARCHAR2	(100)
ERROR_FLAG	VARCHAR2	(1)
ERROR_MESSAGE	VARCHAR2	(4000)

Query Text

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


SELECT SUITE_NUMBER
,      CASE_NUMBER
,      TRX_ID
,      TRX_NUMBER
,      TRX_LINE_NUMBER
,      TRX_DATE
,      TRX_CURRENCY_CODE
,      SUMMARY_TAX_LINE_ID
,      TAX_LINE_ID
,      TAX_REGIME_CODE
,      TAX_JURISDICTION_ID
,      TAX
,      TAX_STATUS_CODE
,      TAX_RATE_ID
,      TAX_RATE_CODE
,      TAX_RATE
,      TAX_AMT
,      TAXABLE_AMT
,      REC_TAX_AMT
,      NREC_TAX_AMT
,      TAX_AMT_FUNCL_CURR
,      TOTAL_REC_TAX_AMT
,      TOTAL_NREC_TAX_AMT
,      TOTAL_REC_TAX_AMT_FUNCL_CURR
,      TOTAL_NREC_TAX_AMT_FUNCL_CURR
,      SELF_ASSESSED_FLAG
,      MANUALLY_ENTERED_FLAG
,      LINE_AMT_INCLUDES_TAX_FLAG
,      TAXABLE_AMT_FUNCL_CURR
,      REC_TAX_AMT_FUNCL_CURR
,      NREC_TAX_AMT_FUNCL_CURR
,      TAX_AMT_INCLUDED_FLAG
,      TAX_EXEMPTION_ID
,      EXEMPTION_RATE
,      EXEMPT_REASON_CODE
,      TAX_APPORTIONMENT_LINE_NUMBER
,      TAX_REGISTRATION_NUMBER
,      TAX_HOLD_CODE
,      TAX_HOLD_RELEASED_CODE
,      LINE_AMT
,      TAX_JURISDICTION_CODE
,      TAX_RATE_NAME
,      TAX_RATE_TYPE
,      TAX_DETERMINE_DATE
,      CANCEL_FLAG
,      EVENT_CLASS_CODE
,      EVENT_TYPE_CODE
,      ETAX_API
,      ERROR_FLAG
,      ERROR_MESSAGE
FROM ZX.ZX_TEST_API_GT;

Dependencies

[top of page]

ZX.ZX_TEST_API_GT does not reference any database object

ZX.ZX_TEST_API_GT is referenced by following:

APPS: ZX_TEST_API_GT