[Home] [Help] [Dependency Information]
Object Name: | IC_TRAN_VW1 |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMI.IC_TRAN_VW1 |
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.
Transaction view. Contains data on all undeleted
transactions in ic_tran_pnd, plus all transactions
in ic_tran_cmp. Used in Single Level Lot Source
inquiry, Single Level Where Used inquiry, and the Daily
Transaction Detail report.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CO_CODE | VARCHAR2 | (4) | ||
COMPLETED_IND | NUMBER | |||
CREATION_DATE | DATE | |||
DOC_ID | NUMBER | (10) | ||
DOC_LINE | NUMBER | (10) | ||
DOC_TYPE | VARCHAR2 | (4) | ||
ITEM_ID | NUMBER | (10) | ||
LINE_ID | NUMBER | (10) | ||
LINE_TYPE | NUMBER | (5) | ||
LOCATION | VARCHAR2 | (16) | ||
LOT_ID | NUMBER | (10) | ||
LOT_STATUS | VARCHAR2 | (4) | ||
OP_CODE | NUMBER | (15) | ||
ORGN_CODE | VARCHAR2 | (4) | ||
QC_GRADE | VARCHAR2 | (4) | ||
REASON_CODE | VARCHAR2 | (4) | ||
TEXT_CODE | NUMBER | (10) | ||
TRANS_DATE | DATE | |||
TRANS_ID | NUMBER | (10) | ||
TRANS_QTY | NUMBER | |||
TRANS_QTY2 | NUMBER | |||
TRANS_STAT | VARCHAR2 | (4) | ||
TRANS_UM | VARCHAR2 | (4) | ||
TRANS_UM2 | VARCHAR2 | (4) | ||
WHSE_CODE | VARCHAR2 | (4) |
Cut, paste (and edit) the following text to query this object:
SELECT CO_CODE
, COMPLETED_IND
, CREATION_DATE
, DOC_ID
, DOC_LINE
, DOC_TYPE
, ITEM_ID
, LINE_ID
, LINE_TYPE
, LOCATION
, LOT_ID
, LOT_STATUS
, OP_CODE
, ORGN_CODE
, QC_GRADE
, REASON_CODE
, TEXT_CODE
, TRANS_DATE
, TRANS_ID
, TRANS_QTY
, TRANS_QTY2
, TRANS_STAT
, TRANS_UM
, TRANS_UM2
, WHSE_CODE
FROM APPS.IC_TRAN_VW1;
|
|
|