[Home] [Help] [Dependency Information]
Object Name: | OPI_PMI_TRANS_INC |
---|---|
Object Type: | TABLE |
Owner: | OPI |
FND Design Data: | OPI.OPI_PMI_TRANS_INC |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CO_CODE | VARCHAR2 | (4) | Yes | |
ORGN_CODE | VARCHAR2 | (4) | Yes | |
WHSE_CODE | VARCHAR2 | (4) | ||
ITEM_ID | NUMBER | (10) | Yes | |
LINE_ID | NUMBER | (10) | Yes | |
LOT_ID | NUMBER | (10) | Yes | |
LOCATION | VARCHAR2 | (16) | ||
DOC_TYPE | VARCHAR2 | (4) | Yes | |
DOC_ID | NUMBER | (10) | Yes | |
DOC_LINE | NUMBER | (10) | Yes | |
TRANS_DATE | DATE | Yes | ||
TRANS_QTY | NUMBER | |||
TRANS_QTY2 | NUMBER | |||
QC_GRADE | VARCHAR2 | (4) | ||
LOT_STATUS | VARCHAR2 | (4) | ||
TRANS_UM | VARCHAR2 | (4) | ||
TRANS_UM2 | VARCHAR2 | (4) | ||
REASON_CODE | VARCHAR2 | (4) | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
CURR_BAL | NUMBER | |||
LINE_TYPE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT CO_CODE
, ORGN_CODE
, WHSE_CODE
, ITEM_ID
, LINE_ID
, LOT_ID
, LOCATION
, DOC_TYPE
, DOC_ID
, DOC_LINE
, TRANS_DATE
, TRANS_QTY
, TRANS_QTY2
, QC_GRADE
, LOT_STATUS
, TRANS_UM
, TRANS_UM2
, REASON_CODE
, CREATION_DATE
, LAST_UPDATE_DATE
, CURR_BAL
, LINE_TYPE
FROM OPI.OPI_PMI_TRANS_INC;
OPI.OPI_PMI_TRANS_INC does not reference any database object
OPI.OPI_PMI_TRANS_INC is referenced by following:
|
|
|