[Home] [Help] [Dependency Information]
Object Name: | JAI_CMN_RG_ROUND_LINES |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JAI_CMN_RG_ROUND_LINES |
Subobject Name: | |
Status: | VALID |
Stores detailed information for Rounding corresponding to information in table JAI_CMN_RG_ROUND_HDRS.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JAI_CMN_RG_ROUND_LINES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | ROUNDING_LINE_ID |
JAI_CMN_RG_ROUND_LINES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ROUNDING_ID |
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 |
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;
JA.JAI_CMN_RG_ROUND_LINES does not reference any database object
JA.JAI_CMN_RG_ROUND_LINES is referenced by following:
|
|
|