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: JG.JG_ZZ_VAT_TRX_UPG_STG

Object Details

Object Name:	JG_ZZ_VAT_TRX_UPG_STG
Object Type:	TABLE
Owner:	JG
FND Design Data:	JG.JG_ZZ_VAT_TRX_UPG_STG
Subobject Name:
Status:	VALID

This table is used to derive TRL call parameters (date range by Ledger) for retrieving the final reported transactions, and to filter TRL output only to those records that are finally reported in R11i.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JG_ZZ_VAT_TRX_UPG_STG_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	VAT_TRX_ID
JG_ZZ_VAT_TRX_UPG_STG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VAT_HEADER_ID
JG_ZZ_VAT_TRX_UPG_STG_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID ENTITY_CODE EVENT_CLASS_CODE TRX_ID

Columns

Name	Datatype	Length	Mandatory	Comments
VAT_TRX_ID	NUMBER	(15)	Yes	VAT Final Reporting Transaction Identifier
VAT_HEADER_ID	NUMBER	(15)	Yes	VAT header identifier
ORGANIZATION_ID	NUMBER	(15)	Yes	Operating Unit Identifier for the transaction
APPLICATION_ID	NUMBER	(15)	Yes	The application corresponding to the transaction
ENTITY_CODE	VARCHAR2	(30)		Entity code of the transaction
EVENT_CLASS_CODE	VARCHAR2	(30)		Application products event class of the transaction
TRX_ID	NUMBER	(15)	Yes	Transaction identifier
LEDGER_ID	NUMBER	(15)	Yes	Ledger to which the transaction belongs
TAX_INVOICE_DATE	DATE			Tax reporting date for the transaction
TAX_REGIME_CODE	VARCHAR2	(30)		Tax Regime Code
TAX_RATE_ID	NUMBER	(15)		Tax Rate Identifier
TAX_RATE_CODE	VARCHAR2	(30)		Tax Rate Code
MIGRATION_FLAG	VARCHAR2	(1)		Flag that indicates migrated transactions
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Object Version Number

Query Text

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


SELECT VAT_TRX_ID
,      VAT_HEADER_ID
,      ORGANIZATION_ID
,      APPLICATION_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      TRX_ID
,      LEDGER_ID
,      TAX_INVOICE_DATE
,      TAX_REGIME_CODE
,      TAX_RATE_ID
,      TAX_RATE_CODE
,      MIGRATION_FLAG
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      CREATED_BY
,      OBJECT_VERSION_NUMBER
FROM JG.JG_ZZ_VAT_TRX_UPG_STG;

Dependencies

[top of page]

JG.JG_ZZ_VAT_TRX_UPG_STG does not reference any database object

JG.JG_ZZ_VAT_TRX_UPG_STG is referenced by following:

APPS: JG_ZZ_VAT_TRX_UPG_STG