eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: APPS.ISC_DBI_FM_0000_MV

Object Details

Object Name:	ISC_DBI_FM_0000_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.ISC_DBI_FM_0000_MV
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_SNAP$_ISC_DBI_FM_0000_MV	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_SUMMARY	SYS_OP_MAP_NONNULL("INV_ORG_ID") SYS_OP_MAP_NONNULL("CUSTOMER_ID") SYS_OP_MAP_NONNULL("ITEM_CATEGORY_ID") SYS_OP_MAP_NONNULL("ITEM_ID") SYS_OP_MAP_NONNULL("UOM") SYS_OP_MAP_NONNULL("PROD_CATEGORY_ID") SYS_OP_MAP_NONNULL("ENT_QTR_ID") SYS_OP_MAP_NONNULL("ENT_PERIOD_ID") SYS_OP_MAP_NONNULL("WEEK_ID") SYS_OP_MAP_NONNULL("DAY_ID") SYS_OP_MAP_NONNULL("GRP_ID") SYS_OP_MAP_NONNULL("ITEM_CAT_FLAG") SYS_OP_MAP_NONNULL("CUSTOMER_FLAG")
ISC_DBI_FM_0000_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID AGG_LEVEL CUSTOMER_ID ITEM_CATEGORY_ID INV_ORG_ID
ISC_DBI_FM_0000_MV_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID AGG_LEVEL CUSTOMER_ID PROD_CATEGORY_ID INV_ORG_ID
ISC_DBI_FM_0000_MV_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID AGG_LEVEL ITEM_ID CUSTOMER_ID INV_ORG_ID
ISC_DBI_FM_0000_MV_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID AGG_LEVEL ITEM_CATEGORY_ID INV_ORG_ID
ISC_DBI_FM_0000_MV_N5	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID AGG_LEVEL PROD_CATEGORY_ID INV_ORG_ID
ISC_DBI_FM_0000_MV_N6	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID AGG_LEVEL INV_ORG_ID ITEM_ID

Columns

Name	Datatype	Length	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 does not reference any database object

APPS.ISC_DBI_FM_0000_MV is referenced by following:

APPS: ISC_DBI_FM_0000_MV; ISC_TRN_005_MV