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

TABLE: JA.JAI_RCV_RTV_BATCH_GRPS

Object Details
Object Name: JAI_RCV_RTV_BATCH_GRPS
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_RCV_RTV_BATCH_GRPS
Subobject Name:
Status: VALID


For every RTV transactions we create a record in this and name it as batch. this is required as we need to generate only one excise invoice per batch


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_RCV_RTV_BATCH_GRPS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_GROUP_ID
JAI_RCV_RTV_BATCH_GRPS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_NUM
Columns
Name Datatype Length Mandatory Comments
BATCH_GROUP_ID NUMBER (15) Yes Batch group identifier
BATCH_NUM NUMBER (15)
Batch number
REGIME_CODE VARCHAR2 (30)
Regime code
ORGANIZATION_ID NUMBER (15)
Organization identifier
LOCATION_ID NUMBER (15)
Location identifier
VENDOR_ID NUMBER (15)
Supplier unique identifier
VENDOR_SITE_ID NUMBER (15)
Supplier site unique identifier
INVOICE_NO VARCHAR2 (150)
Invoice number
INVOICE_DATE DATE

Invoice date
CREATION_DATE DATE
Yes Standard who columns
CREATED_BY NUMBER (15) Yes Standard who columns
LAST_UPDATE_DATE DATE
Yes Standard who columns
LAST_UPDATED_BY NUMBER (15) Yes Standard who columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard who columns
OBJECT_VERSION_NUMBER NUMBER

Object version number
Query Text

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


SELECT BATCH_GROUP_ID
,      BATCH_NUM
,      REGIME_CODE
,      ORGANIZATION_ID
,      LOCATION_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      INVOICE_NO
,      INVOICE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_RCV_RTV_BATCH_GRPS;

Dependencies

[top of page]

JA.JAI_RCV_RTV_BATCH_GRPS does not reference any database object

JA.JAI_RCV_RTV_BATCH_GRPS is referenced by following:

SchemaJA
ViewJAI_RCV_RTV_BATCH_GRPS#