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

TABLE: APPS.ISC_DBI_FM_0004_MV

Object Details
Object Name: ISC_DBI_FM_0004_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.ISC_DBI_FM_0004_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_ISC_DBI_FM_0004_MV NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnM_ROW$$
Columns
Name Datatype Length Mandatory Comments
INV_ORG_ID NUMBER

Inventory Organization Identifier
INVENTORY_ITEM_ID NUMBER

Item Organization Identifier
CUSTOMER_ID NUMBER

Customer Identifier
TIME_BOOKED_DATE_ID DATE

Indicates the date when the order was booked
TIME_SCHEDULE_DATE_ID DATE

Date Scheduled to ship item
ORDER_NUMBER NUMBER

User-visible number of the order
HEADER_ID NUMBER

Order Header Identifier
COUNT_PDUE_LINE NUMBER

Count Column
LINE_NUMBER VARCHAR2 (240)
Line sequence number within the order
UOM VARCHAR2 (30)
Unit Of Measure Code
PDUE_QTY NUMBER

Past Due Quantity
FACT_ROWID ROWID (10)
Row ID of ISC_BOOK_SUM2_F table
SOLD_TO_ORG_ID NUMBER

Sold to Organization ID
SHIP_TO_ORG_ID NUMBER

Ship to Organization ID
LINE_ID NUMBER

Query Text

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


SELECT INV_ORG_ID
,      INVENTORY_ITEM_ID
,      CUSTOMER_ID
,      TIME_BOOKED_DATE_ID
,      TIME_SCHEDULE_DATE_ID
,      ORDER_NUMBER
,      HEADER_ID
,      COUNT_PDUE_LINE
,      LINE_NUMBER
,      UOM
,      PDUE_QTY
,      FACT_ROWID
,      SOLD_TO_ORG_ID
,      SHIP_TO_ORG_ID
,      LINE_ID
FROM APPS.ISC_DBI_FM_0004_MV;

Dependencies

[top of page]

APPS.ISC_DBI_FM_0004_MV does not reference any database object

APPS.ISC_DBI_FM_0004_MV is referenced by following:

SchemaAPPS
Package BodyISC_DBI_BOOK_SUM2_REF_PKG - show dependent code
Materialized ViewISC_DBI_FM_0004_MV