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_AR_DRB_CLAIMS

Object Details

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

Holds the details of the duty drawbacks.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AR_DRB_CLAIMS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CLAIM_NO

Columns

Name	Datatype	Length	Mandatory	Comments
CLAIM_NO	NUMBER		Yes	Indicates the claim number.
POE_ID	NUMBER	(15)		Indicates the Proof of export identifier.
AR4_NUMBER	VARCHAR2	(20)		Indicates the Ar4 number.
IMPORTED_ITEM_UOM	VARCHAR2	(25)		Indicates the uom code of the inventory item.
REVISION	VARCHAR2	(3)		Indicates the revision.
QUANTITY	NUMBER	(15)		Indicates the number of items.
BOE_EXCISE_INV	VARCHAR2	(15)		Indicates the BOE Excise invoice number.
BOE_EXCISE_INV_DATE	DATE			Indicates the BOE Excise invoice date.
BOE_EXCISE_INV_AMOUNT	NUMBER	(15)		Indicates the BOE Excise invoice amount.
CLAIMED_AMOUNT	NUMBER			Indicates the claimed amount.
SHIPMENT_DATE	DATE			Indicates the shipment date.
DESTINATION	VARCHAR2	(50)		Indicates the destination.
SHIPMENT_LINE_ID	NUMBER			Indicates the shipment line identifier.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
IMPORTED_ITEM_ID	NUMBER	(15)		Indicates the item identifier of the inventory item.
OBJECT_VERSION_NUMBER	NUMBER			Object version Number

Query Text

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


SELECT CLAIM_NO
,      POE_ID
,      AR4_NUMBER
,      IMPORTED_ITEM_UOM
,      REVISION
,      QUANTITY
,      BOE_EXCISE_INV
,      BOE_EXCISE_INV_DATE
,      BOE_EXCISE_INV_AMOUNT
,      CLAIMED_AMOUNT
,      SHIPMENT_DATE
,      DESTINATION
,      SHIPMENT_LINE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      IMPORTED_ITEM_ID
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_AR_DRB_CLAIMS;

Dependencies

[top of page]

JA.JAI_AR_DRB_CLAIMS does not reference any database object

JA.JAI_AR_DRB_CLAIMS is referenced by following:

JA: JAI_AR_DRB_CLAIMS#