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

TABLE: JA.JAI_CMN_RG_COMP_BALS

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


Stores the current balances of Each Excise Components RG23A,RG23C,PLA for an Organization/Location. Table designed for Textile Industry


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_CMN_RG_COMP_BALS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMPONENT_BALANCE_ID
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15)
Organization Identifier.
LOCATION_ID NUMBER (15)
Location Identifier.
BASIC_RG23A_BALANCE NUMBER

RG23A Balance for Basic Excise Component.
ADDITIONAL_RG23A_BALANCE NUMBER

RG23A Balance for Additional Excise Component.
OTHER_RG23A_BALANCE NUMBER

RG23A Balance for Other Excise Component.
BASIC_RG23C_BALANCE NUMBER

RG23C Balance for Basic Excise Component.
ADDITIONAL_RG23C_BALANCE NUMBER

RG23C Balance for Additional Excise Component.
OTHER_RG23C_BALANCE NUMBER

RG23C Balance for Other Excise Component.
BASIC_PLA_BALANCE NUMBER

PLA Balance for Basic Excise Component.
ADDITIONAL_PLA_BALANCE NUMBER

PLA Balance for Additional Excise Component.
OTHER_PLA_BALANCE NUMBER

PLA Balance for Other Excise Component.
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
COMPONENT_BALANCE_ID NUMBER (15) Yes Component balance identifier
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
Query Text

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


SELECT ORGANIZATION_ID
,      LOCATION_ID
,      BASIC_RG23A_BALANCE
,      ADDITIONAL_RG23A_BALANCE
,      OTHER_RG23A_BALANCE
,      BASIC_RG23C_BALANCE
,      ADDITIONAL_RG23C_BALANCE
,      OTHER_RG23C_BALANCE
,      BASIC_PLA_BALANCE
,      ADDITIONAL_PLA_BALANCE
,      OTHER_PLA_BALANCE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      COMPONENT_BALANCE_ID
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_CMN_RG_COMP_BALS;

Dependencies

[top of page]

JA.JAI_CMN_RG_COMP_BALS does not reference any database object

JA.JAI_CMN_RG_COMP_BALS is referenced by following:

SchemaJA
ViewJAI_CMN_RG_COMP_BALS#