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

MATERIALIZED VIEW: APPS.ISC_DBI_CFM_008_MV

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

BIS_BUCKET
BIS_BUCKET_CUSTOMIZATIONS
ISC_DBI_CFM_013_MV
     ENI_OLTP_ITEM_STAR
     ISC_BOOK_SUM2_PDUE2_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
INV_ORG_ID NUMBER

ITEM_ID VARCHAR2 (81)
ITEM_CATEGORY_ID NUMBER

CUSTOMER_ID NUMBER

TIME_SNAPSHOT_DATE_ID DATE

UOM VARCHAR2 (30)
LATE_SCHEDULE_FLAG NUMBER

LATE_PROMISE_FLAG NUMBER

GRP_ID NUMBER

ITEM_CAT_FLAG NUMBER

CUSTOMER_FLAG NUMBER

DAYS_LATE NUMBER

DAYS_LATE_CNT NUMBER

DAYS_LATE_PROMISE NUMBER

DAYS_LATE_PROMISE_CNT NUMBER

PDUE_LINE_CNT NUMBER

PDUE_LINE_CNT_C NUMBER

PDUE_AMT_F NUMBER

PDUE_AMT_F_CNT NUMBER

PDUE_AMT_G NUMBER

PDUE_AMT_G_CNT NUMBER

PDUE_AMT_G1 NUMBER

PDUE_AMT_G1_CNT NUMBER

PDUE_QTY NUMBER

PDUE_QTY_CNT NUMBER

BUCKET1_LINE_CNT NUMBER

BUCKET2_LINE_CNT NUMBER

BUCKET3_LINE_CNT NUMBER

BUCKET4_LINE_CNT NUMBER

BUCKET5_LINE_CNT NUMBER

BUCKET6_LINE_CNT NUMBER

BUCKET7_LINE_CNT NUMBER

BUCKET8_LINE_CNT NUMBER

BUCKET9_LINE_CNT NUMBER

BUCKET10_LINE_CNT NUMBER

Count of Past Due Schedule Lines for Bucket10
BUCKET1_LINE_CNT_C NUMBER

BUCKET2_LINE_CNT_C NUMBER

BUCKET3_LINE_CNT_C NUMBER

BUCKET4_LINE_CNT_C NUMBER

BUCKET5_LINE_CNT_C NUMBER

BUCKET6_LINE_CNT_C NUMBER

BUCKET7_LINE_CNT_C NUMBER

BUCKET8_LINE_CNT_C NUMBER

BUCKET9_LINE_CNT_C NUMBER

BUCKET10_LINE_CNT_C NUMBER

Count Column
BUCKET1_DAYS_LATE NUMBER

BUCKET2_DAYS_LATE NUMBER

BUCKET3_DAYS_LATE NUMBER

BUCKET4_DAYS_LATE NUMBER

BUCKET5_DAYS_LATE NUMBER

BUCKET6_DAYS_LATE NUMBER

BUCKET7_DAYS_LATE NUMBER

BUCKET8_DAYS_LATE NUMBER

BUCKET9_DAYS_LATE NUMBER

BUCKET10_DAYS_LATE NUMBER

Days Late Count for Bucket10
BUCKET1_DAYS_LATE_C NUMBER

BUCKET2_DAYS_LATE_C NUMBER

BUCKET3_DAYS_LATE_C NUMBER

BUCKET4_DAYS_LATE_C NUMBER

BUCKET5_DAYS_LATE_C NUMBER

BUCKET6_DAYS_LATE_C NUMBER

BUCKET7_DAYS_LATE_C NUMBER

BUCKET8_DAYS_LATE_C NUMBER

BUCKET9_DAYS_LATE_C NUMBER

BUCKET10_DAYS_LATE_C NUMBER

Count Column
BUCKET1_QTY NUMBER

BUCKET2_QTY NUMBER

BUCKET3_QTY NUMBER

BUCKET4_QTY NUMBER

BUCKET5_QTY NUMBER

BUCKET6_QTY NUMBER

BUCKET7_QTY NUMBER

BUCKET8_QTY NUMBER

BUCKET9_QTY NUMBER

BUCKET10_QTY NUMBER

BUCKET1_QTY_C NUMBER

BUCKET2_QTY_C NUMBER

BUCKET3_QTY_C NUMBER

BUCKET4_QTY_C NUMBER

BUCKET5_QTY_C NUMBER

BUCKET6_QTY_C NUMBER

BUCKET7_QTY_C NUMBER

BUCKET8_QTY_C NUMBER

BUCKET9_QTY_C NUMBER

BUCKET10_QTY_C NUMBER

BUCKET1_PDUE_AMT_F NUMBER

BUCKET2_PDUE_AMT_F NUMBER

BUCKET3_PDUE_AMT_F NUMBER

BUCKET4_PDUE_AMT_F NUMBER

BUCKET5_PDUE_AMT_F NUMBER

BUCKET6_PDUE_AMT_F NUMBER

BUCKET7_PDUE_AMT_F NUMBER

BUCKET8_PDUE_AMT_F NUMBER

BUCKET9_PDUE_AMT_F NUMBER

BUCKET10_PDUE_AMT_F NUMBER

Past Due Schedule amount in Functional currency for Bucket10
BUCKET1_PDUE_AMT_F_C NUMBER

BUCKET2_PDUE_AMT_F_C NUMBER

BUCKET3_PDUE_AMT_F_C NUMBER

BUCKET4_PDUE_AMT_F_C NUMBER

BUCKET5_PDUE_AMT_F_C NUMBER

BUCKET6_PDUE_AMT_F_C NUMBER

BUCKET7_PDUE_AMT_F_C NUMBER

BUCKET8_PDUE_AMT_F_C NUMBER

BUCKET9_PDUE_AMT_F_C NUMBER

BUCKET10_PDUE_AMT_F_C NUMBER

Count Column
BUCKET1_PDUE_AMT_G NUMBER

BUCKET2_PDUE_AMT_G NUMBER

BUCKET3_PDUE_AMT_G NUMBER

BUCKET4_PDUE_AMT_G NUMBER

BUCKET5_PDUE_AMT_G NUMBER

BUCKET6_PDUE_AMT_G NUMBER

BUCKET7_PDUE_AMT_G NUMBER

BUCKET8_PDUE_AMT_G NUMBER

BUCKET9_PDUE_AMT_G NUMBER

BUCKET10_PDUE_AMT_G NUMBER

BUCKET1_PDUE_AMT_G_C NUMBER

BUCKET2_PDUE_AMT_G_C NUMBER

BUCKET3_PDUE_AMT_G_C NUMBER

BUCKET4_PDUE_AMT_G_C NUMBER

BUCKET5_PDUE_AMT_G_C NUMBER

BUCKET6_PDUE_AMT_G_C NUMBER

BUCKET7_PDUE_AMT_G_C NUMBER

BUCKET8_PDUE_AMT_G_C NUMBER

BUCKET9_PDUE_AMT_G_C NUMBER

BUCKET10_PDUE_AMT_G_C NUMBER

BUCKET1_PDUE_AMT_G1 NUMBER

BUCKET2_PDUE_AMT_G1 NUMBER

BUCKET3_PDUE_AMT_G1 NUMBER

BUCKET4_PDUE_AMT_G1 NUMBER

BUCKET5_PDUE_AMT_G1 NUMBER

BUCKET6_PDUE_AMT_G1 NUMBER

BUCKET7_PDUE_AMT_G1 NUMBER

BUCKET8_PDUE_AMT_G1 NUMBER

BUCKET9_PDUE_AMT_G1 NUMBER

BUCKET10_PDUE_AMT_G1 NUMBER

BUCKET1_PDUE_AMT_G1_C NUMBER

BUCKET2_PDUE_AMT_G1_C NUMBER

BUCKET3_PDUE_AMT_G1_C NUMBER

BUCKET4_PDUE_AMT_G1_C NUMBER

BUCKET5_PDUE_AMT_G1_C NUMBER

BUCKET6_PDUE_AMT_G1_C NUMBER

BUCKET7_PDUE_AMT_G1_C NUMBER

BUCKET8_PDUE_AMT_G1_C NUMBER

BUCKET9_PDUE_AMT_G1_C NUMBER

BUCKET10_PDUE_AMT_G1_C NUMBER

BUCKET1_LINE_CNT_P NUMBER

BUCKET2_LINE_CNT_P NUMBER

BUCKET3_LINE_CNT_P NUMBER

BUCKET4_LINE_CNT_P NUMBER

BUCKET5_LINE_CNT_P NUMBER

BUCKET6_LINE_CNT_P NUMBER

BUCKET7_LINE_CNT_P NUMBER

BUCKET8_LINE_CNT_P NUMBER

BUCKET9_LINE_CNT_P NUMBER

BUCKET10_LINE_CNT_P NUMBER

Count of Past Due Promise Lines for Bucket10
BUCKET1_LINE_CNT_P_C NUMBER

BUCKET2_LINE_CNT_P_C NUMBER

BUCKET3_LINE_CNT_P_C NUMBER

BUCKET4_LINE_CNT_P_C NUMBER

BUCKET5_LINE_CNT_P_C NUMBER

BUCKET6_LINE_CNT_P_C NUMBER

BUCKET7_LINE_CNT_P_C NUMBER

BUCKET8_LINE_CNT_P_C NUMBER

BUCKET9_LINE_CNT_P_C NUMBER

BUCKET10_LINE_CNT_P_C NUMBER

Count Column
BUCKET1_DAYS_LATE_P NUMBER

BUCKET2_DAYS_LATE_P NUMBER

BUCKET3_DAYS_LATE_P NUMBER

BUCKET4_DAYS_LATE_P NUMBER

BUCKET5_DAYS_LATE_P NUMBER

BUCKET6_DAYS_LATE_P NUMBER

BUCKET7_DAYS_LATE_P NUMBER

BUCKET8_DAYS_LATE_P NUMBER

BUCKET9_DAYS_LATE_P NUMBER

BUCKET10_DAYS_LATE_P NUMBER

Days Late (to promise) Count for Bucket10
BUCKET1_DAYS_LATE_P_C NUMBER

BUCKET2_DAYS_LATE_P_C NUMBER

BUCKET3_DAYS_LATE_P_C NUMBER

BUCKET4_DAYS_LATE_P_C NUMBER

BUCKET5_DAYS_LATE_P_C NUMBER

BUCKET6_DAYS_LATE_P_C NUMBER

BUCKET7_DAYS_LATE_P_C NUMBER

BUCKET8_DAYS_LATE_P_C NUMBER

BUCKET9_DAYS_LATE_P_C NUMBER

BUCKET10_DAYS_LATE_P_C NUMBER

Count Column
BUCKET1_QTY_P NUMBER

BUCKET2_QTY_P NUMBER

BUCKET3_QTY_P NUMBER

BUCKET4_QTY_P NUMBER

BUCKET5_QTY_P NUMBER

BUCKET6_QTY_P NUMBER

BUCKET7_QTY_P NUMBER

BUCKET8_QTY_P NUMBER

BUCKET9_QTY_P NUMBER

BUCKET10_QTY_P NUMBER

BUCKET1_QTY_P_C NUMBER

BUCKET2_QTY_P_C NUMBER

BUCKET3_QTY_P_C NUMBER

BUCKET4_QTY_P_C NUMBER

BUCKET5_QTY_P_C NUMBER

BUCKET6_QTY_P_C NUMBER

BUCKET7_QTY_P_C NUMBER

BUCKET8_QTY_P_C NUMBER

BUCKET9_QTY_P_C NUMBER

BUCKET10_QTY_P_C NUMBER

BUCKET1_PDUE_AMT_F_P NUMBER

BUCKET2_PDUE_AMT_F_P NUMBER

BUCKET3_PDUE_AMT_F_P NUMBER

BUCKET4_PDUE_AMT_F_P NUMBER

BUCKET5_PDUE_AMT_F_P NUMBER

BUCKET6_PDUE_AMT_F_P NUMBER

BUCKET7_PDUE_AMT_F_P NUMBER

BUCKET8_PDUE_AMT_F_P NUMBER

BUCKET9_PDUE_AMT_F_P NUMBER

BUCKET10_PDUE_AMT_F_P NUMBER

Past Due Promise amount in Functional currency for Bucket10
BUCKET1_PDUE_AMT_F_P_C NUMBER

BUCKET2_PDUE_AMT_F_P_C NUMBER

BUCKET3_PDUE_AMT_F_P_C NUMBER

BUCKET4_PDUE_AMT_F_P_C NUMBER

BUCKET5_PDUE_AMT_F_P_C NUMBER

BUCKET6_PDUE_AMT_F_P_C NUMBER

BUCKET7_PDUE_AMT_F_P_C NUMBER

BUCKET8_PDUE_AMT_F_P_C NUMBER

BUCKET9_PDUE_AMT_F_P_C NUMBER

BUCKET10_PDUE_AMT_F_P_C NUMBER

BUCKET1_PDUE_AMT_G_P NUMBER

BUCKET2_PDUE_AMT_G_P NUMBER

BUCKET3_PDUE_AMT_G_P NUMBER

BUCKET4_PDUE_AMT_G_P NUMBER

BUCKET5_PDUE_AMT_G_P NUMBER

BUCKET6_PDUE_AMT_G_P NUMBER

BUCKET7_PDUE_AMT_G_P NUMBER

BUCKET8_PDUE_AMT_G_P NUMBER

BUCKET9_PDUE_AMT_G_P NUMBER

BUCKET10_PDUE_AMT_G_P NUMBER

BUCKET1_PDUE_AMT_G_P_C NUMBER

BUCKET2_PDUE_AMT_G_P_C NUMBER

BUCKET3_PDUE_AMT_G_P_C NUMBER

BUCKET4_PDUE_AMT_G_P_C NUMBER

BUCKET5_PDUE_AMT_G_P_C NUMBER

BUCKET6_PDUE_AMT_G_P_C NUMBER

BUCKET7_PDUE_AMT_G_P_C NUMBER

BUCKET8_PDUE_AMT_G_P_C NUMBER

BUCKET9_PDUE_AMT_G_P_C NUMBER

BUCKET10_PDUE_AMT_G_P_C NUMBER

BUCKET1_PDUE_AMT_G1_P NUMBER

BUCKET2_PDUE_AMT_G1_P NUMBER

BUCKET3_PDUE_AMT_G1_P NUMBER

BUCKET4_PDUE_AMT_G1_P NUMBER

BUCKET5_PDUE_AMT_G1_P NUMBER

BUCKET6_PDUE_AMT_G1_P NUMBER

BUCKET7_PDUE_AMT_G1_P NUMBER

BUCKET8_PDUE_AMT_G1_P NUMBER

BUCKET9_PDUE_AMT_G1_P NUMBER

BUCKET10_PDUE_AMT_G1_P NUMBER

BUCKET1_PDUE_AMT_G1_P_C NUMBER

BUCKET2_PDUE_AMT_G1_P_C NUMBER

BUCKET3_PDUE_AMT_G1_P_C NUMBER

BUCKET4_PDUE_AMT_G1_P_C NUMBER

BUCKET5_PDUE_AMT_G1_P_C NUMBER

BUCKET6_PDUE_AMT_G1_P_C NUMBER

BUCKET7_PDUE_AMT_G1_P_C NUMBER

BUCKET8_PDUE_AMT_G1_P_C NUMBER

BUCKET9_PDUE_AMT_G1_P_C NUMBER

BUCKET10_PDUE_AMT_G1_P_C NUMBER

LINES_CNT NUMBER

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_SNAPSHOT_DATE_ID
,      UOM
,      LATE_SCHEDULE_FLAG
,      LATE_PROMISE_FLAG
,      GRP_ID
,      ITEM_CAT_FLAG
,      CUSTOMER_FLAG
,      DAYS_LATE
,      DAYS_LATE_CNT
,      DAYS_LATE_PROMISE
,      DAYS_LATE_PROMISE_CNT
,      PDUE_LINE_CNT
,      PDUE_LINE_CNT_C
,      PDUE_AMT_F
,      PDUE_AMT_F_CNT
,      PDUE_AMT_G
,      PDUE_AMT_G_CNT
,      PDUE_AMT_G1
,      PDUE_AMT_G1_CNT
,      PDUE_QTY
,      PDUE_QTY_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
,      BUCKET1_DAYS_LATE
,      BUCKET2_DAYS_LATE
,      BUCKET3_DAYS_LATE
,      BUCKET4_DAYS_LATE
,      BUCKET5_DAYS_LATE
,      BUCKET6_DAYS_LATE
,      BUCKET7_DAYS_LATE
,      BUCKET8_DAYS_LATE
,      BUCKET9_DAYS_LATE
,      BUCKET10_DAYS_LATE
,      BUCKET1_DAYS_LATE_C
,      BUCKET2_DAYS_LATE_C
,      BUCKET3_DAYS_LATE_C
,      BUCKET4_DAYS_LATE_C
,      BUCKET5_DAYS_LATE_C
,      BUCKET6_DAYS_LATE_C
,      BUCKET7_DAYS_LATE_C
,      BUCKET8_DAYS_LATE_C
,      BUCKET9_DAYS_LATE_C
,      BUCKET10_DAYS_LATE_C
,      BUCKET1_QTY
,      BUCKET2_QTY
,      BUCKET3_QTY
,      BUCKET4_QTY
,      BUCKET5_QTY
,      BUCKET6_QTY
,      BUCKET7_QTY
,      BUCKET8_QTY
,      BUCKET9_QTY
,      BUCKET10_QTY
,      BUCKET1_QTY_C
,      BUCKET2_QTY_C
,      BUCKET3_QTY_C
,      BUCKET4_QTY_C
,      BUCKET5_QTY_C
,      BUCKET6_QTY_C
,      BUCKET7_QTY_C
,      BUCKET8_QTY_C
,      BUCKET9_QTY_C
,      BUCKET10_QTY_C
,      BUCKET1_PDUE_AMT_F
,      BUCKET2_PDUE_AMT_F
,      BUCKET3_PDUE_AMT_F
,      BUCKET4_PDUE_AMT_F
,      BUCKET5_PDUE_AMT_F
,      BUCKET6_PDUE_AMT_F
,      BUCKET7_PDUE_AMT_F
,      BUCKET8_PDUE_AMT_F
,      BUCKET9_PDUE_AMT_F
,      BUCKET10_PDUE_AMT_F
,      BUCKET1_PDUE_AMT_F_C
,      BUCKET2_PDUE_AMT_F_C
,      BUCKET3_PDUE_AMT_F_C
,      BUCKET4_PDUE_AMT_F_C
,      BUCKET5_PDUE_AMT_F_C
,      BUCKET6_PDUE_AMT_F_C
,      BUCKET7_PDUE_AMT_F_C
,      BUCKET8_PDUE_AMT_F_C
,      BUCKET9_PDUE_AMT_F_C
,      BUCKET10_PDUE_AMT_F_C
,      BUCKET1_PDUE_AMT_G
,      BUCKET2_PDUE_AMT_G
,      BUCKET3_PDUE_AMT_G
,      BUCKET4_PDUE_AMT_G
,      BUCKET5_PDUE_AMT_G
,      BUCKET6_PDUE_AMT_G
,      BUCKET7_PDUE_AMT_G
,      BUCKET8_PDUE_AMT_G
,      BUCKET9_PDUE_AMT_G
,      BUCKET10_PDUE_AMT_G
,      BUCKET1_PDUE_AMT_G_C
,      BUCKET2_PDUE_AMT_G_C
,      BUCKET3_PDUE_AMT_G_C
,      BUCKET4_PDUE_AMT_G_C
,      BUCKET5_PDUE_AMT_G_C
,      BUCKET6_PDUE_AMT_G_C
,      BUCKET7_PDUE_AMT_G_C
,      BUCKET8_PDUE_AMT_G_C
,      BUCKET9_PDUE_AMT_G_C
,      BUCKET10_PDUE_AMT_G_C
,      BUCKET1_PDUE_AMT_G1
,      BUCKET2_PDUE_AMT_G1
,      BUCKET3_PDUE_AMT_G1
,      BUCKET4_PDUE_AMT_G1
,      BUCKET5_PDUE_AMT_G1
,      BUCKET6_PDUE_AMT_G1
,      BUCKET7_PDUE_AMT_G1
,      BUCKET8_PDUE_AMT_G1
,      BUCKET9_PDUE_AMT_G1
,      BUCKET10_PDUE_AMT_G1
,      BUCKET1_PDUE_AMT_G1_C
,      BUCKET2_PDUE_AMT_G1_C
,      BUCKET3_PDUE_AMT_G1_C
,      BUCKET4_PDUE_AMT_G1_C
,      BUCKET5_PDUE_AMT_G1_C
,      BUCKET6_PDUE_AMT_G1_C
,      BUCKET7_PDUE_AMT_G1_C
,      BUCKET8_PDUE_AMT_G1_C
,      BUCKET9_PDUE_AMT_G1_C
,      BUCKET10_PDUE_AMT_G1_C
,      BUCKET1_LINE_CNT_P
,      BUCKET2_LINE_CNT_P
,      BUCKET3_LINE_CNT_P
,      BUCKET4_LINE_CNT_P
,      BUCKET5_LINE_CNT_P
,      BUCKET6_LINE_CNT_P
,      BUCKET7_LINE_CNT_P
,      BUCKET8_LINE_CNT_P
,      BUCKET9_LINE_CNT_P
,      BUCKET10_LINE_CNT_P
,      BUCKET1_LINE_CNT_P_C
,      BUCKET2_LINE_CNT_P_C
,      BUCKET3_LINE_CNT_P_C
,      BUCKET4_LINE_CNT_P_C
,      BUCKET5_LINE_CNT_P_C
,      BUCKET6_LINE_CNT_P_C
,      BUCKET7_LINE_CNT_P_C
,      BUCKET8_LINE_CNT_P_C
,      BUCKET9_LINE_CNT_P_C
,      BUCKET10_LINE_CNT_P_C
,      BUCKET1_DAYS_LATE_P
,      BUCKET2_DAYS_LATE_P
,      BUCKET3_DAYS_LATE_P
,      BUCKET4_DAYS_LATE_P
,      BUCKET5_DAYS_LATE_P
,      BUCKET6_DAYS_LATE_P
,      BUCKET7_DAYS_LATE_P
,      BUCKET8_DAYS_LATE_P
,      BUCKET9_DAYS_LATE_P
,      BUCKET10_DAYS_LATE_P
,      BUCKET1_DAYS_LATE_P_C
,      BUCKET2_DAYS_LATE_P_C
,      BUCKET3_DAYS_LATE_P_C
,      BUCKET4_DAYS_LATE_P_C
,      BUCKET5_DAYS_LATE_P_C
,      BUCKET6_DAYS_LATE_P_C
,      BUCKET7_DAYS_LATE_P_C
,      BUCKET8_DAYS_LATE_P_C
,      BUCKET9_DAYS_LATE_P_C
,      BUCKET10_DAYS_LATE_P_C
,      BUCKET1_QTY_P
,      BUCKET2_QTY_P
,      BUCKET3_QTY_P
,      BUCKET4_QTY_P
,      BUCKET5_QTY_P
,      BUCKET6_QTY_P
,      BUCKET7_QTY_P
,      BUCKET8_QTY_P
,      BUCKET9_QTY_P
,      BUCKET10_QTY_P
,      BUCKET1_QTY_P_C
,      BUCKET2_QTY_P_C
,      BUCKET3_QTY_P_C
,      BUCKET4_QTY_P_C
,      BUCKET5_QTY_P_C
,      BUCKET6_QTY_P_C
,      BUCKET7_QTY_P_C
,      BUCKET8_QTY_P_C
,      BUCKET9_QTY_P_C
,      BUCKET10_QTY_P_C
,      BUCKET1_PDUE_AMT_F_P
,      BUCKET2_PDUE_AMT_F_P
,      BUCKET3_PDUE_AMT_F_P
,      BUCKET4_PDUE_AMT_F_P
,      BUCKET5_PDUE_AMT_F_P
,      BUCKET6_PDUE_AMT_F_P
,      BUCKET7_PDUE_AMT_F_P
,      BUCKET8_PDUE_AMT_F_P
,      BUCKET9_PDUE_AMT_F_P
,      BUCKET10_PDUE_AMT_F_P
,      BUCKET1_PDUE_AMT_F_P_C
,      BUCKET2_PDUE_AMT_F_P_C
,      BUCKET3_PDUE_AMT_F_P_C
,      BUCKET4_PDUE_AMT_F_P_C
,      BUCKET5_PDUE_AMT_F_P_C
,      BUCKET6_PDUE_AMT_F_P_C
,      BUCKET7_PDUE_AMT_F_P_C
,      BUCKET8_PDUE_AMT_F_P_C
,      BUCKET9_PDUE_AMT_F_P_C
,      BUCKET10_PDUE_AMT_F_P_C
,      BUCKET1_PDUE_AMT_G_P
,      BUCKET2_PDUE_AMT_G_P
,      BUCKET3_PDUE_AMT_G_P
,      BUCKET4_PDUE_AMT_G_P
,      BUCKET5_PDUE_AMT_G_P
,      BUCKET6_PDUE_AMT_G_P
,      BUCKET7_PDUE_AMT_G_P
,      BUCKET8_PDUE_AMT_G_P
,      BUCKET9_PDUE_AMT_G_P
,      BUCKET10_PDUE_AMT_G_P
,      BUCKET1_PDUE_AMT_G_P_C
,      BUCKET2_PDUE_AMT_G_P_C
,      BUCKET3_PDUE_AMT_G_P_C
,      BUCKET4_PDUE_AMT_G_P_C
,      BUCKET5_PDUE_AMT_G_P_C
,      BUCKET6_PDUE_AMT_G_P_C
,      BUCKET7_PDUE_AMT_G_P_C
,      BUCKET8_PDUE_AMT_G_P_C
,      BUCKET9_PDUE_AMT_G_P_C
,      BUCKET10_PDUE_AMT_G_P_C
,      BUCKET1_PDUE_AMT_G1_P
,      BUCKET2_PDUE_AMT_G1_P
,      BUCKET3_PDUE_AMT_G1_P
,      BUCKET4_PDUE_AMT_G1_P
,      BUCKET5_PDUE_AMT_G1_P
,      BUCKET6_PDUE_AMT_G1_P
,      BUCKET7_PDUE_AMT_G1_P
,      BUCKET8_PDUE_AMT_G1_P
,      BUCKET9_PDUE_AMT_G1_P
,      BUCKET10_PDUE_AMT_G1_P
,      BUCKET1_PDUE_AMT_G1_P_C
,      BUCKET2_PDUE_AMT_G1_P_C
,      BUCKET3_PDUE_AMT_G1_P_C
,      BUCKET4_PDUE_AMT_G1_P_C
,      BUCKET5_PDUE_AMT_G1_P_C
,      BUCKET6_PDUE_AMT_G1_P_C
,      BUCKET7_PDUE_AMT_G1_P_C
,      BUCKET8_PDUE_AMT_G1_P_C
,      BUCKET9_PDUE_AMT_G1_P_C
,      BUCKET10_PDUE_AMT_G1_P_C
,      LINES_CNT
FROM APPS.ISC_DBI_CFM_008_MV;

Dependencies

[top of page]

APPS.ISC_DBI_CFM_008_MV references the following:

SchemaAPPS
TableISC_DBI_CFM_008_MV
TableISC_DBI_CFM_013_MV
Materialized ViewISC_DBI_CFM_013_MV
SchemaBIS
TableBIS_BUCKET
TableBIS_BUCKET_CUSTOMIZATIONS
APPS.ISC_DBI_CFM_008_MV is referenced by following:

SchemaAPPS
Materialized ViewISC_DBI_CFM_012_MV