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_RCV_RGM_CLAIMS

Object Details

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

Stores the details of receipt claims by regime.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_RCV_RGM_CLAIMS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CLAIM_SCHEDULE_ID
JAI_RCV_RGM_CLAIMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIPMENT_HEADER_ID SHIPMENT_LINE_ID TAX_TYPE INSTALLMENT_NO STATUS
JAI_RCV_RGM_CLAIMS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RCV_RGM_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CLAIM_SCHEDULE_ID	NUMBER	(15)	Yes	Unique Identifier for the Table
RCV_RGM_LINE_ID	NUMBER	(15)	Yes	Unique Identifier for the table jai_rcv_rgm_lines. Foreign Key in this table
SHIPMENT_HEADER_ID	NUMBER		Yes	Unique Shipment Header Identifier
SHIPMENT_LINE_ID	NUMBER		Yes	Unique Shipment Line Identifier
REGIME_CODE	VARCHAR2	(30)	Yes	Regime Code of the the Regime, to which this record belongs
TAX_TRANSACTION_ID	NUMBER	(15)		Transaction Identifier, which is the Receive Transaction, for the current shipment line
TRANSACTION_TYPE	VARCHAR2	(25)	Yes	Type of the Transaction. Different Values are - RECEIVE, RETURN TO VENDOR, CORRECT OF RECEIVE, CORRECT OF RETURN TO VENDOR
TRANSACTION_ID	NUMBER		Yes	Unique Transaction Identifier of the Transaction
PARENT_TRANSACTION_TYPE	VARCHAR2	(25)		Parent Transaction Type of the Current Transaction
INSTALLMENT_NO	NUMBER	(15)	Yes	Installment No for the current line
INSTALLMENT_AMOUNT	NUMBER			Installment amount, corresponding to the current installment
CLAIMED_AMOUNT	NUMBER			Amount, out of the installment amount, which is claimed
SCHEDULED_DATE	DATE		Yes	Scheduled Date for Claiming the Amount/installment
CLAIMED_DATE	DATE			Date on which the Claim for installment/Amount is made
STATUS	VARCHAR2	(25)		Status, whether the installment is claimed or not
MANUAL_CLAIM_FLAG	VARCHAR2	(1)		In case a Force claim is made. i.e. before the Actual Scheduled Date
REMARKS	VARCHAR2	(240)		Remarks if the Force Claim is made
TAX_TYPE	VARCHAR2	(30)		Tax Type
TAX_ID	NUMBER	(15)		Unique Tax Identifier
TRX_TAX_ID	NUMBER	(15)		Not currently used
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
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	(9)		Object Version Number.

Query Text

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


SELECT CLAIM_SCHEDULE_ID
,      RCV_RGM_LINE_ID
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      REGIME_CODE
,      TAX_TRANSACTION_ID
,      TRANSACTION_TYPE
,      TRANSACTION_ID
,      PARENT_TRANSACTION_TYPE
,      INSTALLMENT_NO
,      INSTALLMENT_AMOUNT
,      CLAIMED_AMOUNT
,      SCHEDULED_DATE
,      CLAIMED_DATE
,      STATUS
,      MANUAL_CLAIM_FLAG
,      REMARKS
,      TAX_TYPE
,      TAX_ID
,      TRX_TAX_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_RCV_RGM_CLAIMS;

Dependencies

[top of page]

JA.JAI_RCV_RGM_CLAIMS does not reference any database object

JA.JAI_RCV_RGM_CLAIMS is referenced by following:

JA: JAI_RCV_RGM_CLAIMS#