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

TABLE: JA.JAI_CMN_RG_CONSLDATIONS

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


Stores Transaction information of RG Consolidation.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_CMN_RG_CONSLDATIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONSOLIDATION_ID
JAI_CMN_RG_CONSLDATIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnLOCATION_ID
Columns
Name Datatype Length Mandatory Comments
CONSOLIDATION_ID NUMBER (15) Yes Indicates the Consolidation Identifier.
CONSOLIDATION_DATE DATE
Yes Indicates the Consolidation Date.
PREV_CONSOLIDATION_DATE DATE
Yes Indicates the Previous Consolidation Date.
ORGANIZATION_ID NUMBER (15) Yes Indicates the Organization Identifier.
LOCATION_ID NUMBER (15) Yes Indicates the Location Identifier.
CUR_RG23AP2_BED NUMBER

Indicates the Current RG23A Basic Excise Duty Amount.
CON_RG23AP2_BED NUMBER

Indicates the Consolidated RG23A Basic Excise Duty Amount.
CUR_RG23AP2_SED NUMBER

Indicates the Current RG23A Special Excise Duty Amount.
CON_RG23AP2_SED NUMBER

Indicates the Consolidated RG23A Special Excise Duty Amount.
CUR_RG23AP2_OED NUMBER

Indicates the Current RG23A Other Excise Duty Amount.
CON_RG23AP2_OED NUMBER

Indicates the Consolidated RG23A Other Excise Duty Amount.
PREV_RG23AP2_RID NUMBER

Indicates the Previous RG23A Register Identifier.
CUR_RG23CP2_BED NUMBER

Indicates the Current RG23C Basic Excise Duty Amount.
CON_RG23CP2_BED NUMBER

Indicates the Consolidated RG23C Basic Excise Duty Amount.
CUR_RG23CP2_SED NUMBER

Indicates the Current RG23C Special Excise Duty Amount.
CON_RG23CP2_SED NUMBER

Indicates the Consolidated RG23C Special Excise Duty Amount.
CUR_RG23CP2_OED NUMBER

Indicates the Current RG23C Other Excise Duty Amount.
CON_RG23CP2_OED NUMBER

Indicates the Consolidated RG23C Other Excise Duty Amount.
PREV_RG23CP2_RID NUMBER

Indicates the Previous RG23C Register Identifier.
CUR_PLA_BED NUMBER

Indicates the Current PLA Basic Excise Duty Amount.
CON_PLA_BED NUMBER

Indicates the Consolidated PLA Basic Excise Duty Amount.
CUR_PLA_SED NUMBER

Indicates the Current PLA Special Excise Duty Amount.
CON_PLA_SED NUMBER

Indicates the Consolidated PLA Special Excise Duty Amount.
CUR_PLA_OED NUMBER

Indicates the Current PLA Other Excise Duty Amount.
CON_PLA_OED NUMBER

Indicates the Consolidated PLA Other Excise Duty Amount.
PREV_PLA_RID NUMBER

Indicates the Previous PLA Register Identifier.
CUR_NET_PAYABLE NUMBER

Indicates the Current Net payable amount.
CON_NET_PAYABLE NUMBER

Indicates the Net Payable Amount.
CON_RG23AP2_RID NUMBER (15)
Indicates the RG23A Register Identifier.
CON_RG23CP2_RID NUMBER (15)
Indicates the RG23C Register Identifier.
CON_PLA_RID NUMBER (15)
Indicates the PLA Register Identifier.
TOD_RG23AP2_BED NUMBER (15)
Indicates the RG23A Basic Excise Duty Amount.
TOD_RG23CP2_BED NUMBER (15)
Indicates the RG23C Basic Excise Duty Amount.
TOD_PLA_BED NUMBER (15)
Indicates the PLA Basic Excise Duty Amount.
TOD_RG23AP2_SED NUMBER (15)
Indicates the RG23A Special Excise Duty Amount.
TOD_RG23CP2_SED NUMBER (15)
Indicates the RG23C Special Excise Duty Amount.
TOD_PLA_SED NUMBER (15)
Indicates the PLA Special Excise Duty Amount.
TOD_RG23AP2_OED NUMBER (15)
Indicates the RG23A Other Excise Duty Amount.
TOD_RG23CP2_OED NUMBER (15)
Indicates the RG23C Other Excise Duty Amount.
TOD_PLA_OED NUMBER (15)
Indicates the PLA Other Excise Duty Amount.
REMARKS VARCHAR2 (100)
Indicates Remarks, if any.
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

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
CUR_RG23AP2_CESS NUMBER

Current RG23A Part 2 Cess Amount
CON_RG23AP2_CESS NUMBER

Consolidated RG23A Part 2 Cess Amount
TOD_RG23AP2_CESS NUMBER

RG23A Part 2 Cess Amount
CUR_RG23CP2_CESS NUMBER

Current RG23C Part 2 Cess Amount
CON_RG23CP2_CESS NUMBER

Consolidated RG23C Part 2 Cess Amount
TOD_RG23CP2_CESS NUMBER

RG23C Part 2 Cess Amount
CUR_PLA_CESS NUMBER

Current PLA Cess Amount
CON_PLA_CESS NUMBER

Consolidated PLA Cess Amount
TOD_PLA_CESS NUMBER

PLA Cess Amount
PAYMENT_ID_REF NUMBER (15)
Indicates the Payment Identifier.
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
CON_SH_PLA_CESS NUMBER

Indicates the PLA Cess balance as on the date of consolidation
CON_SH_RG23AP2_CESS NUMBER

Indicates the RG23 A Cess balance as on the date of consolidation
CON_SH_RG23CP2_CESS NUMBER

Indicates the RG23 C Cess balance as on the date of consolidation
CUR_SH_PLA_CESS NUMBER

Indicates the current PLA Cess Balance
CUR_SH_RG23AP2_CESS NUMBER

Indicates the current RG23 A Cess Balance
CUR_SH_RG23CP2_CESS NUMBER

Indicates the current RG23 C Cess Balance
TOD_SH_PLA_CESS NUMBER

Indicates the PLA Cess Balance
TOD_SH_RG23AP2_CESS NUMBER

Indicates the RG23 A Cess Balance
TOD_SH_RG23CP2_CESS NUMBER

Indicates the RG23 C Cess Balance
Query Text

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


SELECT CONSOLIDATION_ID
,      CONSOLIDATION_DATE
,      PREV_CONSOLIDATION_DATE
,      ORGANIZATION_ID
,      LOCATION_ID
,      CUR_RG23AP2_BED
,      CON_RG23AP2_BED
,      CUR_RG23AP2_SED
,      CON_RG23AP2_SED
,      CUR_RG23AP2_OED
,      CON_RG23AP2_OED
,      PREV_RG23AP2_RID
,      CUR_RG23CP2_BED
,      CON_RG23CP2_BED
,      CUR_RG23CP2_SED
,      CON_RG23CP2_SED
,      CUR_RG23CP2_OED
,      CON_RG23CP2_OED
,      PREV_RG23CP2_RID
,      CUR_PLA_BED
,      CON_PLA_BED
,      CUR_PLA_SED
,      CON_PLA_SED
,      CUR_PLA_OED
,      CON_PLA_OED
,      PREV_PLA_RID
,      CUR_NET_PAYABLE
,      CON_NET_PAYABLE
,      CON_RG23AP2_RID
,      CON_RG23CP2_RID
,      CON_PLA_RID
,      TOD_RG23AP2_BED
,      TOD_RG23CP2_BED
,      TOD_PLA_BED
,      TOD_RG23AP2_SED
,      TOD_RG23CP2_SED
,      TOD_PLA_SED
,      TOD_RG23AP2_OED
,      TOD_RG23CP2_OED
,      TOD_PLA_OED
,      REMARKS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CUR_RG23AP2_CESS
,      CON_RG23AP2_CESS
,      TOD_RG23AP2_CESS
,      CUR_RG23CP2_CESS
,      CON_RG23CP2_CESS
,      TOD_RG23CP2_CESS
,      CUR_PLA_CESS
,      CON_PLA_CESS
,      TOD_PLA_CESS
,      PAYMENT_ID_REF
,      OBJECT_VERSION_NUMBER
,      CON_SH_PLA_CESS
,      CON_SH_RG23AP2_CESS
,      CON_SH_RG23CP2_CESS
,      CUR_SH_PLA_CESS
,      CUR_SH_RG23AP2_CESS
,      CUR_SH_RG23CP2_CESS
,      TOD_SH_PLA_CESS
,      TOD_SH_RG23AP2_CESS
,      TOD_SH_RG23CP2_CESS
FROM JA.JAI_CMN_RG_CONSLDATIONS;

Dependencies

[top of page]

JA.JAI_CMN_RG_CONSLDATIONS does not reference any database object

JA.JAI_CMN_RG_CONSLDATIONS is referenced by following:

SchemaJA
ViewJAI_CMN_RG_CONSLDATIONS#