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


TABLE: APPS.ISC_DBI_FM_0007_MV

Object Details
Object Name: ISC_DBI_FM_0007_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableISC.ISC_DBI_FM_0007_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ISC_DBI_FM_0007_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_SNAPSHOT_DATE_ID
ColumnCUSTOMER_ID
ColumnITEM_CATEGORY_ID
ISC_DBI_FM_0007_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_SNAPSHOT_DATE_ID
ColumnITEM_ID
ColumnCUSTOMER_ID
ISC_DBI_FM_0007_MV_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_SNAPSHOT_DATE_ID
ColumnITEM_CATEGORY_ID
ColumnINV_ORG_ID
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 does not reference any database object

APPS.ISC_DBI_FM_0007_MV is referenced by following:

SchemaAPPS
Materialized ViewISC_DBI_FM_0007_MV