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_WRITEOFFS_T

Object Details

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

Temporary table, which stores the write offs corresponding to the a BOE

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMS_WRITE_OFF_ACCOUNT	NUMBER	(15)		Customs Write Off Account
ADDRESS_LINE_1	VARCHAR2	(60)		Address Line 1
ADDRESS_LINE_2	VARCHAR2	(60)		Address Line 2
ADDRESS_LINE_3	VARCHAR2	(60)		Address Line 3
ORGANIZATION_NAME	VARCHAR2	(60)		Organization Name
CHART_OF_ACCOUNTS_ID	NUMBER	(15)		Account identifier
BOE_TYPE	VARCHAR2	(25)		Type of BOE
BOE_ID	NUMBER			Unique Identifier of BOE
BOE_AMOUNT	NUMBER			BOE Amount
LOCATION_CODE	VARCHAR2	(20)		Location Code
AMOUNT_APPLIED	NUMBER			Amount applied for the BOE
WRITE_OFF_AMOUNT	NUMBER			Amount Written Off
WRITE_OFF_DATE	DATE			Write Off Date
WRITE_OFF_REASON	VARCHAR2	(150)		Reason for Write Off
EARLIER_WRITTEN_OFF_AMOUNT	NUMBER			If there was an earlier write off for the BOE. Then the write off amount corresponding to that
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
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number

Query Text

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


SELECT CUSTOMS_WRITE_OFF_ACCOUNT
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      ORGANIZATION_NAME
,      CHART_OF_ACCOUNTS_ID
,      BOE_TYPE
,      BOE_ID
,      BOE_AMOUNT
,      LOCATION_CODE
,      AMOUNT_APPLIED
,      WRITE_OFF_AMOUNT
,      WRITE_OFF_DATE
,      WRITE_OFF_REASON
,      EARLIER_WRITTEN_OFF_AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_CMN_WRITEOFFS_T;

Dependencies

[top of page]

JA.JAI_CMN_WRITEOFFS_T does not reference any database object

JA.JAI_CMN_WRITEOFFS_T is referenced by following:

APPS: JAI_CMN_WRITEOFFS_T