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

TABLE: AR.AR_GTA_BATCH_NUMBERING

Object Details
Object Name: AR_GTA_BATCH_NUMBERING
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_GTA_BATCH_NUMBERING
Subobject Name:
Status: VALID


The AR_GTA_BATCH_NUMBERING stores next value to generate batch number for GTA invoices that are exported to flat file as a batch, each OU that is ever set to use automatic numbering method in the System Options form has a record in the table. Golden Tax invoice workbench form and Invoice export program will use data in this table to generate batch number if users choose to use automatic numbering. There is no primary key for this table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_GTA_BATCH_NUMBERING_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORG_ID
Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER
Yes Organization identifier
NEXT_VALUE NUMBER
Yes Next value to generate batch number
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (22) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
CREATION_DATE DATE
Yes Standard who column - date when this row was created
CREATED_BY NUMBER (22) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID)
Query Text

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


SELECT ORG_ID
,      NEXT_VALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM AR.AR_GTA_BATCH_NUMBERING;

Dependencies

[top of page]

AR.AR_GTA_BATCH_NUMBERING does not reference any database object

AR.AR_GTA_BATCH_NUMBERING is referenced by following:

SchemaAR
ViewAR_GTA_BATCH_NUMBERING#