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

MATERIALIZED VIEW: APPS.ISC_DBI_FM_0000_MV

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

BIS_BUCKET
BIS_BUCKET_CUSTOMIZATIONS
ENI_OLTP_ITEM_STAR
FII_TIME_DAY
ISC_BOOK_SUM2_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
INV_ORG_ID NUMBER

Inventory Organization Identifier
CUSTOMER_ID NUMBER

Customer Identifier
ITEM_ID VARCHAR2 (81)
Item Organization Identifier
ITEM_CATEGORY_ID NUMBER

Inventory Category Identifier
PROD_CATEGORY_ID NUMBER

AGG_LEVEL NUMBER

GRP_ID NUMBER

Grouping ID Column
ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item Dimension
CUSTOMER_FLAG NUMBER

Grouping ID Column for Customer Dimension
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 Idntifier
ENT_PERIOD_ID NUMBER

Enterprise Period Identifier
ENT_QTR_ID NUMBER

Enterprise Quarter Identifier
SHIPPED_LINE_CNT NUMBER

Count of Shipped Order Lines
SHIPPED_L_C NUMBER

Count Column
LATE_LINE_CNT NUMBER

Count of Shipped (late to schedule) Order Lines
LATE_L_C NUMBER

Count Column
LATE_LINE_PROMISE_CNT NUMBER

Count of Shipped (late to promise) Order Lines
LATE_L_PROMISE_C NUMBER

Count Column
EARLY_LINE_CNT NUMBER

Count of Shipped (early) Order Lines
EARLY_L_C NUMBER

Count Column
ON_TIME_LINE_CNT NUMBER

Count of Shipped (on time) Order Lines
ON_TIME_L_C NUMBER

Count Column
DAYS_LATE NUMBER

Count of Days Shipped Late (to schedule)
DAYS_LATE_CNT NUMBER

Count Column
DAYS_LATE_PROMISE NUMBER

Count of Days Shipped Late (to promise)
DAYS_LATE_PROMISE_CNT NUMBER

Count Column
SHIPPED_LATE_QTY NUMBER

Shipped Late to Schedule Quantity
SHIPPED_LATE_QTY_CNT NUMBER

Count Column
SHIPPED_LATE_P_QTY NUMBER

Shipped Late to Promise Quantity
SHIPPED_LATE_P_QTY_CNT NUMBER

Count Column
BOOK_TO_SHIP_DAYS NUMBER

Count of Days between booked date and shipped date
BOOK_TO_SHIP_CNT NUMBER

Count Column
BOOK_TO_SHIP_DAYS_LATE NUMBER

Count of Days between booked date and shipped date for Order Lines Shipped (late to schedule)
BOOK_TO_SHIP_LATE_CNT NUMBER

Count Column
BOOK_TO_SHIP_DAYS_LATE_P NUMBER

Count of Days between booked date and shipped date for Order Lines Shipped (late to promise)
BOOK_TO_SHIP_LATE_P_CNT NUMBER

Count Column
BUCKET1_LINE_CNT NUMBER

Count of Shipped Lines for Bucket1
BUCKET2_LINE_CNT NUMBER

Count of Shipped Lines for Bucket2
BUCKET3_LINE_CNT NUMBER

Count of Shipped Lines for Bucket3
BUCKET4_LINE_CNT NUMBER

Count of Shipped Lines for Bucket4
BUCKET5_LINE_CNT NUMBER

Count of Shipped Lines for Bucket5
BUCKET6_LINE_CNT NUMBER

Count of Shipped Lines for Bucket6
BUCKET7_LINE_CNT NUMBER

Count of Shipped Lines for Bucket7
BUCKET8_LINE_CNT NUMBER

Count of Shipped Lines for Bucket8
BUCKET9_LINE_CNT NUMBER

Count of Shipped Lines for Bucket9
BUCKET10_LINE_CNT NUMBER

Count of Shipped Lines for Bucket10
BUCKET1_LINE_CNT_C NUMBER

Count Column
BUCKET2_LINE_CNT_C NUMBER

Count Column
BUCKET3_LINE_CNT_C NUMBER

Count Column
BUCKET4_LINE_CNT_C NUMBER

Count Column
BUCKET5_LINE_CNT_C NUMBER

Count Column
BUCKET6_LINE_CNT_C NUMBER

Count Column
BUCKET7_LINE_CNT_C NUMBER

Count Column
BUCKET8_LINE_CNT_C NUMBER

Count Column
BUCKET9_LINE_CNT_C NUMBER

Count Column
BUCKET10_LINE_CNT_C NUMBER

Count Column
UOM VARCHAR2 (30)
Unit Of Measure Code
SHIPPED_QTY NUMBER

Shipped Quantity
FREIGHT_CHARGE_AMT_F NUMBER

Freight Cost Amount in Functional Currency
FREIGHT_CHARGE_AMT_F_CNT NUMBER

Count Column
FREIGHT_CHARGE_AMT_G NUMBER

Freight Cost Amount in Primary Global Currency
FREIGHT_CHARGE_AMT_G_CNT NUMBER

Count Column
FREIGHT_CHARGE_AMT_G1 NUMBER

Freight Cost Amount in Secondary Global Currency
FREIGHT_CHARGE_AMT_G1_CNT NUMBER

Count Column
FREIGHT_COST_AMT_F NUMBER

Freight Cost Amount in Functional Currency
FREIGHT_COST_AMT_F_CNT NUMBER

Count Column
FREIGHT_COST_AMT_G NUMBER

Freight Cost Amount in Primary Global Currency
FREIGHT_COST_AMT_G_CNT NUMBER

Count Column
FREIGHT_COST_AMT_G1 NUMBER

Freight Cost Amount in Secondary Global Currency
FREIGHT_COST_AMT_G1_CNT NUMBER

Count Column
SHIPPED_QTY_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
,      CUSTOMER_ID
,      ITEM_ID
,      ITEM_CATEGORY_ID
,      PROD_CATEGORY_ID
,      AGG_LEVEL
,      GRP_ID
,      ITEM_CAT_FLAG
,      CUSTOMER_FLAG
,      TIME_ID
,      PERIOD_TYPE_ID
,      DAY_ID
,      WEEK_ID
,      ENT_PERIOD_ID
,      ENT_QTR_ID
,      SHIPPED_LINE_CNT
,      SHIPPED_L_C
,      LATE_LINE_CNT
,      LATE_L_C
,      LATE_LINE_PROMISE_CNT
,      LATE_L_PROMISE_C
,      EARLY_LINE_CNT
,      EARLY_L_C
,      ON_TIME_LINE_CNT
,      ON_TIME_L_C
,      DAYS_LATE
,      DAYS_LATE_CNT
,      DAYS_LATE_PROMISE
,      DAYS_LATE_PROMISE_CNT
,      SHIPPED_LATE_QTY
,      SHIPPED_LATE_QTY_CNT
,      SHIPPED_LATE_P_QTY
,      SHIPPED_LATE_P_QTY_CNT
,      BOOK_TO_SHIP_DAYS
,      BOOK_TO_SHIP_CNT
,      BOOK_TO_SHIP_DAYS_LATE
,      BOOK_TO_SHIP_LATE_CNT
,      BOOK_TO_SHIP_DAYS_LATE_P
,      BOOK_TO_SHIP_LATE_P_CNT
,      BUCKET1_LINE_CNT
,      BUCKET2_LINE_CNT
,      BUCKET3_LINE_CNT
,      BUCKET4_LINE_CNT
,      BUCKET5_LINE_CNT
,      BUCKET6_LINE_CNT
,      BUCKET7_LINE_CNT
,      BUCKET8_LINE_CNT
,      BUCKET9_LINE_CNT
,      BUCKET10_LINE_CNT
,      BUCKET1_LINE_CNT_C
,      BUCKET2_LINE_CNT_C
,      BUCKET3_LINE_CNT_C
,      BUCKET4_LINE_CNT_C
,      BUCKET5_LINE_CNT_C
,      BUCKET6_LINE_CNT_C
,      BUCKET7_LINE_CNT_C
,      BUCKET8_LINE_CNT_C
,      BUCKET9_LINE_CNT_C
,      BUCKET10_LINE_CNT_C
,      UOM
,      SHIPPED_QTY
,      FREIGHT_CHARGE_AMT_F
,      FREIGHT_CHARGE_AMT_F_CNT
,      FREIGHT_CHARGE_AMT_G
,      FREIGHT_CHARGE_AMT_G_CNT
,      FREIGHT_CHARGE_AMT_G1
,      FREIGHT_CHARGE_AMT_G1_CNT
,      FREIGHT_COST_AMT_F
,      FREIGHT_COST_AMT_F_CNT
,      FREIGHT_COST_AMT_G
,      FREIGHT_COST_AMT_G_CNT
,      FREIGHT_COST_AMT_G1
,      FREIGHT_COST_AMT_G1_CNT
,      SHIPPED_QTY_CNT
,      CNT
FROM APPS.ISC_DBI_FM_0000_MV;

Dependencies

[top of page]

APPS.ISC_DBI_FM_0000_MV references the following:

SchemaAPPS
TableISC_DBI_FM_0000_MV
SchemaBIS
TableBIS_BUCKET
TableBIS_BUCKET_CUSTOMIZATIONS
SchemaENI
TableENI_OLTP_ITEM_STAR
SchemaFII
TableFII_TIME_DAY
SchemaISC
TableISC_BOOK_SUM2_F
APPS.ISC_DBI_FM_0000_MV is referenced by following:

SchemaAPPS
Materialized ViewISC_TRN_005_MV