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]

VIEW: APPS.IC_ADJS_JNL_VW

Object Details

Object Name:	IC_ADJS_JNL_VW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMI.IC_ADJS_JNL_VW
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A public view which may be useful for custom reporting or other data
requirements.

Inventory Adjustment Journal view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORGN_CODE	VARCHAR2	(4)	Yes	Organization for which the journal was created.
ASSIGNMENT_TYPE	NUMBER	(5)	Yes	1= manual assignment; 2=auto integer sequencing.
JOURNAL_NO	VARCHAR2	(32)	Yes	Number of the journal.
JOURNAL_ID	NUMBER	(10)	Yes	Surrogate key for the journal.
POSTED_IND	NUMBER	(5)	Yes	Indicates whether the journal has been posted.
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
JOURNAL_COMMENT	VARCHAR2	(70)		Journal comment.
PRINT_CNT	NUMBER	(5)	Yes	Number of times the journal was printed.
POSTING_ID	NUMBER	(10)	Yes	Posting ID.
IN_USE	NUMBER	(10)		Not currently used
TRANS_TYPE	VARCHAR2	(4)	Yes	Transaction type, for example, CREI, ADJI.
DOC_ID	NUMBER	(10)	Yes	Surrogate key to the adjustment document (joins to ic_tran_cmp).
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).
TO_LINE_TYPE	NUMBER	(5)		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.
TO_LINE_ID	NUMBER	(10)		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.
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.
TO_DOC_LINE	NUMBER	(10)		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.
COMPLETED_IND	NUMBER	(5)	Yes	0=Pending; 1=Updated to inventory.
DOC_DATE	DATE		Yes	Date of the adjustment.
REASON_CODE	VARCHAR2	(4)	Yes	Reason code for the adjusment.
REASON_TYPE	NUMBER	(5)	Yes
REASON_DESC1	VARCHAR2	(40)	Yes
ITEM_ID	NUMBER	(10)	Yes
ITEM_NO	VARCHAR2	(32)	Yes
ITEM_DESC1	VARCHAR2	(70)	Yes
DUALUM_IND	NUMBER	(5)	Yes
LOT_CTL	NUMBER	(5)	Yes
SUBLOT_CTL	NUMBER	(5)	Yes
ITEM_LOCT_CTL	NUMBER	(5)	Yes
STATUS_CTL	NUMBER	(5)	Yes
GRADE_CTL	NUMBER	(5)	Yes
LOT_INDIVISIBLE	NUMBER	(5)	Yes
DEFAULT_LOT_STATUS	VARCHAR2	(4)
DEFAULT_QC_GRADE	VARCHAR2	(4)
LOT_ID	NUMBER	(10)
LOT_NO	VARCHAR2	(32)
SUBLOT_NO	VARCHAR2	(32)
LOT_DESC	VARCHAR2	(40)
WHSE_CODE	VARCHAR2	(4)
WHSE_NAME	VARCHAR2	(40)
WHSE_LOCT_CTL	NUMBER	(5)
WHSE_CO_CODE	VARCHAR2	(4)		Company code for the warehouse
TO_WHSE_CODE	VARCHAR2	(4)
TO_WHSE_NAME	VARCHAR2	(40)
TO_WHSE_LOCT_CTL	NUMBER	(5)
LOCATION	VARCHAR2	(16)
LOCT_DESC	VARCHAR2	(40)
TO_LOCATION	VARCHAR2	(16)
TO_LOCT_DESC	VARCHAR2	(40)
ITEM_UM	VARCHAR2	(4)	Yes
ITEM_UM2	VARCHAR2	(4)
TO_ITEM_UM	VARCHAR2	(4)
TO_ITEM_UM2	VARCHAR2	(4)
LOT_STATUS	VARCHAR2	(4)
STATUS_DESC	VARCHAR2	(40)
TO_LOT_STATUS	VARCHAR2	(4)
TO_STATUS_DESC	VARCHAR2	(40)
QC_GRADE	VARCHAR2	(4)
QC_GRADE_DESC	VARCHAR2	(40)
TO_QC_GRADE	VARCHAR2	(4)
TO_QC_GRADE_DESC	VARCHAR2	(40)
CO_CODE	VARCHAR2	(4)
QTY	NUMBER
QTY2	NUMBER
TO_QTY	NUMBER
TO_QTY2	NUMBER
NO_INV	NUMBER	(5)	Yes
NO_TRANS	NUMBER	(5)
TRANS_FLAG	NUMBER	(10)	Yes
TEXT_CODE	NUMBER	(10)
TRANS_CNT	NUMBER	(10)
ACCTG_UNIT_ID	NUMBER
ACCTG_UNIT_NO	VARCHAR2	(240)
ACCTG_UNIT_DESC	VARCHAR2	(70)
ACCT_ID	NUMBER
ACCT_NO	VARCHAR2	(240)
ACCT_NO_DESC	VARCHAR2	(70)
ATTRIBUTE1	VARCHAR2	(240)
ATTRIBUTE2	VARCHAR2	(240)
ATTRIBUTE3	VARCHAR2	(240)
ATTRIBUTE4	VARCHAR2	(240)
ATTRIBUTE5	VARCHAR2	(240)
ATTRIBUTE6	VARCHAR2	(240)
ATTRIBUTE7	VARCHAR2	(240)
ATTRIBUTE8	VARCHAR2	(240)
ATTRIBUTE9	VARCHAR2	(240)
ATTRIBUTE10	VARCHAR2	(240)
ATTRIBUTE11	VARCHAR2	(240)
ATTRIBUTE12	VARCHAR2	(240)
ATTRIBUTE13	VARCHAR2	(240)
ATTRIBUTE14	VARCHAR2	(240)
ATTRIBUTE15	VARCHAR2	(240)
ATTRIBUTE16	VARCHAR2	(240)
ATTRIBUTE17	VARCHAR2	(240)
ATTRIBUTE18	VARCHAR2	(240)
ATTRIBUTE19	VARCHAR2	(240)
ATTRIBUTE20	VARCHAR2	(240)
ATTRIBUTE21	VARCHAR2	(240)
ATTRIBUTE22	VARCHAR2	(240)
ATTRIBUTE23	VARCHAR2	(240)
ATTRIBUTE24	VARCHAR2	(240)
ATTRIBUTE25	VARCHAR2	(240)
ATTRIBUTE26	VARCHAR2	(240)
ATTRIBUTE27	VARCHAR2	(240)
ATTRIBUTE28	VARCHAR2	(240)
ATTRIBUTE29	VARCHAR2	(240)
ATTRIBUTE30	VARCHAR2	(240)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
SOBNAME	VARCHAR2	(40)
SEGMENT_DELIM	VARCHAR2	(1)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
REQUEST_ID	NUMBER	(15)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
LAST_UPDATED_BY	NUMBER	(15)	Yes

Query Text

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


SELECT ORGN_CODE
,      ASSIGNMENT_TYPE
,      JOURNAL_NO
,      JOURNAL_ID
,      POSTED_IND
,      DELETE_MARK
,      JOURNAL_COMMENT
,      PRINT_CNT
,      POSTING_ID
,      IN_USE
,      TRANS_TYPE
,      DOC_ID
,      LINE_TYPE
,      TO_LINE_TYPE
,      LINE_ID
,      TO_LINE_ID
,      DOC_LINE
,      TO_DOC_LINE
,      COMPLETED_IND
,      DOC_DATE
,      REASON_CODE
,      REASON_TYPE
,      REASON_DESC1
,      ITEM_ID
,      ITEM_NO
,      ITEM_DESC1
,      DUALUM_IND
,      LOT_CTL
,      SUBLOT_CTL
,      ITEM_LOCT_CTL
,      STATUS_CTL
,      GRADE_CTL
,      LOT_INDIVISIBLE
,      DEFAULT_LOT_STATUS
,      DEFAULT_QC_GRADE
,      LOT_ID
,      LOT_NO
,      SUBLOT_NO
,      LOT_DESC
,      WHSE_CODE
,      WHSE_NAME
,      WHSE_LOCT_CTL
,      WHSE_CO_CODE
,      TO_WHSE_CODE
,      TO_WHSE_NAME
,      TO_WHSE_LOCT_CTL
,      LOCATION
,      LOCT_DESC
,      TO_LOCATION
,      TO_LOCT_DESC
,      ITEM_UM
,      ITEM_UM2
,      TO_ITEM_UM
,      TO_ITEM_UM2
,      LOT_STATUS
,      STATUS_DESC
,      TO_LOT_STATUS
,      TO_STATUS_DESC
,      QC_GRADE
,      QC_GRADE_DESC
,      TO_QC_GRADE
,      TO_QC_GRADE_DESC
,      CO_CODE
,      QTY
,      QTY2
,      TO_QTY
,      TO_QTY2
,      NO_INV
,      NO_TRANS
,      TRANS_FLAG
,      TEXT_CODE
,      TRANS_CNT
,      ACCTG_UNIT_ID
,      ACCTG_UNIT_NO
,      ACCTG_UNIT_DESC
,      ACCT_ID
,      ACCT_NO
,      ACCT_NO_DESC
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      SOBNAME
,      SEGMENT_DELIM
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
FROM APPS.IC_ADJS_JNL_VW;

Dependencies

[top of page]

APPS.IC_ADJS_JNL_VW references the following:

APPS: FND_PROFILE - show dependent code; GL_ACCT_MST; GL_ACCU_MST; GL_PLCY_MST; IC_ADJS_JNL; IC_ITEM_MST; IC_JRNL_MST; IC_LOCT_MST; IC_LOTS_MST; IC_LOTS_STS; IC_WHSE_MST; QC_GRAD_MST; SY_DOCS_SEQ; SY_ORGN_MST; SY_REAS_CDS

APPS.IC_ADJS_JNL_VW is not referenced by any database object