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

MATERIALIZED VIEW: APPS.ISC_DBI_CFM_013_MV

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

Product Category Identifier
CUSTOMER_ID NUMBER

Customer Identifier
TIME_BOOKED_DATE_ID DATE

Indicates the date when the order was booked
ORDER_NUMBER NUMBER

User-visible number of the order
HEADER_ID NUMBER

Order Header Identifier
PDUE_LINE_CNT NUMBER

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

Past Due Quantity
DAYS_LATE NUMBER

Days Late (to schedule) Count
DAYS_LATE_PROMISE NUMBER

Days Late (to promise) Count
PDUE_AMT_F NUMBER

Past Due amount in Functional currency
PDUE_AMT_G NUMBER

Past Due amount in Global currency
PDUE_AMT_G1 NUMBER

Past Due amount in Secondary Global currency
LATE_SCHEDULE_FLAG NUMBER

Grouping ID Column for Late to Schedule Order Lines
LATE_PROMISE_FLAG NUMBER

Grouping ID Column for Late to Promise Order Lines
TIME_SNAPSHOT_DATE_ID DATE

Date on which the snapshot was taken
PDUE_ROWID ROWID (10)
Row ID of ISC_BOOK_SUM2_PDUE2_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
,      TIME_BOOKED_DATE_ID
,      ORDER_NUMBER
,      HEADER_ID
,      PDUE_LINE_CNT
,      LINE_NUMBER
,      UOM
,      PDUE_QTY
,      DAYS_LATE
,      DAYS_LATE_PROMISE
,      PDUE_AMT_F
,      PDUE_AMT_G
,      PDUE_AMT_G1
,      LATE_SCHEDULE_FLAG
,      LATE_PROMISE_FLAG
,      TIME_SNAPSHOT_DATE_ID
,      PDUE_ROWID
,      ITEM_ROWID
,      MARKER
FROM APPS.ISC_DBI_CFM_013_MV;

Dependencies

[top of page]

APPS.ISC_DBI_CFM_013_MV references the following:

SchemaAPPS
TableISC_DBI_CFM_013_MV
SchemaENI
TableENI_OLTP_ITEM_STAR
SchemaISC
TableISC_BOOK_SUM2_PDUE2_F
APPS.ISC_DBI_CFM_013_MV is referenced by following:

SchemaAPPS
Materialized ViewISC_DBI_CFM_008_MV