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

MATERIALIZED VIEW: APPS.ISC_TRN_000_MV

Object Details
Object Name: ISC_TRN_000_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ISC_TRN_000_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:

FII_TIME_DAY
ISC_DBI_DEL_LEGS_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
INV_ORG_ID NUMBER

Inventory organization identifier
SHIPMENT_DIRECTION VARCHAR2 (80)
Shipment direction identifier
CARRIER_ID NUMBER

Freight carrier identifier
MODE_OF_TRANSPORT VARCHAR2 (80)
Mode of transport identifier
SERVICE_LEVEL VARCHAR2 (80)
Service level identifier
AGG_LEVEL NUMBER

MV aggregation level flag
GRP_ID NUMBER

Grouping ID column
TIME_ID NUMBER

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Nested Grouping ID Column for Time
DAY_ID NUMBER

FII day identifier
WEEK_ID NUMBER

FII week identifier
ENT_PERIOD_ID NUMBER

Enterprise period identifer
ENT_QTR_ID NUMBER

Enterprise quarter identifer
FREIGHT_COST_WT_F NUMBER

Rated freight cost with freight weight in functional currency
COST_WT_F_CNT NUMBER

Count column
FREIGHT_COST_WT_G NUMBER

Rated freight cost with freight weight in primary global currency
COST_WT_G_CNT NUMBER

Count column
FREIGHT_COST_WT_G1 NUMBER

Rated freight cost with freight weight in secondary global currency
COST_WT_G1_CNT NUMBER

Count column
FREIGHT_COST_VOL_F NUMBER

Rated freight cost with freight volume in functional currency
COST_VOL_F_CNT NUMBER

Count column
FREIGHT_COST_VOL_G NUMBER

Rated freight cost with freight volume in primary global currency
COST_VOL_G_CNT NUMBER

Count column
FREIGHT_COST_VOL_G1 NUMBER

Rated freight cost with freight volume in secondary global currency
COST_VOL_G1_CNT NUMBER

Count column
FREIGHT_WEIGHT_G NUMBER

Freight weight in weight reporting unit of measure
FREIGHT_WEIGHT_G_CNT NUMBER

Count column
FREIGHT_VOLUME_G NUMBER

Freight volume in volume reporting unit of measure
FREIGHT_VOLUME_G_CNT NUMBER

Count column
CNT NUMBER

Row count
Query Text

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


SELECT INV_ORG_ID
,      SHIPMENT_DIRECTION
,      CARRIER_ID
,      MODE_OF_TRANSPORT
,      SERVICE_LEVEL
,      AGG_LEVEL
,      GRP_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      DAY_ID
,      WEEK_ID
,      ENT_PERIOD_ID
,      ENT_QTR_ID
,      FREIGHT_COST_WT_F
,      COST_WT_F_CNT
,      FREIGHT_COST_WT_G
,      COST_WT_G_CNT
,      FREIGHT_COST_WT_G1
,      COST_WT_G1_CNT
,      FREIGHT_COST_VOL_F
,      COST_VOL_F_CNT
,      FREIGHT_COST_VOL_G
,      COST_VOL_G_CNT
,      FREIGHT_COST_VOL_G1
,      COST_VOL_G1_CNT
,      FREIGHT_WEIGHT_G
,      FREIGHT_WEIGHT_G_CNT
,      FREIGHT_VOLUME_G
,      FREIGHT_VOLUME_G_CNT
,      CNT
FROM APPS.ISC_TRN_000_MV;

Dependencies

[top of page]

APPS.ISC_TRN_000_MV references the following:

SchemaAPPS
TableISC_TRN_000_MV
SchemaFII
TableFII_TIME_DAY
SchemaISC
TableISC_DBI_DEL_LEGS_F

APPS.ISC_TRN_000_MV is not referenced by any database object