[Home] [Help] [Dependency Information]
Object Name: | IC_ADJS_JNL_VW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMI.IC_ADJS_JNL_VW |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A public view which may be useful for custom reporting or other data
requirements.
Inventory Adjustment Journal view
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 |
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;
APPS.IC_ADJS_JNL_VW is not referenced by any database object
|
|
|