eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JA.JAI_CMN_RG_PLA_CMP_DTLS

Object Details

Object Name:	JAI_CMN_RG_PLA_CMP_DTLS
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_CMN_RG_PLA_CMP_DTLS
Subobject Name:
Status:	VALID

This Table stores the Information of Detailed Balance of Each Excise Component for Every line for PLA Register. This Information is specific to Textile Industry.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_CMN_RG_PLA_CMP_DTLS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	REGISTER_ID
JAI_CMN_RG_PLA_CMP_DTLS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID LOCATION_ID FIN_YEAR INVENTORY_ITEM_ID SLNO

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER	(15)		Indicates the Organization Identifier.
LOCATION_ID	NUMBER	(15)		Indicates the Location Identifier.
INVENTORY_ITEM_ID	NUMBER	(15)		Indicates the Inventory Item Identifier.
FIN_YEAR	NUMBER	(9)		Indicates the Financial Year.
REGISTER_ID	NUMBER	(15)	Yes	Indicates the Register Identifier.
SLNO	NUMBER	(15)		Indicates the Serial Number.
BASIC_OPENING_BALANCE	NUMBER			Indicates the Opening Balance of the Basic Excise Component.
ADDITIONAL_OPENING_BALANCE	NUMBER			Indicates the Opening Balance of the Additional Excise Component.
OTHER_OPENING_BALANCE	NUMBER			Indicates the Opening Balance of the Other Excise Component.
CR_BASIC_ED	NUMBER			Indicates the Basic Excise Duty - Credit Amount.
CR_ADDITIONAL_ED	NUMBER			Indicates the Additional Excise Duty - Credit Amount.
CR_OTHER_ED	NUMBER			Indicates the Other Excise Duty - Credit Amount.
DR_BASIC_ED	NUMBER			Indicates the Basic Excise Duty - Debit Amount.
DR_ADDITIONAL_ED	NUMBER			Indicates the Additional Excise Duty - Debit Amount.
DR_OTHER_ED	NUMBER			Indicates the Other Excise Duty - Debit Amount.
BASIC_CLOSING_BALANCE	NUMBER			Indicates the Closing Balance of the Basic Excise Duty component.
ADDITIONAL_CLOSING_BALANCE	NUMBER			Indicates the Closing Balance of the Additional Excise Duty component.
OTHER_CLOSING_BALANCE	NUMBER			Indicates the Closing Balance of the Other Excise Duty component.
TRANSACTION_DATE	DATE			Indicates the Transaction Date of the Transaction.
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
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
,      INVENTORY_ITEM_ID
,      FIN_YEAR
,      REGISTER_ID
,      SLNO
,      BASIC_OPENING_BALANCE
,      ADDITIONAL_OPENING_BALANCE
,      OTHER_OPENING_BALANCE
,      CR_BASIC_ED
,      CR_ADDITIONAL_ED
,      CR_OTHER_ED
,      DR_BASIC_ED
,      DR_ADDITIONAL_ED
,      DR_OTHER_ED
,      BASIC_CLOSING_BALANCE
,      ADDITIONAL_CLOSING_BALANCE
,      OTHER_CLOSING_BALANCE
,      TRANSACTION_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_CMN_RG_PLA_CMP_DTLS;

Dependencies

[top of page]

JA.JAI_CMN_RG_PLA_CMP_DTLS does not reference any database object

JA.JAI_CMN_RG_PLA_CMP_DTLS is referenced by following:

APPS: JAI_CMN_RG_PLA_CMP_DTLS