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

TABLE: JA.JAI_CMN_RG_ROUND_LINES

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


Stores detailed information for Rounding corresponding to information in table JAI_CMN_RG_ROUND_HDRS.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_CMN_RG_ROUND_LINES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnROUNDING_LINE_ID
JAI_CMN_RG_ROUND_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnROUNDING_ID
Columns
Name Datatype Length Mandatory Comments
ROUNDING_ID NUMBER
Yes Rounding Identifier, corresponding to record in JAI_CMN_RG_ROUND_HDRS table
SRC_LINE_ID NUMBER

Shipment Line identifier
SRC_TRANSACTION_ID NUMBER

RCV Transaction identifier
EXCISE_AMT NUMBER

Excise Amount
ITEM_CLASS VARCHAR2 (4)
Item Class
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER

Standard Who column
BASIC_ED NUMBER

Actual Basic Excise Duty
ADDITIONAL_ED NUMBER

Actual Additional Excise Duty
OTHER_ED NUMBER

Actual Other Excise Duty
EXCISE_EDU_CESS NUMBER

Actual Excise Education Cess
CVD_EDU_CESS NUMBER

Actual CVD Education Cess
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
ROUNDING_LINE_ID NUMBER (15) Yes Rounding line identifier
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
ADDITIONAL_CVD NUMBER (38)
This column stores the Additional CVD Amount
SH_CVD_EDU_CESS NUMBER

Indicates the SHE CVD Cess amount for the current line
SH_EXCISE_EDU_CESS NUMBER

Indicates the SHE Excise Cess amount for the current line
Query Text

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


SELECT ROUNDING_ID
,      SRC_LINE_ID
,      SRC_TRANSACTION_ID
,      EXCISE_AMT
,      ITEM_CLASS
,      CREATION_DATE
,      CREATED_BY
,      BASIC_ED
,      ADDITIONAL_ED
,      OTHER_ED
,      EXCISE_EDU_CESS
,      CVD_EDU_CESS
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      ROUNDING_LINE_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ADDITIONAL_CVD
,      SH_CVD_EDU_CESS
,      SH_EXCISE_EDU_CESS
FROM JA.JAI_CMN_RG_ROUND_LINES;

Dependencies

[top of page]

JA.JAI_CMN_RG_ROUND_LINES does not reference any database object

JA.JAI_CMN_RG_ROUND_LINES is referenced by following:

SchemaJA
ViewJAI_CMN_RG_ROUND_LINES#