[Home] [Help] [Dependency Information]
Object Name: | OPI_PMI_IDS_TEMP |
---|---|
Object Type: | TABLE |
Owner: | OPI |
FND Design Data: | OPI.OPI_PMI_IDS_TEMP |
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: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OPI_PMI_IDS_TEMP_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE |
CO_CODE
ORGN_CODE WHSE_CODE LOCATION ITEM_ID LOT_ID TRX_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CO_CODE | VARCHAR2 | (4) | Yes | |
ORGN_CODE | VARCHAR2 | (4) | Yes | |
WHSE_CODE | VARCHAR2 | (4) | Yes | |
LOCATION | VARCHAR2 | (16) | Yes | |
ITEM_ID | NUMBER | Yes | ||
LOT_ID | NUMBER | Yes | ||
TRX_DATE | DATE | Yes | ||
AVG_ONH_QTY | NUMBER | |||
BEG_ONH_QTY | NUMBER | |||
CREATION_DATE | DATE | |||
END_ONH_QTY | NUMBER | |||
FROM_ORG_QTY | NUMBER | |||
INV_ADJ_QTY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
PO_DEL_QTY | NUMBER | |||
TOTAL_REC_QTY | NUMBER | |||
TOT_CUST_SHIP_QTY | NUMBER | |||
TOT_ISSUES_QTY | NUMBER | |||
TO_ORG_QTY | NUMBER | |||
WIP_COMP_QTY | NUMBER | |||
WIP_ISSUE_QTY | NUMBER | |||
PERIOD_FLAG | NUMBER | |||
OPERATION_CODE | VARCHAR2 | (40) |
Cut, paste (and edit) the following text to query this object:
SELECT CO_CODE
, ORGN_CODE
, WHSE_CODE
, LOCATION
, ITEM_ID
, LOT_ID
, TRX_DATE
, AVG_ONH_QTY
, BEG_ONH_QTY
, CREATION_DATE
, END_ONH_QTY
, FROM_ORG_QTY
, INV_ADJ_QTY
, LAST_UPDATE_DATE
, PO_DEL_QTY
, TOTAL_REC_QTY
, TOT_CUST_SHIP_QTY
, TOT_ISSUES_QTY
, TO_ORG_QTY
, WIP_COMP_QTY
, WIP_ISSUE_QTY
, PERIOD_FLAG
, OPERATION_CODE
FROM OPI.OPI_PMI_IDS_TEMP;
OPI.OPI_PMI_IDS_TEMP does not reference any database object
OPI.OPI_PMI_IDS_TEMP is referenced by following:
|
|
|