[Home] [Help] [Dependency Information]
Object Name: | OPI_PMI_INV_DAILY_STAT_TEMP |
---|---|
Object Type: | TABLE |
Owner: | OPI |
FND Design Data: | OPI.OPI_PMI_INV_DAILY_STAT_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_INV_DAILY_STAT_TEMP_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
ORGN_CODE
WHSE_CODE ITEM_ID TRX_DATE CO_CODE LOT_ID LOCATION |
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 | |||
AVG_ONH_VAL_B | NUMBER | |||
BEG_ONH_VAL_B | NUMBER | |||
END_ONH_VAL_B | NUMBER | |||
FROM_ORG_VAL_B | NUMBER | |||
INV_ADJ_VAL_B | NUMBER | |||
PO_DEL_VAL_B | NUMBER | |||
TOTAL_REC_VAL_B | NUMBER | |||
TOT_CUST_SHIP_VAL_B | NUMBER | |||
TOT_ISSUES_VAL_B | NUMBER | |||
TO_ORG_VAL_B | NUMBER | |||
WIP_COMP_VAL_B | NUMBER | |||
WIP_ISSUE_VAL_B | NUMBER | |||
PERIOD_STATUS | NUMBER | |||
DATA_PUSHED_IND | NUMBER |
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
, AVG_ONH_VAL_B
, BEG_ONH_VAL_B
, END_ONH_VAL_B
, FROM_ORG_VAL_B
, INV_ADJ_VAL_B
, PO_DEL_VAL_B
, TOTAL_REC_VAL_B
, TOT_CUST_SHIP_VAL_B
, TOT_ISSUES_VAL_B
, TO_ORG_VAL_B
, WIP_COMP_VAL_B
, WIP_ISSUE_VAL_B
, PERIOD_STATUS
, DATA_PUSHED_IND
FROM OPI.OPI_PMI_INV_DAILY_STAT_TEMP;
OPI.OPI_PMI_INV_DAILY_STAT_TEMP does not reference any database object
OPI.OPI_PMI_INV_DAILY_STAT_TEMP is referenced by following:
|
|
|