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

TABLE: JA.JAI_CMN_RG_ROUND_HDRS

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


Stores the excise amount, which is rounded for each excise invoice


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_CMN_RG_ROUND_HDRS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnROUNDING_ID
Columns
Name Datatype Length Mandatory Comments
ROUNDING_ID NUMBER
Yes Unique Identifier for the table
SOURCE_HEADER_ID NUMBER

Receiving Shipment Header ID
EXCISE_INVOICE_NO VARCHAR2 (40)
Excise Invoice Number
EXCISE_INVOICE_DATE DATE

Excise Invoice date
EXCISE_AMT_BEFORE_ROUNDING NUMBER

Excise amount before doing the rounding
EXCISE_AMT_AFTER_ROUNDING NUMBER

Excise amount after doing the rounding
REGISTER_ID NUMBER

Register Identifier corresponding to the entry in Register
SOURCE VARCHAR2 (25)
Source of the Transaction
SRC_TRANSACTION_TYPE VARCHAR2 (40)
Type of Receiving Transaction
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
BASIC_ED NUMBER

Actual Basic Excise Duty
ROUNDED_BASIC_ED NUMBER

Rounded Basic Excise Duty
ADDITIONAL_ED NUMBER

Actual Additional Excise Duty
ROUNDED_ADDITIONAL_ED NUMBER

Rounded Additional Excise Duty
OTHER_ED NUMBER

Actual Other Excise Duty
ROUNDED_OTHER_ED NUMBER

Rounded Other Exicse Duty
EXCISE_EDU_CESS NUMBER

Actual Excise Education Cess
ROUNDED_EXCISE_EDU_CESS NUMBER

Rounded Excise Education Cess
CVD_EDU_CESS NUMBER

Actual CVD Education Cess
ROUNDED_CVD_EDU_CESS NUMBER

Rounded CVD Education Cess
REGISTER VARCHAR2 (10)
Identifies the register that is hit because of this rounding entry
PROGRAM_ID NUMBER

Identifies the concurrent program
PROGRAM_LOGIN_ID NUMBER

Identifies the Oracle Applications Concurrent Program Login ID
PROGRAM_APPLICATION_ID NUMBER

Identifies the Oracle Application that spawned the concurrent program
REQUEST_ID NUMBER

Identifies the concurrent request instance that spawned the concurrent program
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
ADDITIONAL_CVD NUMBER (38)
This column stores the Additional CVD Amount
ROUNDED_ADDITIONAL_CVD NUMBER (38)
This column stores the rounded value of Additional CVD Amount
ROUNDED_SH_CVD_EDU_CESS NUMBER

Indicates the rounded amount of SHE CVD Cess.
ROUNDED_SH_EXCISE_EDU_CESS NUMBER

Indicates the rounded amount of SHE Excise Cess.
SH_CVD_EDU_CESS NUMBER

Indicates the unrounded amount of SHE CVD Cess.
SH_EXCISE_EDU_CESS NUMBER

Indicates the unrounded amount of SHE Excise Cess.
Query Text

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


SELECT ROUNDING_ID
,      SOURCE_HEADER_ID
,      EXCISE_INVOICE_NO
,      EXCISE_INVOICE_DATE
,      EXCISE_AMT_BEFORE_ROUNDING
,      EXCISE_AMT_AFTER_ROUNDING
,      REGISTER_ID
,      SOURCE
,      SRC_TRANSACTION_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      BASIC_ED
,      ROUNDED_BASIC_ED
,      ADDITIONAL_ED
,      ROUNDED_ADDITIONAL_ED
,      OTHER_ED
,      ROUNDED_OTHER_ED
,      EXCISE_EDU_CESS
,      ROUNDED_EXCISE_EDU_CESS
,      CVD_EDU_CESS
,      ROUNDED_CVD_EDU_CESS
,      REGISTER
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      OBJECT_VERSION_NUMBER
,      ADDITIONAL_CVD
,      ROUNDED_ADDITIONAL_CVD
,      ROUNDED_SH_CVD_EDU_CESS
,      ROUNDED_SH_EXCISE_EDU_CESS
,      SH_CVD_EDU_CESS
,      SH_EXCISE_EDU_CESS
FROM JA.JAI_CMN_RG_ROUND_HDRS;

Dependencies

[top of page]

JA.JAI_CMN_RG_ROUND_HDRS does not reference any database object

JA.JAI_CMN_RG_ROUND_HDRS is referenced by following:

SchemaJA
ViewJAI_CMN_RG_ROUND_HDRS#