DBA Data[Home] [Help] [Dependency Information]

MATERIALIZED VIEW: APPS.ISC_WMS_001_MV

Object Details
Object Name: ISC_WMS_001_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ISC_WMS_001_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

ENI_OLTP_ITEM_STAR
FII_TIME_DAY
ISC_DBI_DEL_DETAILS_F
OPI_DBI_CONC_PROG_RUN_LOG

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
INV_ORG_ID NUMBER

Inventory Organization Identifier
SUBINVENTORY_CODE VARCHAR2 (71)
Subinventory Code
ITEM_CATEGORY_ID NUMBER

Inventory Category Identifier
ITEM_ID VARCHAR2 (81)
Item Organization Identifier
AGG_LEVEL NUMBER

MV Aggregation Level flag
GRP_ID NUMBER

Grouping ID Column
TIME_ID NUMBER

Activity date time identifier
PERIOD_TYPE_ID NUMBER

Period Type Identifier
QTR_ID NUMBER

Enterprise Quarter Identifier
MONTH_ID NUMBER

Enterprise Period Identifier
WEEK_ID NUMBER

FII Week Identifier
DAY_ID NUMBER

FII Day Identifier
UOM VARCHAR2 (30)
Primary Unit of Measure code for the item
SHIP_CONFIRM_QTY NUMBER

Quantity Ship Confirmed
SHIP_CONFIRM_QTY_CNT NUMBER

Count Column
RELEASE_TO_SHIP NUMBER

Days elapsed between ship confirm and pick release
RELEASE_TO_SHIP_CNT NUMBER

Count Column
SHIP_CONFIRM_CNT NUMBER

Number of Ship Confirm transactions
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INV_ORG_ID
,      SUBINVENTORY_CODE
,      ITEM_CATEGORY_ID
,      ITEM_ID
,      AGG_LEVEL
,      GRP_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      QTR_ID
,      MONTH_ID
,      WEEK_ID
,      DAY_ID
,      UOM
,      SHIP_CONFIRM_QTY
,      SHIP_CONFIRM_QTY_CNT
,      RELEASE_TO_SHIP
,      RELEASE_TO_SHIP_CNT
,      SHIP_CONFIRM_CNT
FROM APPS.ISC_WMS_001_MV;

Dependencies

[top of page]

APPS.ISC_WMS_001_MV references the following:

SchemaAPPS
TableISC_WMS_001_MV
SchemaENI
TableENI_OLTP_ITEM_STAR
SchemaFII
TableFII_TIME_DAY
SchemaISC
TableISC_DBI_DEL_DETAILS_F
SchemaOPI
TableOPI_DBI_CONC_PROG_RUN_LOG

APPS.ISC_WMS_001_MV is not referenced by any database object