[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ISC_DBI_CFM_012_MV |
|---|---|
| Object Type: | MATERIALIZED VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Container: | ISC_DBI_CFM_012_MV |
|---|---|
| Updatable: | N |
| Rewrite Enabled: | N |
| Rewrite Capability: | TEXTMATCH |
| Refresh Mode: | DEMAND |
| Refresh Method: | FAST |
| Build Mode: | DEFERRED |
| Fast Refreshable: | DIRLOAD_DML |
ENI_DENORM_HIERARCHIES
ISC_DBI_CFM_008_MV
BIS_BUCKET
BIS_BUCKET_CUSTOMIZATIONS
ISC_DBI_CFM_013_MV
ENI_OLTP_ITEM_STAR
ISC_BOOK_SUM2_PDUE2_F
MTL_DEFAULT_CATEGORY_SETS
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INV_ORG_ID | NUMBER | Inventory Organization Identifier | ||
| TOP_NODE_FLAG | VARCHAR2 | (1) | ||
| PARENT_ID | NUMBER | Product Category Identifier | ||
| IMM_CHILD_ID | NUMBER | |||
| TIME_SNAPSHOT_DATE_ID | DATE | Date on which the snapshot was taken | ||
| LATE_SCHEDULE_FLAG | NUMBER | Grouping ID Column for Past Due Schedule Order Lines | ||
| LATE_PROMISE_FLAG | NUMBER | Grouping ID Column for Past Due Promise Order Lines | ||
| GRP_ID | NUMBER | Grouping ID Column | ||
| UMARKER | NUMBER | |||
| DAYS_LATE | NUMBER | Count of Days Late (to schedule) | ||
| DAYS_LATE_CNT | NUMBER | Count Column | ||
| DAYS_LATE_PROMISE | NUMBER | Count of Days Late (to promise) | ||
| DAYS_LATE_PROMISE_CNT | NUMBER | Count Column | ||
| PDUE_LINE_CNT | NUMBER | Count of Past Due Lines | ||
| PDUE_LINE_CNT_C | NUMBER | Count Column | ||
| PDUE_AMT_F | NUMBER | Past Due amount in Functional currency | ||
| PDUE_AMT_F_CNT | NUMBER | Count Column | ||
| PDUE_AMT_G | NUMBER | Past Due amount in Global currency | ||
| PDUE_AMT_G_CNT | NUMBER | Count Column | ||
| PDUE_AMT_G1 | NUMBER | Past Due amount in Secondary Global currency | ||
| PDUE_AMT_G1_CNT | NUMBER | Count Column | ||
| PDUE_QTY | NUMBER | Past Due Quantity | ||
| PDUE_QTY_CNT | NUMBER | Count Column | ||
| BUCKET1_LINE_CNT | NUMBER | Count of Past Due Schedule Lines for Bucket1 | ||
| BUCKET2_LINE_CNT | NUMBER | Count of Past Due Schedule Lines for Bucket2 | ||
| BUCKET3_LINE_CNT | NUMBER | Count of Past Due Schedule Lines for Bucket3 | ||
| BUCKET4_LINE_CNT | NUMBER | Count of Past Due Schedule Lines for Bucket4 | ||
| BUCKET5_LINE_CNT | NUMBER | Count of Past Due Schedule Lines for Bucket5 | ||
| BUCKET6_LINE_CNT | NUMBER | Count of Past Due Schedule Lines for Bucket6 | ||
| BUCKET7_LINE_CNT | NUMBER | Count of Past Due Schedule Lines for Bucket7 | ||
| BUCKET8_LINE_CNT | NUMBER | Count of Past Due Schedule Lines for Bucket8 | ||
| BUCKET9_LINE_CNT | NUMBER | Count of Past Due Schedule Lines for Bucket9 | ||
| BUCKET10_LINE_CNT | NUMBER | Count of Past Due Schedule Lines for Bucket10 | ||
| BUCKET1_LINE_CNT_C | NUMBER | Count Column | ||
| BUCKET2_LINE_CNT_C | NUMBER | Count Column | ||
| BUCKET3_LINE_CNT_C | NUMBER | Count Column | ||
| BUCKET4_LINE_CNT_C | NUMBER | Count Column | ||
| BUCKET5_LINE_CNT_C | NUMBER | Count Column | ||
| BUCKET6_LINE_CNT_C | NUMBER | Count Column | ||
| BUCKET7_LINE_CNT_C | NUMBER | Count Column | ||
| BUCKET8_LINE_CNT_C | NUMBER | Count Column | ||
| BUCKET9_LINE_CNT_C | NUMBER | Count Column | ||
| BUCKET10_LINE_CNT_C | NUMBER | Count Column | ||
| BUCKET1_DAYS_LATE | NUMBER | Days Late Count for Bucket1 | ||
| BUCKET2_DAYS_LATE | NUMBER | Days Late Count for Bucket2 | ||
| BUCKET3_DAYS_LATE | NUMBER | Days Late Count for Bucket3 | ||
| BUCKET4_DAYS_LATE | NUMBER | Days Late Count for Bucket4 | ||
| BUCKET5_DAYS_LATE | NUMBER | Days Late Count for Bucket5 | ||
| BUCKET6_DAYS_LATE | NUMBER | Days Late Count for Bucket6 | ||
| BUCKET7_DAYS_LATE | NUMBER | Days Late Count for Bucket7 | ||
| BUCKET8_DAYS_LATE | NUMBER | Days Late Count for Bucket8 | ||
| BUCKET9_DAYS_LATE | NUMBER | Days Late Count for Bucket | ||
| BUCKET10_DAYS_LATE | NUMBER | Days Late Count for Bucket10 | ||
| BUCKET1_DAYS_LATE_C | NUMBER | Count Column | ||
| BUCKET2_DAYS_LATE_C | NUMBER | Count Column | ||
| BUCKET3_DAYS_LATE_C | NUMBER | Count Column | ||
| BUCKET4_DAYS_LATE_C | NUMBER | Count Column | ||
| BUCKET5_DAYS_LATE_C | NUMBER | Count Column | ||
| BUCKET6_DAYS_LATE_C | NUMBER | Count Column | ||
| BUCKET7_DAYS_LATE_C | NUMBER | Count Column | ||
| BUCKET8_DAYS_LATE_C | NUMBER | Count Column | ||
| BUCKET9_DAYS_LATE_C | NUMBER | Count Column | ||
| BUCKET10_DAYS_LATE_C | NUMBER | Count Column | ||
| BUCKET1_QTY | NUMBER | Past Due Schedule Quantity for Bucket1 | ||
| BUCKET2_QTY | NUMBER | Past Due Schedule Quantity for Bucket2 | ||
| BUCKET3_QTY | NUMBER | Past Due Schedule Quantity for Bucket3 | ||
| BUCKET4_QTY | NUMBER | Past Due Schedule Quantity for Bucket4 | ||
| BUCKET5_QTY | NUMBER | Past Due Schedule Quantity for Bucket5 | ||
| BUCKET6_QTY | NUMBER | Past Due Schedule Quantity for Bucket6 | ||
| BUCKET7_QTY | NUMBER | Past Due Schedule Quantity for Bucket7 | ||
| BUCKET8_QTY | NUMBER | Past Due Schedule Quantity for Bucket8 | ||
| BUCKET9_QTY | NUMBER | Past Due Schedule Quantity for Bucket9 | ||
| BUCKET10_QTY | NUMBER | Past Due Schedule Quantity for Bucket10 | ||
| BUCKET1_QTY_C | NUMBER | Count Column | ||
| BUCKET2_QTY_C | NUMBER | Count Column | ||
| BUCKET3_QTY_C | NUMBER | Count Column | ||
| BUCKET4_QTY_C | NUMBER | Count Column | ||
| BUCKET5_QTY_C | NUMBER | Count Column | ||
| BUCKET6_QTY_C | NUMBER | Count Column | ||
| BUCKET7_QTY_C | NUMBER | Count Column | ||
| BUCKET8_QTY_C | NUMBER | Count Column | ||
| BUCKET9_QTY_C | NUMBER | Count Column | ||
| BUCKET10_QTY_C | NUMBER | Count Column | ||
| BUCKET1_PDUE_AMT_F | NUMBER | Past Due Schedule amount in Functional currency for Bucket1 | ||
| BUCKET2_PDUE_AMT_F | NUMBER | Past Due Schedule amount in Functional currency for Bucket2 | ||
| BUCKET3_PDUE_AMT_F | NUMBER | Past Due Schedule amount in Functional currency for Bucket3 | ||
| BUCKET4_PDUE_AMT_F | NUMBER | Past Due Schedule amount in Functional currency for Bucket4 | ||
| BUCKET5_PDUE_AMT_F | NUMBER | Past Due Schedule amount in Functional currency for Bucket5 | ||
| BUCKET6_PDUE_AMT_F | NUMBER | Past Due Schedule amount in Functional currency for Bucket6 | ||
| BUCKET7_PDUE_AMT_F | NUMBER | Past Due Schedule amount in Functional currency for Bucket7 | ||
| BUCKET8_PDUE_AMT_F | NUMBER | Past Due Schedule amount in Functional currency for Bucket8 | ||
| BUCKET9_PDUE_AMT_F | NUMBER | Past Due Schedule amount in Functional currency for Bucket9 | ||
| BUCKET10_PDUE_AMT_F | NUMBER | Past Due Schedule amount in Functional currency for Bucket10 | ||
| BUCKET1_PDUE_AMT_F_C | NUMBER | Count Column | ||
| BUCKET2_PDUE_AMT_F_C | NUMBER | Count Column | ||
| BUCKET3_PDUE_AMT_F_C | NUMBER | Count Column | ||
| BUCKET4_PDUE_AMT_F_C | NUMBER | Count Column | ||
| BUCKET5_PDUE_AMT_F_C | NUMBER | Count Column | ||
| BUCKET6_PDUE_AMT_F_C | NUMBER | Count Column | ||
| BUCKET7_PDUE_AMT_F_C | NUMBER | Count Column | ||
| BUCKET8_PDUE_AMT_F_C | NUMBER | Count Column | ||
| BUCKET9_PDUE_AMT_F_C | NUMBER | Count Column | ||
| BUCKET10_PDUE_AMT_F_C | NUMBER | Count Column | ||
| BUCKET1_PDUE_AMT_G | NUMBER | Past Due Schedule amount in Global currency for Bucket1 | ||
| BUCKET2_PDUE_AMT_G | NUMBER | Past Due Schedule amount in Global currency for Bucket2 | ||
| BUCKET3_PDUE_AMT_G | NUMBER | Past Due Schedule amount in Global currency for Bucket3 | ||
| BUCKET4_PDUE_AMT_G | NUMBER | Past Due Schedule amount in Global currency for Bucket4 | ||
| BUCKET5_PDUE_AMT_G | NUMBER | Past Due Schedule amount in Global currency for Bucket5 | ||
| BUCKET6_PDUE_AMT_G | NUMBER | Past Due Schedule amount in Global currency for Bucket6 | ||
| BUCKET7_PDUE_AMT_G | NUMBER | Past Due Schedule amount in Global currency for Bucket7 | ||
| BUCKET8_PDUE_AMT_G | NUMBER | Past Due Schedule amount in Global currency for Bucket8 | ||
| BUCKET9_PDUE_AMT_G | NUMBER | Past Due Schedule amount in Global currency for Bucket9 | ||
| BUCKET10_PDUE_AMT_G | NUMBER | Past Due Schedule amount in Global currency for Bucket10 | ||
| BUCKET1_PDUE_AMT_G_C | NUMBER | Count Column | ||
| BUCKET2_PDUE_AMT_G_C | NUMBER | Count Column | ||
| BUCKET3_PDUE_AMT_G_C | NUMBER | Count Column | ||
| BUCKET4_PDUE_AMT_G_C | NUMBER | Count Column | ||
| BUCKET5_PDUE_AMT_G_C | NUMBER | Count Column | ||
| BUCKET6_PDUE_AMT_G_C | NUMBER | Count Column | ||
| BUCKET7_PDUE_AMT_G_C | NUMBER | Count Column | ||
| BUCKET8_PDUE_AMT_G_C | NUMBER | Count Column | ||
| BUCKET9_PDUE_AMT_G_C | NUMBER | Count Column | ||
| BUCKET10_PDUE_AMT_G_C | NUMBER | Count Column | ||
| BUCKET1_PDUE_AMT_G1 | NUMBER | Past Due Schedule amount in Secondary Global currency for Bucket1 | ||
| BUCKET2_PDUE_AMT_G1 | NUMBER | Past Due Schedule amount in Secondary Global currency for Bucket2 | ||
| BUCKET3_PDUE_AMT_G1 | NUMBER | Past Due Schedule amount in Secondary Global currency for Bucket3 | ||
| BUCKET4_PDUE_AMT_G1 | NUMBER | Past Due Schedule amount in Secondary Global currency for Bucket4 | ||
| BUCKET5_PDUE_AMT_G1 | NUMBER | Past Due Schedule amount in Secondary Global currency for Bucket5 | ||
| BUCKET6_PDUE_AMT_G1 | NUMBER | Past Due Schedule amount in Secondary Global currency for Bucket6 | ||
| BUCKET7_PDUE_AMT_G1 | NUMBER | Past Due Schedule amount in Secondary Global currency for Bucket7 | ||
| BUCKET8_PDUE_AMT_G1 | NUMBER | Past Due Schedule amount in Secondary Global currency for Bucket8 | ||
| BUCKET9_PDUE_AMT_G1 | NUMBER | Past Due Schedule amount in Secondary Global currency for Bucket9 | ||
| BUCKET10_PDUE_AMT_G1 | NUMBER | Past Due Schedule amount in Secondary Global currency for Bucket10 | ||
| BUCKET1_PDUE_AMT_G1_C | NUMBER | Count Column | ||
| BUCKET2_PDUE_AMT_G1_C | NUMBER | Count Column | ||
| BUCKET3_PDUE_AMT_G1_C | NUMBER | Count Column | ||
| BUCKET4_PDUE_AMT_G1_C | NUMBER | Count Column | ||
| BUCKET5_PDUE_AMT_G1_C | NUMBER | Count Column | ||
| BUCKET6_PDUE_AMT_G1_C | NUMBER | Count Column | ||
| BUCKET7_PDUE_AMT_G1_C | NUMBER | Count Column | ||
| BUCKET8_PDUE_AMT_G1_C | NUMBER | Count Column | ||
| BUCKET9_PDUE_AMT_G1_C | NUMBER | Count Column | ||
| BUCKET10_PDUE_AMT_G1_C | NUMBER | Count Column | ||
| BUCKET1_LINE_CNT_P | NUMBER | Count of Past Due Promise Lines for Bucket1 | ||
| BUCKET2_LINE_CNT_P | NUMBER | Count of Past Due Promise Lines for Bucket2 | ||
| BUCKET3_LINE_CNT_P | NUMBER | Count of Past Due Promise Lines for Bucket3 | ||
| BUCKET4_LINE_CNT_P | NUMBER | Count of Past Due Promise Lines for Bucket4 | ||
| BUCKET5_LINE_CNT_P | NUMBER | Count of Past Due Promise Lines for Bucket5 | ||
| BUCKET6_LINE_CNT_P | NUMBER | Count of Past Due Promise Lines for Bucket6 | ||
| BUCKET7_LINE_CNT_P | NUMBER | Count of Past Due Promise Lines for Bucket7 | ||
| BUCKET8_LINE_CNT_P | NUMBER | Count of Past Due Promise Lines for Bucket8 | ||
| BUCKET9_LINE_CNT_P | NUMBER | Count of Past Due Promise Lines for Bucket9 | ||
| BUCKET10_LINE_CNT_P | NUMBER | Count of Past Due Promise Lines for Bucket10 | ||
| BUCKET1_LINE_CNT_P_C | NUMBER | Count Column | ||
| BUCKET2_LINE_CNT_P_C | NUMBER | Count Column | ||
| BUCKET3_LINE_CNT_P_C | NUMBER | Count Column | ||
| BUCKET4_LINE_CNT_P_C | NUMBER | Count Column | ||
| BUCKET5_LINE_CNT_P_C | NUMBER | Count Column | ||
| BUCKET6_LINE_CNT_P_C | NUMBER | Count Column | ||
| BUCKET7_LINE_CNT_P_C | NUMBER | Count Column | ||
| BUCKET8_LINE_CNT_P_C | NUMBER | Count Column | ||
| BUCKET9_LINE_CNT_P_C | NUMBER | Count Column | ||
| BUCKET10_LINE_CNT_P_C | NUMBER | Count Column | ||
| BUCKET1_DAYS_LATE_P | NUMBER | Days Late (to promise) Count for Bucket1 | ||
| BUCKET2_DAYS_LATE_P | NUMBER | Days Late (to promise) Count for Bucket2 | ||
| BUCKET3_DAYS_LATE_P | NUMBER | Days Late (to promise) Count for Bucket3 | ||
| BUCKET4_DAYS_LATE_P | NUMBER | Days Late (to promise) Count for Bucket4 | ||
| BUCKET5_DAYS_LATE_P | NUMBER | Days Late (to promise) Count for Bucket5 | ||
| BUCKET6_DAYS_LATE_P | NUMBER | Days Late (to promise) Count for Bucket6 | ||
| BUCKET7_DAYS_LATE_P | NUMBER | Days Late (to promise) Count for Bucket7 | ||
| BUCKET8_DAYS_LATE_P | NUMBER | Days Late (to promise) Count for Bucket8 | ||
| BUCKET9_DAYS_LATE_P | NUMBER | Days Late (to promise) Count for Bucket9 | ||
| BUCKET10_DAYS_LATE_P | NUMBER | Days Late (to promise) Count for Bucket10 | ||
| BUCKET1_DAYS_LATE_P_C | NUMBER | Count Column | ||
| BUCKET2_DAYS_LATE_P_C | NUMBER | Count Column | ||
| BUCKET3_DAYS_LATE_P_C | NUMBER | Count Column | ||
| BUCKET4_DAYS_LATE_P_C | NUMBER | Count Column | ||
| BUCKET5_DAYS_LATE_P_C | NUMBER | Count Column | ||
| BUCKET6_DAYS_LATE_P_C | NUMBER | Count Column | ||
| BUCKET7_DAYS_LATE_P_C | NUMBER | Count Column | ||
| BUCKET8_DAYS_LATE_P_C | NUMBER | Count Column | ||
| BUCKET9_DAYS_LATE_P_C | NUMBER | Count Column | ||
| BUCKET10_DAYS_LATE_P_C | NUMBER | Count Column | ||
| BUCKET1_QTY_P | NUMBER | Past Due Promise Quantity for Bucket1 | ||
| BUCKET2_QTY_P | NUMBER | Past Due Promise Quantity for Bucket2 | ||
| BUCKET3_QTY_P | NUMBER | Past Due Promise Quantity for Bucket3 | ||
| BUCKET4_QTY_P | NUMBER | Past Due Promise Quantity for Bucket4 | ||
| BUCKET5_QTY_P | NUMBER | Past Due Promise Quantity for Bucket5 | ||
| BUCKET6_QTY_P | NUMBER | Past Due Promise Quantity for Bucket6 | ||
| BUCKET7_QTY_P | NUMBER | Past Due Promise Quantity for Bucket7 | ||
| BUCKET8_QTY_P | NUMBER | Past Due Promise Quantity for Bucket8 | ||
| BUCKET9_QTY_P | NUMBER | Past Due Promise Quantity for Bucket9 | ||
| BUCKET10_QTY_P | NUMBER | Past Due Promise Quantity for Bucket10 | ||
| BUCKET1_QTY_P_C | NUMBER | Count Column | ||
| BUCKET2_QTY_P_C | NUMBER | Count Column | ||
| BUCKET3_QTY_P_C | NUMBER | Count Column | ||
| BUCKET4_QTY_P_C | NUMBER | Count Column | ||
| BUCKET5_QTY_P_C | NUMBER | Count Column | ||
| BUCKET6_QTY_P_C | NUMBER | Count Column | ||
| BUCKET7_QTY_P_C | NUMBER | Count Column | ||
| BUCKET8_QTY_P_C | NUMBER | Count Column | ||
| BUCKET9_QTY_P_C | NUMBER | Count Column | ||
| BUCKET10_QTY_P_C | NUMBER | Count Column | ||
| BUCKET1_PDUE_AMT_F_P | NUMBER | Past Due Promise amount in Functional currency for Bucket1 | ||
| BUCKET2_PDUE_AMT_F_P | NUMBER | Past Due Promise amount in Functional currency for Bucket2 | ||
| BUCKET3_PDUE_AMT_F_P | NUMBER | Past Due Promise amount in Functional currency for Bucket3 | ||
| BUCKET4_PDUE_AMT_F_P | NUMBER | Past Due Promise amount in Functional currency for Bucket4 | ||
| BUCKET5_PDUE_AMT_F_P | NUMBER | Past Due Promise amount in Functional currency for Bucket5 | ||
| BUCKET6_PDUE_AMT_F_P | NUMBER | Past Due Promise amount in Functional currency for Bucket6 | ||
| BUCKET7_PDUE_AMT_F_P | NUMBER | Past Due Promise amount in Functional currency for Bucket7 | ||
| BUCKET8_PDUE_AMT_F_P | NUMBER | Past Due Promise amount in Functional currency for Bucket8 | ||
| BUCKET9_PDUE_AMT_F_P | NUMBER | Past Due Promise amount in Functional currency for Bucket9 | ||
| BUCKET10_PDUE_AMT_F_P | NUMBER | Past Due Promise amount in Functional currency for Bucket10 | ||
| BUCKET1_PDUE_AMT_F_P_C | NUMBER | Count Column | ||
| BUCKET2_PDUE_AMT_F_P_C | NUMBER | Count Column | ||
| BUCKET3_PDUE_AMT_F_P_C | NUMBER | Count Column | ||
| BUCKET4_PDUE_AMT_F_P_C | NUMBER | Count Column | ||
| BUCKET5_PDUE_AMT_F_P_C | NUMBER | Count Column | ||
| BUCKET6_PDUE_AMT_F_P_C | NUMBER | Count Column | ||
| BUCKET7_PDUE_AMT_F_P_C | NUMBER | Count Column | ||
| BUCKET8_PDUE_AMT_F_P_C | NUMBER | Count Column | ||
| BUCKET9_PDUE_AMT_F_P_C | NUMBER | Count Column | ||
| BUCKET10_PDUE_AMT_F_P_C | NUMBER | Count Column | ||
| BUCKET1_PDUE_AMT_G_P | NUMBER | Past Due Promise amount in Global currency for Bucket1 | ||
| BUCKET2_PDUE_AMT_G_P | NUMBER | Past Due Promise amount in Global currency for Bucket2 | ||
| BUCKET3_PDUE_AMT_G_P | NUMBER | Past Due Promise amount in Global currency for Bucket3 | ||
| BUCKET4_PDUE_AMT_G_P | NUMBER | Past Due Promise amount in Global currency for Bucket4 | ||
| BUCKET5_PDUE_AMT_G_P | NUMBER | Past Due Promise amount in Global currency for Bucket5 | ||
| BUCKET6_PDUE_AMT_G_P | NUMBER | Past Due Promise amount in Global currency for Bucket6 | ||
| BUCKET7_PDUE_AMT_G_P | NUMBER | Past Due Promise amount in Global currency for Bucket7 | ||
| BUCKET8_PDUE_AMT_G_P | NUMBER | Past Due Promise amount in Global currency for Bucket8 | ||
| BUCKET9_PDUE_AMT_G_P | NUMBER | Past Due Promise amount in Global currency for Bucket9 | ||
| BUCKET10_PDUE_AMT_G_P | NUMBER | Past Due Promise amount in Global currency for Bucket10 | ||
| BUCKET1_PDUE_AMT_G_P_C | NUMBER | Count Column | ||
| BUCKET2_PDUE_AMT_G_P_C | NUMBER | Count Column | ||
| BUCKET3_PDUE_AMT_G_P_C | NUMBER | Count Column | ||
| BUCKET4_PDUE_AMT_G_P_C | NUMBER | Count Column | ||
| BUCKET5_PDUE_AMT_G_P_C | NUMBER | Count Column | ||
| BUCKET6_PDUE_AMT_G_P_C | NUMBER | Count Column | ||
| BUCKET7_PDUE_AMT_G_P_C | NUMBER | Count Column | ||
| BUCKET8_PDUE_AMT_G_P_C | NUMBER | Count Column | ||
| BUCKET9_PDUE_AMT_G_P_C | NUMBER | Count Column | ||
| BUCKET10_PDUE_AMT_G_P_C | NUMBER | Count Column | ||
| BUCKET1_PDUE_AMT_G1_P | NUMBER | Past Due Promise amount in Secondary Global currency for Bucket1 | ||
| BUCKET2_PDUE_AMT_G1_P | NUMBER | Past Due Promise amount in Secondary Global currency for Bucket2 | ||
| BUCKET3_PDUE_AMT_G1_P | NUMBER | Past Due Promise amount in Secondary Global currency for Bucket3 | ||
| BUCKET4_PDUE_AMT_G1_P | NUMBER | Past Due Promise amount in Secondary Global currency for Bucket4 | ||
| BUCKET5_PDUE_AMT_G1_P | NUMBER | Past Due Promise amount in Secondary Global currency for Bucket5 | ||
| BUCKET6_PDUE_AMT_G1_P | NUMBER | Past Due Promise amount in Secondary Global currency for Bucket6 | ||
| BUCKET7_PDUE_AMT_G1_P | NUMBER | Past Due Promise amount in Secondary Global currency for Bucket7 | ||
| BUCKET8_PDUE_AMT_G1_P | NUMBER | Past Due Promise amount in Secondary Global currency for Bucket8 | ||
| BUCKET9_PDUE_AMT_G1_P | NUMBER | Past Due Promise amount in Secondary Global currency for Bucket9 | ||
| BUCKET10_PDUE_AMT_G1_P | NUMBER | Past Due Promise amount in Secondary Global currency for Bucket10 | ||
| BUCKET1_PDUE_AMT_G1_P_C | NUMBER | Count Column | ||
| BUCKET2_PDUE_AMT_G1_P_C | NUMBER | Count Column | ||
| BUCKET3_PDUE_AMT_G1_P_C | NUMBER | Count Column | ||
| BUCKET4_PDUE_AMT_G1_P_C | NUMBER | Count Column | ||
| BUCKET5_PDUE_AMT_G1_P_C | NUMBER | Count Column | ||
| BUCKET6_PDUE_AMT_G1_P_C | NUMBER | Count Column | ||
| BUCKET7_PDUE_AMT_G1_P_C | NUMBER | Count Column | ||
| BUCKET8_PDUE_AMT_G1_P_C | NUMBER | Count Column | ||
| BUCKET9_PDUE_AMT_G1_P_C | NUMBER | Count Column | ||
| BUCKET10_PDUE_AMT_G1_P_C | NUMBER | Count Column | ||
| CNT | NUMBER | Row Count |
Cut, paste (and edit) the following text to query this object:
SELECT INV_ORG_ID
, TOP_NODE_FLAG
, PARENT_ID
, IMM_CHILD_ID
, TIME_SNAPSHOT_DATE_ID
, LATE_SCHEDULE_FLAG
, LATE_PROMISE_FLAG
, GRP_ID
, UMARKER
, 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
, CNT
FROM APPS.ISC_DBI_CFM_012_MV;
APPS
ISC_DBI_CFM_008_MV
ISC_DBI_CFM_008_MV
ISC_DBI_CFM_012_MV
ENI
ENI_DENORM_HIERARCHIES
INV
MTL_DEFAULT_CATEGORY_SETS
APPS.ISC_DBI_CFM_012_MV is not referenced by any database object
|
|
|
|