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: GMI.IC_ADJS_JNL

Object Details

Object Name:	IC_ADJS_JNL
Object Type:	TABLE
Owner:	GMI
FND Design Data:	GMI.IC_ADJS_JNL
Subobject Name:
Status:	VALID

Inventory adjustment detail table. Contains the document details for
actions performed on the Inventory Quantities form, such as inventory
adjustments, moves, status and grade changes.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IC_ADJS_JNL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANS_TYPE TRANS_FLAG DOC_ID DOC_LINE
IC_ADJS_JNLI1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JOURNAL_ID DOC_LINE
IC_ADJS_JNLI2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOC_ID LINE_ID
IC_ADJS_JNLI3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_ID LOT_ID WHSE_CODE LOCATION
IC_ADJS_JNL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANS_TYPE	VARCHAR2	(4)	Yes	Transaction type, for example, CREI, ADJI.
TRANS_FLAG	NUMBER	(10)	Yes	0 or session_no if selected or updated.
DOC_ID	NUMBER	(10)	Yes	Surrogate key to the adjustment document (joins to ic_tran_cmp).
DOC_LINE	NUMBER	(10)	Yes	Line number of the adjustment. Moves and grade and status changes create two rows with different values for doc_line, but the same value for line_id.
JOURNAL_ID	NUMBER	(10)	Yes	Surrogate key to the journal (joins to ic_jrnl_mst).
COMPLETED_IND	NUMBER	(5)	Yes	0=Pending; 1=Updated to inventory.
WHSE_CODE	VARCHAR2	(4)		The warehouse in which the adjustment took place.
REASON_CODE	VARCHAR2	(4)	Yes	Reason code for the adjusment.
DOC_DATE	DATE		Yes	Date of the adjustment.
ITEM_ID	NUMBER	(10)	Yes	Surrogate key for the item adjusted.
ITEM_UM	VARCHAR2	(4)	Yes	Primary unit of measure of item.
ITEM_UM2	VARCHAR2	(4)		Secondary unit of measure of item, for dual UOM items.
LOT_ID	NUMBER	(10)		Surrogate key to the lot that was adjusted.
LOCATION	VARCHAR2	(16)		Location in which the adjustment took place.
QTY	NUMBER			Quantity of the adjustment in the item_um.
QTY2	NUMBER			Quantity of the adjustment in the item_um2.
QC_GRADE	VARCHAR2	(4)		The grade of the lot.
LOT_STATUS	VARCHAR2	(4)		The status of the lot.
LINE_TYPE	NUMBER	(5)	Yes	Line type. 0=Adjustment, -1=From line (for moves and grade and status changes), 1=To line (for moves and grade and status changes).
LINE_ID	NUMBER	(10)	Yes	Surrogate key for the adjustment "line". The two lines created by moves, and grade and status changes share the same line_id, but have different values for doc_line.
CO_CODE	VARCHAR2	(4)		The company of which the adjustment organization is a part.
ORGN_CODE	VARCHAR2	(4)	Yes	The organization for which the adjustment is made.
NO_INV	NUMBER	(5)	Yes	Not currently used.
NO_TRANS	NUMBER	(5)		Not currently used.
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
TRANS_CNT	NUMBER	(10)		Not currently used
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
REQUEST_ID	NUMBER	(15)		Concurrent who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
ACCTG_UNIT_ID	NUMBER			Accounting unit ID
ACCT_ID	NUMBER			Account ID
TEXT_CODE	NUMBER	(10)		Stores text code for text attached to record.

Query Text

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


SELECT TRANS_TYPE
,      TRANS_FLAG
,      DOC_ID
,      DOC_LINE
,      JOURNAL_ID
,      COMPLETED_IND
,      WHSE_CODE
,      REASON_CODE
,      DOC_DATE
,      ITEM_ID
,      ITEM_UM
,      ITEM_UM2
,      LOT_ID
,      LOCATION
,      QTY
,      QTY2
,      QC_GRADE
,      LOT_STATUS
,      LINE_TYPE
,      LINE_ID
,      CO_CODE
,      ORGN_CODE
,      NO_INV
,      NO_TRANS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      TRANS_CNT
,      LAST_UPDATED_BY
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      LAST_UPDATE_LOGIN
,      ACCTG_UNIT_ID
,      ACCT_ID
,      TEXT_CODE
FROM GMI.IC_ADJS_JNL;

Dependencies

[top of page]

GMI.IC_ADJS_JNL does not reference any database object

GMI.IC_ADJS_JNL is referenced by following:

GMI: IC_ADJS_JNL#