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

TABLE: JG.JG_ZZ_VAT_DOC_SEQUENCES

Object Details
Object Name: JG_ZZ_VAT_DOC_SEQUENCES
Object Type: TABLE
Owner: JG
FND Design Data: TableJG.JG_ZZ_VAT_DOC_SEQUENCES
Subobject Name:
Status: VALID


Each record in this table stores the FND document sequence associated with VAT register. For reporting purpose document category is derived based on FND document sequence association with document categories.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JG_ZZ_VAT_DOC_SEQUENCES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVAT_DOC_SEQUENCE_ID
JG_ZZ_VAT_DOC_SEQUENCES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVAT_REGISTER_ID
ColumnDOC_SEQUENCE_ID
Columns
Name Datatype Length Mandatory Comments
VAT_REGISTER_ID NUMBER (15) Yes VAT Register Identifier
DOC_SEQUENCE_ID NUMBER (15) Yes Document Sequence Identifier. Foreign key to FND_DOCUMENT_SEQUENCES
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
VAT_DOC_SEQUENCE_ID NUMBER (15) Yes VAT Document Sequence Identifier
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

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


SELECT VAT_REGISTER_ID
,      DOC_SEQUENCE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      VAT_DOC_SEQUENCE_ID
,      LAST_UPDATE_LOGIN
FROM JG.JG_ZZ_VAT_DOC_SEQUENCES;

Dependencies

[top of page]

JG.JG_ZZ_VAT_DOC_SEQUENCES does not reference any database object

JG.JG_ZZ_VAT_DOC_SEQUENCES is referenced by following:

SchemaJG
ViewJG_ZZ_VAT_DOC_SEQUENCES#