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_TRX_POE_DTLS

Object Details

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

This table holds the details of the proof of exports details.,This table holds the details of the proof of exports details.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AR_TRX_POE_DTLS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	POE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
POE_ID	NUMBER	(15)	Yes	Indicates System generated identifier of for this POE Entry.
CUSTOMER_TRX_ID	NUMBER	(15)	Yes	Customer transaction identifier of the invoice where the export sales was done.
AR4_NUMBER	VARCHAR2	(20)	Yes	Indicates the AR4 number of the POE Entry.
SHIP_BILL_NUMBER	VARCHAR2	(20)		Indicates the ship bill number of the POE Entry.
SHIP_BILL_DATE	DATE			Indicates the ship bill date of the POE Entry.
DESTINATION	VARCHAR2	(50)		Indicates the destination place where the export sale was done.
ORGANIZATION_ID	NUMBER	(15)		Inventory Organization identifier of the invoice
CLOSED_FLAG	VARCHAR2	(1)		Indicates whether the POE is closed.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
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
CLAIM_DUTY_DRAWBACK	VARCHAR2	(2)		Indicates whether duty drawback is to be claimed.
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number

Query Text

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


SELECT POE_ID
,      CUSTOMER_TRX_ID
,      AR4_NUMBER
,      SHIP_BILL_NUMBER
,      SHIP_BILL_DATE
,      DESTINATION
,      ORGANIZATION_ID
,      CLOSED_FLAG
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CLAIM_DUTY_DRAWBACK
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_AR_TRX_POE_DTLS;

Dependencies

[top of page]

JA.JAI_AR_TRX_POE_DTLS does not reference any database object

JA.JAI_AR_TRX_POE_DTLS is referenced by following:

APPS: JAI_AR_TRX_POE_DTLS