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

MATERIALIZED VIEW: APPS.ISC_DBI_FM_0007_MV

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

ENI_OLTP_ITEM_STAR
ISC_BOOK_SUM2_BKORD_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
INV_ORG_ID NUMBER

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

Inventory Category Identifier
CUSTOMER_ID NUMBER

Customer Identifier
ORDER_NUMBER NUMBER

User-visible number of the order
HEADER_ID NUMBER

Order Header Identifier
TIME_REQUEST_DATE_ID DATE

Ordered Item Request date
TIME_SCHEDULE_DATE_ID DATE

Date Scheduled to ship item
LINE_NUMBER VARCHAR2 (240)
Line sequence number within the order
DAYS_LATE_REQUEST NUMBER

Count of Days Late (to request)
DAYS_LATE_SCHEDULE NUMBER

Count of Days Late (to schedule)
BACKORDER_QTY NUMBER

Backordered Quantity
UOM VARCHAR2 (30)
Unit Of Measure Code
BACKORDER_LINE_CNT NUMBER

Count of Backordered Order Lines
TIME_SNAPSHOT_DATE_ID DATE

Date on which the snapshot was taken
BACK_ROWID ROWID (10)
Row ID of ISC_BOOK_SUM2_BKORD_F table
ITEM_ROWID ROWID (10)
Row ID of ENI_OLTP_ITEM_STAR table
MARKER NUMBER

Union Marker Column
Query Text

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


SELECT INV_ORG_ID
,      ITEM_ID
,      ITEM_CATEGORY_ID
,      CUSTOMER_ID
,      ORDER_NUMBER
,      HEADER_ID
,      TIME_REQUEST_DATE_ID
,      TIME_SCHEDULE_DATE_ID
,      LINE_NUMBER
,      DAYS_LATE_REQUEST
,      DAYS_LATE_SCHEDULE
,      BACKORDER_QTY
,      UOM
,      BACKORDER_LINE_CNT
,      TIME_SNAPSHOT_DATE_ID
,      BACK_ROWID
,      ITEM_ROWID
,      MARKER
FROM APPS.ISC_DBI_FM_0007_MV;

Dependencies

[top of page]

APPS.ISC_DBI_FM_0007_MV references the following:

SchemaAPPS
TableISC_DBI_FM_0007_MV
SchemaENI
TableENI_OLTP_ITEM_STAR
SchemaISC
TableISC_BOOK_SUM2_BKORD_F

APPS.ISC_DBI_FM_0007_MV is not referenced by any database object