Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - ISC Tables and Views

TABLE - ISC.EDW_MRP_DCDM_DM_LSTG
TABLE - ISC.EDW_MRP_DCDM_DM_LTC
TABLE - ISC.EDW_MRP_DM_CLS_A_LTC
TABLE - ISC.EDW_MRP_DM_CLS_M
TABLE - ISC.EDW_MRP_FCDM_FCS_LSTG
TABLE - ISC.EDW_MRP_FCDM_FCS_LTC
TABLE - ISC.EDW_MRP_FCDM_SET_LSTG
TABLE - ISC.EDW_MRP_FCDM_SET_LTC
TABLE - ISC.EDW_MRP_FORECAST_M
TABLE - ISC.EDW_MRP_PLAN_M
TABLE - ISC.EDW_MRP_PNDM_PLN_LSTG
TABLE - ISC.EDW_MRP_PNDM_PLN_LTC
TABLE - ISC.EDW_OE_SCHN_SCHN_LSTG
TABLE - ISC.EDW_OE_SCHN_SCHN_LTC
TABLE - ISC.EDW_OE_SLCHNL_A_LTC
TABLE - ISC.EDW_OE_SLCHNL_M
TABLE - APPS.ISC_DBI_CFM_008_MV
TABLE - APPS.ISC_DBI_CFM_012_MV
TABLE - APPS.ISC_DBI_CPM_001_MV
TABLE - APPS.ISC_DBI_CPM_002_MV
TABLE - APPS.ISC_DBI_CPM_003_MV
TABLE - APPS.ISC_DBI_CPM_004_MV
TABLE - APPS.ISC_DBI_CPM_005_MV
TABLE - ISC.ISC_DBI_DEMANDS_F
TABLE - ISC.ISC_DBI_EXCEPTION_DETAILS_F
TABLE - APPS.ISC_DBI_FM_0001_MV
TABLE - APPS.ISC_DBI_FM_0003_MV
TABLE - APPS.ISC_DBI_FM_0006_MV
TABLE - APPS.ISC_DBI_FM_0007_MV
TABLE - APPS.ISC_DBI_FM_0008_MV
TABLE - ISC.ISC_DBI_FULL_PEGGING_F
TABLE - ISC.ISC_DBI_INV_DETAIL_F
TABLE - ISC.ISC_DBI_INV_DETAIL_SNAPSHOTS
TABLE - APPS.ISC_DBI_PM_0000_MV
TABLE - APPS.ISC_DBI_PM_0001_MV
TABLE - APPS.ISC_DBI_PM_0002_MV
TABLE - APPS.ISC_DBI_PM_0003_MV
TABLE - APPS.ISC_DBI_PM_0004_MV
TABLE - ISC.ISC_DBI_RES_SUMMARY_F
TABLE - ISC.ISC_DBI_RES_SUM_SNAPSHOTS
TABLE - ISC.ISC_DBI_SHORTFALL_SNAPSHOTS
TABLE - ISC.ISC_DBI_SUPPLIES_F
TABLE - ISC.ISC_DBI_SUPPLIES_SNAPSHOTS
TABLE - ISC.ISC_EDW_BACKLOGS_F
TABLE - ISC.ISC_EDW_BACKLOGS_FSTG
TABLE - ISC.ISC_EDW_BOOKINGS_F
TABLE - ISC.ISC_EDW_BOOKINGS_FSTG
TABLE - ISC.ISC_EDW_BOOKINGS_F_DLOG
TABLE - ISC.ISC_EDW_BOOK_SUM1_F
TABLE - ISC.ISC_EDW_BOOK_SUM1_FSTG
TABLE - ISC.ISC_TMP_BACK
TABLE - ISC.ISC_TMP_BOOK_SUM1
TABLE - ISC.ISC_TMP_PK
VIEW - APPS.EDW_DEMAND_CLASS_FKV
VIEW - APPS.EDW_FORECAST_FKV
VIEW - APPS.EDW_MRP_DCDM_DM_LCV
VIEW - APPS.EDW_MRP_FCDM_FCS_LCV
VIEW - APPS.EDW_MRP_FCDM_SET_LCV
VIEW - APPS.EDW_MRP_PNDM_PLN_LCV
VIEW - APPS.EDW_OE_SCHN_SCHN_LCV
VIEW - APPS.EDW_PLAN_NAME_FKV
VIEW - APPS.EDW_SALES_CHANNEL_FKV
VIEW - APPS.ISCBV_BACKLOGS_FCV
VIEW - APPS.ISCBV_BOOKINGS_BASE_FCV
VIEW - APPS.ISCBV_EDW_BOOK_SUM1_BASE_FCV
VIEW - APPS.ISCBV_EDW_BOOK_SUM1_FCV
VIEW - APPS.ISC_EDW_BACKLOGS_F_FCV
VIEW - APPS.ISC_EDW_BACKLOG_S
VIEW - APPS.ISC_EDW_BOOKINGS_BILLINGS_S
VIEW - APPS.ISC_EDW_BOOKINGS_F_FCV
VIEW - APPS.ISC_EDW_BOOK_FULFILL_CYCLE_S
VIEW - APPS.ISC_EDW_BOOK_SUM1_F_FCV
VIEW - APPS.ISC_EDW_BOOK_TO_SHIP_CYCLE_S
VIEW - APPS.ISC_EDW_ORDER_ENTRY_S
VIEW - APPS.ISC_EDW_ORDER_FULFILL_SHIP_S
VIEW - APPS.ISC_EDW_ORDER_FULFILL_VOLUME_S
VIEW - APPS.ISC_EDW_ORDER_SHIP_VOLUME_S
VIEW - APPS.ISC_EDW_ORD_RECV_PAY_CYCLE_S
VIEW - APPS.ISC_EDW_PICK_TO_SHIP_CYCLE_S
VIEW - APPS.ISC_EDW_RECEIVE_PAY_CYCLE_S
VIEW - APPS.ISC_OPI_IND_CR_TAB_BASE_V
VIEW - APPS.ISC_OPI_IND_CR_TAB_S
VIEW - APPS.ISC_OPI_IND_QTD_S
VIEW - APPS.ISC_OPI_IND_WK_S
VIEW - APPS.ISC_OPI_TOP_ORD_QTD_BASE_V
VIEW - APPS.ISC_OPI_TOP_ORD_QTD_S
VIEW - APPS.ISC_OPI_TOP_ORD_WK_BASE_V
VIEW - APPS.ISC_OPI_TOP_ORD_WK_S
VIEW - APPS.ISC_RISK_INDICATORS_S
VIEW - APPS.ISC_RISK_SHIP_DLQT_S

Table: EDW_MRP_DCDM_DM_LSTG

Description: Interface table for Demand Class level
Comments

This is the interface table for the Demand Class level table. Data from multiple transactional systems is staged here for verification and cleansing, before it is loaded into the Dimension level table.

Indexes
Index Type Tablespace Column
EDW_MRP_DCDM_DM_LSTG_N1 NONUNIQUE APPS_TS_INTERFACE DEMAND_CLASS_PK
EDW_MRP_DCDM_DM_LSTG_N2 NONUNIQUE APPS_TS_INTERFACE COLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
DEMAND_CLASS_PK VARCHAR2 (80)
Unique identifier
ALL_FK VARCHAR2 (40)
Foreign key to the top level of the Demand Class dimension
ALL_FK_KEY NUMBER

System generated foreign key to the top level of the Demand Class dimension
COLLECTION_STATUS VARCHAR2 (30)
Collection status code for the record
DEMAND_CLASS VARCHAR2 (80)
Demand Class
DEMAND_CLASS_DP VARCHAR2 (240)
Unique Demand Class name
DESCRIPTION VARCHAR2 (240)
Demand Class description
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
INSTANCE_CODE VARCHAR2 (40)
Instance code referring to the source application
NAME VARCHAR2 (2000)
Alternate Demand Class name
OPERATION_CODE VARCHAR2 (30)
Code used by the collection program to determine whether to insert/update/delete this record
REQUEST_ID NUMBER

Identifier used by collection program
ROW_ID ROWID (10)
Row Id
USER_ATTRIBUTE1 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User attribute

[top of page]

ISC.EDW_MRP_DCDM_DM_LSTG does not reference any database object

ISC.EDW_MRP_DCDM_DM_LSTG is referenced by following:

APPS
SYNONYM - EDW_MRP_DCDM_DM_LSTG

[top of page]

Table: EDW_MRP_DCDM_DM_LTC

Description: Demand Class level table
Comments

This is the Demand Class level table in the Demand Class dimension. The Demand Class dimension has a single level, that stores all of the Demand Classes.

Indexes
Index Type Tablespace Column
EDW_MRP_DCDM_DM_LTC_U1 UNIQUE APPS_TS_SUMMARY DEMAND_CLASS_PK_KEY
EDW_MRP_DCDM_DM_LTC_U2 UNIQUE APPS_TS_SUMMARY DEMAND_CLASS_PK
DEMAND_CLASS_PK_KEY
EDW_MRP_DCDM_DM_LTC_N1 NONUNIQUE APPS_TS_SUMMARY ALL_FK_KEY
Columns
Name Datatype Length Mandatory Comments
DEMAND_CLASS_PK VARCHAR2 (80)
Unique identifier
DEMAND_CLASS_PK_KEY NUMBER

System generated unique identifier
ALL_FK VARCHAR2 (80)
Foreign key to the top level of the Demand Class dimension
ALL_FK_KEY NUMBER

System generated foreign key to the top level of the Demand Class dimension
CREATION_DATE DATE
Y Standard Who column
DEMAND_CLASS VARCHAR2 (80)
Demand Class
DEMAND_CLASS_DP VARCHAR2 (240)
Unique Demand Class name
DESCRIPTION VARCHAR2 (240)
Demand Class description
INSTANCE_CODE VARCHAR2 (40)
Instance code refering to the source application
LAST_UPDATE_DATE DATE
Y Standard Who column
NAME VARCHAR2 (2000)
Alternate Demand Class name
USER_ATTRIBUTE1 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User attribute

[top of page]

ISC.EDW_MRP_DCDM_DM_LTC does not reference any database object

ISC.EDW_MRP_DCDM_DM_LTC is referenced by following:

APPS
SYNONYM - EDW_MRP_DCDM_DM_LTC

[top of page]

Table: EDW_MRP_DM_CLS_A_LTC

Description: Top level table for the Demand Class dimension
Comments

This is the top level table for the Demand Class dimension.

Indexes
Index Type Tablespace Column
EDW_MRP_DM_CLS_A_LTC_U1 UNIQUE APPS_TS_SUMMARY ALL_PK_KEY
EDW_MRP_DM_CLS_A_LTC_U2 UNIQUE APPS_TS_SUMMARY ALL_PK
ALL_PK_KEY
Columns
Name Datatype Length Mandatory Comments
ALL_PK VARCHAR2 (40)
Unique identifier
ALL_PK_KEY NUMBER

System generated unique identifier
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
NAME VARCHAR2 (80)
All Demand Classes name

[top of page]

ISC.EDW_MRP_DM_CLS_A_LTC does not reference any database object

ISC.EDW_MRP_DM_CLS_A_LTC is referenced by following:

APPS
SYNONYM - EDW_MRP_DM_CLS_A_LTC

[top of page]

Table: EDW_MRP_DM_CLS_M

Description: Demand Class dimension
Comments

This is the denormalized star table for the Demand Class dimension. It contains records for the lowest level of the Demand Class dimension and their parentage up to the top level of the dimension, across all hierarchies.

Indexes
Index Type Tablespace Column
EDW_MRP_DM_CLS_M_U1 UNIQUE APPS_TS_SUMMARY DCLS_DEMAND_CLASS_PK
DCLS_DEMAND_CLASS_PK_KEY
EDW_MRP_DM_CLS_M_U2 UNIQUE APPS_TS_SUMMARY DCLS_DEMAND_CLASS_PK_KEY
Columns
Name Datatype Length Mandatory Comments
DCLS_DEMAND_CLASS_PK VARCHAR2 (80)
Unique Identifier
DCLS_DEMAND_CLASS_PK_KEY NUMBER
Y System generated unique Identifier
L0_ALL_PK VARCHAR2 (40)
Unique identifier for the top level of the Demand Class dimension
L0_ALL_PK_KEY NUMBER

System generated unique identifier for the top level of the Demand Class dimension
CREATION_DATE DATE
Y Standard Who column
DCLS_DEMAND_CLASS VARCHAR2 (80)
Demand Class
DCLS_DEMAND_CLASS_DP VARCHAR2 (240)
Unique Demand Class name
DCLS_DESCRIPTION VARCHAR2 (240)
Demand Class description
DCLS_INSTANCE_CODE VARCHAR2 (40)
Instance code refering to the source application
DCLS_NAME VARCHAR2 (80)
Demand Class name
DCLS_USER_ATTRIBUTE1 VARCHAR2 (240)
User attribute
DCLS_USER_ATTRIBUTE2 VARCHAR2 (240)
User attribute
DCLS_USER_ATTRIBUTE3 VARCHAR2 (240)
User attribute
DCLS_USER_ATTRIBUTE4 VARCHAR2 (240)
User attribute
DCLS_USER_ATTRIBUTE5 VARCHAR2 (240)
User attribute
L0_NAME VARCHAR2 (240)
Top level name
LAST_UPDATE_DATE DATE
Y Standard Who column

[top of page]

ISC.EDW_MRP_DM_CLS_M does not reference any database object

ISC.EDW_MRP_DM_CLS_M is referenced by following:

APPS
SYNONYM - EDW_MRP_DM_CLS_M

[top of page]

Table: EDW_MRP_FCDM_FCS_LSTG

Description: Interface table for Forecast level
Comments

This is the interface table for the Forecast level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the dimension level table.

Indexes
Index Type Tablespace Column
EDW_MRP_FCDM_FCS_LSTG_N1 NONUNIQUE APPS_TS_INTERFACE FORECAST_PK
EDW_MRP_FCDM_FCS_LSTG_N2 NONUNIQUE APPS_TS_INTERFACE COLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
FORECAST_PK VARCHAR2 (40)
Unique identifier
FORECAST_SET_FK VARCHAR2 (40)
Foreign key to the Forecast Set level
FORECAST_SET_FK_KEY NUMBER

System generated foreign key to the Forecast Set level
COLLECTION_STATUS VARCHAR2 (30)
Collection status code for the record
DESCRIPTION VARCHAR2 (240)
Forecast description
DISABLE_DATE DATE

Date on which that Forecast was disabled
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
FORECAST_DP VARCHAR2 (240)
Unique Forecast name
FORECAST_NAME VARCHAR2 (80)
Forecast name
INSTANCE_CODE VARCHAR2 (40)
Instance code refering to the source application
NAME VARCHAR2 (2000)
Alternate Forecast name
OPERATION_CODE VARCHAR2 (30)
Code used by the collection program to determine whether to insert/update/delete this record
REQUEST_ID NUMBER

Identifier used by collection program
ROW_ID ROWID (10)
Row Id
USER_ATTRIBUTE1 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User attribute

[top of page]

ISC.EDW_MRP_FCDM_FCS_LSTG does not reference any database object

ISC.EDW_MRP_FCDM_FCS_LSTG is referenced by following:

APPS
SYNONYM - EDW_MRP_FCDM_FCS_LSTG

[top of page]

Table: EDW_MRP_FCDM_FCS_LTC

Description: Forecast level table
Comments

This is the Forecast level table in the Forecast dimension. This stores all the Forecasts.

Indexes
Index Type Tablespace Column
EDW_MRP_FCDM_FCS_LTC_U1 UNIQUE APPS_TS_SUMMARY FORECAST_PK_KEY
EDW_MRP_FCDM_FCS_LTC_U2 UNIQUE APPS_TS_SUMMARY FORECAST_PK
FORECAST_PK_KEY
EDW_MRP_FCDM_FCS_LTC_N1 NONUNIQUE APPS_TS_SUMMARY FORECAST_SET_FK_KEY
Columns
Name Datatype Length Mandatory Comments
FORECAST_PK VARCHAR2 (40)
Unique identifier
FORECAST_PK_KEY NUMBER

System generated unique identifier
FORECAST_SET_FK VARCHAR2 (40)
Foreign key to the Forecast Set level of the Forecast dimension
FORECAST_SET_FK_KEY NUMBER

System generated foreign key to the Forecast Set level of the Forecast dimension
CREATION_DATE DATE
Y Standard Who column
DESCRIPTION VARCHAR2 (240)
Forecast description
DISABLE_DATE DATE

Date on which that Forecast was disabled
FORECAST_DP VARCHAR2 (240)
Unique Forecast name
FORECAST_NAME VARCHAR2 (80)
Forecast name
INSTANCE_CODE VARCHAR2 (40)
Instance code refering to the source application
LAST_UPDATE_DATE DATE
Y Standard Who column
NAME VARCHAR2 (2000)
Alternate Forecast name
USER_ATTRIBUTE1 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User attribute

[top of page]

ISC.EDW_MRP_FCDM_FCS_LTC does not reference any database object

ISC.EDW_MRP_FCDM_FCS_LTC is referenced by following:

APPS
SYNONYM - EDW_MRP_FCDM_FCS_LTC

[top of page]

Table: EDW_MRP_FCDM_SET_LSTG

Description: Interface table for Forecast Set level
Comments

This is the interface table for the Forecast Set level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the dimension level table.

Indexes
Index Type Tablespace Column
EDW_MRP_FCDM_SET_LSTG_N1 NONUNIQUE APPS_TS_INTERFACE FORECAST_SET_PK
EDW_MRP_FCDM_SET_LSTG_N2 NONUNIQUE APPS_TS_INTERFACE COLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
FORECAST_SET_PK VARCHAR2 (40)
Unique identifier
COLLECTION_STATUS VARCHAR2 (30)
Collection status code for the record
CONSUMPTION_LEVEL VARCHAR2 (80)
Consumption Level for the Forecast Set. This determines how forecasts in the set are defined and consumed; for example, Consumption Level can bet set at the Item level, or at the Item and Customer level, or at the Item, Customer and Ship-to level, etc.
DESCRIPTION VARCHAR2 (240)
Forecast Set description
DISABLE_DATE DATE

Date on which that Forecast Set was disabled
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
FORECAST_SET_DP VARCHAR2 (240)
Unique Forecast Set name
FORECAST_SET_NAME VARCHAR2 (80)
Forecast Set name
INSTANCE_CODE VARCHAR2 (40)
Instance code refering to the source application
NAME VARCHAR2 (2000)
Alternate Forecast Set name
OPERATION_CODE VARCHAR2 (30)
Code used by the collection program to determine whether to insert/update/delete this record
REQUEST_ID NUMBER

Identifier used by collection program
ROW_ID ROWID (10)
Row Id
USER_ATTRIBUTE1 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User attribute

[top of page]

ISC.EDW_MRP_FCDM_SET_LSTG does not reference any database object

ISC.EDW_MRP_FCDM_SET_LSTG is referenced by following:

APPS
SYNONYM - EDW_MRP_FCDM_SET_LSTG

[top of page]

Table: EDW_MRP_FCDM_SET_LTC

Description: Forecast Set level table
Comments

This is the Forecast Set level table in the Forecast dimension. This stores all the Forecast Sets.

Indexes
Index Type Tablespace Column
EDW_MRP_FCDM_SET_LTC_U1 UNIQUE APPS_TS_SUMMARY FORECAST_SET_PK_KEY
EDW_MRP_FCDM_SET_LTC_U2 UNIQUE APPS_TS_SUMMARY FORECAST_SET_PK
FORECAST_SET_PK_KEY
Columns
Name Datatype Length Mandatory Comments
FORECAST_SET_PK VARCHAR2 (40)
Unique identifier
FORECAST_SET_PK_KEY NUMBER

System generated unique identifier
CONSUMPTION_LEVEL VARCHAR2 (80)
Consumption Level for the Forecast Set. This determines how forecasts in the set are defined and consumed; for example, Consumption Level can bet set at the Item level, or at the Item and Customer level, or at the Item, Customer and Ship-to level, etc.
CREATION_DATE DATE
Y Standard Who column
DESCRIPTION VARCHAR2 (240)
Forecast Set description
DISABLE_DATE DATE

Date on which that Forecast Set was disabled
FORECAST_SET_DP VARCHAR2 (240)
Unique Forecast Set name
FORECAST_SET_NAME VARCHAR2 (80)
Forecast Set name
INSTANCE_CODE VARCHAR2 (40)
Instance code refering to the source application
LAST_UPDATE_DATE DATE
Y Standard Who column
NAME VARCHAR2 (2000)
Alternate Forecast Set name
USER_ATTRIBUTE1 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User attribute

[top of page]

ISC.EDW_MRP_FCDM_SET_LTC does not reference any database object

ISC.EDW_MRP_FCDM_SET_LTC is referenced by following:

APPS
SYNONYM - EDW_MRP_FCDM_SET_LTC

[top of page]

Table: EDW_MRP_FORECAST_M

Description: Forecast dimension
Comments

This is the denormalized star table for the Forecast dimension. It contains records for the lowest level of the Forecast dimension and their parentage up to the top level, across all hierarchies.

Indexes
Index Type Tablespace Column
EDW_MRP_FORECAST_M_U1 UNIQUE APPS_TS_SUMMARY FCST_FORECAST_PK
FCST_FORECAST_PK_KEY
EDW_MRP_FORECAST_M_U2 UNIQUE APPS_TS_SUMMARY FCST_FORECAST_PK_KEY
Columns
Name Datatype Length Mandatory Comments
FCST_FORECAST_PK VARCHAR2 (40)
Unique identifier
FCST_FORECAST_PK_KEY NUMBER
Y System generated Forecast unique identifier
FSTS_FORECAST_SET_PK VARCHAR2 (40)
Unique identifier for the Forecast Set
FSTS_FORECAST_SET_PK_KEY NUMBER
Y System generated unique identifier for the Forecast Set
CREATION_DATE DATE
Y Standard Who column
FCST_DESCRIPTION VARCHAR2 (240)
Forecast description
FCST_DISABLE_DATE DATE

Date on which that Forecast was disabled
FCST_FORECAST_DP VARCHAR2 (240)
Unique Forecast name
FCST_FORECAST_NAME VARCHAR2 (80)
Forecast name
FCST_INSTANCE_CODE VARCHAR2 (40)
Instance code refering to the source application for the Forecast
FCST_NAME VARCHAR2 (80)
Alternate Forecast name
FCST_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute (Forecast level)
FCST_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute (Forecast level)
FCST_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute (Forecast level)
FCST_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute (Forecast level)
FCST_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute (Forecast level)
FSTS_CONSUMPTION_LEVEL VARCHAR2 (80)
Consumption Level for the Forecast Set. This determines how forecasts in the set are defined and consumed; for example, Consumption Level can bet set at the Item level, or at the Item and Customer level, or at the Item, Customer and Ship-to level, etc.
FSTS_DESCRIPTION VARCHAR2 (240)
Forecast Set description
FSTS_DISABLE_DATE DATE

Date on which that Forecast Set was disabled
FSTS_FORECAST_SET_DP VARCHAR2 (240)
Unique Forecast Set name
FSTS_FORECAST_SET_NAME VARCHAR2 (80)
Forecast Set name
FSTS_INSTANCE_CODE VARCHAR2 (40)
Instance code refering to the source application for the Forecast Set
FSTS_NAME VARCHAR2 (80)
Alternate Forecast Set name
FSTS_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute (Forecast Set level)
FSTS_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute (Forecast Set level)
FSTS_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute (Forecast Set level)
FSTS_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute (Forecast Set level)
FSTS_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute (Forecast Set level)
LAST_UPDATE_DATE DATE
Y Standard Who column

[top of page]

ISC.EDW_MRP_FORECAST_M does not reference any database object

ISC.EDW_MRP_FORECAST_M is referenced by following:

APPS
SYNONYM - EDW_MRP_FORECAST_M

[top of page]

Table: EDW_MRP_PLAN_M

Description: Plan dimension
Comments

This is the denormalized star table for the Plan dimension. It contains records for the lowest level of the Plan dimension and their parentage up to the top level, across all hierarchies.

Indexes
Index Type Tablespace Column
EDW_MRP_PLAN_M_U1 UNIQUE APPS_TS_SUMMARY PLAN_PLAN_NAME_PK
PLAN_PLAN_NAME_PK_KEY
EDW_MRP_PLAN_M_U2 UNIQUE APPS_TS_SUMMARY PLAN_PLAN_NAME_PK_KEY
Columns
Name Datatype Length Mandatory Comments
PLAN_PLAN_NAME_PK VARCHAR2 (120)
Unique identifier
PLAN_PLAN_NAME_PK_KEY NUMBER
Y System generated unique identifier
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
PLAN_COMPLETION_DATE DATE

Date/time the Plan was completed
PLAN_DESCRIPTION VARCHAR2 (240)
Plan description
PLAN_INCLUDE_PO_FLAG VARCHAR2 (20)
Flag to indicate if Purchase Orders were included in the plan
PLAN_INCLUDE_WIP_FLAG VARCHAR2 (20)
Flag to indicate if Work in Process inventories were included in the plan
PLAN_INSTANCE_CODE VARCHAR2 (40)
Instance code refering to the source application
PLAN_NAME VARCHAR2 (80)
Alternate Plan name
PLAN_PLAN_CUTOFF_DATE DATE

Cutoff date of the plan. The cutoff date is used to determine the end date when selecting entries into the plan (for example, when loading forecast entries into the plan, end date = cutoff date + carry forward days).
PLAN_PLAN_NAME VARCHAR2 (40)
Plan name
PLAN_PLAN_NAME_DP VARCHAR2 (240)
Unique Plan name
PLAN_PLAN_RESERVE_FLAG VARCHAR2 (20)
Flag to indicate if supply was reserved against demand
PLAN_PLAN_SAFETY_STOCK VARCHAR2 (20)
Flag to indicate if safety stock was calculated for each item during the execution of the plan
PLAN_PLAN_TYPE VARCHAR2 (40)
Type of the plan. Indicates if the Plan was an MRP, CRP, MPS, or Supply Chain plan.
PLAN_USER_ATTRIBUTE1 VARCHAR2 (240)
User attribute
PLAN_USER_ATTRIBUTE2 VARCHAR2 (240)
User attribute
PLAN_USER_ATTRIBUTE3 VARCHAR2 (240)
User attribute
PLAN_USER_ATTRIBUTE4 VARCHAR2 (240)
User attribute
PLAN_USER_ATTRIBUTE5 VARCHAR2 (240)
User attribute

[top of page]

ISC.EDW_MRP_PLAN_M does not reference any database object

ISC.EDW_MRP_PLAN_M is referenced by following:

APPS
SYNONYM - EDW_MRP_PLAN_M

[top of page]

Table: EDW_MRP_PNDM_PLN_LSTG

Description: Interface table for Plan level
Comments

This is the interface table for the Plan level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the dimension level table.

Indexes
Index Type Tablespace Column
EDW_MRP_PNDM_PLN_LSTG_N1 NONUNIQUE APPS_TS_INTERFACE PLAN_NAME_PK
EDW_MRP_PNDM_PLN_LSTG_N2 NONUNIQUE APPS_TS_INTERFACE COLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
PLAN_NAME_PK VARCHAR2 (120)
Unique identifier
COLLECTION_STATUS VARCHAR2 (30)
Collection status code for the record
COMPLETION_DATE DATE

Date/time the Plan was completed
DESCRIPTION VARCHAR2 (240)
Plan description
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
INCLUDE_PO_FLAG VARCHAR2 (20)
Flag to indicate if Purchase Orders were included in the plan
INCLUDE_WIP_FLAG VARCHAR2 (20)
Flag to indicate if Work in Process inventories were included in the plan
INSTANCE VARCHAR2 (40)
Instance code refering to the source application
NAME VARCHAR2 (2000)
Alternate Plan name
OPERATION_CODE VARCHAR2 (30)
Code used by the collection program to determine whether to insert/update/delete this record
PLAN_CUTOFF_DATE DATE

Cutoff date of the plan. The cutoff date is used to determine the end date when selecting entries into the plan (for example, when loading forecast entries into the plan, end date = cutoff date + carry forward days).
PLAN_NAME VARCHAR2 (40)
Plan name
PLAN_NAME_DP VARCHAR2 (240)
Unique Plan name
PLAN_RESERVE_FLAG VARCHAR2 (20)
Flag to indicate if supply was reserved against demand
PLAN_SAFETY_STOCK VARCHAR2 (20)
Flag to indicate if safety stock was calculated for each item during the execution of the plan
PLAN_TYPE VARCHAR2 (40)
Type of the plan. Indicates if the Plan was an MRP, CRP, MPS, or Supply Chain plan.
REQUEST_ID NUMBER

Identifier used by collection program
ROW_ID ROWID (10)
Row Id
USER_ATTRIBUTE1 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User attribute

[top of page]

ISC.EDW_MRP_PNDM_PLN_LSTG does not reference any database object

ISC.EDW_MRP_PNDM_PLN_LSTG is referenced by following:

APPS
SYNONYM - EDW_MRP_PNDM_PLN_LSTG

[top of page]

Table: EDW_MRP_PNDM_PLN_LTC

Description: Plan level table
Comments

This is the Plan level table in the Plan dimension. This stores all the Plans.

Indexes
Index Type Tablespace Column
EDW_MRP_PNDM_PLN_LTC_U1 UNIQUE APPS_TS_SUMMARY PLAN_NAME_PK_KEY
EDW_MRP_PNDM_PLN_LTC_U2 UNIQUE APPS_TS_SUMMARY PLAN_NAME_PK
PLAN_NAME_PK_KEY
Columns
Name Datatype Length Mandatory Comments
PLAN_NAME_PK VARCHAR2 (120)
Unique identifier
PLAN_NAME_PK_KEY NUMBER

System generated unique identifier
COMPLETION_DATE DATE

Date/time the Plan was completed
CREATION_DATE DATE
Y Standard Who column
DESCRIPTION VARCHAR2 (240)
Plan description
INCLUDE_PO_FLAG VARCHAR2 (20)
Flag to indicate if Purchase Orders were included in the plan
INCLUDE_WIP_FLAG VARCHAR2 (20)
Flag to indicate if Work in Process inventories were included in the plan
INSTANCE_CODE VARCHAR2 (40)
Instance code refering to the source application
LAST_UPDATE_DATE DATE
Y Standard Who column
NAME VARCHAR2 (2000)
Plan alternate name
PLAN_CUTOFF_DATE DATE

Cutoff date of the plan. The cutoff date is used to determine the end date when selecting entries into the plan (for example, when loading forecast entries into the plan, end date = cutoff date + carry forward days).
PLAN_NAME VARCHAR2 (40)
Plan name
PLAN_NAME_DP VARCHAR2 (240)
Unique Plan name
PLAN_RESERVE_FLAG VARCHAR2 (20)
Flag to indicate if supply was reserved against demand
PLAN_SAFETY_STOCK VARCHAR2 (20)
Flag to indicate if safety stock was calculated for each item during the execution of the plan
PLAN_TYPE VARCHAR2 (40)
Type of the plan. Indicates if the Plan was an MRP, CRP, MPS, or Supply Chain plan.
USER_ATTRIBUTE1 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User attribute

[top of page]

ISC.EDW_MRP_PNDM_PLN_LTC does not reference any database object

ISC.EDW_MRP_PNDM_PLN_LTC is referenced by following:

APPS
SYNONYM - EDW_MRP_PNDM_PLN_LTC

[top of page]

Table: EDW_OE_SCHN_SCHN_LSTG

Description: Interface table for Sales Channel level
Comments

This is the interface table for the Sales Channel level table. Data from multiple transactional systems is staged here for verification and cleansing, before it is loaded into the Dimension level table.

Indexes
Index Type Tablespace Column
EDW_OE_SCHN_SCHN_LSTG_N1 NONUNIQUE APPS_TS_INTERFACE SALES_CHANNEL_PK
EDW_OE_SCHN_SCHN_LSTG_N2 NONUNIQUE APPS_TS_INTERFACE COLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
SALES_CHANNEL_PK VARCHAR2 (120)
Unique identifier
ALL_FK VARCHAR2 (40)
Foreign key to the top level of the Sales Channel dimension
ALL_FK_KEY NUMBER

System generated foreign key to the top level of the Sales Channel dimension
ACTIVE_FROM_DATE DATE

Date from which that Sales Channel was active
ACTIVE_TO_DATE DATE

Date to which that Sales Channel was active
COLLECTION_STATUS VARCHAR2 (40)
Collection status code for the record
CREATION_DATE DATE

Standard Who column
ENABLED_FLAG VARCHAR2 (20)
Flag to indicate if that Sales Channel was enabled in the source system
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
INSTANCE_CODE VARCHAR2 (40)
Instance code referring to the source application
LAST_UPDATE_DATE DATE

Standard Who column
NAME VARCHAR2 (80)
Alternate Sales Channel name
OPERATION_CODE VARCHAR2 (40)
Code used by the collection program to determine whether to insert/update/delete this record
REQUEST_ID NUMBER

Identifier used by the collection program
ROW_ID ROWID (10)
Row Id
SALES_CHANNEL_CODE VARCHAR2 (80)
Sales Channel code
SALES_CHANNEL_DP VARCHAR2 (240)
Unique Sales Channel name
SALES_CHANNEL_NAME VARCHAR2 (240)
Sales Channel name
USER_ATTRIBUTE1 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User attribute

[top of page]

ISC.EDW_OE_SCHN_SCHN_LSTG does not reference any database object

ISC.EDW_OE_SCHN_SCHN_LSTG is referenced by following:

APPS
SYNONYM - EDW_OE_SCHN_SCHN_LSTG

[top of page]

Table: EDW_OE_SCHN_SCHN_LTC

Description: Sales Channel level table
Comments

This is the Sales Channel level table in the Sales Channel Dimension. The Sales Channel dimension has a single level that stores all of the Sales Channels.

Indexes
Index Type Tablespace Column
EDW_OE_SCHN_SCHN_LTC_U1 UNIQUE APPS_TS_SUMMARY SCHANNEL_PK_KEY
EDW_OE_SCHN_SCHN_LTC_U2 UNIQUE APPS_TS_SUMMARY SCHANNEL_PK
SCHANNEL_PK_KEY
EDW_OE_SCHN_SCHN_LTC_N1 NONUNIQUE APPS_TS_SUMMARY ALL_FK_KEY
Columns
Name Datatype Length Mandatory Comments
SCHANNEL_PK VARCHAR2 (120)
Unique identifier
SCHANNEL_PK_KEY NUMBER

System generated unique identifer
ALL_FK VARCHAR2 (40)
Foreign key to the top level of the Sales Channel dimension
ALL_FK_KEY NUMBER

System generated foreign key to the top level of the Sales Channel dimension
ACTIVE_FROM_DATE DATE

Date from which that Sales Channel was active
ACTIVE_TO_DATE DATE

Date to which that Sales Channel was active
CREATION_DATE DATE
Y Standard Who column
ENABLED_FLAG VARCHAR2 (20)
Flag to indicate if that Sales Channel was enabled in the source system
INSTANCE VARCHAR2 (40)
Instance code referring to the source application
LAST_UPDATE_DATE DATE
Y Standard Who column
NAME VARCHAR2 (80)
Sales Channel alternate name
SALES_CHANNEL_CODE VARCHAR2 (80)
Sales Channel code
SALES_CHANNEL_NAME VARCHAR2 (240)
Sales Channel name
SCHANNEL_DP VARCHAR2 (240)
Unique Sales Channel name
USER_ATTRIBUTE1 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User attribute

[top of page]

ISC.EDW_OE_SCHN_SCHN_LTC does not reference any database object

ISC.EDW_OE_SCHN_SCHN_LTC is referenced by following:

APPS
SYNONYM - EDW_OE_SCHN_SCHN_LTC

[top of page]

Table: EDW_OE_SLCHNL_A_LTC

Description: Top level table for the Sales Channel dimension
Comments

This is the top level table for the Sales Channel dimension.

Indexes
Index Type Tablespace Column
EDW_OE_SLCHNL_A_LTC_U1 UNIQUE APPS_TS_SUMMARY ALL_PK_KEY
EDW_OE_SLCHNL_A_LTC_U2 UNIQUE APPS_TS_SUMMARY ALL_PK
ALL_PK_KEY
Columns
Name Datatype Length Mandatory Comments
ALL_PK VARCHAR2 (40)
Unique identifier
ALL_PK_KEY NUMBER

System generated unique identifier
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
NAME VARCHAR2 (80)
All Sales Channels name

[top of page]

ISC.EDW_OE_SLCHNL_A_LTC does not reference any database object

ISC.EDW_OE_SLCHNL_A_LTC is referenced by following:

APPS
SYNONYM - EDW_OE_SLCHNL_A_LTC

[top of page]

Table: EDW_OE_SLCHNL_M

Description: Sales Channel dimension
Comments

This is the denormalized star table for the Sales Channel dimension. It contains records for the lowest level of the Sales Channel dimension and their parentage up to the top level of the dimension, across all hierarchies.

Indexes
Index Type Tablespace Column
EDW_OE_SLCHNL_M_U1 UNIQUE APPS_TS_SUMMARY SCHN_SLSCHNL_PK
SCHN_SLSCHNL_PK_KEY
EDW_OE_SLCHNL_M_U2 UNIQUE APPS_TS_SUMMARY SCHN_SLSCHNL_PK_KEY
Columns
Name Datatype Length Mandatory Comments
A_ALL_PK VARCHAR2 (40)
Unique identifier for All Sales Channels
A_ALL_PK_KEY NUMBER

System generated unique identifier for All Sales Channels
SCHN_SLSCHNL_PK VARCHAR2 (120)
Unique identifier for the Sales Channel
SCHN_SLSCHNL_PK_KEY NUMBER
Y System generated unique identifier for the Sales Channel
A_NAME VARCHAR2 (80)
All Sales Channels name
SCHN_ACTIVE_FROM_DATE DATE

Date from which that Sales Channel was active
SCHN_ACTIVE_TO_DATE DATE

Date to which that Sales Channel was active
SCHN_ENABLED_FLAG VARCHAR2 (20)
Flag to indicate if that Sales Channel was enabled in the source system
SCHN_INSTANCE_CODE VARCHAR2 (40)
nstance code referring to the source application
SCHN_NAME VARCHAR2 (80)
Alternate Sales Channel name
SCHN_SALES_CHANNEL_CODE VARCHAR2 (80)
Sales Channel code
SCHN_SALES_CHANNEL_NAME VARCHAR2 (240)
Sales Channel name
SCHN_SLSCHNL_DP VARCHAR2 (240)
Unique Sales Channel name
SCHN_USER_ATTRIBUTE1 VARCHAR2 (240)
User attribute
SCHN_USER_ATTRIBUTE2 VARCHAR2 (240)
User attribute
SCHN_USER_ATTRIBUTE3 VARCHAR2 (240)
User attribute
SCHN_USER_ATTRIBUTE4 VARCHAR2 (240)
User attribute
SCHN_USER_ATTRIBUTE5 VARCHAR2 (240)
User attribute
SCHN_LAST_UPDATE_DATE DATE

Sales Channel Last Update Date
SCHN_CREATION_DATE DATE

Sales Channel Creation Date
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column

[top of page]

ISC.EDW_OE_SLCHNL_M does not reference any database object

ISC.EDW_OE_SLCHNL_M is referenced by following:

APPS
SYNONYM - EDW_OE_SLCHNL_M

[top of page]

Table: ISC_DBI_CFM_008_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ISC_DBI_CFM_008_MV UNIQUE APPS_TS_SUMMARY SYS_NC00267$
SYS_NC00268$
SYS_NC00269$
SYS_NC00270$
SYS_NC00271$
SYS_NC00272$
SYS_NC00273$
SYS_NC00274$
SYS_NC00275$
SYS_NC00276$
SYS_NC00277$
ISC_DBI_CFM_008_MV_N1 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
LATE_SCHEDULE_FLAG
CUSTOMER_ID
ITEM_CATEGORY_ID
ISC_DBI_CFM_008_MV_N2 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
LATE_SCHEDULE_FLAG
ITEM_ID
CUSTOMER_ID
ISC_DBI_CFM_008_MV_N3 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
LATE_SCHEDULE_FLAG
ITEM_CATEGORY_ID
ISC_DBI_CFM_008_MV_N4 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
LATE_PROMISE_FLAG
CUSTOMER_ID
ITEM_CATEGORY_ID
ISC_DBI_CFM_008_MV_N5 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
LATE_PROMISE_FLAG
ITEM_ID
CUSTOMER_ID
ISC_DBI_CFM_008_MV_N6 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
LATE_PROMISE_FLAG
ITEM_CATEGORY_ID
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

[top of page]

APPS.ISC_DBI_CFM_008_MV does not reference any database object

APPS.ISC_DBI_CFM_008_MV is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_CFM_008_MV
MATERIALIZED VIEW - ISC_DBI_CFM_012_MV

[top of page]

Table: ISC_DBI_CFM_012_MV

Description:
Indexes
Index Type Tablespace Column
ISC_DBI_CFM_012_MV_N1 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
LATE_SCHEDULE_FLAG
TOP_NODE_FLAG
INV_ORG_ID
ISC_DBI_CFM_012_MV_N2 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
LATE_SCHEDULE_FLAG
PARENT_ID
INV_ORG_ID
ISC_DBI_CFM_012_MV_N3 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
LATE_PROMISE_FLAG
TOP_NODE_FLAG
INV_ORG_ID
ISC_DBI_CFM_012_MV_N4 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
LATE_PROMISE_FLAG
PARENT_ID
INV_ORG_ID
Columns
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

[top of page]

APPS.ISC_DBI_CFM_012_MV does not reference any database object

APPS.ISC_DBI_CFM_012_MV is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_CFM_012_MV

[top of page]

Table: ISC_DBI_CPM_001_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ISC_DBI_CPM_001_MV UNIQUE APPS_TS_SUMMARY SYS_NC00025$
SYS_NC00026$
SYS_NC00027$
SYS_NC00028$
SYS_NC00029$
SYS_NC00030$
SYS_NC00031$
SYS_NC00032$
SYS_NC00033$
SYS_NC00034$
SYS_NC00035$
ISC_DBI_CPM_001_MV_N1 NONUNIQUE APPS_TS_SUMMARY ENT_YEAR_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
CUSTOMER_ID
ITEM_CATEGORY_ID
ISC_DBI_CPM_001_MV_N2 NONUNIQUE APPS_TS_SUMMARY ENT_YEAR_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
PRODUCT_ID
CUSTOMER_ID
ISC_DBI_CPM_001_MV_N3 NONUNIQUE APPS_TS_SUMMARY ENT_YEAR_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
ITEM_CATEGORY_ID
CLASS_CODE
ISC_DBI_CPM_001_MV_N4 NONUNIQUE APPS_TS_SUMMARY ENT_YEAR_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
CLASS_CODE
PRODUCT_ID
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_FLAG NUMBER

Grouping ID Column for Customer Dimension
ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item Dimension
GRP_ID NUMBER

Grouping ID Column
ENT_YEAR_ID NUMBER

Enterprise Year Identifier
CUSTOMER_ID NUMBER

Customer Identifier
CLASS_CODE VARCHAR2 (30)
Customer Classification code
PRODUCT_ID VARCHAR2 (81)
Item Organization Identifier
ITEM_CATEGORY_ID NUMBER

Product Category Identifier
SERVICE_ITEM_ID VARCHAR2 (81)
Item Organization Identifier
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
ACTIVE_G NUMBER

Balance of Active Contracts as of Enterprise Year End in Global Currency
ACTIVE_NEW_G NUMBER

Balance of Active New Constracts as of Enterprise Year End in Global Currency
ACTIVE_RENEW_G NUMBER

Balance of Active Renewal Constracts as of Enterprise Year End in Global Currency
C_ACTIVE_G NUMBER

Count Column
C_ACTIVE_NEW_G NUMBER

Count Column
C_ACTIVE_RENEW_G NUMBER

Count Column
ACTIVE_G1 NUMBER

Balance of Active Contracts as of Enterprise Year End in Secondary Global Currency
ACTIVE_NEW_G1 NUMBER

Balance of Active New Constracts as of Enterprise Year End in Secondary Global Currency
ACTIVE_RENEW_G1 NUMBER

Balance of Active Renewal Constracts as of Enterprise Year End in Secondary Global Currency
C_ACTIVE_G1 NUMBER

Count Column
C_ACTIVE_NEW_G1 NUMBER

Count Column
C_ACTIVE_RENEW_G1 NUMBER

Count Column
C_TOTAL NUMBER

Row Count

[top of page]

APPS.ISC_DBI_CPM_001_MV does not reference any database object

APPS.ISC_DBI_CPM_001_MV is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_CPM_001_MV
MATERIALIZED VIEW - ISC_DBI_CPM_004_MV

[top of page]

Table: ISC_DBI_CPM_002_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ISC_DBI_CPM_002_MV UNIQUE APPS_TS_SUMMARY SYS_NC00022$
SYS_NC00023$
SYS_NC00024$
SYS_NC00025$
SYS_NC00026$
SYS_NC00027$
SYS_NC00028$
SYS_NC00029$
SYS_NC00030$
SYS_NC00031$
SYS_NC00032$
ISC_DBI_CPM_002_MV_N1 NONUNIQUE APPS_TS_SUMMARY TIME_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
CUSTOMER_ID
ITEM_CATEGORY_ID
ISC_DBI_CPM_002_MV_N2 NONUNIQUE APPS_TS_SUMMARY TIME_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
PRODUCT_ID
CUSTOMER_ID
ISC_DBI_CPM_002_MV_N3 NONUNIQUE APPS_TS_SUMMARY TIME_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
ITEM_CATEGORY_ID
CLASS_CODE
ISC_DBI_CPM_002_MV_N4 NONUNIQUE APPS_TS_SUMMARY TIME_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
CLASS_CODE
PRODUCT_ID
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_FLAG NUMBER

Grouping ID Column for Customer Dimension
ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item Dimension
GRP_ID NUMBER

Grouping ID Column
TIME_ID NUMBER

Nested Grouping ID Column for Time
CUSTOMER_ID NUMBER

Customer Identifier
CLASS_CODE VARCHAR2 (30)
Customer Classification code
PRODUCT_ID VARCHAR2 (25)
Item Organization Identifier
ITEM_CATEGORY_ID NUMBER

Product Category Identifier
REPORT_DATE_JULIAN NUMBER

FII Day Identifier
WEEK_ID NUMBER

FII Week Identifier
ENT_PERIOD_ID NUMBER

Enterprise Period Identifier
ENT_QTR_ID NUMBER

Enterprise Quarter Identifier
BOOKED_AMT_G NUMBER

Booked Amount in Global Currency
C_BOOKED_AMT_G NUMBER

Count Column
BOOKED_AMT_G1 NUMBER

Booked Amount in Secondary Global Currency
C_BOOKED_AMT_G1 NUMBER

Count Column
RETURNED_AMT_G NUMBER

Returned Amount in Global Currency
C_RETURNED_AMT_G NUMBER

Count Column
RETURNED_AMT_G1 NUMBER

Returned Amount in Secondary Global Currency
C_RETURNED_AMT_G1 NUMBER

Count Column
C_TOTAL NUMBER

Row Count

[top of page]

APPS.ISC_DBI_CPM_002_MV does not reference any database object

APPS.ISC_DBI_CPM_002_MV is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_CPM_002_MV
MATERIALIZED VIEW - ISC_DBI_CPM_005_MV

[top of page]

Table: ISC_DBI_CPM_003_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ISC_DBI_CPM_003_MV UNIQUE APPS_TS_SUMMARY SYS_NC00032$
SYS_NC00033$
SYS_NC00034$
SYS_NC00035$
ISC_DBI_CPM_003_MV_N1 NONUNIQUE APPS_TS_SUMMARY TIME_ID
PARENT_ID
ISC_DBI_CPM_003_MV_N2 NONUNIQUE APPS_TS_SUMMARY TIME_ID
TOP_NODE_FLAG
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_FLAG NUMBER

Grouping ID Column for Customer Dimension
ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item Dimension
TOP_NODE_FLAG VARCHAR2 (1)
Flag to Indicate the Top Node Product Category
TIME_ID NUMBER

Nested Grouping ID Column for Time
PARENT_ID NUMBER

Product Category Identifier
IMM_CHILD_ID NUMBER

Product Category Identifier
ACTIVATED_G NUMBER

Total Amount of Contracts Activated in Global Currency
ACTIVATED_NEW_G NUMBER

Total Amount of New Contracts Activated in Global Currency
ACTIVATED_RENEW_G NUMBER

Total Amount of Renewal Contracts Activated in Global Currency
EXPIRED_G NUMBER

Total Amount of Contracts Expired in Global Currency
EXPIRED_NEW_G NUMBER

Total Amount of New Contracts Expired in Global Currency
EXPIRED_RENEW_G NUMBER

Total Amount of Renewal Contracts Expired in Global Currency
C_ACTIVATED_G NUMBER

Count Column
C_ACTIVATED_NEW_G NUMBER

Count Column
C_ACTIVATED_RENEW_G NUMBER

Count Column
C_EXPIRED_G NUMBER

Count Column
C_EXPIRED_NEW_G NUMBER

Count Column
C_EXPIRED_RENEW_G NUMBER

Count Column
ACTIVATED_G1 NUMBER

Total Amount of Contracts Activated in Secondary Global Currency
ACTIVATED_NEW_G1 NUMBER

Total Amount of New Contracts Activated in Secondary Global Currency
ACTIVATED_RENEW_G1 NUMBER

Total Amount of Renewal Contracts Activated in Secondary Global Currency
EXPIRED_G1 NUMBER

Total Amount of Contracts Expired in Secondary Global Currency
EXPIRED_NEW_G1 NUMBER

Total Amount of New Contracts Expired in Secondary Global Currency
EXPIRED_RENEW_G1 NUMBER

Total Amount of Renewal Contracts Expired in Secondary Global Currency
C_ACTIVATED_G1 NUMBER

Count Column
C_ACTIVATED_NEW_G1 NUMBER

Count Column
C_ACTIVATED_RENEW_G1 NUMBER

Count Column
C_EXPIRED_G1 NUMBER

Count Column
C_EXPIRED_NEW_G1 NUMBER

Count Colum
C_EXPIRED_RENEW_G1 NUMBER

Count Column
C_TOTAL NUMBER

Row Count

[top of page]

APPS.ISC_DBI_CPM_003_MV does not reference any database object

APPS.ISC_DBI_CPM_003_MV is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_CPM_003_MV

[top of page]

Table: ISC_DBI_CPM_004_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ISC_DBI_CPM_004_MV UNIQUE APPS_TS_SUMMARY SYS_NC00020$
SYS_NC00021$
SYS_NC00022$
SYS_NC00023$
ISC_DBI_CPM_004_MV_N1 NONUNIQUE APPS_TS_SUMMARY ENT_YEAR_ID
PARENT_ID
ISC_DBI_CPM_004_MV_N2 NONUNIQUE APPS_TS_SUMMARY ENT_YEAR_ID
TOP_NODE_FLAG
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_FLAG NUMBER

Grouping ID Column for Customer Dimension
ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item Dimension
TOP_NODE_FLAG VARCHAR2 (1)
Flag to Indicate the Top Node Product Category
ENT_YEAR_ID NUMBER

Enterprise Year Identifier
PARENT_ID NUMBER

Product Category Identifier
IMM_CHILD_ID NUMBER

Product Category Identifier
ACTIVE_G NUMBER

Balance of Active Contracts as of Enterprise Year End in Global Currency
ACTIVE_NEW_G NUMBER

Balance of Active New Contracts as of Enterprise Year End in Global Currency
ACTIVE_RENEW_G NUMBER

Balance of Active Renewal Contracts as of Enterprise Year End in Global Currency
C_ACTIVE_G NUMBER

Count Column
C_ACTIVE_NEW_G NUMBER

Count Column
C_ACTIVE_RENEW_G NUMBER

Count Column
ACTIVE_G1 NUMBER

Balance of Active Contracts as of Enterprise Year End in Secondary Global Currency
ACTIVE_NEW_G1 NUMBER

Balance of Active New Contracts as of Enterprise Year End in Secondary Global Currency
ACTIVE_RENEW_G1 NUMBER

Balance of Active Renewal Contracts as of Enterprise Year End in Secondary Global Currency
C_ACTIVE_G1 NUMBER

Count Column
C_ACTIVE_NEW_G1 NUMBER

Count Column
C_ACTIVE_RENEW_G1 NUMBER

Count Column
C_TOTAL NUMBER

Row Count

[top of page]

APPS.ISC_DBI_CPM_004_MV does not reference any database object

APPS.ISC_DBI_CPM_004_MV is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_CPM_004_MV

[top of page]

Table: ISC_DBI_CPM_005_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ISC_DBI_CPM_005_MV UNIQUE APPS_TS_SUMMARY SYS_NC00016$
SYS_NC00017$
SYS_NC00018$
SYS_NC00019$
ISC_DBI_CPM_005_MV_N1 NONUNIQUE APPS_TS_SUMMARY TIME_ID
PARENT_ID
ISC_DBI_CPM_005_MV_N2 NONUNIQUE APPS_TS_SUMMARY TIME_ID
TOP_NODE_FLAG
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_FLAG NUMBER

Grouping ID Column for Customer Dimension
ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item Dimension
TOP_NODE_FLAG VARCHAR2 (1)
Flag to Indicate the Top Node Product Category
TIME_ID NUMBER

Nested Grouping ID Column for Time
PARENT_ID NUMBER

Product Category Identifier
IMM_CHILD_ID NUMBER

Product Category Identifier
BOOKED_AMT_G NUMBER

Booked Amount in Global Currency
C_BOOKED_AMT_G NUMBER

Count Column
BOOKED_AMT_G1 NUMBER

Booked Amount in Secondary Global Currency
C_BOOKED_AMT_G1 NUMBER

Count Column
RETURNED_AMT_G NUMBER

Returned Amount in Global Currency
C_RETURNED_AMT_G NUMBER

Count Column
RETURNED_AMT_G1 NUMBER

Returned Amount in Secondary Global Currency
C_RETURNED_AMT_G1 NUMBER

Count Column
C_TOTAL NUMBER

Row Count

[top of page]

APPS.ISC_DBI_CPM_005_MV does not reference any database object

APPS.ISC_DBI_CPM_005_MV is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_CPM_005_MV

[top of page]

Table: ISC_DBI_DEMANDS_F

Description:
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
DEMAND_ID NUMBER

PLAN_ID NUMBER

ORGANIZATION_ID NUMBER

SR_INVENTORY_ITEM_ID NUMBER

TIME_AS_DMD_COMP_DATE DATE

TIME_DMD_DATE_ID DATE

TIME_USING_AS_DMD_DATE DATE

AVERAGE_DISCOUNT NUMBER

ASSEMBLY_DEMAND_COMP_DATE DATE

LIST_PRICE NUMBER

ORIGINATION_TYPE NUMBER

SELLING_PRICE NUMBER

STANDARD_COST NUMBER

UOM_CODE VARCHAR2 (3)
USING_ASSEMBLY_DEMAND_DATE DATE

USING_REQUIREMENT_QUANTITY NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

[top of page]

ISC.ISC_DBI_DEMANDS_F does not reference any database object

ISC.ISC_DBI_DEMANDS_F is referenced by following:

APPS
SYNONYM - ISC_DBI_DEMANDS_F

[top of page]

Table: ISC_DBI_EXCEPTION_DETAILS_F

Description:
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER

EXCEPTION_DETAIL_ID NUMBER

DEPARTMENT_ID NUMBER

ORGANIZATION_ID NUMBER

RESOURCE_ID NUMBER

SR_INVENTORY_ITEM_ID NUMBER

SR_SUPPLIER_ID NUMBER

SR_SUPPLIER_SITE_ID NUMBER

EXCEPTION_TYPE NUMBER

NUMBER1 NUMBER

NUMBER2 NUMBER

ORGANIZATION_TYPE NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

[top of page]

ISC.ISC_DBI_EXCEPTION_DETAILS_F does not reference any database object

ISC.ISC_DBI_EXCEPTION_DETAILS_F is referenced by following:

APPS
SYNONYM - ISC_DBI_EXCEPTION_DETAILS_F

[top of page]

Table: ISC_DBI_FM_0001_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ISC_DBI_FM_0001_MV UNIQUE APPS_TS_SUMMARY SYS_NC00017$
SYS_NC00018$
SYS_NC00019$
SYS_NC00020$
SYS_NC00021$
SYS_NC00022$
SYS_NC00023$
SYS_NC00024$
SYS_NC00025$
SYS_NC00026$
SYS_NC00027$
ISC_DBI_FM_0001_MV_N1 NONUNIQUE APPS_TS_SUMMARY TIME_ID
PERIOD_TYPE_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
CUSTOMER_ID
ITEM_CATEGORY_ID
ISC_DBI_FM_0001_MV_N2 NONUNIQUE APPS_TS_SUMMARY TIME_ID
PERIOD_TYPE_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
ITEM_ID
CUSTOMER_ID
ISC_DBI_FM_0001_MV_N3 NONUNIQUE APPS_TS_SUMMARY TIME_ID
PERIOD_TYPE_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
ITEM_CATEGORY_ID
INV_ORG_ID
Columns
Name Datatype Length Mandatory Comments
INV_ORG_ID NUMBER

Inventory Organization Identifier
ITEM_ID VARCHAR2 (81)
Item Organization Identifier
CUSTOMER_ID NUMBER

Customer Identifier
ITEM_CATEGORY_ID NUMBER

Inventory Category Identifier
GRP_ID NUMBER

Grouping ID Column
ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item Dimension
CUSTOMER_FLAG NUMBER

Grouping ID Column for Customer Dimension
TIME_ID NUMBER

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Nested Grouping ID Column for Time
DAY_ID NUMBER

FII Day Identifier
WEEK_ID NUMBER

FII Week Identifier
ENT_PERIOD_ID NUMBER

Enterprise Period Identifier
ENT_QTR_ID NUMBER

Enterprise Quarter Identifier
SCHEDULE_LINE_CNT NUMBER

Count of Scheduled Order Lines
SCHEDULE_L_C NUMBER

Count Column
CNT NUMBER

Row Count

[top of page]

APPS.ISC_DBI_FM_0001_MV does not reference any database object

APPS.ISC_DBI_FM_0001_MV is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_FM_0001_MV

[top of page]

Table: ISC_DBI_FM_0003_MV

Description:
Indexes
Index Type Tablespace Column
ISC_DBI_FM_0003_MV_N1 NONUNIQUE APPS_TS_SUMMARY TIME_SHIPPED_DATE_ID
CUSTOMER_ID
ITEM_CATEGORY_ID
ISC_DBI_FM_0003_MV_N2 NONUNIQUE APPS_TS_SUMMARY TIME_SHIPPED_DATE_ID
ITEM_ID
CUSTOMER_ID
ISC_DBI_FM_0003_MV_N3 NONUNIQUE APPS_TS_SUMMARY TIME_SHIPPED_DATE_ID
ITEM_CATEGORY_ID
INV_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_SHIPPED_DATE_ID DATE

Actual Shipment Date of the line
LATE_LINE_CNT NUMBER

Count Column
DAYS_LATE_PROMISE NUMBER

Count of Days Late (to promise)
DAYS_LATE NUMBER

Count of Days Late (to schedule)
BOOK_TO_SHIP_DAYS NUMBER

Count of Days between booked date and shipped date
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
UOM VARCHAR2 (30)
Unit Of Measure Code
SHIPPED_LATE_QTY NUMBER

Shipped Late Quantity
LINE_NUMBER VARCHAR2 (240)
Line sequence number within the order
FACT_ROWID ROWID (10)
Row ID of ISC_BOOK_SUM2_F table
ITEM_ROWID ROWID (10)
Row ID of ENI_OLTP_ITEM_STAR table

[top of page]

APPS.ISC_DBI_FM_0003_MV does not reference any database object

APPS.ISC_DBI_FM_0003_MV is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_FM_0003_MV

[top of page]

Table: ISC_DBI_FM_0006_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ISC_DBI_FM_0006_MV UNIQUE APPS_TS_SUMMARY SYS_NC00077$
SYS_NC00078$
SYS_NC00079$
SYS_NC00080$
SYS_NC00081$
SYS_NC00082$
SYS_NC00083$
SYS_NC00084$
SYS_NC00085$
ISC_DBI_FM_0006_MV_N1 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
CUSTOMER_ID
ITEM_CATEGORY_ID
ISC_DBI_FM_0006_MV_N2 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
ITEM_ID
CUSTOMER_ID
ISC_DBI_FM_0006_MV_N3 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
ITEM_CAT_FLAG
CUSTOMER_FLAG
ITEM_CATEGORY_ID
INV_ORG_ID
Columns
Name Datatype Length Mandatory Comments
INV_ORG_ID NUMBER

Inventory Organization Identifier
CUSTOMER_ID NUMBER

Customer Identifier
ITEM_ID VARCHAR2 (81)
Item Organization Identifier
ITEM_CATEGORY_ID NUMBER

Inventory Category Identifier
TIME_SNAPSHOT_DATE_ID DATE

Date on which the snapshot was taken
UOM VARCHAR2 (30)
Unit Of Measure Code
GRP_ID NUMBER

Grouping ID Column
ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item Dimension
CUSTOMER_FLAG NUMBER

Grouping ID Column for Customer Dimension
DAYS_LATE NUMBER

Count of Days Late (to Schedule)
DAYS_LATE_CNT NUMBER

Count Column
PDUE_LINE_CNT NUMBER

Count of Past Due Schedule Order Lines
PDUE_LINE_CNT_C 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

Count of Days Late (to schedule) for Bucket1
BUCKET2_DAYS_LATE NUMBER

Count of Days Late (to schedule) for Bucket2
BUCKET3_DAYS_LATE NUMBER

Count of Days Late (to schedule) for Bucke3
BUCKET4_DAYS_LATE NUMBER

Count of Days Late (to schedule) for Bucket4
BUCKET5_DAYS_LATE NUMBER

Count of Days Late (to schedule) for Bucket5
BUCKET6_DAYS_LATE NUMBER

Count of Days Late (to schedule) for Bucket6
BUCKET7_DAYS_LATE NUMBER

Count of Days Late (to schedule) for Bucket7
BUCKET8_DAYS_LATE NUMBER

Count of Days Late (to schedule) for Bucket8
BUCKET9_DAYS_LATE NUMBER

Count of Days Late (to schedule) for Bucket9
BUCKET10_DAYS_LATE NUMBER

Count of Days Late (to schedule) 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
LINES_CNT NUMBER

Row Count

[top of page]

APPS.ISC_DBI_FM_0006_MV does not reference any database object

APPS.ISC_DBI_FM_0006_MV is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_FM_0006_MV

[top of page]

Table: ISC_DBI_FM_0007_MV

Description:
Indexes
Index Type Tablespace Column
ISC_DBI_FM_0007_MV_N1 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
CUSTOMER_ID
ITEM_CATEGORY_ID
ISC_DBI_FM_0007_MV_N2 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
ITEM_ID
CUSTOMER_ID
ISC_DBI_FM_0007_MV_N3 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
ITEM_CATEGORY_ID
INV_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

[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:

APPS
MATERIALIZED VIEW - ISC_DBI_FM_0007_MV

[top of page]

Table: ISC_DBI_FM_0008_MV

Description:
Indexes
Index Type Tablespace Column
ISC_DBI_FM_0008_MV_N1 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
CUSTOMER_ID
ITEM_CATEGORY_ID
ISC_DBI_FM_0008_MV_N2 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
ITEM_ID
CUSTOMER_ID
ISC_DBI_FM_0008_MV_N3 NONUNIQUE APPS_TS_SUMMARY TIME_SNAPSHOT_DATE_ID
ITEM_CATEGORY_ID
INV_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
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

Count of Past Due Schedule Lines
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

Count of Day Late (to schedule)
TIME_SNAPSHOT_DATE_ID DATE

Date on which the snapshot was taken
PDUE_ROWID ROWID (10)
Row ID of ISC_BOOK_SUM2_PDUE_F table
ITEM_ROWID ROWID (10)
Row ID of ENI_OLTP_ITEM_STAR table
MARKER NUMBER

Union Marker Column

[top of page]

APPS.ISC_DBI_FM_0008_MV does not reference any database object

APPS.ISC_DBI_FM_0008_MV is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_FM_0006_MV
MATERIALIZED VIEW - ISC_DBI_FM_0008_MV

[top of page]

Table: ISC_DBI_FULL_PEGGING_F

Description:
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER

PEGGING_ID NUMBER

DEMAND_ID NUMBER

END_PEGGING_ID NUMBER

TRANSACTION_ID NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

[top of page]

ISC.ISC_DBI_FULL_PEGGING_F does not reference any database object

ISC.ISC_DBI_FULL_PEGGING_F is referenced by following:

APPS
SYNONYM - ISC_DBI_FULL_PEGGING_F

[top of page]

Table: ISC_DBI_INV_DETAIL_F

Description:
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER

ORGANIZATION_ID NUMBER

SR_INVENTORY_ITEM_ID NUMBER

TIME_DETAIL_DATE_ID DATE

CARRYING_COST NUMBER

DETAIL_DATE DATE

INVENTORY_COST NUMBER

MDS_COST NUMBER

MDS_PRICE NUMBER

MDS_QUANTITY NUMBER

PRODUCTION_COST NUMBER

PURCHASING_COST NUMBER

UOM_CODE VARCHAR2 (3)
CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

[top of page]

ISC.ISC_DBI_INV_DETAIL_F does not reference any database object

ISC.ISC_DBI_INV_DETAIL_F is referenced by following:

APPS
SYNONYM - ISC_DBI_INV_DETAIL_F

[top of page]

Table: ISC_DBI_INV_DETAIL_SNAPSHOTS

Description: Base summary table for the Plan Management page, built mainly on the MSC_BIS_INV_DETAIL, MSD_DEMANDS and MSC_EXCEPTION_DETAILS tables. The base table contains the following dimensions: item, organization, plan snapshot, and time. It contain
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_ID NUMBER

ORGANIZATION_ID NUMBER

SR_INVENTORY_ITEM_ID NUMBER

START_DATE DATE

PERIOD_TYPE_ID NUMBER

CARRYING_COST NUMBER

CARRYING_COST_G NUMBER

COST_SHORTFALL NUMBER

COST_SHORTFALL_G NUMBER

INVENTORY_COST NUMBER

INVENTORY_COST_G NUMBER

LATE_LINES NUMBER

MDS_COST NUMBER

MDS_COST_G NUMBER

MDS_PRICE NUMBER

MDS_PRICE_G NUMBER

MDS_QUANTITY NUMBER

PRODUCTION_COST NUMBER

PRODUCTION_COST_G NUMBER

PURCHASING_COST NUMBER

PURCHASING_COST_G NUMBER

REV_SHORTFALL NUMBER

REV_SHORTFALL_G NUMBER

TOTAL_LINES NUMBER

UOM_CODE VARCHAR2 (3)
UNION1_FLAG NUMBER

UNION2_FLAG NUMBER

CARRYING_COST_G1 NUMBER

Carrying Cost in Secondary Global Currency
COST_SHORTFALL_G1 NUMBER

Potential Cost Shortfall in Secondary Global Currency
INVENTORY_COST_G1 NUMBER

Inventory Cost in Secondary Global Currency
MDS_COST_G1 NUMBER

MDS Cost in Secondary Global Currency
MDS_PRICE_G1 NUMBER

MDS Price in Secondary Global Currency
PRODUCTION_COST_G1 NUMBER

Production Cost in Secondary Global Currency
PURCHASING_COST_G1 NUMBER

Purchasing Cost in Secondary Global Currency
REV_SHORTFALL_G1 NUMBER

Potential Revenue Shortfall in Secondary Global Currency

[top of page]

ISC.ISC_DBI_INV_DETAIL_SNAPSHOTS does not reference any database object

ISC.ISC_DBI_INV_DETAIL_SNAPSHOTS is referenced by following:

APPS
SYNONYM - ISC_DBI_INV_DETAIL_SNAPSHOTS
MATERIALIZED VIEW - ISC_DBI_PM_0001_MV

[top of page]

Table: ISC_DBI_PM_0000_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ISC_DBI_PM_0000_MV UNIQUE APPS_TS_SUMMARY SYS_NC00017$
SYS_NC00018$
SYS_NC00019$
SYS_NC00020$
SYS_NC00021$
SYS_NC00022$
SYS_NC00023$
SYS_NC00024$
SYS_NC00025$
ISC_DBI_PM_0000_MV_N1 NONUNIQUE APPS_TS_SUMMARY START_DATE
SNAPSHOT_ID
PERIOD_TYPE_ID
ITEM_CAT_FLAG
ITEM_ID
SR_SUPPLIER_ID
ISC_DBI_PM_0000_MV_N2 NONUNIQUE APPS_TS_SUMMARY START_DATE
SNAPSHOT_ID
PERIOD_TYPE_ID
ITEM_CAT_FLAG
SR_SUPPLIER_ID
ITEM_CATEGORY_ID
ORGANIZATION_ID
ISC_DBI_PM_0000_MV_N3 NONUNIQUE APPS_TS_SUMMARY START_DATE
SNAPSHOT_ID
PERIOD_TYPE_ID
ITEM_CAT_FLAG
ITEM_CATEGORY_ID
ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_ID NUMBER

Plan Snapshot Identifier
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
SR_SUPPLIER_ID NUMBER

Supplier Identifier
ITEM_ID VARCHAR2 (81)
Item Organization Identifier
ITEM_CATEGORY_ID NUMBER

Inventory Category Identifier
GRP_ID NUMBER

Grouping ID Column
ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item
START_DATE DATE

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Nested Grouping ID Column for Time
PURCHASING_COST NUMBER

Purchasing Cost in Functional Currency
PURCHASING_COST_CNT NUMBER

Count Column
PURCHASING_COST_G NUMBER

Purchasing Cost in Global Currency
PUR_COST_G_CNT NUMBER

Count Column
PURCHASING_COST_G1 NUMBER

Purchasing Cost in Secondary Global Currency
PUR_COST_G1_CNT NUMBER

Count Column
CNT NUMBER

Row Count

[top of page]

APPS.ISC_DBI_PM_0000_MV does not reference any database object

APPS.ISC_DBI_PM_0000_MV is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_PM_0000_MV

[top of page]

Table: ISC_DBI_PM_0001_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ISC_DBI_PM_0001_MV UNIQUE APPS_TS_SUMMARY SYS_NC00070$
SYS_NC00071$
SYS_NC00072$
SYS_NC00073$
SYS_NC00074$
SYS_NC00075$
SYS_NC00076$
SYS_NC00077$
SYS_NC00078$
ISC_DBI_PM_0001_MV_N1 NONUNIQUE APPS_TS_SUMMARY START_DATE
SNAPSHOT_ID
PERIOD_TYPE_ID
ITEM_CAT_FLAG
ITEM_ID
ISC_DBI_PM_0001_MV_N2 NONUNIQUE APPS_TS_SUMMARY START_DATE
SNAPSHOT_ID
PERIOD_TYPE_ID
ITEM_CAT_FLAG
INV_CATEGORY_ID
ORGANIZATION_ID
ISC_DBI_PM_0001_MV_N3 NONUNIQUE APPS_TS_SUMMARY START_DATE
SNAPSHOT_ID
PERIOD_TYPE_ID
ITEM_CAT_FLAG
VBH_CATEGORY_ID
ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_ID NUMBER

Plan Snapshot Identifier
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
ITEM_ID VARCHAR2 (81)
Item Organization Identifier
INV_CATEGORY_ID NUMBER

Inventory Category Identifier
VBH_CATEGORY_ID NUMBER

Product Category Identifier
GRP_ID NUMBER

Grouping ID Column
ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item
UOM_CODE VARCHAR2 (3)
Unit of Measure Code
START_DATE DATE

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Nested Grouping ID Column for Time
CARRYING_COST NUMBER

Carrying Cost in Functional Currency
CARRYING_COST_CNT NUMBER

Count Column
CARRYING_COST_G NUMBER

Carrying Cost in Global Currency
CARRYING_COST_G_CNT NUMBER

Count Column
CARRYING_COST_G1 NUMBER

Carrying Cost in Secondary Global Currency
CARRYING_COST_G1_CNT NUMBER

Count Column
COST_SHORTFALL NUMBER

Potential Cost Shortfall in Functional Currency
COST_SH_CNT NUMBER

Count Column
COST_SHORTFALL_G NUMBER

Potential Cost Shortfall in Global Currency
COST_SH_G_CNT NUMBER

Count Column
COST_SHORTFALL_G1 NUMBER

Potential Cost Shortfall in Secondary Global Currency
COST_SH_G1_CNT NUMBER

Count Column
INVENTORY_COST NUMBER

Inventory Cost in Functional Currency
INVENTORY_COST_CNT NUMBER

Count Column
INVENTORY_COST_G NUMBER

Inventory Cost in Global Currency
INVENTORY_COST_G_CNT NUMBER

Count Column
INVENTORY_COST_G1 NUMBER

Inventory Cost in Secondary Global Currency
INVENTORY_COST_G1_CNT NUMBER

Count Column
MDS_COST NUMBER

MDS Cost in Functional Currency
MDS_COST_CNT NUMBER

Count Column
MDS_COST_G NUMBER

MDS Cost in Global Currency
MDS_COST_G_CNT NUMBER

Count Column
MDS_COST_G1 NUMBER

MDS Cost in Secondary Global Currency
MDS_COST_G1_CNT NUMBER

Count Column
MDS_PRICE NUMBER

MDS Price in Functional Currency
MDS_PRICE_CNT NUMBER

Count Column
MDS_PRICE_G NUMBER

MDS Price in Global Currency
MDS_PRICE_G_CNT NUMBER

Count Column
MDS_PRICE_G1 NUMBER

MDS Price in Secondary Global Currency
MDS_PRICE_G1_CNT NUMBER

Count Column
MDS_QUANTITY NUMBER

MDS Quantity
MDS_QUANTITY_CNT NUMBER

Count Column
PRODUCTION_COST NUMBER

Production Cost in Functional Currency
PRODUCTION_COST_CNT NUMBER

Count Column
PRO_COST_G NUMBER

Production Cost in Global Currency
PRO_COST_G_CNT NUMBER

Count Column
PRO_COST_G1 NUMBER

Production Cost in Secondary Global Currency
PRO_COST_G1_CNT NUMBER

Count Column
PURCHASING_COST NUMBER

Purchasing Cost in Functional Currency
PURCHASING_COST_CNT NUMBER

Count Column
PUR_COST_G NUMBER

Purchasing Cost in Global Currency
PUR_COST_G_CNT NUMBER

Count Column
PUR_COST_G1 NUMBER

Purchasing Cost in Secondary Global Currency
PUR_COST_G1_CNT NUMBER

Count Column
LATE_LINES NUMBER

Number of Late Lines
LATE_LINES_CNT NUMBER

Count Column
REV_SHORTFALL NUMBER

Potential Revenue Shortfall in Functional Currency
REV_SH_CNT NUMBER

Count Column
REV_SHORTFALL_G NUMBER

Potential Revenue Shortfall in Global Currency
REV_SH_G_CNT NUMBER

Count Column
REV_SHORTFALL_G1 NUMBER

Potential Revenue Shortfall in Secondary Global Currency
REV_SH_G1_CNT NUMBER

Count Column
TOTAL_LINES NUMBER

Total Number of lines
TOTAL_LINES_CNT NUMBER

Count Column
UNION1_FLAG NUMBER

Union Marker Column
UNION1_FLAG_CNT NUMBER

Count Column
UNION2_FLAG NUMBER

Union Marker Column
UNION2_FLAG_CNT NUMBER

Count Column
CNT NUMBER

Row Count

[top of page]

APPS.ISC_DBI_PM_0001_MV does not reference any database object

APPS.ISC_DBI_PM_0001_MV is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_PM_0001_MV
MATERIALIZED VIEW - ISC_DBI_PM_0003_MV

[top of page]

Table: ISC_DBI_PM_0002_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ISC_DBI_PM_0002_MV UNIQUE APPS_TS_SUMMARY SYS_NC00015$
SYS_NC00016$
SYS_NC00017$
SYS_NC00018$
SYS_NC00019$
SYS_NC00020$
SYS_NC00021$
SYS_NC00022$
ISC_DBI_PM_0002_MV_N1 NONUNIQUE APPS_TS_SUMMARY START_DATE
SNAPSHOT_ID
PERIOD_TYPE_ID
RES_GP_FLAG
RESOURCE_ID
DEPARTMENT_ID
ORGANIZATION_ID
ISC_DBI_PM_0002_MV_N2 NONUNIQUE APPS_TS_SUMMARY START_DATE
SNAPSHOT_ID
PERIOD_TYPE_ID
RES_GP_FLAG
DEPARTMENT_ID
RESOURCE_GROUP_ID
ISC_DBI_PM_0002_MV_N3 NONUNIQUE APPS_TS_SUMMARY START_DATE
SNAPSHOT_ID
PERIOD_TYPE_ID
RES_GP_FLAG
RESOURCE_GROUP_ID
ORGANIZATION_ID
ISC_DBI_PM_0002_MV_N4 NONUNIQUE APPS_TS_SUMMARY START_DATE
SNAPSHOT_ID
PERIOD_TYPE_ID
RES_GP_FLAG
ORGANIZATION_ID
RESOURCE_ID
Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_ID NUMBER

Plan Snapshot Identifier
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
RESOURCE_ID VARCHAR2 (122)
Manufacturing Resource Identifier
DEPARTMENT_ID VARCHAR2 (42)
Manufacturing Department Identifier
RESOURCE_GROUP_ID VARCHAR2 (32)
Manufacturing Resource Group Identifier
GRP_ID NUMBER

Grouping ID Column
RES_GP_FLAG NUMBER

Grouping ID Column for Resource
START_DATE DATE

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Nested Grouping ID Column for Time
REQUIRED_HOURS NUMBER

Resource Required Hours
REQUIRED_HOURS_CNT NUMBER

Count Column
AVAILABLE_HOURS NUMBER

Resource Available Hours
AVAILABLE_HOURS_CNT NUMBER

Count Column
CNT NUMBER

Row Count

[top of page]

APPS.ISC_DBI_PM_0002_MV does not reference any database object

APPS.ISC_DBI_PM_0002_MV is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_PM_0002_MV

[top of page]

Table: ISC_DBI_PM_0003_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ISC_DBI_PM_0003_MV UNIQUE APPS_TS_SUMMARY SYS_NC00020$
SYS_NC00021$
SYS_NC00022$
SYS_NC00023$
SYS_NC00024$
ISC_DBI_PM_0003_MV_N1 NONUNIQUE APPS_TS_SUMMARY START_DATE
SNAPSHOT_ID
PERIOD_TYPE_ID
PARENT_ID
ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_ID NUMBER

Plan Snapshot Identifier
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
PARENT_ID NUMBER

Product Category Identifier
GRP_ID NUMBER

Grouping ID Column
START_DATE DATE

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Nested Grouping ID Column for Time
MDS_COST NUMBER

MDS Cost in Functional Currency
MDS_COST_CNT NUMBER

Count Column
MDS_COST_G NUMBER

MDS Cost in Global Currency
MDS_COST_G_CNT NUMBER

Count Column
MDS_COST_G1 NUMBER

MDS Cost in Secondary Global Currency
MDS_COST_G1_CNT NUMBER

Count Column
MDS_PRICE NUMBER

MDS Price in Functional Currency
MDS_PRICE_CNT NUMBER

Count Column
MDS_PRICE_G NUMBER

MDS Price in Global Currency
MDS_PRICE_G_CNT NUMBER

Count Column
MDS_PRICE_G1 NUMBER

MDS Price in Secondary Global Currency
MDS_PRICE_G1_CNT NUMBER

Count Column
CNT NUMBER

Row Count

[top of page]

APPS.ISC_DBI_PM_0003_MV does not reference any database object

APPS.ISC_DBI_PM_0003_MV is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_PM_0003_MV

[top of page]

Table: ISC_DBI_PM_0004_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ISC_DBI_PM_0004_MV UNIQUE APPS_TS_SUMMARY SYS_NC00023$
SYS_NC00024$
SYS_NC00025$
SYS_NC00026$
SYS_NC00027$
SYS_NC00028$
SYS_NC00029$
SYS_NC00030$
ISC_DBI_PM_0004_MV_N1 NONUNIQUE APPS_TS_SUMMARY START_DATE
SNAPSHOT_ID
PERIOD_TYPE_ID
R_RESOURCE_ID
ORGANIZATION_ID
ISC_DBI_PM_0004_MV_N2 NONUNIQUE APPS_TS_SUMMARY START_DATE
SNAPSHOT_ID
PERIOD_TYPE_ID
R_ORG_ID
R_RESOURCE_ID
Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_ID NUMBER

Plan Snapshot Identifier
DMD_ITEM_ID NUMBER

Demand Item Identifier
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
R_RESOURCE_ID VARCHAR2 (122)
Manufacturing Resource Identifier
R_ORG_ID NUMBER

Manufacturing Resource Organization Identifier
R_DEPARTMENT_ID VARCHAR2 (42)
Manufacturing Department Identifier
START_DATE DATE

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Nested Grouping ID Column for Time
GRP_ID NUMBER

Grouping ID Column
REV_SHORTFALL NUMBER

Potential Revenue Shortfall in Functional Currency
REV_SHORTFALL_CNT NUMBER

Count Column
REV_SHORTFALL_G NUMBER

Potential Revenue Shortfall in Global Currency
REV_SHORTFALL_G_CNT NUMBER

Count Column
REV_SHORTFALL_G1 NUMBER

Potential Revenue Shortfall in Secondary Global Currency
REV_SHORTFALL_G1_CNT NUMBER

Count Column
COST_SHORTFALL NUMBER

Potential Cost Shortfall in Functional Currency
COST_SHORTFALL_CNT NUMBER

Count Column
COST_SHORTFALL_G NUMBER

Potential Cost Shortfall in Global Currency
COST_SHORTFALL_G_CNT NUMBER

Count Column
COST_SHORTFALL_G1 NUMBER

Potential Cost Shortfall in Secondary Global Currency
COST_SHORTFALL_G1_CNT NUMBER

Count Column
CNT NUMBER

Row Count

[top of page]

APPS.ISC_DBI_PM_0004_MV does not reference any database object

APPS.ISC_DBI_PM_0004_MV is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_PM_0004_MV

[top of page]

Table: ISC_DBI_RES_SUMMARY_F

Description:
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
DEPARTMENT_ID NUMBER

ORGANIZATION_ID NUMBER

PLAN_ID NUMBER

RESOURCE_ID NUMBER

TIME_RESOURCE_DATE_ID DATE

AVAILABLE_HOURS NUMBER

ORGANIZATION_TYPE NUMBER

REQUIRED_HOURS NUMBER

RESOURCE_DATE DATE

UTILIZATION NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

[top of page]

ISC.ISC_DBI_RES_SUMMARY_F does not reference any database object

ISC.ISC_DBI_RES_SUMMARY_F is referenced by following:

APPS
SYNONYM - ISC_DBI_RES_SUMMARY_F

[top of page]

Table: ISC_DBI_RES_SUM_SNAPSHOTS

Description:
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_ID NUMBER

ORGANIZATION_ID NUMBER

START_DATE DATE

PERIOD_TYPE_ID NUMBER

DEPARTMENT_ID NUMBER

ORGANIZATION_TYPE NUMBER

RESOURCE_ID NUMBER

AVAILABLE_HOURS NUMBER

REQUIRED_HOURS NUMBER

[top of page]

ISC.ISC_DBI_RES_SUM_SNAPSHOTS does not reference any database object

ISC.ISC_DBI_RES_SUM_SNAPSHOTS is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_PM_0002_MV
SYNONYM - ISC_DBI_RES_SUM_SNAPSHOTS

[top of page]

Table: ISC_DBI_SHORTFALL_SNAPSHOTS

Description: Base summary table for the Plan Management page, built mainly on the MSC_DEMANDS, MSC_EXCEPTION_DETAILS, and MSC_FULL_PEGGING tables. The base table contains the following dimensions: demand item, organization, item, resource, plan snapshot
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
ISC_DBI_SHORTFALL_SNAPSHOTS_N1 NONUNIQUE APPS_TS_SUMMARY START_DATE
PERIOD_TYPE_ID
REASON_TYPE
SNAPSHOT_ID
ISC_DBI_SHORTFALL_SNAPSHOTS_N2 NONUNIQUE APPS_TS_SUMMARY ORGANIZATION_ID
ISC_DBI_SHORTFALL_SNAPSHOTS_N3 NONUNIQUE APPS_TS_SUMMARY R_ITEM_ID
R_ORG_ID
ISC_DBI_SHORTFALL_SNAPSHOTS_N4 NONUNIQUE APPS_TS_SUMMARY R_SUPPLIER_ID
Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_ID NUMBER

DMD_ITEM_ID NUMBER

ORGANIZATION_ID NUMBER

PERIOD_TYPE_ID NUMBER

R_DEPARTMENT_ID NUMBER

R_ITEM_ID NUMBER

R_ORG_ID NUMBER

R_RESOURCE_ID NUMBER

R_SUPPLIER_ID NUMBER

R_SUPPLIER_SITE_ID NUMBER

START_DATE DATE

COST_SHORTFALL NUMBER

COST_SHORTFALL_G NUMBER

COST_TEMP NUMBER

COST_TEMP_G NUMBER

LATE_LINES_TEMP NUMBER

ORGANIZATION_TYPE NUMBER

REASON_TYPE NUMBER

REV_SHORTFALL NUMBER

REV_SHORTFALL_G NUMBER

REV_TEMP NUMBER

REV_TEMP_G NUMBER

TOTAL_LINES_TEMP NUMBER

UOM_CODE VARCHAR2 (3)
COST_SHORTFALL_G1 NUMBER

Potential Cost Shortfall amount in Secondary Global Currency
COST_TEMP_G1 NUMBER

Cost amount in Secondary Global Currency
REV_SHORTFALL_G1 NUMBER

Potential Revenue Shortfall amount in Secondary Global Currency
REV_TEMP_G1 NUMBER

Revenue amount in Secondary Global Currency

[top of page]

ISC.ISC_DBI_SHORTFALL_SNAPSHOTS does not reference any database object

ISC.ISC_DBI_SHORTFALL_SNAPSHOTS is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_PM_0004_MV
SYNONYM - ISC_DBI_SHORTFALL_SNAPSHOTS

[top of page]

Table: ISC_DBI_SUPPLIES_F

Description:
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER

TRANSACTION_ID NUMBER

ORGANIZATION_ID NUMBER

SR_INVENTORY_ITEM_ID NUMBER

SR_INSTANCE_ID NUMBER

SR_SUPPLIER_ID NUMBER

TIME_NEW_SCH_DATE_ID DATE

BOM_ITEM_TYPE NUMBER

DISPOSITION_STATUS_TYPE NUMBER

IN_SOURCE_PLAN NUMBER

ITEM_PRICE NUMBER

NEW_ORDER_QUANTITY NUMBER

NEW_PROCESSING_DAYS NUMBER

NEW_SCHEDULE_DATE DATE

ORDER_TYPE NUMBER

PLANNING_MAKE_BUY_CODE NUMBER

R_CFM_ROUTING_FLAG NUMBER

SOURCE_ORGANIZATION_ID NUMBER

SOURCE_SR_INSTANCE_ID NUMBER

SOURCE_SUPPLIER_ID NUMBER

SOURCE_SUPPLIER_SITE_ID NUMBER

STANDARD_COST NUMBER

SUPPLIER_ID NUMBER

SUPPLIER_SITE_ID NUMBER

UOM_CODE VARCHAR2 (3)
CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

[top of page]

ISC.ISC_DBI_SUPPLIES_F does not reference any database object

ISC.ISC_DBI_SUPPLIES_F is referenced by following:

APPS
SYNONYM - ISC_DBI_SUPPLIES_F

[top of page]

Table: ISC_DBI_SUPPLIES_SNAPSHOTS

Description: Base summary table for the Plan Management page, built mainly on MSC_SUPPLIES table. The base table contains the following dimensions: item, supplier, organization, plan snapshot, and time. It also contains the purchasing cost in the global
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_ID NUMBER

SR_INVENTORY_ITEM_ID NUMBER

ORGANIZATION_ID NUMBER

PERIOD_TYPE_ID NUMBER

SR_SUPPLIER_ID NUMBER

START_DATE DATE

PURCHASING_COST NUMBER

PURCHASING_COST_G NUMBER

UOM_CODE VARCHAR2 (3)
PURCHASING_COST_G1 NUMBER

Purchasing Cost in Secondary Global Currency

[top of page]

ISC.ISC_DBI_SUPPLIES_SNAPSHOTS does not reference any database object

ISC.ISC_DBI_SUPPLIES_SNAPSHOTS is referenced by following:

APPS
MATERIALIZED VIEW - ISC_DBI_PM_0000_MV
SYNONYM - ISC_DBI_SUPPLIES_SNAPSHOTS

[top of page]

Table: ISC_EDW_BACKLOGS_F

Description: Backlog Snapshot fact table
Comments

This fact table stores the daily status of the Sales Order Backlog activity. It maintains
a history of measures by taking a daily snapshot of backlog situation. Using this fact
table, users can perform trend analysis on backlog balances. They can also analyze
potential margin due to backlog in billing or shipment. Data is retrieved from the
Sales Order Headers, Sales Order Lines, and Sales Order Line Details (Oracle Order
Entry) and is kept at the day + dimensions combination level. The measures
available in this fact table are Quantity, Cost, Value (at Sell Price), and Margin for
the Shipping Backlog (Booked not Shipped), the Delinquent Backlog (Scheduled but
not Shipped), the Unbilled Shipment Backlog (Shipped but not Billed), the Billing
Backlog (Booked but not Billed) expressed in Base UoM (Quantities), and both
original Transaction Currency and Global Warehouse Currency (monetary
amounts). Backlog measures can be aggregated by Item, Order Category, Trading
Partner, Geography, Project, Demand Class, Time, Internal Organization, Set of Books,
Order Source, Order Type, Sales Channel, Person, Unit of Measure, Instance, and Currency.

Indexes
Index Type Tablespace Column
ISC_EDW_BACKLOGS_F_U1 UNIQUE APPS_TS_SUMMARY BACKLOGS_PK
ISC_EDW_BACKLOGS_F_N1 NONUNIQUE APPS_TS_SUMMARY ORDER_TYPE_FK_KEY
ISC_EDW_BACKLOGS_F_N10 NONUNIQUE APPS_TS_SUMMARY BASE_UOM_FK_KEY
ISC_EDW_BACKLOGS_F_N11 NONUNIQUE APPS_TS_SUMMARY INV_ORG_FK_KEY
ISC_EDW_BACKLOGS_F_N12 NONUNIQUE APPS_TS_SUMMARY TASK_FK_KEY
ISC_EDW_BACKLOGS_F_N13 NONUNIQUE APPS_TS_SUMMARY DATE_BALANCE_FK_KEY
ISC_EDW_BACKLOGS_F_N14 NONUNIQUE APPS_TS_SUMMARY BILL_TO_CUST_FK_KEY
ISC_EDW_BACKLOGS_F_N15 NONUNIQUE APPS_TS_SUMMARY CUSTOMER_FK_KEY
ISC_EDW_BACKLOGS_F_N17 NONUNIQUE APPS_TS_SUMMARY GL_SET_OF_BOOKS_FK_KEY
ISC_EDW_BACKLOGS_F_N18 NONUNIQUE APPS_TS_SUMMARY ITEM_ORG_FK_KEY
ISC_EDW_BACKLOGS_F_N19 NONUNIQUE APPS_TS_SUMMARY TOP_MODEL_ITEM_FK_KEY
ISC_EDW_BACKLOGS_F_N2 NONUNIQUE APPS_TS_SUMMARY SHIP_TO_CUST_FK_KEY
ISC_EDW_BACKLOGS_F_N20 NONUNIQUE APPS_TS_SUMMARY SALES_CHANNEL_FK_KEY
ISC_EDW_BACKLOGS_F_N21 NONUNIQUE APPS_TS_SUMMARY OPERATING_UNIT_FK_KEY
ISC_EDW_BACKLOGS_F_N22 NONUNIQUE APPS_TS_SUMMARY ORDER_CATEGORY_FK_KEY
ISC_EDW_BACKLOGS_F_N3 NONUNIQUE APPS_TS_SUMMARY TRX_CURRENCY_FK_KEY
ISC_EDW_BACKLOGS_F_N4 NONUNIQUE APPS_TS_SUMMARY DEMAND_CLASS_FK_KEY
ISC_EDW_BACKLOGS_F_N5 NONUNIQUE APPS_TS_SUMMARY BILL_TO_LOCATION_FK_KEY
ISC_EDW_BACKLOGS_F_N6 NONUNIQUE APPS_TS_SUMMARY SHIP_TO_LOCATION_FK_KEY
ISC_EDW_BACKLOGS_F_N7 NONUNIQUE APPS_TS_SUMMARY SALES_PERSON_FK_KEY
ISC_EDW_BACKLOGS_F_N8 NONUNIQUE APPS_TS_SUMMARY INSTANCE_FK_KEY
ISC_EDW_BACKLOGS_F_N9 NONUNIQUE APPS_TS_SUMMARY ORDER_SOURCE_FK_KEY
Columns
Name Datatype Length Mandatory Comments
BACKLOGS_PK VARCHAR2 (240)
Unique identifier
BACKLOGS_PK_KEY NUMBER

System generated unique identifier
BASE_UOM_FK_KEY NUMBER

System generated foreign key to the UoM dimension
BILL_TO_CUST_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Bill-to Site)
BILL_TO_LOCATION_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Bill-to Location)
DATE_BALANCE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date of Snapshot)
DEMAND_CLASS_FK_KEY NUMBER

System generated foreign key to the Demand Class dimension
CUSTOMER_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Customer)
GL_SET_OF_BOOKS_FK_KEY NUMBER

System generated foreign key to the Set of Books dimension (GL Set of Book)
INSTANCE_FK_KEY NUMBER

System generated foreign key to the Instance dimension
INV_ORG_FK_KEY NUMBER

System generated foreign key to the Inventory Location dimension (Inventory Organization) from which the Items are issued
ITEM_ORG_FK_KEY NUMBER

System generated foreign key to the Organization Item dimension
OPERATING_UNIT_FK_KEY NUMBER

System generated foreign key to the Internal Organization dimension (Operating Unit)
ORDER_CATEGORY_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Category)
ORDER_SOURCE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Source)
ORDER_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Type)
SALES_CHANNEL_FK_KEY NUMBER

System generated foreign key to the Sales Channel dimension
SALES_PERSON_FK_KEY NUMBER

Reserved for future use
SHIP_TO_CUST_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped
SHIP_TO_LOCATION_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
TASK_FK_KEY NUMBER

System generated foreign key to the Project dimension (Project Task)
TOP_MODEL_ITEM_FK_KEY NUMBER

System generated foreign key to the Item dimension (Top Model Organization Item) when the item is a component in a bill of material (BOM)
TRX_CURRENCY_FK_KEY NUMBER

System generated foreign key to the Currency dimension (Transaction Currency)
BILL_BKLG_COST_G NUMBER

Billing Backlog Cost in Warehouse Currency
BILL_BKLG_COST_T NUMBER

Billing Backlog Cost in Transaction Currency
BILL_BKLG_MRG_G NUMBER

Billing Backlog Gross Margin in Warehouse Currency
BILL_BKLG_MRG_T NUMBER

Billing Backlog Gross Margin in Transaction Currency
BILL_BKLG_REV_G NUMBER

Billing Backlog Revenue in Warehouse Currency
BILL_BKLG_REV_T NUMBER

Billing Backlog Revenue in Transaction Currency
CREATION_DATE DATE

Standard Who column
DLQT_BKLG_COST_G NUMBER

Delinquent Backlog Cost in Warehouse Currency
DLQT_BKLG_COST_T NUMBER

Delinquent Backlog Cost in Transaction Currency
DLQT_BKLG_MRG_T NUMBER

Delinquent Backlog Gross Margin in Transaction Currency
DLQT_BKLG_MRG_G NUMBER

Delinquent Backlog Gross Margin in Warehouse Currency
DLQT_BKLG_REV_G NUMBER

Delinquent Backlog Revenue in Warehouse Currency
DLQT_BKLG_REV_T NUMBER

Delinquent Backlog Revenue in Transaction Currency
INSTANCE VARCHAR2 (40)
Instance
LAST_UPDATE_DATE DATE

Standard Who column
QTY_BILL_BKLG_B NUMBER

Billing Backlog Quantity
QTY_DLQT_BKLG_B NUMBER

Delinquent Backlog Quantity
QTY_SHIP_BKLG_B NUMBER

Shipping Backlog Quantity
QTY_UNBILL_SHIP_B NUMBER

Unbilled Shipments Backlog Quantity
SHIP_BKLG_COST_G NUMBER

Shipping Backlog Cost in Warehouse Currency
SHIP_BKLG_COST_T NUMBER

Shipping Backlog Cost in Transaction Currency
SHIP_BKLG_MRG_G NUMBER

Shipping Backlog Gross Margin in Warehouse Currency
SHIP_BKLG_MRG_T NUMBER

Shipping Backlog Gross Margin in Transaction Currency
SHIP_BKLG_REV_G NUMBER

Shipping Backlog Revenue in Warehouse Currency
SHIP_BKLG_REV_T NUMBER

Shipping Backlog Revenue in Transaction Currency
UNBILL_SHIP_COST_G NUMBER

Unbilled Shipments Cost in Warehouse Currency
UNBILL_SHIP_COST_T NUMBER

Unbilled Shipments Cost in Transaction Currency
UNBILL_SHIP_MRG_G NUMBER

Unbilled Shipments Gross Margin in Warehouse Currency
UNBILL_SHIP_MRG_T NUMBER

Unbilled Shipments Gross Margin in Transaction Currency
UNBILL_SHIP_REV_G NUMBER

Unbilled Shipments Revenue in Warehouse Currency
UNBILL_SHIP_REV_T NUMBER

Unbilled Shipments Gross Margin in Transaction Currency
USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE6 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE7 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE8 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE9 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE10 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE11 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE12 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE13 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE14 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE15 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE16 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE17 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE18 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE19 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE20 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE21 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE22 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE23 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE24 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE25 VARCHAR2 (240)
User defined attribute
USER_FK1_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK2_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK3_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK4_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK5_KEY NUMBER

System generated foreign key to user defined dimension
USER_MEASURE1 NUMBER

User defined measure
USER_MEASURE2 NUMBER

User defined measure
USER_MEASURE3 NUMBER

User defined measure
USER_MEASURE4 NUMBER

User defined measure
USER_MEASURE5 NUMBER

User defined measure

[top of page]

ISC.ISC_EDW_BACKLOGS_F does not reference any database object

ISC.ISC_EDW_BACKLOGS_F is referenced by following:

APPS
SYNONYM - ISC_EDW_BACKLOGS_F

[top of page]

Table: ISC_EDW_BACKLOGS_FSTG

Description: Interface table for the Backlog Snapshot fact
Comments

This is the interface table for the Backlog Snapshot fact table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the fact table.

Indexes
Index Type Tablespace Column
ISC_EDW_BACKLOGS_FSTG_N1 NONUNIQUE APPS_TS_INTERFACE BACKLOGS_PK
ISC_EDW_BACKLOGS_FSTG_N2 NONUNIQUE APPS_TS_INTERFACE COLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
BACKLOGS_PK VARCHAR2 (240)
Unique identifier
BASE_UOM_FK VARCHAR2 (240)
Foreign key to the UoM dimension
BASE_UOM_FK_KEY NUMBER

System generated foreign key to the UoM dimension
BILL_TO_CUST_FK VARCHAR2 (320)
Foreign key to the Trading Partner dimension (Bill-to Site)
BILL_TO_CUST_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Bill-to Site)
BILL_TO_LOCATION_FK VARCHAR2 (240)
System generated foreign key to the Geography dimension (Bill-to Location)
BILL_TO_LOCATION_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Bill-to Location)
CUSTOMER_FK VARCHAR2 (240)
Foreign key to the Trading Partner dimension (Customer)
CUSTOMER_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Customer)
DATE_BALANCE_FK VARCHAR2 (240)
Foreign key to the Time dimension (Date of Snapshot)
DATE_BALANCE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date of Snapshot)
DEMAND_CLASS_FK VARCHAR2 (240)
Foreign key to the Demand Class dimension
DEMAND_CLASS_FK_KEY NUMBER

System generated foreign key to the Demand Class dimension
GL_BOOK_FK VARCHAR2 (240)
Foreign key to the Set of Books dimension (GL Set of Book)
GL_BOOK_FK_KEY NUMBER

System generated foreign key to the Set of Books dimension (GL Set of Book)
INSTANCE_FK VARCHAR2 (240)
Foreign key to the Instance dimension
INSTANCE_FK_KEY NUMBER

System generated foreign key to the Instance dimension
INV_ORG_FK VARCHAR2 (240)
Foreign key to the Inventory Location dimension (Inventory Organization) from which the Items are issued
INV_ORG_FK_KEY NUMBER

System generated foreign key to the Inventory Location dimension (Inventory Organization) from which the Items are issued
ITEM_ORG_FK VARCHAR2 (320)
Foreign key to the Organization Item dimension
ITEM_ORG_FK_KEY NUMBER

System generated foreign key to the Organization Item dimension
OPERATING_UNIT_FK VARCHAR2 (240)
Foreign key to the Internal Organization dimension (Operating Unit)
OPERATING_UNIT_FK_KEY NUMBER

System generated foreign key to the Internal Organization dimension (Operating Unit)
ORDER_CATEGORY_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Sales Order Category)
ORDER_CATEGORY_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Category)
ORDER_SOURCE_FK VARCHAR2 (240)
Foreign key to the Sales Order Source dimension
ORDER_SOURCE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Source)
ORDER_TYPE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Sales Order Type)
ORDER_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Type)
SALES_CHANNEL_FK VARCHAR2 (240)
Foreign key to the Sales Channel dimension
SALES_CHANNEL_FK_KEY NUMBER

System generated foreign key to the Sales Channel dimension
SALES_PERSON_FK VARCHAR2 (320)
Reserved for future use
SALES_PERSON_FK_KEY NUMBER

Reserved for future use
SHIP_TO_CUST_FK VARCHAR2 (320)
Foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped
SHIP_TO_CUST_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped
SHIP_TO_LOCATION_FK VARCHAR2 (320)
Foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
SHIP_TO_LOCATION_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
TASK_FK VARCHAR2 (240)
Foreign key to the Project dimension (Project Task)
TASK_FK_KEY NUMBER

System generated foreign key to the Project dimension (Project Task)
TOP_MODEL_ITEM_FK VARCHAR2 (320)
Foreign key to the Item dimension (Top Model Organization Item) when the item is a component in a bill of material (BOM)
TOP_MODEL_ITEM_FK_KEY NUMBER

System generated foreign key to the Item dimension (Top Model Organization Item) when the item is a component in a bill of material (BOM)
TRX_CURRENCY_FK VARCHAR2 (240)
Foreign key to the Currency dimension (Transaction Currency)
TRX_CURRENCY_FK_KEY NUMBER

System generated foreign key to the Currency dimension (Transaction Currency)
BILL_BKLG_COST_G NUMBER

Billing Backlog Cost in Warehouse Currency
BILL_BKLG_COST_T NUMBER

Billing Backlog Cost in Transaction Currency
BILL_BKLG_MRG_G NUMBER

Billing Backlog Gross Margin in Warehouse Currency
BILL_BKLG_MRG_T NUMBER

Billing Backlog Gross Margin in Transaction Currency
BILL_BKLG_REV_G NUMBER

Billing Backlog Revenue in Warehouse Currency
BILL_BKLG_REV_T NUMBER

Billing Backlog Revenue in Transaction Currency
DLQT_BKLG_COST_G NUMBER

Delinquent Backlog Cost in Warehouse Currency
DLQT_BKLG_COST_T NUMBER

Delinquent Backlog Cost in Transaction Currency
DLQT_BKLG_MRG_G NUMBER

Delinquent Backlog Gross Margin in Warehouse Currency
DLQT_BKLG_MRG_T NUMBER

Delinquent Backlog Gross Margin in Transaction Currency
DLQT_BKLG_REV_G NUMBER

Delinquent Backlog Revenue in Warehouse Currency
DLQT_BKLG_REV_T NUMBER

Delinquent Backlog Revenue in Transaction Currency
EDW_COLLECTION_DATE DATE

Date on which this row was collected
COLLECTION_STATUS VARCHAR2 (40)
Collection status code for the record
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
INSTANCE VARCHAR2 (40)
Instance
LAST_UPDATE_DATE DATE

Standard Who column
OPERATION_CODE VARCHAR2 (40)
Code used by the collection program to determine whether to insert/update/delete this record
QTY_BILL_BKLG_B NUMBER

Billing Backlog Quantity
QTY_DLQT_BKLG_B NUMBER

Delinquent Backlog Quantity
QTY_SHIP_BKLG_B NUMBER

Shipping Backlog Quantity
QTY_UNBILL_SHIP_B NUMBER

Unbilled Shipments Backlog Quantity
REQUEST_ID NUMBER

Identifier used by collection program
ROW_ID ROWID (10)
Row Id
SHIP_BKLG_COST_G NUMBER

Shipping Backlog Cost in Warehouse Currency
SHIP_BKLG_COST_T NUMBER

Shipping Backlog Cost in Transaction Currency
SHIP_BKLG_MRG_G NUMBER

Shipping Backlog Gross Margin in Warehouse Currency
SHIP_BKLG_MRG_T NUMBER

Shipping Backlog Gross Margin in Transaction Currency
SHIP_BKLG_REV_G NUMBER

Shipping Backlog Revenue in Warehouse Currency
SHIP_BKLG_REV_T NUMBER

Shipping Backlog Revenue in Transaction Currency
UNBILL_SHIP_COST_G NUMBER

Unbilled Shipments Cost in Warehouse Currency
UNBILL_SHIP_COST_T NUMBER

Unbilled Shipments Cost in Transaction Currency
UNBILL_SHIP_MRG_G NUMBER

Unbilled Shipments Gross Margin in Warehouse Currency
UNBILL_SHIP_MRG_T NUMBER

Unbilled Shipments Gross Margin in Transaction Currency
UNBILL_SHIP_REV_G NUMBER

Unbilled Shipments Revenue in Warehouse Currency
UNBILL_SHIP_REV_T NUMBER

Unbilled Shipments Revenue in Transaction Currency
USER_ATTRIBUTE1 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE6 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE7 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE8 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE9 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE10 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE11 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE12 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE13 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE14 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE15 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE16 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE17 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE18 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE19 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE20 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE21 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE22 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE23 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE24 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE25 VARCHAR2 (240)
User attribute
USER_FK1 VARCHAR2 (240)
Foreign key to user defined dimension
USER_FK2 VARCHAR2 (240)
Foreign key to user defined dimension
USER_FK3 VARCHAR2 (240)
Foreign key to user defined dimension
USER_FK4 VARCHAR2 (240)
Foreign key to user defined dimension
USER_FK5 VARCHAR2 (240)
Foreign key to user defined dimension
USER_FK1_KEY NUMBER

System generated key foreign key to user defined dimension
USER_FK2_KEY NUMBER

System generated key foreign key to user defined dimension
USER_FK3_KEY NUMBER

System generated key foreign key to user defined dimension
USER_FK4_KEY NUMBER

System generated key foreign key to user defined dimension
USER_FK5_KEY NUMBER

System generated key foreign key to user defined dimension
USER_MEASURE1 NUMBER

User defined measure
USER_MEASURE2 NUMBER

User defined measure
USER_MEASURE3 NUMBER

User defined measure
USER_MEASURE4 NUMBER

User defined measure
USER_MEASURE5 NUMBER

User defined measure

[top of page]

ISC.ISC_EDW_BACKLOGS_FSTG does not reference any database object

ISC.ISC_EDW_BACKLOGS_FSTG is referenced by following:

APPS
SYNONYM - ISC_EDW_BACKLOGS_FSTG

[top of page]

Table: ISC_EDW_BOOKINGS_F

Description: Bookings fact table
Comments

This fact table stores information collected from Booked Sales Orders as well as
Cancellations and Returns. Data is retrieved from Sales Order Headers and Sales
Order Lines, and is kept at the lowest transaction level. The measures available in
this fact table are Dates (Booked, Requested, Promised, Scheduled, Ordered, Latest
Ship, Latest Pick, Fulfilled ), Quantities (Ordered, Reserved, Shipped, Invoiced, Canceled,
Returned, Fulfilled), expressed in Base Unit of Measure, and Prices (List, Unit Sell, and Cost),
stored in original Transaction Currency as well as in Global Warehouse Currency.
Reference to source transactions (Instance, Order Number, Header Id, Line Id,
Line Detail Id) is also kept. Bookings measures (except for Total Net Order Value) can be
aggregated by Item, Order Category, Trading Partner, Geography, Project, Demand Class, Cancellation Reason, Time, Inventory Organization, Internal Organization, Set of Books,
Order Type, Order Source, Sales Channel, Return Reason, Unit of Measure, Currency, Agreement, Sales Person, Instance, Campaign Schedule, Campaign Status, Marketing Event Offer, Market Segment, Media Channel, Marketing Offer, Marketing Target Segment Level, and Source List.

Indexes
Index Type Tablespace Column
ISC_EDW_BOOKINGS_F_U1 UNIQUE APPS_TS_SUMMARY BOOKINGS_PK
ISC_EDW_BOOKINGS_F_N1 NONUNIQUE APPS_TS_SUMMARY CAMPAIGN_INIT_FK_KEY
ISC_EDW_BOOKINGS_F_N10 NONUNIQUE APPS_TS_SUMMARY TOP_MODEL_FK_KEY
ISC_EDW_BOOKINGS_F_N11 NONUNIQUE APPS_TS_SUMMARY CANCEL_REASON_FK_KEY
ISC_EDW_BOOKINGS_F_N12 NONUNIQUE APPS_TS_SUMMARY ORDER_CATEGORY_FK_KEY
ISC_EDW_BOOKINGS_F_N13 NONUNIQUE APPS_TS_SUMMARY ORDER_TYPE_FK_KEY
ISC_EDW_BOOKINGS_F_N14 NONUNIQUE APPS_TS_SUMMARY MARKET_SEGMENT_FK_KEY
ISC_EDW_BOOKINGS_F_N15 NONUNIQUE APPS_TS_SUMMARY MEDCHN_INIT_FK_KEY
ISC_EDW_BOOKINGS_F_N16 NONUNIQUE APPS_TS_SUMMARY MEDCHN_ACTL_FK_KEY
ISC_EDW_BOOKINGS_F_N17 NONUNIQUE APPS_TS_SUMMARY OFFER_HDR_FK_KEY
ISC_EDW_BOOKINGS_F_N18 NONUNIQUE APPS_TS_SUMMARY OFFER_LINE_FK_KEY
ISC_EDW_BOOKINGS_F_N19 NONUNIQUE APPS_TS_SUMMARY SOURCE_LIST_FK_KEY
ISC_EDW_BOOKINGS_F_N2 NONUNIQUE APPS_TS_SUMMARY CAMPAIGN_ACTL_FK_KEY
ISC_EDW_BOOKINGS_F_N20 NONUNIQUE APPS_TS_SUMMARY INV_ORG_FK_KEY
ISC_EDW_BOOKINGS_F_N21 NONUNIQUE APPS_TS_SUMMARY OPERATING_UNIT_FK_KEY
ISC_EDW_BOOKINGS_F_N22 NONUNIQUE APPS_TS_SUMMARY SALES_PERSON_FK_KEY
ISC_EDW_BOOKINGS_F_N23 NONUNIQUE APPS_TS_SUMMARY TASK_FK_KEY
ISC_EDW_BOOKINGS_F_N24 NONUNIQUE APPS_TS_SUMMARY SALES_CHANNEL_FK_KEY
ISC_EDW_BOOKINGS_F_N25 NONUNIQUE APPS_TS_SUMMARY DATE_BOOKED_FK_KEY
ISC_EDW_BOOKINGS_F_N26 NONUNIQUE APPS_TS_SUMMARY DATE_REQUESTED_FK_KEY
ISC_EDW_BOOKINGS_F_N27 NONUNIQUE APPS_TS_SUMMARY DATE_PROMISED_FK_KEY
ISC_EDW_BOOKINGS_F_N28 NONUNIQUE APPS_TS_SUMMARY DATE_SCHEDULED_FK_KEY
ISC_EDW_BOOKINGS_F_N29 NONUNIQUE APPS_TS_SUMMARY UOM_UOM_FK_KEY
ISC_EDW_BOOKINGS_F_N30 NONUNIQUE APPS_TS_SUMMARY DEMAND_CLASS_FK_KEY
ISC_EDW_BOOKINGS_F_N31 NONUNIQUE APPS_TS_SUMMARY RETURN_REASON_FK_KEY
ISC_EDW_BOOKINGS_F_N32 NONUNIQUE APPS_TS_SUMMARY SET_OF_BOOKS_FK_KEY
ISC_EDW_BOOKINGS_F_N33 NONUNIQUE APPS_TS_SUMMARY ORDER_SOURCE_FK_KEY
ISC_EDW_BOOKINGS_F_N34 NONUNIQUE APPS_TS_SUMMARY BILL_TO_CUST_FK_KEY
ISC_EDW_BOOKINGS_F_N35 NONUNIQUE APPS_TS_SUMMARY SHIP_TO_CUST_FK_KEY
ISC_EDW_BOOKINGS_F_N37 NONUNIQUE APPS_TS_SUMMARY EVENT_OFFER_ACTL_FK_KEY
ISC_EDW_BOOKINGS_F_N38 NONUNIQUE APPS_TS_SUMMARY EVENT_OFFER_INIT_FK_KEY
ISC_EDW_BOOKINGS_F_N39 NONUNIQUE APPS_TS_SUMMARY CUSTOMER_FK_KEY
ISC_EDW_BOOKINGS_F_N4 NONUNIQUE APPS_TS_SUMMARY CURRENCY_TRN_FK_KEY
ISC_EDW_BOOKINGS_F_N40 NONUNIQUE APPS_TS_SUMMARY TARGET_SEGMENT_INIT_FK_KEY
ISC_EDW_BOOKINGS_F_N41 NONUNIQUE APPS_TS_SUMMARY TARGET_SEGMENT_ACTL_FK_KEY
ISC_EDW_BOOKINGS_F_N42 NONUNIQUE APPS_TS_SUMMARY EVENT_OFFER_REG_FK_KEY
ISC_EDW_BOOKINGS_F_N43 NONUNIQUE APPS_TS_SUMMARY AGREEMENT_TYPE_FK_KEY
ISC_EDW_BOOKINGS_F_N44 NONUNIQUE APPS_TS_SUMMARY CAMPAIGN_STATUS_ACTL_FK_KEY
ISC_EDW_BOOKINGS_F_N45 NONUNIQUE APPS_TS_SUMMARY CAMPAIGN_STATUS_INIT_FK_KEY
ISC_EDW_BOOKINGS_F_N47 NONUNIQUE APPS_TS_SUMMARY HEADER_ID
FULFILLMENT_FLAG
ISC_EDW_BOOKINGS_F_N48 NONUNIQUE APPS_TS_SUMMARY FULFILLMENT_FLAG
ISC_EDW_BOOKINGS_F_N6 NONUNIQUE APPS_TS_SUMMARY BILL_TO_LOC_FK_KEY
ISC_EDW_BOOKINGS_F_N7 NONUNIQUE APPS_TS_SUMMARY SHIP_TO_LOC_FK_KEY
ISC_EDW_BOOKINGS_F_N8 NONUNIQUE APPS_TS_SUMMARY INSTANCE_FK_KEY
ISC_EDW_BOOKINGS_F_N9 NONUNIQUE APPS_TS_SUMMARY ITEM_ORG_FK_KEY
Columns
Name Datatype Length Mandatory Comments
BOOKINGS_PK VARCHAR2 (240)
Unique Identifier
BOOKINGS_PK_KEY NUMBER
Y System generated unique identifier
AGREEMENT_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Customer Agreement Type)
BILL_TO_CUST_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Bill-to Site)
BILL_TO_LOC_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Bill-to Location)
CAMPAIGN_ACTL_FK_KEY NUMBER

System generated foreign key to the Campaign Schedule dimension (Campaign Schedule Actual)
CAMPAIGN_INIT_FK_KEY NUMBER

System generated foreign key to the Campaign Schedule dimension (Campaign Schedule Attributed)
CAMPAIGN_STATUS_ACTL_FK_KEY NUMBER

System generated foreign key to the Campaign Status dimension (Campaign Status Actual)
CAMPAIGN_STATUS_INIT_FK_KEY NUMBER

System generated foreign key to the Campaign Status dimension (Campaign Status Attributed)
CANCEL_REASON_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Cancel Reason)
CURRENCY_TRN_FK_KEY NUMBER

System generated foreign key to the Currency dimension (Transaction Currency)
CUSTOMER_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Customer)
DATE_BOOKED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Booked)
DATE_REQUESTED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Requested)
DATE_PROMISED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Promised)
DATE_SCHEDULED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Scheduled)
DEMAND_CLASS_FK_KEY NUMBER

System generated foreign key to the Demand Class Dimension
EVENT_OFFER_ACTL_FK_KEY NUMBER

System generated foreign key to the Marketing Event Offer dimension (Marketing Event Offer Actual)
EVENT_OFFER_INIT_FK_KEY NUMBER

System generated foreign key to the Marketing Event Offer dimension (Marketing Event Offer Attributed)
EVENT_OFFER_REG_FK_KEY NUMBER

System generated foreign key to the Marketing Event Offer dimension (Marketing Event Offer Registration)
INSTANCE_FK_KEY NUMBER

System generated foreign key to the Instance dimension
INV_ORG_FK_KEY NUMBER

System generated foreign key to the Inventory Location dimension (Inventory Organization) from which the Items are issued
ITEM_ORG_FK_KEY NUMBER

System generated foreign key to the Item dimension (Organization Item)
MARKET_SEGMENT_FK_KEY NUMBER

System generated foreign key to the Market Segment dimension
MEDCHN_ACTL_FK_KEY NUMBER

System generated foreign key to the Media Channel dimension (Media Channel Actual)
MEDCHN_INIT_FK_KEY NUMBER

System generated foreign key to the Media Channel dimension (Media Channel Attributed)
OFFER_HDR_FK_KEY NUMBER

System generated foreign key to the Marketing Offer dimension (Header level)
OFFER_LINE_FK_KEY NUMBER

System generated foreign key to the Marketing Offer dimension (Line level)
OPERATING_UNIT_FK_KEY NUMBER

System generated foreign key to the Internal Organization dimension (Operating Unit) where the order was booked
ORDER_CATEGORY_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Category)
ORDER_SOURCE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Source)
ORDER_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Type)
RETURN_REASON_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Return Reason)
SALES_CHANNEL_FK_KEY NUMBER

System generated foreign key to the Sales Channel dimension
SALES_PERSON_FK_KEY NUMBER

Reserved for future use
SET_OF_BOOKS_FK_KEY NUMBER

System generated foreign key to the Set of Books dimension (GL Set of Book)
SHIP_TO_CUST_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped
SHIP_TO_LOC_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
SOURCE_LIST_FK_KEY NUMBER

System generated foreign key to the Source List dimension
TARGET_SEGMENT_ACTL_FK_KEY NUMBER

System generated foreign key to the Marketing Target Segment Level dimension (Marketing Target Segment Level Actual)
TARGET_SEGMENT_INIT_FK_KEY NUMBER

System generated foreign key to the Marketing Target Segment Level dimension (Marketing Target Segment Level Attributed)
TASK_FK_KEY NUMBER

System generated foreign key to the Project dimension (Project Task)
TOP_MODEL_FK_KEY NUMBER

System generated foreign key to the Item dimension (Top Model Organization Item) when the item is a component in a bill of material (BOM)
UOM_UOM_FK_KEY NUMBER

System generated foreign key to the UoM dimension
AGREEMENT_ID VARCHAR2 (80)
Id of the Agreement to which this order relates
BOOKED_DATE DATE

Date Booked
CONFIGURATION_ITEM_FLAG VARCHAR2 (40)
Flag indicating if the item is part of a configuration
CONVERSION_DATE DATE

Currency Conversion Date
CONVERSION_RATE NUMBER

Currency Conversion Rate
CONVERSION_TYPE VARCHAR2 (80)
Currency Conversion Type
CREATION_DATE DATE
Y Standard Who column
CUST_PO_NUMBER VARCHAR2 (80)
Customer's Purchase Order Number
DATE_FULFILLED DATE

Date Fulfilled
DATE_LATEST_SHIP DATE

Date Latest Ship
DATE_LATEST_PICK DATE

Date Latest Pick
FULFILLMENT_FLAG VARCHAR2 (40)
Flag indicating if the line has been fulfilled (typically fully shipped and invoiced for shippable items, fully invoiced for non-shippable items)
HEADER_ID VARCHAR2 (80)
Sales Order Header Identifier in the source system
INCLUDED_ITEM_FLAG VARCHAR2 (40)
Used as invoiceable_flag. Future realeases will have a new column for invoiceable_flag. This flag is set to "Y" if the sales order line is not from an Internal order, is not an "INCLUDED" item, and the invoiceable flag for this item = "Y"
ITEM_TYPE_CODE VARCHAR2 (80)
Code for the item type : STANDARD, CONFIG, KIT, MODEL, CLASS, OPTION, INCLUDED, SERVICE
LAST_UPDATE_DATE DATE
Y Standard Who column
LINE_DETAILS_ID VARCHAR2 (80)
Sales Order Line Details Identifier in the source system
LINE_ID VARCHAR2 (80)
Sales Order Line Identifier in the source system
ORDER_NUMBER VARCHAR2 (80)
Sales Order Number in the source system
ORDERED_DATE DATE

Date Ordered
PRICE_LIST_ID VARCHAR2 (80)
Id of the Price List from which the List Price was issued
PROMISED_DATE DATE

Date Promised
QTY_CANCELLED NUMBER

Quantity Canceled
QTY_INVOICED NUMBER

Quantity Invoiced
QTY_FULFILLED NUMBER

Quantity Fulfilled
QTY_ORDERED NUMBER

Quantity Ordered
QTY_RESERVED NUMBER

Quantity Reserved
QTY_RETURNED NUMBER

Quantity Returned
QTY_SHIPPED NUMBER

Quantity Shipped
REQUESTED_DATE DATE

Date Requested
SCHEDULED_DATE DATE

Date Scheduled
SHIPPABLE_FLAG VARCHAR2 (40)
Shippable Flag
TOTAL_NET_ORDER_VALUE NUMBER

Total net value for the entire order (non additive across lines of the same order)
TRANSACTABLE_FLAG VARCHAR2 (40)
Reserved for future use
UNIT_COST_G NUMBER

Unit Cost in Warehouse Currency
UNIT_COST_T NUMBER

Unit Cost in Transaction Currency
UNIT_LIST_PRC_G NUMBER

Unit List Price in Warehouse Currency
UNIT_LIST_PRC_T NUMBER

Unit List Price in Transaction Currency
UNIT_SELL_PRC_G NUMBER

Unit Sell Price in Warehouse Currency
UNIT_SELL_PRC_T NUMBER

Unit Sell Price in Transaction Currency
USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE6 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE7 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE8 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE9 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE10 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE11 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE12 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE13 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE14 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE15 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE16 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE17 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE18 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE19 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE20 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE21 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE22 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE23 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE24 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE25 VARCHAR2 (240)
User defined attribute
USER_FK1_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK2_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK3_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK4_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK5_KEY NUMBER

System generated foreign key to user defined dimension
USER_MEASURE1 NUMBER

User defined measure
USER_MEASURE2 NUMBER

User defined measure
USER_MEASURE3 NUMBER

User defined measure
USER_MEASURE4 NUMBER

User defined measure
USER_MEASURE5 NUMBER

User defined measure

[top of page]

ISC.ISC_EDW_BOOKINGS_F does not reference any database object

ISC.ISC_EDW_BOOKINGS_F is referenced by following:

APPS
SYNONYM - ISC_EDW_BOOKINGS_F

[top of page]

Table: ISC_EDW_BOOKINGS_FSTG

Description: Interface table for the Bookings fact
Comments

This is the interface table for the Bookings fact table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the fact table.

Indexes
Index Type Tablespace Column
ISC_EDW_BOOKINGS_FSTG_N1 NONUNIQUE APPS_TS_INTERFACE BOOKINGS_PK
ISC_EDW_BOOKINGS_FSTG_N2 NONUNIQUE APPS_TS_INTERFACE COLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
BOOKINGS_PK VARCHAR2 (240)
Unique Identifier
AGREEMENT_TYPE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Customer Agreement Type)
AGREEMENT_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Customer Agreement Type)
BILL_TO_CUST_FK VARCHAR2 (320)
Foreign key to the Trading Partner dimension (Bill-to Site)
BILL_TO_CUST_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Bill-to Site)
BILL_TO_LOC_FK VARCHAR2 (240)
Foreign key to the Geography dimension (Bill-to Location)
BILL_TO_LOC_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Bill-to Location)
CAMPAIGN_ACTL_FK VARCHAR2 (320)
Foreign key to the Campaign dimension (Campaign Actual)
CAMPAIGN_ACTL_FK_KEY NUMBER

System generated foreign key to the Campaign dimension (Campaign Actual)
CAMPAIGN_INIT_FK VARCHAR2 (320)
Foreign key to the Lookup dimension (Cancel Reason)
CAMPAIGN_INIT_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Cancel Reason)
CAMPAIGN_STATUS_ACTL_FK VARCHAR2 (320)
Foreign key to the Campaign Status dimension (Campaign Status Actual)
CAMPAIGN_STATUS_ACTL_FK_KEY NUMBER

System generated foreign key to the Campaign Status dimension (Campaign Status Actual)
CAMPAIGN_STATUS_INIT_FK VARCHAR2 (320)
Foreign key to the Campaign Status dimension (Campaign Status Attributed)
CAMPAIGN_STATUS_INIT_FK_KEY NUMBER

System generated foreign key to the Campaign Status dimension (Campaign Status Attributed)
CANCEL_REASON_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Cancel Reason)
CANCEL_REASON_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Cancel Reason)
CURRENCY_TRN_FK VARCHAR2 (240)
Foreign key to the Currency dimension (Transaction Currency)
CURRENCY_TRN_FK_KEY NUMBER

System generated foreign key to the Currency dimension (Transaction Currency)
CUSTOMER_FK VARCHAR2 (240)
Foreign key to the Trading Partner dimension (Customer)
CUSTOMER_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Customer)
DATE_BOOKED_FK VARCHAR2 (240)
Foreign key to the Time dimension (Date Booked)
DATE_BOOKED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Booked)
DATE_PROMISED_FK VARCHAR2 (240)
Foreign key to the Time dimension (Date Promised)
DATE_PROMISED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Promised)
DATE_REQUESTED_FK VARCHAR2 (240)
Foreign key to the Time dimension (Date Requested)
DATE_REQUESTED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Requested)
DATE_SCHEDULED_FK VARCHAR2 (240)
Foreign key to the Time dimension (Date Scheduled)
DATE_SCHEDULED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Scheduled)
DEMAND_CLASS_FK VARCHAR2 (240)
Foreign key to the Demand Class dimension
DEMAND_CLASS_FK_KEY NUMBER

System generated foreign key to the Demand Class dimension
EVENT_OFFER_ACTL_FK VARCHAR2 (240)
Foreign key to the Event dimension (Event Offer Actual)
EVENT_OFFER_ACTL_FK_KEY NUMBER

System generated foreign key to the Event dimension (Event Offer Actual)
EVENT_OFFER_INIT_FK VARCHAR2 (240)
Foreign key to the Event dimension (Event Offer Attributed)
EVENT_OFFER_INIT_FK_KEY NUMBER

System generated foreign key to the Event dimension (Event Offer Attributed)
EVENT_OFFER_REG_FK VARCHAR2 (240)
Foreign key to the Event dimension (Event Registration)
EVENT_OFFER_REG_FK_KEY NUMBER

System generated foreign key to the Event dimension (Event Registration)
INSTANCE_FK VARCHAR2 (240)
Foreign key to the Instance dimension
INSTANCE_FK_KEY NUMBER

System generated foreign key to the Instance dimension
INV_ORG_FK VARCHAR2 (240)
Foreign key to the Inventory Location dimension (Inventory Organization) from which the Items are issued
INV_ORG_FK_KEY NUMBER

System generated foreign key to the Inventory Location dimension (Inventory Organization) from which the Items are issued
ITEM_ORG_FK VARCHAR2 (320)
Foreign key to the Item dimension (Organization Item)
ITEM_ORG_FK_KEY NUMBER

System generated foreign key to the Item dimension (Organization Item)
MARKET_SEGMENT_FK VARCHAR2 (240)
Foreign key to the Market Segment dimension
MARKET_SEGMENT_FK_KEY NUMBER

System generated foreign key to the Market Segment dimension
MEDCHN_ACTL_FK VARCHAR2 (240)
Foreign key to the Media Channel dimension (Media Channel Actual)
MEDCHN_ACTL_FK_KEY NUMBER

System generated foreign key to the Media Channel dimension (Media Channel Actual)
MEDCHN_INIT_FK VARCHAR2 (240)
Foreign key to the Media Channel dimension (Media Channel Attributed)
MEDCHN_INIT_FK_KEY NUMBER

System generated foreign key to the Media Channel dimension (Media Channel Attributed)
OFFER_HDR_FK VARCHAR2 (240)
Foreign key to the Offer dimension (Header level)
OFFER_HDR_FK_KEY NUMBER

System generated foreign key to the Offer dimension (Header level)
OFFER_LINE_FK VARCHAR2 (240)
Foreign key to the Offer dimension (Line level)
OFFER_LINE_FK_KEY NUMBER

System generated foreign key to the Offer dimension (Line level)
OPERATING_UNIT_FK VARCHAR2 (240)
Foreign key to the Internal Organization dimension (Operating Unit) where the order was booked
OPERATING_UNIT_FK_KEY NUMBER

System generated foreign key to the Internal Organization dimension (Operating Unit) where the order was booked
ORDER_CATEGORY_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Sales Order Category)
ORDER_CATEGORY_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Category)
ORDER_SOURCE_FK VARCHAR2 (240)
Foreign key to the Sales Order Source dimension
ORDER_SOURCE_FK_KEY NUMBER

System generated foreign key to the Sales Order Source dimension
ORDER_TYPE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Sales Order Type)
ORDER_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Type)
RETURN_REASON_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Return Reason)
RETURN_REASON_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Return Reason)
SALES_CHANNEL_FK VARCHAR2 (240)
Foreign key to the Sales Channel dimension
SALES_CHANNEL_FK_KEY NUMBER

Reserved for future use
SALES_PERSON_FK VARCHAR2 (240)
Reserved for future use
SALES_PERSON_FK_KEY NUMBER

System generated foreign key to the Person dimension (Salesperson)
SET_OF_BOOKS_FK VARCHAR2 (240)
Foreign key to the Set of Books dimension (GL Set of Book)
SET_OF_BOOKS_FK_KEY NUMBER

System generated foreign key to the Set of Books dimension (GL Set of Book)
SHIP_TO_CUST_FK VARCHAR2 (320)
Foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped
SHIP_TO_CUST_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped
SHIP_TO_LOC_FK VARCHAR2 (240)
Foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
SHIP_TO_LOC_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
SOURCE_LIST_FK VARCHAR2 (240)
Foreign key to the Source List dimension
SOURCE_LIST_FK_KEY NUMBER

System generated foreign key to the Source List dimension
TARGET_SEGMENT_ACTL_FK VARCHAR2 (240)
Foreign key to the Target Segment dimension (Target Segment Actual)
TARGET_SEGMENT_ACTL_FK_KEY NUMBER

System generated foreign key to the Target Segment dimension (Target Segment Actual)
TARGET_SEGMENT_INIT_FK VARCHAR2 (240)
Foreign key to the Target Segment dimension (Target Segment Attributed)
TARGET_SEGMENT_INIT_FK_KEY NUMBER

System generated foreign key to the Target Segment dimension (Target Segment Attributed)
TASK_FK VARCHAR2 (240)
Foreign key to the Project dimension (Project Task)
TASK_FK_KEY NUMBER

System generated foreign key to the Project dimension (Project Task)
TOP_MODEL_FK VARCHAR2 (320)
Foreign key to the Item dimension (Top Model Organization Item) when the item is a component in a bill of material (BOM)
TOP_MODEL_FK_KEY NUMBER

System generated foreign key to the Item dimension (Top Model Organization Item) when the item is a component in a bill of material (BOM)
UOM_UOM_FK VARCHAR2 (240)
Foreign key to the UoM dimension
UOM_UOM_FK_KEY NUMBER

System generated foreign key to the UoM dimension
AGREEMENT_ID VARCHAR2 (80)
Id of the Agreement to which this order relates to
BOOKED_DATE DATE

Date Booked
COLLECTION_STATUS VARCHAR2 (40)
Collection status code for the record
CONFIGURATION_ITEM_FLAG VARCHAR2 (40)
Flag indicating if the item is part of a configuration.
CONVERSION_DATE DATE

Currency Conversion Date
CONVERSION_RATE NUMBER

Currency Conversion Rate
CONVERSION_TYPE VARCHAR2 (80)
Currency Conversion Type
CUST_PO_NUMBER VARCHAR2 (80)
Customer's Purchase Order Number
DATE_FULFILLED DATE

Date Fulfilled
DATE_LATEST_SHIP DATE

Date Latest Ship
DATE_LATEST_PICK DATE

Date Latest Pick
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
FULFILLMENT_FLAG VARCHAR2 (40)
Flag indicating if the line has been fulfilled (typically fully shipped and invoiced for shippable items, fully invoiced for non-shippable items)
HEADER_ID VARCHAR2 (80)
Sales Order Header Identifier in the source system
INCLUDED_ITEM_FLAG VARCHAR2 (40)
Used as invoiceable_flag. Future realeases will have a new column for invoiceable_flag.This flag is set to "Y" if the sales order line is not : Internal, an "INCLUDED" item, and the invoiceable flag for this item = "Y"
INSTANCE VARCHAR2 (40)
Instance
ITEM_TYPE_CODE VARCHAR2 (80)
Code for the item type : STANDARD, CONFIG, KIT, MODEL, CLASS, OPTION, INCLUDED, SERVICE)
LAST_UPDATE_DATE DATE

Standard Who column
LINE_DETAIL_ID VARCHAR2 (80)
Sales Order Line Details Identifier in the source system
LINE_ID VARCHAR2 (80)
Sales Order Line Identifier in the source system
PRICE_LIST_ID VARCHAR2 (80)
Id of the Price List from which the List Price was issued
OPERATION_CODE VARCHAR2 (40)
Code used by the collection program to determine whether to insert/update/delete this record
ORDER_NUMBER VARCHAR2 (80)
Sales Order Number in the source system
ORDERED_DATE DATE

Date Ordered
PROMISED_DATE DATE

Date Promised
QTY_CANCELLED NUMBER

Quantity Canceled
QTY_FULFILLED NUMBER

Quantity Fulfilled
QTY_INVOICED NUMBER

Quantity Invoiced
QTY_SHIPPED NUMBER

Quantity Shipped
QTY_ORDERED NUMBER

Quantity Ordered
QTY_RESERVED NUMBER

Quantity Reserved
QTY_RETURNED NUMBER

Quantity Returned
REQUEST_ID NUMBER

Identifier used by collection program
REQUESTED_DATE DATE

Date Requested
ROW_ID ROWID (10)
Row Id
SCHEDULED_DATE DATE

Date Scheduled
SHIPPABLE_FLAG VARCHAR2 (40)
Shippable Flag
TOTAL_NET_ORDER_VALUE NUMBER

Total net value for the entire order (non additive across lines of the same order)
TRANSACTABLE_FLAG VARCHAR2 (40)
Reserved for future use
UNIT_COST_G NUMBER

Unit Cost in Warehouse currency
UNIT_COST_T NUMBER

Unit Cost in Transaction currency
UNIT_LIST_PRC_G NUMBER

Unit List Price in Warehouse currency
UNIT_LIST_PRC_T NUMBER

Unit List Price in Transaction currency
UNIT_SELL_PRC_G NUMBER

Unit Sell Price in Warehouse Currency
UNIT_SELL_PRC_T NUMBER

Unit Sell Price in Transaction Currency
USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE6 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE7 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE8 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE9 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE10 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE11 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE12 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE13 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE14 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE15 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE16 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE17 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE18 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE19 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE20 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE21 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE22 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE23 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE24 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE25 VARCHAR2 (240)
User defined attribute
USER_FK1_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK2_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK3_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK4_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK5_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK1 VARCHAR2 (240)
Foreign Key to user defined dimension
USER_FK2 VARCHAR2 (240)
Foreign Key to user defined dimension
USER_FK3 VARCHAR2 (240)
Foreign Key to user defined dimension
USER_FK4 VARCHAR2 (240)
Foreign Key to user defined dimension
USER_FK5 VARCHAR2 (240)
Foreign Key to user defined dimension
USER_MEASURE1 NUMBER

User Defined Measure
USER_MEASURE2 NUMBER

User Defined Measure
USER_MEASURE3 NUMBER

User Defined Measure
USER_MEASURE4 NUMBER

User Defined Measure
USER_MEASURE5 NUMBER

User Defined Measure
SALES_RESOURCE_FK_KEY NUMBER

System generated foreign key for Sales Resource
SALES_RESOURCE_FK VARCHAR2 (240)
Foreign key for Sales Resource

[top of page]

ISC.ISC_EDW_BOOKINGS_FSTG does not reference any database object

ISC.ISC_EDW_BOOKINGS_FSTG is referenced by following:

APPS
SYNONYM - ISC_EDW_BOOKINGS_FSTG

[top of page]

Table: ISC_EDW_BOOKINGS_F_DLOG

Description: This is the delete log table for the Bookings fact
Comments

This is the delete log table for the Bookings fact

Columns
Name Datatype Length Mandatory Comments
SOURCE_LIST_FK_KEY NUMBER

System generated foreign key to the Source List dimension
UNIT_SELL_PRC_T NUMBER

Unit Sell Price in Transaction Currency
UNIT_SELL_PRC_G NUMBER

Unit Sell Price in Warehouse Currency
SET_OF_BOOKS_FK_KEY NUMBER

System generated foreign key to the Set of Books dimension (GL Set of Book)
USER_FK5_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK4_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK3_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK2_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK1_KEY NUMBER

System generated foreign key to user defined dimension
EVENT_OFFER_REG_FK_KEY NUMBER

System generated foreign key to the Marketing Event Offer dimension (Marketing Event Offer Registration)
TARGET_SEGMENT_ACTL_FK_KEY NUMBER

System generated foreign key to the Marketing Target Segment Level dimension (Marketing Target Segment Level Actual)
TARGET_SEGMENT_INIT_FK_KEY NUMBER

System generated foreign key to the Marketing Target Segment Level dimension (Marketing Target Segment Level Attributed)
BOOKINGS_PK_KEY NUMBER

System generated unique identifier
CUSTOMER_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Customer)
EVENT_OFFER_INIT_FK_KEY NUMBER

System generated foreign key to the Marketing Event Offer dimension (Marketing Event Offer Attributed)
EVENT_OFFER_ACTL_FK_KEY NUMBER

System generated foreign key to the Marketing Event Offer dimension (Marketing Event Offer Actual)
SHIP_TO_CUST_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped
BILL_TO_CUST_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Bill-to Site)
ORDER_SOURCE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Source)
RETURN_REASON_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Return Reason)
DEMAND_CLASS_FK_KEY NUMBER

System generated foreign key to the Demand Class Dimension
MEDCHN_INIT_FK_KEY NUMBER

System generated foreign key to the Media Channel dimension (Media Channel Attributed)
MEDCHN_ACTL_FK_KEY NUMBER

System generated foreign key to the Media Channel dimension (Media Channel Actual)
UNIT_COST_G NUMBER

Unit Cost in Warehouse Currency
UNIT_COST_T NUMBER

Unit Cost in Transaction Currency
UNIT_LIST_PRC_G NUMBER

Unit List Price in Warehouse Currency
UNIT_LIST_PRC_T NUMBER

Unit List Price in Transaction Currency
AGREEMENT_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Customer Agreement Type)
UOM_UOM_FK_KEY NUMBER

System generated foreign key to the UoM dimension
DATE_SCHEDULED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Scheduled)
DATE_PROMISED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Promised)
DATE_REQUESTED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Requested)
DATE_BOOKED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Booked)
SALES_CHANNEL_FK_KEY NUMBER

System generated foreign key to the Sales Channel dimension
TASK_FK_KEY NUMBER

System generated foreign key to the Project dimension (Project Task)
SALES_PERSON_FK_KEY NUMBER

Reserved for future use
OPERATING_UNIT_FK_KEY NUMBER

System generated foreign key to the Internal Organization dimension (Operating Unit) where the order was booked
INV_ORG_FK_KEY NUMBER

System generated foreign key to the Inventory Location dimension (Inventory Organization) from which the Items are issued
OFFER_LINE_FK_KEY NUMBER

System generated foreign key to the Marketing Offer dimension (Line level)
OFFER_HDR_FK_KEY NUMBER

System generated foreign key to the Marketing Offer dimension (Header level)
MARKET_SEGMENT_FK_KEY NUMBER

System generated foreign key to the Market Segment dimension
ORDER_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Type)
ORDER_CATEGORY_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Category)
CANCEL_REASON_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Cancel Reason)
TOP_MODEL_FK_KEY NUMBER

System generated foreign key to the Item dimension (Top Model Organization Item) when the item is a component in a bill of material (BOM)
ITEM_ORG_FK_KEY NUMBER

System generated foreign key to the Item dimension (Organization Item)
INSTANCE_FK_KEY NUMBER

System generated foreign key to the Instance dimension
SHIP_TO_LOC_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
BILL_TO_LOC_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Bill-to Location)
CURRENCY_TRN_FK_KEY NUMBER

System generated foreign key to the Currency dimension (Transaction Currency)
CAMPAIGN_ACTL_FK_KEY NUMBER

System generated foreign key to the Campaign Schedule dimension (Campaign Schedule Actual)
CAMPAIGN_INIT_FK_KEY NUMBER

System generated foreign key to the Campaign Schedule dimension (Campaign Schedule Attributed)
CAMPAIGN_STATUS_ACTL_FK_KEY NUMBER

System generated foreign key to the Campaign Status dimension (Campaign Status Actual)
CAMPAIGN_STATUS_INIT_FK_KEY NUMBER

System generated foreign key to the Campaign Status dimension (Campaign Status Attributed)
CONVERSION_RATE NUMBER

Currency Conversion Rate
USER_MEASURE5 NUMBER

User defined measure
USER_MEASURE4 NUMBER

User defined measure
USER_MEASURE3 NUMBER

User defined measure
USER_MEASURE2 NUMBER

User defined measure
USER_MEASURE1 NUMBER

User defined measure
QTY_SHIPPED NUMBER

Quantity Shipped
QTY_RETURNED NUMBER

Quantity Returned
QTY_RESERVED NUMBER

Quantity Reserved
QTY_ORDERED NUMBER

Quantity Ordered
QTY_INVOICED NUMBER

Quantity Invoiced
QTY_CANCELLED NUMBER

Quantity Cancelled
PRICE_LIST_ID VARCHAR2 (80)
Id of the Price List from which the List Price was issued
CUST_PO_NUMBER VARCHAR2 (80)
Customer's Purchase Order Number
AGREEMENT_ID VARCHAR2 (80)
Id of the Agreement to which this order relates
CONFIGURATION_ITEM_FLAG VARCHAR2 (40)
Flag indicating if the item is part of a configuration
INCLUDED_ITEM_FLAG VARCHAR2 (40)
Used as invoiceable_flag. Future realeases will have a new column for invoiceable_flag. This flag is set to "Y" if the sales order line is not from an Internal order, is not an "INCLUDED" item, and the invoiceable flag for this item = "Y"
TRANSACTABLE_FLAG VARCHAR2 (40)
Reserved for future use
ORDER_NUMBER VARCHAR2 (80)
Sales Order Number in the source system
LINE_ID VARCHAR2 (80)
Sales Order Line Identifier in the source system
LINE_DETAILS_ID VARCHAR2 (80)
Sales Order Line Details Identifier in the source system
HEADER_ID VARCHAR2 (80)
Sales Order Header Identifier in the source system
CONVERSION_TYPE VARCHAR2 (80)
Currency Conversion Type
BOOKINGS_PK VARCHAR2 (240)
Unique Identifier
LAST_UPDATE_DATE DATE

Standard Who column
CREATION_DATE DATE

Standard Who column
CONVERSION_DATE DATE

Currency Conversion Date
USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE6 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE7 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE8 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE9 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE10 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE11 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE12 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE13 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE14 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE15 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE16 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE17 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE18 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE19 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE20 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE21 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE22 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE23 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE24 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE25 VARCHAR2 (240)
User defined attribute
SHIPPABLE_FLAG VARCHAR2 (40)
Shippable Flag
DATE_LATEST_SHIP DATE

Date Latest Ship
DATE_LATEST_PICK DATE

Date Latest Pick
FULFILLMENT_FLAG VARCHAR2 (40)
Flag indicating if the line has been fulfilled (typically fully shipped and invoiced for shippable items, fully invoiced for non-shippable items)
DATE_FULFILLED DATE

Date Fulfilled
QTY_FULFILLED NUMBER

Quantity Fulfilled
BOOKED_DATE DATE

Date Booked
PROMISED_DATE DATE

Date Promised
ORDERED_DATE DATE

Date Ordered
REQUESTED_DATE DATE

Date Requested
TOTAL_NET_ORDER_VALUE NUMBER

Total net value for the entire order (non additive across lines of the same order)
ITEM_TYPE_CODE VARCHAR2 (80)
Code for the item type : STANDARD, CONFIG, KIT, MODEL, CLASS, OPTION, INCLUDED, SERVICE
SCHEDULED_DATE DATE

Date Scheduled

[top of page]

ISC.ISC_EDW_BOOKINGS_F_DLOG does not reference any database object

ISC.ISC_EDW_BOOKINGS_F_DLOG is referenced by following:

APPS
SYNONYM - ISC_EDW_BOOKINGS_F_DLOG

[top of page]

Table: ISC_EDW_BOOK_SUM1_F

Description:
Comments

This summary table holds Booking Summary information

Indexes
Index Type Tablespace Column
ISC_EDW_BOOK_SUM1_F_U1 UNIQUE APPS_TS_SUMMARY BOOKINGS_PK
ISC_EDW_BOOK_SUM1_F_N1 NONUNIQUE APPS_TS_SUMMARY INSTANCE_FK_KEY
ISC_EDW_BOOK_SUM1_F_N2 NONUNIQUE APPS_TS_SUMMARY DATE_BOOKED_FK_KEY
ISC_EDW_BOOK_SUM1_F_N3 NONUNIQUE APPS_TS_SUMMARY BILL_TO_CUST_FK_KEY
ISC_EDW_BOOK_SUM1_F_N4 NONUNIQUE APPS_TS_SUMMARY SET_OF_BOOKS_FK_KEY
ISC_EDW_BOOK_SUM1_F_N5 NONUNIQUE APPS_TS_SUMMARY OPERATING_UNIT_FK_KEY
ISC_EDW_BOOK_SUM1_F_N6 NONUNIQUE APPS_TS_SUMMARY CURRENCY_BASE_FK_KEY
Columns
Name Datatype Length Mandatory Comments
BOOKINGS_PK VARCHAR2 (240)
Unique Identifier
BOOKINGS_PK_KEY NUMBER

System generated unique identifier
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
INSTANCE_FK_KEY NUMBER

System generated foreign key to the Instance dimension
INSTANCE VARCHAR2 (40)
Instance
DATE_BOOKED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Booked)
BILL_TO_CUST_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Bill-to Site)
SET_OF_BOOKS_FK_KEY NUMBER

System generated foreign key to the Set of Books dimension (GL Set of Book)
OPERATING_UNIT_FK_KEY NUMBER

System generated foreign key to the Internal Organization dimension (Operating Unit) where the order was booked
CURRENCY_BASE_FK_KEY NUMBER

System generated foreign key to the Currency dimension (Base Currency)
BOOKED_LIST_AMT_B NUMBER

Total amount of bookings in list price in Base Currency
BOOKED_LIST_AMT_G NUMBER

Total amount of bookings in list price in Warehouse Currency
BOOKED_AMT_B NUMBER

Total amount of bookings in Base Currency
BOOKED_AMT_G NUMBER

Total amount of bookings in Warehouse Currency
SHIPPED_AMT_B NUMBER

Total amount shipped in Base Currency
SHIPPED_AMT_G NUMBER

Total amount shipped in Warehouse Currency
INVOICED_AMT_B NUMBER

Total amount invoiced in Base Currency
INVOICED_AMT_G NUMBER

Total amount invoiced in Warehouse Currency
FULFILLED_AMT_B NUMBER

Total amount fulfilled in Base Currency
FULFILLED_AMT_G NUMBER

Total amount fulfilled in Warehouse Currency
DATE_BOOKED DATE

Date Booked
DATE_ORDERED DATE

Date Ordered
DATE_LATEST_SHIP DATE

Date Latest Ship
DATE_LATEST_FULFILLED DATE

Date Latest Fulfilled
ORDER_NUMBER VARCHAR2 (80)
Sales Order Number in the source system
HEADER_ID VARCHAR2 (80)
Sales Order Header Identifier in the source system
USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE6 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE7 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE8 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE9 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE10 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE11 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE12 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE13 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE14 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE15 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE16 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE17 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE18 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE19 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE20 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE21 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE22 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE23 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE24 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE25 VARCHAR2 (240)
User defined attribute
USER_FK1_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK2_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK3_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK4_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK5_KEY NUMBER

System generated foreign key to user defined dimension
USER_MEASURE1 NUMBER

User defined measure
USER_MEASURE2 NUMBER

User defined measure
USER_MEASURE3 NUMBER

User defined measure
USER_MEASURE4 NUMBER

User defined measure
USER_MEASURE5 NUMBER

User defined measure

[top of page]

ISC.ISC_EDW_BOOK_SUM1_F does not reference any database object

ISC.ISC_EDW_BOOK_SUM1_F is referenced by following:

APPS
SYNONYM - ISC_EDW_BOOK_SUM1_F

[top of page]

Table: ISC_EDW_BOOK_SUM1_FSTG

Description:
Comments

This is the interface table for the Booking Summary table

Indexes
Index Type Tablespace Column
ISC_EDW_BOOK_SUM1_FSTG_N1 NONUNIQUE APPS_TS_INTERFACE BOOKINGS_PK
ISC_EDW_BOOK_SUM1_FSTG_N2 NONUNIQUE APPS_TS_INTERFACE COLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
BOOKINGS_PK VARCHAR2 (240)
Unique Identifier
LAST_UPDATE_DATE DATE

Standard Who column
COLLECTION_STATUS VARCHAR2 (40)
Collection status code for the record
ERROR_CODE VARCHAR2 (2000)
ode used to store error messages
OPERATION_CODE VARCHAR2 (40)
Code used by the collection program to determine whether to insert/update/delete this record
REQUEST_ID NUMBER

Identifier used by collection program
ROW_ID ROWID (10)
Row Id
INSTANCE VARCHAR2 (40)
Instance
INSTANCE_FK VARCHAR2 (240)
Foreign key to the Instance dimension
INSTANCE_FK_KEY NUMBER

System generated foreign key to the Instance dimension
DATE_BOOKED_FK VARCHAR2 (240)
Foreign key to the Time dimension (Date Booked)
DATE_BOOKED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Booked)
BILL_TO_CUST_FK VARCHAR2 (320)
Foreign key to the Trading Partner dimension (Bill-to Site)
BILL_TO_CUST_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Bill-to Site)
SET_OF_BOOKS_FK VARCHAR2 (240)
Foreign key to the Set of Books dimension (GL Set of Book)
SET_OF_BOOKS_FK_KEY NUMBER

System generated foreign key to the Set of Books dimension (GL Set of Book)
OPERATING_UNIT_FK VARCHAR2 (240)
Foreign key to the Internal Organization dimension (Operating Unit) where the order was booked
OPERATING_UNIT_FK_KEY NUMBER

System generated foreign key to the Internal Organization dimension (Operating Unit) where the order was booked
CURRENCY_BASE_FK VARCHAR2 (240)
Foreign key to the Currency dimension (Base Currency)
CURRENCY_BASE_FK_KEY NUMBER

System generated foreign key to the Currency dimension (Base Currency)
BOOKED_LIST_AMT_B NUMBER

Total amount of bookings in list price in Base Currency
BOOKED_LIST_AMT_G NUMBER

Total amount of bookings in list price in Warehouse Currency
BOOKED_AMT_B NUMBER

Total amount of bookings in Base Currency
BOOKED_AMT_G NUMBER

Total amount of bookings in Warehouse Currency
SHIPPED_AMT_B NUMBER

Total amount shipped in Base Currency
SHIPPED_AMT_G NUMBER

Total amount shipped in Warehouse Currency
INVOICED_AMT_B NUMBER

Total amount invoiced in Base Currency
INVOICED_AMT_G NUMBER

Total amount invoiced in Warehouse Currency
FULFILLED_AMT_B NUMBER

Total amount fulfilled in Base Currency
FULFILLED_AMT_G NUMBER

Total amount fulfilled in Warehouse Currency
DATE_BOOKED DATE

Date Booked
DATE_ORDERED DATE

Date Ordered
DATE_LATEST_SHIP DATE

Date Latest Ship
DATE_LATEST_FULFILLED DATE

Date Latest Fulfilled
ORDER_NUMBER VARCHAR2 (80)
Sales Order Number in the source system
HEADER_ID VARCHAR2 (80)
Sales Order Header Identifier in the source system
USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE6 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE7 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE8 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE9 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE10 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE11 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE12 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE13 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE14 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE15 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE16 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE17 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE18 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE19 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE20 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE21 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE22 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE23 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE24 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE25 VARCHAR2 (240)
User defined attribute
USER_FK1 VARCHAR2 (240)
Foreign key to user defined dimension
USER_FK1_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK2 VARCHAR2 (240)
Foreign key to user defined dimension
USER_FK2_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK3 VARCHAR2 (240)
Foreign key to user defined dimension
USER_FK3_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK4 VARCHAR2 (240)
Foreign key to user defined dimension
USER_FK4_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK5 VARCHAR2 (240)
Foreign key to user defined dimension
USER_FK5_KEY NUMBER

System generated foreign key to user defined dimension
USER_MEASURE1 NUMBER

User defined measure
USER_MEASURE2 NUMBER

User defined measure
USER_MEASURE3 NUMBER

User defined measure
USER_MEASURE4 NUMBER

User defined measure
USER_MEASURE5 NUMBER

User defined measure

[top of page]

ISC.ISC_EDW_BOOK_SUM1_FSTG does not reference any database object

ISC.ISC_EDW_BOOK_SUM1_FSTG is referenced by following:

APPS
SYNONYM - ISC_EDW_BOOK_SUM1_FSTG

[top of page]

Table: ISC_TMP_BACK

Description: This is a temporary table used by the Backlog Snapshot collection program
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
ISC_TMP_BACK_N1 NONUNIQUE APPS_TS_INTERFACE PK1
SEQ_ID
Columns
Name Datatype Length Mandatory Comments
SEQ_ID NUMBER

PK1 VARCHAR2 (240)
PK2 VARCHAR2 (240)
PK3 VARCHAR2 (240)

[top of page]

ISC.ISC_TMP_BACK does not reference any database object

ISC.ISC_TMP_BACK is referenced by following:

APPS
SYNONYM - ISC_TMP_BACK

[top of page]

Table: ISC_TMP_BOOK_SUM1

Description:
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
ISC_TMP_BOOK_SUM1_N1 NONUNIQUE APPS_TS_INTERFACE PK1
SEQ_ID
Columns
Name Datatype Length Mandatory Comments
SEQ_ID NUMBER

PK1 VARCHAR2 (240)
PK2 VARCHAR2 (240)
PK3 VARCHAR2 (240)

[top of page]

ISC.ISC_TMP_BOOK_SUM1 does not reference any database object

ISC.ISC_TMP_BOOK_SUM1 is referenced by following:

APPS
SYNONYM - ISC_TMP_BOOK_SUM1

[top of page]

Table: ISC_TMP_PK

Description: This is a temporary table used by the Bookings collection program
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
ISC_TMP_PK_N1 NONUNIQUE APPS_TS_INTERFACE PK1
SEQ_ID
Columns
Name Datatype Length Mandatory Comments
SEQ_ID NUMBER

PK1 VARCHAR2 (240)
PK2 VARCHAR2 (240)
PK3 VARCHAR2 (240)

[top of page]

ISC.ISC_TMP_PK does not reference any database object

ISC.ISC_TMP_PK is referenced by following:

APPS
SYNONYM - ISC_TMP_PK

[top of page]

View: EDW_DEMAND_CLASS_FKV

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view builds and returns foreign keys to the Demand Class dimension. Demand Class foreign keys are based on lookup code values found in the DEMAND_CLASS lookup type.

Columns
Name Datatype Length Mandatory Comments
DEMAND_CLASS_FK VARCHAR2 (61)
Demand Class foreign key
DEMAND_CLASS_ID VARCHAR2 (30) Y Demand Class Id

[top of page]

APPS.EDW_DEMAND_CLASS_FKV references the following:

APPS
SYNONYM - EDW_LOCAL_INSTANCE
SYNONYM - FND_LOOKUP_VALUES

APPS.EDW_DEMAND_CLASS_FKV is not referenced by any database object

[top of page]

View: EDW_FORECAST_FKV

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view builds and returns foreign keys to the Forecast dimension. Forecast foreign keys are based on forecast designators values found in the mrp_forecast_designators table.

Columns
Name Datatype Length Mandatory Comments
FORECAST_FK VARCHAR2 (82)
Forecast foreign key
FORECAST_DESIGNATOR VARCHAR2 (10) Y Forecast designator
ORGANIZATION_ID NUMBER
Y Organization Id

[top of page]

APPS.EDW_FORECAST_FKV references the following:

APPS
SYNONYM - EDW_LOCAL_INSTANCE
SYNONYM - MRP_FORECAST_DESIGNATORS
SYNONYM - MTL_PARAMETERS

APPS.EDW_FORECAST_FKV is not referenced by any database object

[top of page]

View: EDW_MRP_DCDM_DM_LCV

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is used by the Demand Class collection program to retrieve Demand Class level information from the DEMAND_CLASS lookup type.

Columns
Name Datatype Length Mandatory Comments
DEMAND_CLASS_PK VARCHAR2 (61)
Unique identifier
ALL_FK CHAR (3)
Foreign key to the top level of the Demand Class dimension
CREATION_DATE DATE
Y Standard Who column
DEMAND_CLASS VARCHAR2 (30) Y Demand Class
DEMAND_CLASS_DP VARCHAR2 (111)
Unique Demand Class name
DESCRIPTION VARCHAR2 (240)
Demand Class description
INSTANCE_CODE VARCHAR2 (30)
Instance code refering to the source application
LAST_UPDATE_DATE DATE
Y Standard Who column
NAME VARCHAR2 (80) Y Alternate Demand Class name
USER_ATTRIBUTE1 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (0)
User attribute

[top of page]

APPS.EDW_MRP_DCDM_DM_LCV references the following:

APPS
SYNONYM - EDW_LOCAL_INSTANCE
SYNONYM - FND_LOOKUP_VALUES

APPS.EDW_MRP_DCDM_DM_LCV is not referenced by any database object

[top of page]

View: EDW_MRP_FCDM_FCS_LCV

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is used by the Forecast collection program to retrieve Forecast level information from the mrp_forecast_designators table.

Columns
Name Datatype Length Mandatory Comments
FORECAST_PK VARCHAR2 (82)
Unique identifier for the Forecast
FORECAST_SET_FK VARCHAR2 (82)
Foreign key to the Forecast Set level of the Forecast dimension
CREATION_DATE DATE
Y Standard Who column
DESCRIPTION VARCHAR2 (50)
Forecast description
DISABLE_DATE DATE

Date on which the Forecast is disabled
FORECAST_DP VARCHAR2 (45)
Unique Forecast name
FORECAST_NAME VARCHAR2 (15)
Forecast name
INSTANCE_CODE VARCHAR2 (30)
Instance code refering to the source application
LAST_UPDATE_DATE DATE
Y Standard Who column
NAME VARCHAR2 (15)
Alternate Forecast name
USER_ATTRIBUTE1 VARCHAR2 (0)
User Attribute
USER_ATTRIBUTE2 VARCHAR2 (0)
User Attribute
USER_ATTRIBUTE3 VARCHAR2 (0)
User Attribute
USER_ATTRIBUTE4 VARCHAR2 (0)
User Attribute
USER_ATTRIBUTE5 VARCHAR2 (0)
User Attribute

[top of page]

APPS.EDW_MRP_FCDM_FCS_LCV references the following:

APPS
SYNONYM - EDW_LOCAL_INSTANCE
SYNONYM - MRP_FORECAST_DESIGNATORS
SYNONYM - MTL_PARAMETERS

APPS.EDW_MRP_FCDM_FCS_LCV is not referenced by any database object

[top of page]

View: EDW_MRP_FCDM_SET_LCV

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is used by the Forecast collection program to retrieve Forecast Set level information from the mrp_forecast_designators table.

Columns
Name Datatype Length Mandatory Comments
FORECAST_SET_PK VARCHAR2 (82)
Unique identifier
CONSUMPTION_LEVEL VARCHAR2 (80) Y Consumption Level for the Forecast Set. This determines how forecasts in the set are defined and consumed; for example, Consumption Level can bet set at the Item level, or at the Item and Customer level, or at the Item, Customer and Shipto level, etc.
CREATION_DATE DATE
Y Standard Who column
DESCRIPTION VARCHAR2 (50)
Forecast Set description
DISABLE_DATE DATE

Date on which the Forecast Set is disabled
FORECAST_SET_DP VARCHAR2 (45)
Unique Forecast Set name
FORECAST_SET_NAME VARCHAR2 (15)
Forecast Set name
INSTANCE_CODE VARCHAR2 (30)
Instance code refering to the source application
LAST_UPDATE_DATE DATE
Y Standard Who column
NAME VARCHAR2 (15)
Alternate Forecast Set name
USER_ATTRIBUTE1 VARCHAR2 (0)
User Attribute
USER_ATTRIBUTE2 VARCHAR2 (0)
User Attribute
USER_ATTRIBUTE3 VARCHAR2 (0)
User Attribute
USER_ATTRIBUTE4 VARCHAR2 (0)
User Attribute
USER_ATTRIBUTE5 VARCHAR2 (0)
User Attribute

[top of page]

APPS.EDW_MRP_FCDM_SET_LCV references the following:

APPS
SYNONYM - EDW_LOCAL_INSTANCE
VIEW - MFG_LOOKUPS
SYNONYM - MRP_FORECAST_DESIGNATORS
SYNONYM - MTL_PARAMETERS

APPS.EDW_MRP_FCDM_SET_LCV is not referenced by any database object

[top of page]

View: EDW_MRP_PNDM_PLN_LCV

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is used by the Plan Name collection program to retrieve Plan level information from the MRP_PLAN_TYPE lookup type.

Columns
Name Datatype Length Mandatory Comments
PLAN_NAME_PK VARCHAR2 (82)
Unique identifier
COMPLETION_DATE DATE

Date/time the Plan was completed
CREATION_DATE DATE
Y Standard Who column
DESCRIPTION VARCHAR2 (50)
Plan description
INCLUDE_PO_FLAG NUMBER

Flag to indicate if Purchase Orders were included in the plan
INCLUDE_WIP_FLAG NUMBER

Flag to indicate if Work in Process inventories were included in the plan
INSTANCE VARCHAR2 (30)
Instance code refering to the source application
LAST_UPDATE_DATE DATE
Y Standard Who column
NAME VARCHAR2 (15)
Alternate Plan name
PLAN_CUTOFF_DATE DATE

Cutoff date of the plan. The cutoff date is used to determine the end date when selecting entries into the plan (for example, when loading forecast entries into the plan, end date = cutoff date + carry forward days).
PLAN_NAME VARCHAR2 (15)
Plan name
PLAN_NAME_DP VARCHAR2 (45)
Unique Plan name
PLAN_RESERVE_FLAG NUMBER

Flag to indicate if supply was reserved against demand
PLAN_SAFETY_STOCK NUMBER

Flag to indicate if safety stock was calculated for each item during the execution of the plan
PLAN_TYPE VARCHAR2 (80) Y Type of the plan. Indicates if the Plan was an MRP, CRP, MPS, or Supply Chain plan.
USER_ATTRIBUTE1 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (0)
User attribute

[top of page]

APPS.EDW_MRP_PNDM_PLN_LCV references the following:

APPS
SYNONYM - EDW_LOCAL_INSTANCE
VIEW - MFG_LOOKUPS
SYNONYM - MRP_PLANS
SYNONYM - MTL_PARAMETERS

APPS.EDW_MRP_PNDM_PLN_LCV is not referenced by any database object

[top of page]

View: EDW_OE_SCHN_SCHN_LCV

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is used by the Sales Channel collection program to retrieve Sales Channel level information from the SALES_CHANNEL lookup type.

Columns
Name Datatype Length Mandatory Comments
SALES_CHANNEL_PK VARCHAR2 (61)
Unique identifier
ALL_FK CHAR (3)
Foreign key to the top level of the Sales Channel dimension
ACTIVE_FROM_DATE DATE

Date from which that Sales Channel was active
ACTIVE_TO_DATE DATE

Date to which that Sales Channel was active
CREATION_DATE DATE
Y Standard Who column
ENABLED_FLAG VARCHAR2 (1) Y Flag to indicate if that Sales Channel was enabled in the source system
INSTANCE_CODE VARCHAR2 (30)
Instance code referring to the source application
LAST_UPDATE_DATE DATE
Y Standard Who column
NAME VARCHAR2 (80) Y Alternate Sales Channel name
SALES_CHANNEL_CODE VARCHAR2 (30) Y Sales Channel code
SALES_CHANNEL_DP VARCHAR2 (111)
Unique Sales Channel name
SALES_CHANNEL_NAME VARCHAR2 (240)
Sales Channel name
USER_ATTRIBUTE1 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (0)
User attribute

[top of page]

APPS.EDW_OE_SCHN_SCHN_LCV references the following:

APPS
SYNONYM - EDW_LOCAL_INSTANCE
SYNONYM - FND_LOOKUP_VALUES
APPS.EDW_OE_SCHN_SCHN_LCV is referenced by following:

APPS
PACKAGE BODY - EDW_OE_SLCHNL_M_C

[top of page]

View: EDW_PLAN_NAME_FKV

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view builds and returns foreign keys to the Plan Name dimension. Plan Name foreign keys are based on lookup code values found in the MRP_PLAN_TYPE lookup type.

Columns
Name Datatype Length Mandatory Comments
PLAN_FK VARCHAR2 (82)
Plan Name foreign key
COMPILE_DESIGNATOR VARCHAR2 (10) Y Compile Designator: MPS, MRP or DRP plan identifier
ORGANIZATION_ID NUMBER
Y Organization Id

[top of page]

APPS.EDW_PLAN_NAME_FKV references the following:

APPS
SYNONYM - EDW_LOCAL_INSTANCE
VIEW - MFG_LOOKUPS
SYNONYM - MRP_PLANS
SYNONYM - MTL_PARAMETERS

APPS.EDW_PLAN_NAME_FKV is not referenced by any database object

[top of page]

View: EDW_SALES_CHANNEL_FKV

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view builds and returns foreign keys to the Sales Channel dimension. Sales Channel foreign keys are based on lookup code values found in the SALES_CHANNEL lookup type.

Columns
Name Datatype Length Mandatory Comments
SALES_CHANNEL_FK VARCHAR2 (61)
Sales Channel foreign key
SALES_CHANNEL_ID VARCHAR2 (30) Y Sales Channel Id

[top of page]

APPS.EDW_SALES_CHANNEL_FKV references the following:

APPS
SYNONYM - EDW_LOCAL_INSTANCE
SYNONYM - FND_LOOKUP_VALUES

APPS.EDW_SALES_CHANNEL_FKV is not referenced by any database object

[top of page]

View: ISCBV_BACKLOGS_FCV

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is used by the Backlog Snapshot collection program to group by dimension rows retrieved by the ISCBV_BACKLOGS_BASE_FCV view.

Columns
Name Datatype Length Mandatory Comments
SEQ_ID NUMBER

Sequence id used by the collection program
BACKLOGS_PK VARCHAR2 (768)
Unique identifier
BASE_UOM_FK VARCHAR2 (4000)
Foreign key to the UoM dimension
BILL_TO_CUST_FK VARCHAR2 (85)
Foreign key to the Trading Partner dimension (Bill-to Site)
BILL_TO_LOCATION_FK VARCHAR2 (4000)
Foreign key to the Geography dimension (Bill-to Location)
CUSTOMER_FK VARCHAR2 (86)
Foreign key to the Trading Partner dimension (Customer)
DATE_BALANCE_FK VARCHAR2 (76)
Foreign key to the Time dimension (Date of Snapshot)
DEMAND_CLASS_FK VARCHAR2 (61)
Foreign key to the Demand Class dimension
GL_BOOK_FK VARCHAR2 (71)
Foreign key to the Set of Books dimension (GL Set of Book)
INSTANCE_FK VARCHAR2 (30)
Foreign key to the Instance dimension
INV_ORG_FK VARCHAR2 (71)
Foreign key to the Inventory Location dimension (Inventory Organization) from which the Items are issued
ITEM_ORG_FK VARCHAR2 (117)
Foreign key to the Organization Item dimension
OPERATING_UNIT_FK VARCHAR2 (4000)
Foreign key to the Internal Organization dimension (Operating Unit)
ORDER_CATEGORY_FK VARCHAR2 (49)
Foreign key to the Lookup dimension (Sales Order Category)
ORDER_SOURCE_FK VARCHAR2 (257)
Foreign key to the Lookup dimension (Sales Order Source)
ORDER_TYPE_FK VARCHAR2 (45)
Foreign key to the Lookup dimension (Sales Order Type)
SALES_CHANNEL_FK VARCHAR2 (61)
Foreign key to the Sales Channel dimension
SALES_PERSON_FK VARCHAR2 (126)
Foreign key to the Person dimension (Salesperson)
SHIP_TO_CUST_FK VARCHAR2 (85)
Foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped
SHIP_TO_LOCATION_FK VARCHAR2 (4000)
Foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
TASK_FK VARCHAR2 (78)
Foreign key to the Project dimension (Project Task)
TOP_MODEL_ITEM_FK VARCHAR2 (117)
Foreign key to the Item dimension (Top Model Organization Item) when the item is a component in a bill of material
TRX_CURRENCY_FK VARCHAR2 (15)
Foreign key to the Currency dimension (Transaction Currency)
INSTANCE VARCHAR2 (30)
Source instance
LAST_UPDATE_DATE DATE

Standard Who column
BILL_BKLG_MRG_T NUMBER

Billing Backlog Gross Margin in Transaction Currency
SHIP_BKLG_MRG_T NUMBER

Shipping Backlog Gross Margin in Transaction Currency
DLQT_BKLG_MRG_T NUMBER

Delinquent Backlog Gross Margin in Transaction Currency
BILL_BKLG_REV_T NUMBER

Billing Backlog Revenue in Transaction Currency
SHIP_BKLG_REV_T NUMBER

Shipping Backlog Revenue in Transaction Currency
DLQT_BKLG_REV_T NUMBER

Delinquent Backlog Revenue in Transaction Currency
BILL_BKLG_COST_T NUMBER

Billing Backlog Cost in Transaction Currency
SHIP_BKLG_COST_T NUMBER

Shipping Backlog Cost in Transaction Currency
DLQT_BKLG_COST_T NUMBER

Delinquent Backlog Cost in Transaction Currency
BILL_BKLG_MRG_G NUMBER

Billing Backlog Gross Margin in Warehouse Currency
SHIP_BKLG_MRG_G NUMBER

Shipping Backlog Gross Margin in Warehouse Currency
DLQT_BKLG_MRG_G NUMBER

Delinquent Backlog Gross Margin in Warehouse Currency
BILL_BKLG_REV_G NUMBER

Billing Backlog Revenue in Warehouse Currency
SHIP_BKLG_REV_G NUMBER

Shipping Backlog Revenue in Warehouse Currency
DLQT_BKLG_REV_G NUMBER

Delinquent Backlog Revenue in Warehouse Currency
BILL_BKLG_COST_G NUMBER

Billing Backlog Cost in Warehouse Currency
SHIP_BKLG_COST_G NUMBER

Shipping Backlog Cost in Warehouse Currency
DLQT_BKLG_COST_G NUMBER

Delinquent Backlog Cost in Warehouse Currency
QTY_BILL_BKLG_B NUMBER

Billing Backlog Quantity
QTY_SHIP_BKLG_B NUMBER

Shipping Backlog Quantity
QTY_DLQT_BKLG_B NUMBER

Delinquent Backlog Quantity
QTY_UNBILL_SHIP_B NUMBER

Unbilled Shipments Backlog Quantity
UNBILL_SHIP_REV_T NUMBER

Unbilled Shipments Revenue in Transaction Currency
UNBILL_SHIP_REV_G NUMBER

Unbilled Shipments Revenue in Warehouse Currency
UNBILL_SHIP_COST_T NUMBER

Unbilled Shipments Cost in Transaction Currency
UNBILL_SHIP_COST_G NUMBER

Unbilled Shipments Cost in Warehouse Currency
UNBILL_SHIP_MRG_T NUMBER

Unbilled Shipments Gross Margin in Transaction Currency
UNBILL_SHIP_MRG_G NUMBER

Unbilled Shipments Gross Margin in Warehouse Currency
USER_ATTRIBUTE1 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE6 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE7 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE8 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE9 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE10 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE11 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE12 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE13 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE14 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE15 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE16 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE17 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE18 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE19 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE20 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE21 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE22 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE23 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE24 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE25 VARCHAR2 (0)
User attribute
USER_FK1 VARCHAR2 (0)
Foreign key to user defined dimension
USER_FK2 VARCHAR2 (0)
Foreign key to user defined dimension
USER_FK3 VARCHAR2 (0)
Foreign key to user defined dimension
USER_FK4 VARCHAR2 (0)
Foreign key to user defined dimension
USER_FK5 VARCHAR2 (0)
Foreign key to user defined dimension
USER_MEASURE1 NUMBER

User defined measure
USER_MEASURE2 NUMBER

User defined measure
USER_MEASURE3 NUMBER

User defined measure
USER_MEASURE4 NUMBER

User defined measure
USER_MEASURE5 NUMBER

User defined measure

[top of page]

APPS.ISCBV_BACKLOGS_FCV references the following:

APPS
PACKAGE - EDW_CURRENCY
PACKAGE - EDW_GEOGRAPHY_PKG
PACKAGE - EDW_ORGANIZATION_PKG
PACKAGE - EDW_UTIL
PACKAGE - GL_CURRENCY_API
VIEW - ISCBV_BACKLOGS_BASE_FCV
APPS.ISCBV_BACKLOGS_FCV is referenced by following:

APPS
VIEW - ISC_EDW_BACKLOGS_F_FCV

[top of page]

View: ISCBV_BOOKINGS_BASE_FCV

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is used by the ISCBV_BOOKINGS_FCV view to retrieve from the inventory move order lines table the latest pick release date of a sales order line.

Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER

Sales Order Line Id
DATE_LATEST_PICK DATE

Date of last pick release

[top of page]

APPS.ISCBV_BOOKINGS_BASE_FCV references the following:

APPS
SYNONYM - MTL_TXN_REQUEST_LINES
APPS.ISCBV_BOOKINGS_BASE_FCV is referenced by following:

APPS
VIEW - ISCBV_BOOKINGS_FCV

[top of page]

View: ISCBV_EDW_BOOK_SUM1_BASE_FCV

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This is the base view for the Bookings Summary 1 Fact

Columns
Name Datatype Length Mandatory Comments
SEQ_ID NUMBER

Sequence Id used by the collection program
BOOKINGS_PK VARCHAR2 (71)
Unique Identifier
BILL_TO_CUST_FK VARCHAR2 (85)
Foreign key to the Trading Partner dimension (Bill-to Site)
CURRENCY_BASE_FK VARCHAR2 (15)
Foreign key to the Currency dimension (Base Currency)
DATE_BOOKED_FK VARCHAR2 (76)
Foreign key to the Time dimension (Date Booked)
INSTANCE_FK VARCHAR2 (30)
Foreign key to the Instance dimension
OPERATING_UNIT_FK VARCHAR2 (4000)
Foreign key to the Internal Organization dimension (Operating Unit) where the order was booked
SET_OF_BOOKS_FK VARCHAR2 (71)
Foreign key to the Set of Books dimension (GL Set of Book)
BOOKED_AMT_B NUMBER

Total amount of bookings in Base Currency
BOOKED_AMT_G NUMBER

Total amount of bookings in Warehouse Currency
BOOKED_LIST_AMT_B NUMBER

Total amount of bookings in list price in Base Currency
BOOKED_LIST_AMT_G NUMBER

Total amount of bookings in list price in Warehouse Currency
FULFILLED_AMT_B NUMBER

Total amount fulfilled in Base Currency
FULFILLED_AMT_G NUMBER

Total amount fulfilled in Warehouse Currency
INVOICED_AMT_B NUMBER

Total amount invoiced in Base Currency
INVOICED_AMT_G NUMBER

Total amount invoiced in Warehouse Currency
SHIPPED_AMT_B NUMBER

Total amount shipped in Base Currency
SHIPPED_AMT_G NUMBER

Total amount shipped in Warehouse Currency
DATE_BOOKED DATE

Date Booked
DATE_LATEST_FULFILLED DATE

Date latest fulfilled
DATE_LATEST_SHIP DATE

Date latest shipped
DATE_ORDERED DATE

Date Ordered
HEADER_ID NUMBER
Y Sales Order Header Identifier in the source system
INSTANCE VARCHAR2 (30)
Instance
ORDER_NUMBER NUMBER
Y Sales Order Number in the source system
USER_ATTRIBUTE1 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE5 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE6 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE7 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE8 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE9 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE10 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE11 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE12 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE13 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE14 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE15 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE16 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE17 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE18 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE19 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE20 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE21 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE22 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE23 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE24 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE25 VARCHAR2 (0)
User defined attribute
USER_FK1 CHAR (6)
Foreign key to user defined dimension
USER_FK2 CHAR (6)
Foreign key to user defined dimension
USER_FK3 CHAR (6)
Foreign key to user defined dimension
USER_FK4 CHAR (6)
Foreign key to user defined dimension
USER_FK5 CHAR (6)
Foreign key to user defined dimension
USER_MEASURE1 NUMBER

User defined measure
USER_MEASURE2 NUMBER

User defined measure
USER_MEASURE3 NUMBER

User defined measure
USER_MEASURE4 NUMBER

User defined measure
USER_MEASURE5 NUMBER

User defined measure

[top of page]

APPS.ISCBV_EDW_BOOK_SUM1_BASE_FCV references the following:

APPS
PACKAGE - EDW_CURRENCY
SYNONYM - EDW_LOCAL_INSTANCE
SYNONYM - EDW_LOCAL_SYSTEM_PARAMETERS
PACKAGE - EDW_ORGANIZATION_PKG
SYNONYM - FINANCIALS_SYSTEM_PARAMS_ALL
PACKAGE - GL_CURRENCY_API
VIEW - GL_SETS_OF_BOOKS
SYNONYM - ISC_TMP_BOOK_SUM1
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
APPS.ISCBV_EDW_BOOK_SUM1_BASE_FCV is referenced by following:

APPS
VIEW - ISCBV_EDW_BOOK_SUM1_FCV

[top of page]

View: ISCBV_EDW_BOOK_SUM1_FCV

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This is the flexview for the Bookings Summary 1 Fact

Columns
Name Datatype Length Mandatory Comments
SEQ_ID NUMBER

Sequence Id used by the collection program
BOOKINGS_PK VARCHAR2 (71)
Unique Identifier
BILL_TO_CUST_FK VARCHAR2 (85)
Foreign key to the Trading Partner dimension (Bill-to Site)
CURRENCY_BASE_FK VARCHAR2 (15)
Foreign key to the Currency dimension (Base Currency)
DATE_BOOKED_FK VARCHAR2 (76)
Foreign key to the Time dimension (Date Booked)
INSTANCE_FK VARCHAR2 (30)
Foreign key to the Instance dimension
OPERATING_UNIT_FK VARCHAR2 (4000)
Foreign key to the Internal Organization dimension (Operating Unit) where the order was booked
SET_OF_BOOKS_FK VARCHAR2 (71)
Foreign key to the Set of Books dimension (GL Set of Book)
BOOKED_AMT_B NUMBER

Total amount of bookings in Base Currency
BOOKED_AMT_G NUMBER

Total amount of bookings in Warehouse Currency
BOOKED_LIST_AMT_B NUMBER

Total amount of bookings in list price in Base Currency
BOOKED_LIST_AMT_G NUMBER

Total amount of bookings in list price in Warehouse Currency
FULFILLED_AMT_B NUMBER

Total amount fulfilled in Base Currency
FULFILLED_AMT_G NUMBER

Total amount fulfilled in Warehouse Currency
INVOICED_AMT_B NUMBER

Total amount invoiced in Base Currency
INVOICED_AMT_G NUMBER

Total amount invoiced in Warehouse Currency
SHIPPED_AMT_B NUMBER

Total amount shipped in Base Currency
SHIPPED_AMT_G NUMBER

Total amount shipped in Warehouse Currency
DATE_BOOKED DATE

Date Booked
DATE_LATEST_FULFILLED DATE

Date latest fulfilled
DATE_LATEST_SHIP DATE

Date latest shipped
DATE_ORDERED DATE

Date Ordered
HEADER_ID NUMBER
Y Sales Order Header Identifier in the source system
INSTANCE VARCHAR2 (30)
Instance
ORDER_NUMBER NUMBER
Y Sales Order Number in the source system
USER_ATTRIBUTE1 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE5 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE6 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE7 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE8 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE9 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE10 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE11 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE12 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE13 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE14 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE15 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE16 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE17 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE18 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE19 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE20 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE21 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE22 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE23 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE24 VARCHAR2 (0)
User defined attribute
USER_ATTRIBUTE25 VARCHAR2 (0)
User defined attribute
USER_FK1 CHAR (6)
Foreign key to user defined dimension
USER_FK2 CHAR (6)
Foreign key to user defined dimension
USER_FK3 CHAR (6)
Foreign key to user defined dimension
USER_FK4 CHAR (6)
Foreign key to user defined dimension
USER_FK5 CHAR (6)
Foreign key to user defined dimension
USER_MEASURE1 NUMBER

User defined measure
USER_MEASURE2 NUMBER

User defined measure
USER_MEASURE3 NUMBER

User defined measure
USER_MEASURE4 NUMBER

User defined measure
USER_MEASURE5 NUMBER

User defined measure

[top of page]

APPS.ISCBV_EDW_BOOK_SUM1_FCV references the following:

APPS
PACKAGE - EDW_CURRENCY
PACKAGE - EDW_ORGANIZATION_PKG
PACKAGE - GL_CURRENCY_API
VIEW - ISCBV_EDW_BOOK_SUM1_BASE_FCV
APPS.ISCBV_EDW_BOOK_SUM1_FCV is referenced by following:

APPS
VIEW - ISC_EDW_BOOK_SUM1_F_FCV

[top of page]

View: ISC_EDW_BACKLOGS_F_FCV

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
BACKLOGS_PK VARCHAR2 (768)
Unique identifier
BASE_UOM_FK VARCHAR2 (4000)
Foreign key to the UoM dimension
BILL_TO_CUST_FK VARCHAR2 (85)
Foreign key to the Trading Partner dimension (Bill-to Site)
BILL_TO_LOCATION_FK VARCHAR2 (4000)
Foreign key to the Geography dimension (Bill-to Location)
CUSTOMER_FK VARCHAR2 (86)
Foreign key to the Trading Partner dimension (Customer)
DATE_BALANCE_FK VARCHAR2 (76)
Foreign key to the Time dimension (Date of Snapshot)
DEMAND_CLASS_FK VARCHAR2 (61)
Foreign key to the Demand Class dimension
GL_BOOK_FK VARCHAR2 (71)
Foreign key to the Set of Books dimension (GL Set of Book)
INSTANCE_FK VARCHAR2 (30)
Foreign key to the Instance dimension
INV_ORG_FK VARCHAR2 (71)
Foreign key to the Inventory Location dimension (Inventory Organization) from which the Items are issued
ITEM_ORG_FK VARCHAR2 (117)
Foreign key to the Organization Item dimension
OPERATING_UNIT_FK VARCHAR2 (4000)
Foreign key to the Internal Organization dimension (Operating Unit)
ORDER_CATEGORY_FK VARCHAR2 (49)
Foreign key to the Lookup dimension (Sales Order Category)
ORDER_SOURCE_FK VARCHAR2 (257)
Foreign key to the Lookup dimension (Sales Order Source)
ORDER_TYPE_FK VARCHAR2 (45)
Foreign key to the Lookup dimension (Sales Order Type)
SALES_CHANNEL_FK VARCHAR2 (61)
Foreign key to the Sales Channel dimension
SALES_PERSON_FK VARCHAR2 (126)
Foreign key to the Person dimension (Salesperson)
SHIP_TO_CUST_FK VARCHAR2 (85)
Foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped
SHIP_TO_LOCATION_FK VARCHAR2 (4000)
Foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
TASK_FK VARCHAR2 (78)
Foreign key to the Project dimension (Project Task)
TOP_MODEL_ITEM_FK VARCHAR2 (117)
Foreign key to the Item dimension (Top Model Organization Item) when the item is a component in a bill of material
TRX_CURRENCY_FK VARCHAR2 (15)
Foreign key to the Currency dimension (Transaction Currency)
BILL_BKLG_COST_G NUMBER

Billing Backlog Cost in Warehouse Currency
BILL_BKLG_COST_T NUMBER

Billing Backlog Cost in Transaction Currency
BILL_BKLG_MRG_G NUMBER

Billing Backlog Gross Margin in Warehouse Currency
BILL_BKLG_MRG_T NUMBER

Billing Backlog Gross Margin in Transaction Currency
BILL_BKLG_REV_G NUMBER

Billing Backlog Revenue in Warehouse Currency
BILL_BKLG_REV_T NUMBER

Billing Backlog Revenue in Transaction Currency
DLQT_BKLG_COST_G NUMBER

Delinquent Backlog Cost in Warehouse Currency
DLQT_BKLG_COST_T NUMBER

Delinquent Backlog Cost in Transaction Currency
DLQT_BKLG_MRG_G NUMBER

Delinquent Backlog Gross Margin in Warehouse Currency
DLQT_BKLG_MRG_T NUMBER

Delinquent Backlog Gross Margin in Transaction Currency
DLQT_BKLG_REV_G NUMBER

Delinquent Backlog Revenue in Warehouse Currency
DLQT_BKLG_REV_T NUMBER

Delinquent Backlog Revenue in Transaction Currency
QTY_BILL_BKLG_B NUMBER

Billing Backlog Quantity
QTY_DLQT_BKLG_B NUMBER

Delinquent Backlog Quantity
QTY_SHIP_BKLG_B NUMBER

Shipping Backlog Quantity
QTY_UNBILL_SHIP_B NUMBER

Unbilled Shipments Backlog Quantity
SHIP_BKLG_COST_G NUMBER

Shipping Backlog Cost in Warehouse Currency
SHIP_BKLG_COST_T NUMBER

Shipping Backlog Cost in Transaction Currency
SHIP_BKLG_MRG_G NUMBER

Shipping Backlog Gross Margin in Warehouse Currency
SHIP_BKLG_MRG_T NUMBER

Shipping Backlog Gross Margin in Transaction Currency
SHIP_BKLG_REV_G NUMBER

Shipping Backlog Revenue in Warehouse Currency
SHIP_BKLG_REV_T NUMBER

Shipping Backlog Revenue in Transaction Currency
UNBILL_SHIP_COST_G NUMBER

Unbilled Shipments Cost in Warehouse Currency
UNBILL_SHIP_COST_T NUMBER

Unbilled Shipments Cost in Transaction Currency
UNBILL_SHIP_MRG_G NUMBER

Unbilled Shipments Gross Margin in Warehouse Currency
UNBILL_SHIP_MRG_T NUMBER

Unbilled Shipments Gross Margin in Transaction Currency
UNBILL_SHIP_REV_G NUMBER

Unbilled Shipments Revenue in Warehouse Currency
UNBILL_SHIP_REV_T NUMBER

Unbilled Shipments Revenue in Transaction Currency
INSTANCE VARCHAR2 (30)
Source instance
LAST_UPDATE_DATE DATE

Standard Who column
SEQ_ID NUMBER

Sequence id used by the collection program
USER_ATTRIBUTE1 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE6 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE7 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE8 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE9 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE10 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE11 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE12 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE13 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE14 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE15 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE16 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE17 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE18 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE19 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE20 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE21 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE22 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE23 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE24 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE25 VARCHAR2 (0)
User attribute
USER_FK1 CHAR (6)
Foreign key to user defined dimension
USER_FK2 CHAR (6)
Foreign key to user defined dimension
USER_FK3 CHAR (6)
Foreign key to user defined dimension
USER_FK4 CHAR (6)
Foreign key to user defined dimension
USER_FK5 CHAR (6)
Foreign key to user defined dimension
USER_MEASURE1 NUMBER

User defined measure
USER_MEASURE2 NUMBER

User defined measure
USER_MEASURE3 NUMBER

User defined measure
USER_MEASURE4 NUMBER

User defined measure
USER_MEASURE5 NUMBER

User defined measure

[top of page]

APPS.ISC_EDW_BACKLOGS_F_FCV references the following:

APPS
PACKAGE - EDW_CURRENCY
PACKAGE - EDW_GEOGRAPHY_PKG
PACKAGE - EDW_ORGANIZATION_PKG
PACKAGE - EDW_UTIL
PACKAGE - GL_CURRENCY_API
VIEW - ISCBV_BACKLOGS_FCV
APPS.ISC_EDW_BACKLOGS_F_FCV is referenced by following:

APPS
PACKAGE BODY - ISC_EDW_BACKLOGS_F_C

[top of page]

View: ISC_EDW_BACKLOG_S

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the Backlog Snapshot fact table.

Columns
Name Datatype Length Mandatory Comments
AREA_FK NUMBER

Foreign key to the Geography dimension, Area level
BUS_GRP_FK NUMBER

Foreign key to the Internal Organization dimension, Business Group level
CATG_FK NUMBER

Foreign key to the Item dimension, Category level
COUNTRY_FK NUMBER

Foreign key to the Geography dimension, Country level
DAY_FK NUMBER

Foreign key to the Time dimension, Day level
INT_ORGA_FK NUMBER
Y Foreign key to the Internal Organization dimension, Internal Organization level
LEGAL_ENT_FK NUMBER

Foreign key to the Internal Organization dimension, Legal Entity level
OPER_UNIT_FK NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
ORDER_SOURCE_FK NUMBER

Foreign key to the Lookup dimension (Order Source)
ORDER_TYPE_FK NUMBER

Foreign key to the Lookup dimension (Order Type)
REGION_FK NUMBER

Foreign key to the Geography dimension, Region level
SALES_CHANNEL_FK NUMBER

Foreign key to the Sales Channel dimension, Sales Channel level
BILLING_COST NUMBER

Billing Backlog amount at cost
BILLING_MARGIN NUMBER

Billing Backlog Margin (Billing Backlog at Sell Price - Billing Backlog at Cost)
BILLING_REVENUE NUMBER

Billing Backlog at Sell Price
DELINQUENT_COST NUMBER

Delinquent Backlog amount at cost
DELINQUENT_MARGIN NUMBER

Delinquent Backlog Margin (Delinquent Backlog at Sell Price - Delinquent Backlog at Cost)
DELINQUENT_REVENUE NUMBER

Delinquent Backlog at Sell Price
SHIPPING_COST NUMBER

Shipping Backlog amount at cost
SHIPPING_MARGIN NUMBER

Shipping Backlog Margin (Shipping Backlog at Sell Price - Shipping Backlog at Cost)
SHIPPING_REVENUE NUMBER

Shipping Backlog at Sell Price
UNBILL_COST NUMBER

Unbilled Shipments Backlog amount at cost
UNBILL_MARGIN NUMBER

Unbilled Shipments Backlog Margin (Unbilled Shipments Backlog at Sell Price - Unbilled Shipments Backlog at Cost)
UNBILL_REVENUE NUMBER

Unbilled Shipments Backlog at Sell Price

[top of page]

APPS.ISC_EDW_BACKLOG_S references the following:

APPS
SYNONYM - EDW_GEOGRAPHY_M
SYNONYM - EDW_ITEMS_M
SYNONYM - EDW_ORGANIZATION_M
SYNONYM - EDW_TIME_M
SYNONYM - ISC_EDW_BACKLOGS_F

APPS.ISC_EDW_BACKLOG_S is not referenced by any database object

[top of page]

View: ISC_EDW_BOOKINGS_BILLINGS_S

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the Bookings fact table.

Columns
Name Datatype Length Mandatory Comments
AREA_FK NUMBER

Foreign key to the Geography dimension, Area level
BUS_GRP_FK NUMBER

Foreign key to the Internal Organization dimension, Business Group level
CATG_FK NUMBER

Foreign key to the Item dimension, Category level
COUNTRY_FK NUMBER

Foreign key to the Geography dimension, Country level
INT_ORGA_FK NUMBER
Y Foreign key to the Internal Organization dimension, Internal Organization level
LEGAL_ENT_FK NUMBER

Foreign key to the Internal Organization dimension, Legal Entity level
OPER_UNIT_FK NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
ORDER_SOURCE_FK NUMBER

Foreign key to the Lookup dimension (Order Source)
ORDER_TYPE_FK NUMBER

Foreign key to the Lookup dimension (Order Type)
PERIOD_FK NUMBER

Foreign key to the Time dimension, Period level
QTR_FK NUMBER

Foreign key to the Time dimension, Quarter level
REGION_FK NUMBER

Foreign key to the Geography dimension, Region level
SALES_CHANNEL_FK NUMBER

Foreign key to the Sales Channel dimension, Sales Channel level
YEAR_FK NUMBER

Foreign key to the Time dimension, Year level
BILLINGS NUMBER

Billing amount
CANCELLATIONS NUMBER

Cancellation amount
COGS NUMBER

Cost of Goods Sold
DISCOUNTS NUMBER

Discounts amount
GROSS_BOOKINGS NUMBER

Gross Bookings amount
GROSS_MARGIN NUMBER

Gross Margin (Net Bookings - COGS)
NET_BOOKINGS NUMBER

Net Bookings (at Sell Price)
NET_BOOKINGS_AT_LIST NUMBER

Bookings (at List Price)
RETURNS NUMBER

Returns amount

[top of page]

APPS.ISC_EDW_BOOKINGS_BILLINGS_S references the following:

APPS
SYNONYM - EDW_GEOGRAPHY_M
SYNONYM - EDW_ITEMS_M
SYNONYM - EDW_ORGANIZATION_M
SYNONYM - EDW_TIME_M
SYNONYM - ISC_EDW_BOOKINGS_F

APPS.ISC_EDW_BOOKINGS_BILLINGS_S is not referenced by any database object

[top of page]

View: ISC_EDW_BOOKINGS_F_FCV

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
BOOKINGS_PK VARCHAR2 (81)
Unique Identifier
AGREEMENT_TYPE_FK VARCHAR2 (52)
Foreign key to the Lookup dimension (Customer Agreement Type)
BILL_TO_CUST_FK VARCHAR2 (85)
Foreign key to the Trading Partner dimension (Bill-to Site)
BILL_TO_LOC_FK VARCHAR2 (4000)
Foreign key to the Geography dimension (Bill-to Location)
CAMPAIGN_ACTL_FK CHAR (6)
Foreign key to the Campaign dimension (Campaign Actual)
CAMPAIGN_INIT_FK CHAR (6)
Foreign key to the Campaign dimension (Campaign Attributed)
CAMPAIGN_STATUS_ACTL_FK CHAR (6)
Foreign key to the Campaign Status dimension (Campaign Status Actual)
CAMPAIGN_STATUS_INIT_FK CHAR (6)
Foreign key to the Campaign Status dimension (Campaign Status Attributed)
CANCEL_REASON_FK VARCHAR2 (46)
Foreign key to the Lookup dimension (Cancel Reason)
CURRENCY_TRN_FK VARCHAR2 (15)
Foreign key to the Currency dimension (Transaction Currency)
CUSTOMER_FK VARCHAR2 (86)
Foreign key to the Trading Partner dimension (Customer)
DATE_BOOKED_FK VARCHAR2 (76)
Foreign key to the Time dimension (Date Booked)
DATE_PROMISED_FK VARCHAR2 (76)
Foreign key to the Time dimension (Date Promised)
DATE_REQUESTED_FK VARCHAR2 (76)
Foreign key to the Time dimension (Date Requested)
DATE_SCHEDULED_FK VARCHAR2 (76)
Foreign key to the Time dimension (Date Scheduled)
DEMAND_CLASS_FK VARCHAR2 (61)
Foreign key to the Demand Class dimension
EVENT_OFFER_ACTL_FK CHAR (6)
Foreign key to the Event dimension (Event Offer Actual)
EVENT_OFFER_INIT_FK CHAR (6)
Foreign key to the Event dimension (Event Offer Attributed)
EVENT_OFFER_REG_FK CHAR (6)
Foreign key to the Event dimension (Event Registration)
INSTANCE_FK VARCHAR2 (30)
Foreign key to the Instance dimension
INV_ORG_FK VARCHAR2 (71)
Foreign key to the Inventory Location dimension (Inventory Organization) from which the Items are issued
ITEM_ORG_FK VARCHAR2 (117)
Foreign key to the Item dimension (Organization Item)
MARKET_SEGMENT_FK CHAR (6)
Foreign key to the Market Segment dimension
MEDCHN_ACTL_FK CHAR (6)
Foreign key to the Media Channel dimension (Media Channel Actual)
MEDCHN_INIT_FK CHAR (6)
Foreign key to the Media Channel dimension (Media Channel Attributed)
OFFER_HDR_FK CHAR (6)
Foreign key to the Offer dimension (Header level)
OFFER_LINE_FK CHAR (6)
Foreign key to the Offer dimension (Line level)
OPERATING_UNIT_FK VARCHAR2 (4000)
Foreign key to the Internal Organization dimension (Operating Unit) where the order was booked
ORDER_CATEGORY_FK VARCHAR2 (49)
Foreign key to the Lookup dimension (Sales Order Category)
ORDER_SOURCE_FK VARCHAR2 (257)
Foreign key to the Lookup dimension (Sales Order Source)
ORDER_TYPE_FK VARCHAR2 (45)
Foreign key to the Lookup dimension (Sales Order Type)
RETURN_REASON_FK VARCHAR2 (52)
Foreign key to the Lookup dimension (Return Reason)
SALES_CHANNEL_FK VARCHAR2 (61)
Foreign key to the Sales Channel dimension
SALES_PERSON_FK VARCHAR2 (126)
Foreign key to the Person dimension (Salesperson)
SET_OF_BOOKS_FK VARCHAR2 (71)
Foreign key to the Set of Books dimension (GL Set of Book)
SHIP_TO_CUST_FK VARCHAR2 (85)
Foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped
SHIP_TO_LOC_FK VARCHAR2 (4000)
Foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
SOURCE_LIST_FK CHAR (6)
Foreign key to the Source List dimension
TARGET_SEGMENT_ACTL_FK CHAR (6)
Foreign key to the Target Segment dimension (Target Segment Actual)
TARGET_SEGMENT_INIT_FK CHAR (6)
Foreign key to the Target Segment dimension (Target Segment Attributed)
TASK_FK VARCHAR2 (78)
Foreign key to the Project dimension (Project Task)
TOP_MODEL_FK VARCHAR2 (117)
Foreign key to the Item dimension (Top Model Organization Item) when the item is a component in a bill of material (BOM)
UOM_UOM_FK VARCHAR2 (4000)
Foreign key to the UoM dimension
QTY_CANCELLED NUMBER

Quantity Canceled
QTY_FULFILLED NUMBER

Quantity Fulfilled
QTY_INVOICED NUMBER

Quantity Invoiced
QTY_ORDERED NUMBER

Quantity Ordered
QTY_RESERVED NUMBER

Quantity Reserved
QTY_RETURNED NUMBER

Quantity Returned
QTY_SHIPPED NUMBER

Quantity Shipped
TOTAL_NET_ORDER_VALUE VARCHAR2 (0)
Total net value for the entire order (non additive across lines of the same order)
UNIT_COST_G NUMBER

Unit Cost in Warehouse currency
UNIT_COST_T NUMBER

Unit Cost in Transaction currency
UNIT_LIST_PRC_G NUMBER

Unit List Price in Warehouse currency
UNIT_LIST_PRC_T NUMBER

Unit List Price in Transaction currency
UNIT_SELL_PRC_G NUMBER

Unit Sell Price in Warehouse Currency
UNIT_SELL_PRC_T NUMBER

Unit Sell Price in Transaction Currency
AGREEMENT_ID VARCHAR2 (40)
Id of the Agreement to which this order relates to
BOOKED_DATE DATE

Date Booked
CONFIGURATION_ITEM_FLAG VARCHAR2 (1)
Flag indicating if the item is part of a configuration.
CONVERSION_DATE DATE

Currency Conversion Date
CONVERSION_RATE NUMBER

Currency Conversion Rate
CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CUST_PO_NUMBER VARCHAR2 (50)
Customer's Purchase Order Number
DATE_FULFILLED DATE

Date Fulfilled
DATE_LATEST_PICK DATE

Date Latest Pick
DATE_LATEST_SHIP DATE

Date Latest Ship
FULFILLMENT_FLAG VARCHAR2 (1)
Flag indicating if the line has been fulfilled (typically fully shipped and invoiced for shippable items, fully invoiced for non-shippable items)
HEADER_ID NUMBER

Sales Order Header Identifier in the source system
INCLUDED_ITEM_FLAG VARCHAR2 (1)
Flag indicating if the line is invoiceable or not. This flag is set to "Y" if the sales order line is not Internal, an "INCLUDED" item, and the invoiceable flag for this item = "Y"
INSTANCE VARCHAR2 (30)
Source instance
ITEM_TYPE_CODE VARCHAR2 (30)
Code for the item type : STANDARD, CONFIG, KIT, MODEL, CLASS, OPTION, INCLUDED, SERVICE
LAST_UPDATE_DATE DATE

Standard Who column
LINE_DETAIL_ID CHAR (6)
Sales Order Line Details Identifier in the source system
LINE_ID NUMBER

Sales Order Line Identifier in the source system
ORDERED_DATE DATE

Date Ordered
ORDER_NUMBER NUMBER

Sales Order Number in the source system
PRICE_LIST_ID VARCHAR2 (40)
Id of the Price List from which the List Price was issued
PROMISED_DATE DATE

Date Promised
REQUESTED_DATE DATE

Date Requested
SCHEDULED_DATE DATE

Date Scheduled
SEQ_ID NUMBER

Sequence Id used by the collection program
SHIPPABLE_FLAG VARCHAR2 (1)
Flag indicating if the line is shippable or not.
TRANSACTABLE_FLAG CHAR (6)
Reserved for future use
VIEW_TYPE NUMBER

Column used by the collection program
USER_ATTRIBUTE1 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE2 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE3 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE4 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE5 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE6 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE7 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE8 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE9 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE10 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE11 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE12 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE13 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE14 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE15 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE16 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE17 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE18 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE19 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE20 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE21 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE22 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE23 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE24 VARCHAR2 (0)
Uder defined attribute
USER_ATTRIBUTE25 VARCHAR2 (0)
Uder defined attribute
USER_FK1 CHAR (6)
System generated foreign key to user defined dimension
USER_FK2 CHAR (6)
System generated foreign key to user defined dimension
USER_FK3 CHAR (6)
System generated foreign key to user defined dimension
USER_FK4 CHAR (6)
System generated foreign key to user defined dimension
USER_FK5 CHAR (6)
System generated foreign key to user defined dimension
USER_MEASURE1 NUMBER

User defined measure
USER_MEASURE2 NUMBER

User defined measure
USER_MEASURE3 NUMBER

User defined measure
USER_MEASURE4 NUMBER

User defined measure
USER_MEASURE5 NUMBER

User defined measure

[top of page]

APPS.ISC_EDW_BOOKINGS_F_FCV references the following:

APPS
PACKAGE - EDW_CURRENCY
PACKAGE - EDW_GEOGRAPHY_PKG
PACKAGE - EDW_ORGANIZATION_PKG
PACKAGE - EDW_UTIL
PACKAGE - GL_CURRENCY_API
VIEW - ISCBV_BOOKINGS_FCV
APPS.ISC_EDW_BOOKINGS_F_FCV is referenced by following:

APPS
PACKAGE BODY - ISC_EDW_BOOKINGS_F_C

[top of page]

View: ISC_EDW_BOOK_FULFILL_CYCLE_S

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the Bookings fact table.

Columns
Name Datatype Length Mandatory Comments
AREA_FK NUMBER

Foreign key to the Geography dimension, Area level
BUS_GRP_FK NUMBER

Foreign key to the Internal Organization dimension, Business Group level
CATG_FK NUMBER

Foreign key to Item dimension, Category level
COUNTRY_FK NUMBER

Foreign key to the Geography dimension, Country level
INT_ORGA_FK NUMBER
Y Foreign key to the Internal Organization dimension, Internal Organization level
LEGAL_ENT_FK NUMBER

Foreign key to the Internal Organization dimension, Legal Entity level
OPER_UNIT_FK NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
ORDER_SOURCE_FK NUMBER

Foreign key to the Lookup dimension (Order Source)
ORDER_TYPE_FK NUMBER

Foreign key to the Lookup dimension (Order Type)
PERIOD_FK NUMBER

Foreign key to the Time dimension, Period level
QTR_FK NUMBER

Foreign key to the Time dimension, Quarter level
REGION_FK NUMBER

Foreign key to the Geography dimension, Region level
SALES_CHANNEL_FK NUMBER

Foreign key to the Sales Channel dimension, Sales Channel level
YEAR_FK NUMBER

Foreign key to the Time dimension, Year level
BOOK_TO_FULFILL_CYCLE NUMBER

Book to Fulfill Cycle Time
LINE_ID VARCHAR2 (80)
Sales Order Line Id

[top of page]

APPS.ISC_EDW_BOOK_FULFILL_CYCLE_S references the following:

APPS
SYNONYM - EDW_GEOGRAPHY_M
SYNONYM - EDW_ITEMS_M
SYNONYM - EDW_LOOKUP_M
SYNONYM - EDW_ORGANIZATION_M
SYNONYM - EDW_TIME_M
SYNONYM - ISC_EDW_BOOKINGS_F

APPS.ISC_EDW_BOOK_FULFILL_CYCLE_S is not referenced by any database object

[top of page]

View: ISC_EDW_BOOK_SUM1_F_FCV

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
SEQ_ID NUMBER

BOOKINGS_PK VARCHAR2 (71)
BILL_TO_CUST_FK VARCHAR2 (85)
CURRENCY_BASE_FK VARCHAR2 (15)
DATE_BOOKED_FK VARCHAR2 (76)
INSTANCE_FK VARCHAR2 (30)
OPERATING_UNIT_FK VARCHAR2 (4000)
SET_OF_BOOKS_FK VARCHAR2 (71)
BOOKED_AMT_B NUMBER

BOOKED_AMT_G NUMBER

BOOKED_LIST_AMT_B NUMBER

BOOKED_LIST_AMT_G NUMBER

FULFILLED_AMT_B NUMBER

FULFILLED_AMT_G NUMBER

INVOICED_AMT_B NUMBER

INVOICED_AMT_G NUMBER

SHIPPED_AMT_B NUMBER

SHIPPED_AMT_G NUMBER

DATE_BOOKED DATE

DATE_LATEST_FULFILLED DATE

DATE_LATEST_SHIP DATE

DATE_ORDERED DATE

HEADER_ID NUMBER
Y
INSTANCE VARCHAR2 (30)
ORDER_NUMBER NUMBER
Y
USER_ATTRIBUTE1 VARCHAR2 (0)
USER_ATTRIBUTE2 VARCHAR2 (0)
USER_ATTRIBUTE3 VARCHAR2 (0)
USER_ATTRIBUTE4 VARCHAR2 (0)
USER_ATTRIBUTE5 VARCHAR2 (0)
USER_ATTRIBUTE6 VARCHAR2 (0)
USER_ATTRIBUTE7 VARCHAR2 (0)
USER_ATTRIBUTE8 VARCHAR2 (0)
USER_ATTRIBUTE9 VARCHAR2 (0)
USER_ATTRIBUTE10 VARCHAR2 (0)
USER_ATTRIBUTE11 VARCHAR2 (0)
USER_ATTRIBUTE12 VARCHAR2 (0)
USER_ATTRIBUTE13 VARCHAR2 (0)
USER_ATTRIBUTE14 VARCHAR2 (0)
USER_ATTRIBUTE15 VARCHAR2 (0)
USER_ATTRIBUTE16 VARCHAR2 (0)
USER_ATTRIBUTE17 VARCHAR2 (0)
USER_ATTRIBUTE18 VARCHAR2 (0)
USER_ATTRIBUTE19 VARCHAR2 (0)
USER_ATTRIBUTE20 VARCHAR2 (0)
USER_ATTRIBUTE21 VARCHAR2 (0)
USER_ATTRIBUTE22 VARCHAR2 (0)
USER_ATTRIBUTE23 VARCHAR2 (0)
USER_ATTRIBUTE24 VARCHAR2 (0)
USER_ATTRIBUTE25 VARCHAR2 (0)
USER_FK1 CHAR (6)
USER_FK2 CHAR (6)
USER_FK3 CHAR (6)
USER_FK4 CHAR (6)
USER_FK5 CHAR (6)
USER_MEASURE1 NUMBER

USER_MEASURE2 NUMBER

USER_MEASURE3 NUMBER

USER_MEASURE4 NUMBER

USER_MEASURE5 NUMBER

[top of page]

APPS.ISC_EDW_BOOK_SUM1_F_FCV references the following:

APPS
PACKAGE - EDW_CURRENCY
PACKAGE - EDW_ORGANIZATION_PKG
PACKAGE - GL_CURRENCY_API
VIEW - ISCBV_EDW_BOOK_SUM1_FCV
APPS.ISC_EDW_BOOK_SUM1_F_FCV is referenced by following:

APPS
PACKAGE BODY - ISC_EDW_BOOK_SUM1_F_C

[top of page]

View: ISC_EDW_BOOK_TO_SHIP_CYCLE_S

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the Bookings fact table.

Columns
Name Datatype Length Mandatory Comments
AREA_FK NUMBER

Foreign key to the Geography dimension, Area level
BUS_GRP_FK NUMBER

Foreign key to the Internal Organization dimension, Business Group level
CATG_FK NUMBER

Foreign key to the Item dimension, Category Level
COUNTRY_FK NUMBER

Foreign key to the Geography dimension, Country level
INT_ORGA_FK NUMBER
Y Foreign key to the Internal Organization dimension, Internal Organization level
LEGAL_ENT_FK NUMBER

Foreign key to the Internal Organization dimension, Legal Entity level
OPER_UNIT_FK NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
ORDER_SOURCE_FK NUMBER

Foreign key to the Lookup dimension (Order Source)
ORDER_TYPE_FK NUMBER

Foreign key to the Lookup dimension (Order Type)
PERIOD_FK NUMBER

Foreign key to the Time dimension, Period level
QTR_FK NUMBER

Foreign key to the Time dimension, Quarter level
REGION_FK NUMBER

Foreign key to the Geography dimension, Region level
SALES_CHANNEL_FK NUMBER

Foreign key to the Sales Channel dimension, Sales Channel level
YEAR_FK NUMBER

Foreign key to the Time dimension, Year level
BOOK_TO_LATEST_PICK_CYCLE NUMBER

Book to Latest Pick release Cycle Time
BOOK_TO_LATEST_SHIP_CYCLE NUMBER

Book to Latest Ship Cycle Time
LINE_ID VARCHAR2 (80)
Sales Order Line Id

[top of page]

APPS.ISC_EDW_BOOK_TO_SHIP_CYCLE_S references the following:

APPS
SYNONYM - EDW_GEOGRAPHY_M
SYNONYM - EDW_ITEMS_M
SYNONYM - EDW_LOOKUP_M
SYNONYM - EDW_ORGANIZATION_M
SYNONYM - EDW_TIME_M
SYNONYM - ISC_EDW_BOOKINGS_F

APPS.ISC_EDW_BOOK_TO_SHIP_CYCLE_S is not referenced by any database object

[top of page]

View: ISC_EDW_ORDER_ENTRY_S

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the Bookings fact table.

Columns
Name Datatype Length Mandatory Comments
AREA_FK NUMBER

Foreign key to the Geography dimension, Area level
BUS_GRP_FK NUMBER

Foreign key to the Internal Organization dimension, Business Group level
CATG_FK NUMBER

Foreign key to the Item dimension, Catogory level
COUNTRY_FK NUMBER

Foreign key to the Geography dimension, Country level
HEADER_ID VARCHAR2 (80)
Order Header Id
INT_ORGA_FK NUMBER
Y Foreign key to the Internal Organization dimension, Internal Organization level
LEGAL_ENT_FK NUMBER

Foreign key to the Internal Organization dimension, Legal Entity level
OPER_UNIT_FK NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
ORDER_SOURCE_FK NUMBER

Foreign key to the Lookup dimension (Order Source)
ORDER_TYPE_FK NUMBER

Foreign key to the Lookup dimension (Order Type)
PERIOD_FK NUMBER

Foreign key to the Time dimension, Period level
QTR_FK NUMBER

Foreign key to the Time dimension, Quarter level
REGION_FK NUMBER

Foreign key to the Geography dimension, Region level
SALES_CHANNEL_FK NUMBER

Foreign key to the Sales Channel dimension, Sales Channel level
YEAR_FK NUMBER

Foreign key to the Time dimension, Year level
ORDER_ENTRY_CYCLE NUMBER

Order Entry Cycle Time

[top of page]

APPS.ISC_EDW_ORDER_ENTRY_S references the following:

APPS
SYNONYM - EDW_GEOGRAPHY_M
SYNONYM - EDW_ITEMS_M
SYNONYM - EDW_LOOKUP_M
SYNONYM - EDW_ORGANIZATION_M
SYNONYM - EDW_TIME_M
SYNONYM - ISC_EDW_BOOKINGS_F

APPS.ISC_EDW_ORDER_ENTRY_S is not referenced by any database object

[top of page]

View: ISC_EDW_ORDER_FULFILL_SHIP_S

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the Bookings fact table.

Columns
Name Datatype Length Mandatory Comments
AREA_FK NUMBER

Foreign key to the Geography dimension, Area level
BUS_GRP_FK NUMBER

Foreign key to the Internal Organization dimension, Business Group level
CATG_FK NUMBER

Foreign key to the Lookup dimension (Order Category)
COUNTRY_FK NUMBER

Foreign key to the Geography dimension, Country level
INT_ORGA_FK NUMBER
Y Foreign key to the Internal Organization dimension, Internal Organization level
LEGAL_ENT_FK NUMBER

Foreign key to the Internal Organization dimension, Legal Entity level
OPER_UNIT_FK NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
ORDER_SOURCE_FK NUMBER

Foreign key to the Lookup dimension (Order Source)
ORDER_TYPE_FK NUMBER

Foreign key to the Lookup dimension (Order Type)
PERIOD_FK NUMBER

Foreign key to the Time dimension, Period level
QTR_FK NUMBER

Foreign key to the Time dimension, Quarter level
REGION_FK NUMBER

Foreign key to the Geography dimension, Region level
SALES_CHANNEL_FK NUMBER

Foreign key to the Sales Channel dimension, Sales Channel level
YEAR_FK NUMBER

Foreign key to the Time dimension, Year level
ONEDAYPICK NUMBER

Number of Orders Booked and Picked within 24 hours
ONEDAYSHIP NUMBER

Number of Orders Booked and Shipped within 24 hours
NOWKENDPICK NUMBER

Number of Orders Booked and Picked within 24 hours, weekends excluded
NOWKENDSHIP NUMBER

Number of Orders Booked and Shipped within 24 hours, weekends excluded
FULFILLED NUMBER

Counter of fulfilled orders
HEADER_ID VARCHAR2 (121)
Sales Order Header Id

[top of page]

APPS.ISC_EDW_ORDER_FULFILL_SHIP_S references the following:

APPS
SYNONYM - EDW_GEOGRAPHY_M
SYNONYM - EDW_ITEMS_M
SYNONYM - EDW_LOOKUP_M
SYNONYM - EDW_ORGANIZATION_M
SYNONYM - EDW_TIME_M
SYNONYM - ISC_EDW_BOOKINGS_F

APPS.ISC_EDW_ORDER_FULFILL_SHIP_S is not referenced by any database object

[top of page]

View: ISC_EDW_ORDER_FULFILL_VOLUME_S

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the Bookings fact table.

Columns
Name Datatype Length Mandatory Comments
AREA_FK NUMBER

Foreign key to the Geography dimension, Area level
BUS_GRP_FK NUMBER

Foreign key to the Internal Organization dimension, Business Group level
CATG_FK NUMBER

Foreign key to the Item dimension, Category level
COUNTRY_FK NUMBER

Foreign key to the Geography dimension, Country level
INT_ORGA_FK NUMBER
Y Foreign key to the Internal Organization dimension, Internal Organization level
LEGAL_ENT_FK NUMBER

Foreign key to the Internal Organization dimension, Legal Entity level
OPER_UNIT_FK NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
ORDER_SOURCE_FK NUMBER

Foreign key to the Lookup dimension (Order Source)
ORDER_TYPE_FK NUMBER

Foreign key to the Lookup dimension (Order Type)
PERIOD_FK NUMBER

Foreign key to the Time dimension, Period level
QTR_FK NUMBER

Foreign key to the Time dimension, Quarter level
REGION_FK NUMBER

Foreign key to the Geography dimension, Region level
SALES_CHANNEL_FK NUMBER

Foreign key to the Sales Channel dimension, Sales Channel level
YEAR_FK NUMBER

Foreign key to the Time dimension, Year level
ORDERS_FULFILLED NUMBER

Number of Orders Fulfilled

[top of page]

APPS.ISC_EDW_ORDER_FULFILL_VOLUME_S references the following:

APPS
SYNONYM - EDW_GEOGRAPHY_M
SYNONYM - EDW_ITEMS_M
SYNONYM - EDW_LOOKUP_M
SYNONYM - EDW_ORGANIZATION_M
SYNONYM - EDW_TIME_M
SYNONYM - ISC_EDW_BOOKINGS_F

APPS.ISC_EDW_ORDER_FULFILL_VOLUME_S is not referenced by any database object

[top of page]

View: ISC_EDW_ORDER_SHIP_VOLUME_S

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the Bookings fact table.

Columns
Name Datatype Length Mandatory Comments
AREA_FK NUMBER

Foreign key to the Geography dimension, Area level
BUS_GRP_FK NUMBER

Foreign key to the Internal Organization dimension, Business Group level
CATG_FK NUMBER

Foreign key to the Item dimension, Category level
COUNTRY_FK NUMBER

Foreign key to the Geography dimension, Country level
INT_ORGA_FK NUMBER
Y Foreign key to the Internal Organization dimension, Internal Organization level
LEGAL_ENT_FK NUMBER

Foreign key to the Internal Organization dimension, Legal Entity level
OPER_UNIT_FK NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
ORDER_SOURCE_FK NUMBER

Foreign key to the Lookup dimension (Order Source)
ORDER_TYPE_FK NUMBER

Foreign key to the Lookup dimension (Order Type)
PERIOD_FK NUMBER

Foreign key to the Time dimension, Period level
QTR_FK NUMBER

Foreign key to the Time dimension, Quarter level
REGION_FK NUMBER

Foreign key to the Geography dimension, Region level
SALES_CHANNEL_FK NUMBER

Foreign key to the Sales Channel dimension, Sales Channel level
YEAR_FK NUMBER

Foreign key to the Time dimension, Year level
ORDERS_SHIPPED NUMBER

Number of Orders Shipped

[top of page]

APPS.ISC_EDW_ORDER_SHIP_VOLUME_S references the following:

APPS
SYNONYM - EDW_GEOGRAPHY_M
SYNONYM - EDW_ITEMS_M
SYNONYM - EDW_LOOKUP_M
SYNONYM - EDW_ORGANIZATION_M
SYNONYM - EDW_TIME_M
SYNONYM - ISC_EDW_BOOKINGS_F

APPS.ISC_EDW_ORDER_SHIP_VOLUME_S is not referenced by any database object

[top of page]

View: ISC_EDW_ORD_RECV_PAY_CYCLE_S

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the Purchase Order Distribution fact table.

Columns
Name Datatype Length Mandatory Comments
AREA_FK NUMBER

Foreign key to the Geography dimension, Area level
BUS_GRP_FK NUMBER

Foreign key to the Internal Organization dimension, Business Group level
CATG_FK NUMBER

Foreign key to the Item dimension, Category level
COUNTRY_FK NUMBER

Foreign key to the Geography dimension, Country level
INT_ORGA_FK NUMBER
Y Foreign key to the Internal Organization dimension, Internal Organization level
LEGAL_ENT_FK NUMBER

Foreign key to the Internal Organization dimension, Legal Entity level
OPER_UNIT_FK NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
PERIOD_FK NUMBER

Foreign key to the Time dimension, Period level
QTR_FK NUMBER

Foreign key to the Time dimension, Quarter level
REGION_FK NUMBER

Foreign key to the Geography dimension, Region level
TRD_PARTNER_FK NUMBER

Foreign key to the Trading Partners dimension, Trading Partners level
YEAR_FK NUMBER

Foreign key to the Time dimension, Year level
ORDER_TO_PAY_CYCLE_TIME NUMBER

Order to Pay Cycle Time
ORDER_TO_RECEIVE_CYCLE_TIME NUMBER

Order to Receive Cycle Time
RECEIVE_TO_PAY_CYCLE_TIME NUMBER

Receive to Pay Cycle Time

[top of page]

APPS.ISC_EDW_ORD_RECV_PAY_CYCLE_S references the following:

APPS
SYNONYM - EDW_GEOGRAPHY_M
SYNONYM - EDW_ITEMS_M
SYNONYM - EDW_ORGANIZATION_M
SYNONYM - EDW_TIME_M
SYNONYM - EDW_TRD_PARTNER_M
SYNONYM - POA_EDW_PO_DIST_F

APPS.ISC_EDW_ORD_RECV_PAY_CYCLE_S is not referenced by any database object

[top of page]

View: ISC_EDW_PICK_TO_SHIP_CYCLE_S

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the Bookings fact table.

Columns
Name Datatype Length Mandatory Comments
AREA_FK NUMBER

Foreign key to the Geography dimension, Area level
BUS_GRP_FK NUMBER

Foreign key to the Internal Organization dimension, Business Group level
CATG_FK NUMBER

Foreign key to the Item dimension, Category level
COUNTRY_FK NUMBER

Foreign key to the Geography dimension, Country level
INT_ORGA_FK NUMBER
Y Foreign key to the Internal Organization dimension, Internal Organization level
LEGAL_ENT_FK NUMBER

Foreign key to the Internal Organization dimension, Legal Entity level
OPER_UNIT_FK NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
ORDER_SOURCE_FK NUMBER

Foreign key to the Lookup dimension (Order Source)
ORDER_TYPE_FK NUMBER

Foreign key to the Lookup dimension (Order Type)
PERIOD_FK NUMBER

Foreign key to the Time dimension, Period level
QTR_FK NUMBER

Foreign key to the Time dimension, Quarter level
REGION_FK NUMBER

Foreign key to the Geography dimension, Region level
SALES_CHANNEL_FK NUMBER

Foreign key to the Sales Channel dimension, Sales Channel level
YEAR_FK NUMBER

Foreign key to the Time dimension, Year level
PICK_TO_LATEST_SHIP_CYCLE NUMBER

Pick Release to Latest Ship Cycle Time
LINE_ID VARCHAR2 (80)
Sales Order Line Id

[top of page]

APPS.ISC_EDW_PICK_TO_SHIP_CYCLE_S references the following:

APPS
SYNONYM - EDW_GEOGRAPHY_M
SYNONYM - EDW_ITEMS_M
SYNONYM - EDW_LOOKUP_M
SYNONYM - EDW_ORGANIZATION_M
SYNONYM - EDW_TIME_M
SYNONYM - ISC_EDW_BOOKINGS_F

APPS.ISC_EDW_PICK_TO_SHIP_CYCLE_S is not referenced by any database object

[top of page]

View: ISC_EDW_RECEIVE_PAY_CYCLE_S

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the PO Distribution fact table.

Columns
Name Datatype Length Mandatory Comments
AREA_FK NUMBER

Foreign key to the Geography dimension, Area level
BUS_GRP_FK NUMBER

Foreign key to the Internal Organization dimension, Business Group level
CATG_FK NUMBER

Foreign key to the Item dimension, Category level
COUNTRY_FK NUMBER

Foreign key to the Geography dimension, Country level
INT_ORGA_FK NUMBER
Y Foreign key to the Internal Organization dimension, Internal Organization level
LEGAL_ENT_FK NUMBER

Foreign key to the Internal Organization dimension, Legal Entity level
OPER_UNIT_FK NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
PERIOD_FK NUMBER

Foreign key to the Time dimension, Period level
QTR_FK NUMBER

Foreign key to the Time dimension, Quarter level
REGION_FK NUMBER

Foreign key to the Geography dimension, Region level
TRD_PARTNER_FK NUMBER

Foreign key to the Trading Partners dimension, Trading Partners level
YEAR_FK NUMBER

Foreign key to the Time dimension, Year level
RECEIVE_TO_PAY_CYCLE_TIME NUMBER

Receive to Pay Cycle Time

[top of page]

APPS.ISC_EDW_RECEIVE_PAY_CYCLE_S references the following:

APPS
SYNONYM - EDW_GEOGRAPHY_M
SYNONYM - EDW_ITEMS_M
SYNONYM - EDW_ORGANIZATION_M
SYNONYM - EDW_TIME_M
SYNONYM - EDW_TRD_PARTNER_M
SYNONYM - POA_EDW_PO_DIST_F

APPS.ISC_EDW_RECEIVE_PAY_CYCLE_S is not referenced by any database object

[top of page]

View: ISC_OPI_IND_CR_TAB_BASE_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the AR Operations Summary table.

Columns
Name Datatype Length Mandatory Comments
SOBL_BOOK_FK_KEY NUMBER

Foreign key to the Set of Books dimension, Set of Books level
MEASURE_NAME VARCHAR2 (255) Y Name measure
MEASURE_QTD NUMBER

Quarter-to-date measure
MEASURE_WK NUMBER

Week measure
SORT_ORDER NUMBER

Sort order

[top of page]

APPS.ISC_OPI_IND_CR_TAB_BASE_V references the following:

APPS
VIEW - BISBV_PERFORMANCE_MEASURES
SYNONYM - EDW_GL_BOOK_M
SYNONYM - FII_AR_OPERATIONS_SUMMARY
PACKAGE - FII_TIME_WH_API
PUBLIC
SYNONYM - DUAL
- DUAL
APPS.ISC_OPI_IND_CR_TAB_BASE_V is referenced by following:

APPS
VIEW - ISC_OPI_IND_CR_TAB_S

[top of page]

View: ISC_OPI_IND_CR_TAB_S

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the AR Operations Summary table.

Columns
Name Datatype Length Mandatory Comments
SOBL_BOOK_FK_KEY NUMBER

Foreign key to the Set of Books dimension, Set of Books level
MEASURE_NAME VARCHAR2 (255) Y Name measure
MEASURE_QTD NUMBER

Quarter-to-date measure
MEASURE_WK NUMBER

Week measure
MEASURE_Q_W NUMBER

Quarter-to-date measure without weekends
SORT_ORDER NUMBER

Sort order

[top of page]

APPS.ISC_OPI_IND_CR_TAB_S references the following:

APPS
PACKAGE - FII_TIME_WH_API
VIEW - ISC_OPI_IND_CR_TAB_BASE_V

APPS.ISC_OPI_IND_CR_TAB_S is not referenced by any database object

[top of page]

View: ISC_OPI_IND_QTD_S

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the AR Operations Summary table.

Columns
Name Datatype Length Mandatory Comments
SOBL_BOOK_FK_KEY NUMBER

Foreign key to the Set of Books dimension, Set of Books level
OPER_UNIT_FK_KEY NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
OPER_UNIT_NAME VARCHAR2 (500)
Operating Unit name
NUM_OF_ORDERS NUMBER

Number of orders
BOOKED_VALUE NUMBER

Booked value
SHIPPED_VALUE NUMBER

Shipped value
INVOICED_AR_VALUE NUMBER

Invoiced Accounts Receivable value
INVOICED_OE_VALUE NUMBER

Invoiced Order Entry value
EARNED_REVENUE NUMBER

Earned revenue
CASH_COLLECTED NUMBER

Cash collected

[top of page]

APPS.ISC_OPI_IND_QTD_S references the following:

APPS
SYNONYM - EDW_GL_BOOK_M
SYNONYM - EDW_ORGANIZATION_M
SYNONYM - FII_AR_OPERATIONS_SUMMARY
PACKAGE - FII_TIME_WH_API

APPS.ISC_OPI_IND_QTD_S is not referenced by any database object

[top of page]

View: ISC_OPI_IND_WK_S

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the AR Operations Summary table.

Columns
Name Datatype Length Mandatory Comments
SOBL_BOOK_FK_KEY NUMBER

Foreign key to the Set of Books dimension, Set of Books level
OPER_UNIT_FK_KEY NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
OPER_UNIT_NAME VARCHAR2 (500)
Operating Unit name
NUM_OF_ORDERS NUMBER

Number of orders
BOOKED_VALUE NUMBER

Booked value
SHIPPED_VALUE NUMBER

Shipped value
INVOICED_AR_VALUE NUMBER

Invoiced Accounts Receivable value
INVOICED_OE_VALUE NUMBER

Invoiced Order Entry value
EARNED_REVENUE NUMBER

Earned revenue
CASH_COLLECTED NUMBER

Cash collected

[top of page]

APPS.ISC_OPI_IND_WK_S references the following:

APPS
SYNONYM - EDW_GL_BOOK_M
SYNONYM - EDW_ORGANIZATION_M
SYNONYM - FII_AR_OPERATIONS_SUMMARY
PACKAGE - FII_TIME_WH_API

APPS.ISC_OPI_IND_WK_S is not referenced by any database object

[top of page]

View: ISC_OPI_TOP_ORD_QTD_BASE_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the Booking Summary table.

Columns
Name Datatype Length Mandatory Comments
SOBL_BOOK_FK_KEY NUMBER

Foreign key to the Set of Books dimension, Set of Books level
OPER_UNIT_FK_KEY NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
CAL_DAY_FK_KEY NUMBER

Foreign key to the Time dimension, Calendar Day level
EC_PERIOD_FK_KEY NUMBER

Foreign key to the Enterprise Calendar dimension, Period level
EC_QTR_FK_KEY NUMBER

Foreign key to the Enterprise Calendar dimension, Quarter level
TPRT_FK_KEY NUMBER

Foreign key to the Trade Partner dimension, Trade Partner level
ORDER_NUMBER VARCHAR2 (80)
Order number
CUSTOMER_NAME VARCHAR2 (480)
Customer name
ORDERED_DATE DATE

Ordered date
NET_BOOKED_VALUE NUMBER

Net booked value
BOOKED_DATE DATE

Booked date
SHIPPED_VALUE NUMBER

Shipped value
LATEST_SHIP_DATE DATE

Latest ship date
FULFILLED_VALUE NUMBER

Fulfilled value
FULFILLED_DATE DATE

Date fulfilled
INVOICED_VALUE NUMBER

Invoiced value
HEADER_ID VARCHAR2 (80)
Unique identifier of the Header of an order
NUM_OF_ORDERS NUMBER

Number of orders
RANK NUMBER

Ranking by Net Order Value

[top of page]

APPS.ISC_OPI_TOP_ORD_QTD_BASE_V references the following:

APPS
SYNONYM - EDW_GL_BOOK_M
SYNONYM - EDW_ORGANIZATION_M
SYNONYM - EDW_TIME_M
SYNONYM - EDW_TRD_PARTNER_M
PACKAGE - FII_TIME_WH_API
SYNONYM - ISC_EDW_BOOK_SUM1_F
APPS.ISC_OPI_TOP_ORD_QTD_BASE_V is referenced by following:

APPS
VIEW - ISC_OPI_TOP_ORD_QTD_S

[top of page]

View: ISC_OPI_TOP_ORD_QTD_S

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the Booking Summary table.

Columns
Name Datatype Length Mandatory Comments
SOBL_BOOK_FK_KEY NUMBER

Foreign key to the Set of Books dimension, Set of Books level
OPER_UNIT_FK_KEY NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
CAL_DAY_FK_KEY NUMBER

Foreign key to the Time dimension, Calendar Day level
EC_PERIOD_FK_KEY NUMBER

Foreign key to the Enterprise Calendar dimension, Period level
EC_QTR_FK_KEY NUMBER

Foreign key to the Enterprise Calendar dimension, Quarter level
TPRT_FK_KEY NUMBER

Foreign key to the Trade Partner dimension, Trade Partner level
ORDER_NUMBER VARCHAR2 (80)
Order number
CUSTOMER_NAME VARCHAR2 (480)
Customer name
ORDERED_DATE DATE

Ordered date
NET_BOOKED_VALUE NUMBER

Net booked value
BOOKED_DATE DATE

Booked date
SHIPPED_VALUE NUMBER

Shipped value
LATEST_SHIP_DATE DATE

Latest ship date
FULFILLED_VALUE NUMBER

Fulfilled value
FULFILLED_DATE DATE

Date fulfilled
INVOICED_VALUE NUMBER

Invoiced value
HEADER_ID VARCHAR2 (80)
Unique identifier of the Header of an order
NUM_OF_ORDERS NUMBER

Number of orders
RANK NUMBER

Ranking by Net Order Value

[top of page]

APPS.ISC_OPI_TOP_ORD_QTD_S references the following:

APPS
PACKAGE - FII_TIME_WH_API
VIEW - ISC_OPI_TOP_ORD_QTD_BASE_V

APPS.ISC_OPI_TOP_ORD_QTD_S is not referenced by any database object

[top of page]

View: ISC_OPI_TOP_ORD_WK_BASE_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the Booking Summary table.

Columns
Name Datatype Length Mandatory Comments
SOBL_BOOK_FK_KEY NUMBER

Foreign key to the Set of Books dimension, Set of Books level
OPER_UNIT_FK_KEY NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
CAL_DAY_FK_KEY NUMBER

Foreign key to the Time dimension, Calendar Day level
TPRT_FK_KEY NUMBER

Foreign key to the Trade Partner dimension, Trade Partner level
ORDER_NUMBER VARCHAR2 (80)
Order number
CUSTOMER_NAME VARCHAR2 (480)
Customer name
ORDERED_DATE DATE

Ordered date
NET_BOOKED_VALUE NUMBER

Net booked value
BOOKED_DATE DATE

Booked date
SHIPPED_VALUE NUMBER

Shipped value
LATEST_SHIP_DATE DATE

Latest ship date
FULFILLED_VALUE NUMBER

Fulfilled value
FULFILLED_DATE DATE

Date fulfilled
INVOICED_VALUE NUMBER

Invoiced value
HEADER_ID VARCHAR2 (80)
Unique identifier of the Header of an order
NUM_OF_ORDERS NUMBER

Number of orders
RANK NUMBER

Ranking by Net Order Value

[top of page]

APPS.ISC_OPI_TOP_ORD_WK_BASE_V references the following:

APPS
SYNONYM - EDW_GL_BOOK_M
SYNONYM - EDW_ORGANIZATION_M
SYNONYM - EDW_TIME_M
SYNONYM - EDW_TRD_PARTNER_M
PACKAGE - FII_TIME_WH_API
SYNONYM - ISC_EDW_BOOK_SUM1_F
APPS.ISC_OPI_TOP_ORD_WK_BASE_V is referenced by following:

APPS
VIEW - ISC_OPI_TOP_ORD_WK_S

[top of page]

View: ISC_OPI_TOP_ORD_WK_S

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the Booking Summary table.

Columns
Name Datatype Length Mandatory Comments
SOBL_BOOK_FK_KEY NUMBER

Foreign key to the Set of Books dimension, Set of Books level
OPER_UNIT_FK_KEY NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
CAL_DAY_FK_KEY NUMBER

Foreign key to the Time dimension, Calendar Day level
TPRT_FK_KEY NUMBER

Foreign key to the Trade Partner dimension, Trade Partner level
ORDER_NUMBER VARCHAR2 (80)
Order number
CUSTOMER_NAME VARCHAR2 (480)
Customer name
ORDERED_DATE DATE

Ordered date
NET_BOOKED_VALUE NUMBER

Net booked value
BOOKED_DATE DATE

Booked date
SHIPPED_VALUE NUMBER

Shipped value
LATEST_SHIP_DATE DATE

Latest ship date
FULFILLED_VALUE NUMBER

Fulfilled value
FULFILLED_DATE DATE

Date fulfilled
INVOICED_VALUE NUMBER

Invoiced value
HEADER_ID VARCHAR2 (80)
Unique identifier of the Header of an order
NUM_OF_ORDERS NUMBER

Number of orders
RANK NUMBER

Ranking by Net Order Value

[top of page]

APPS.ISC_OPI_TOP_ORD_WK_S references the following:

APPS
PACKAGE - FII_TIME_WH_API
VIEW - ISC_OPI_TOP_ORD_WK_BASE_V

APPS.ISC_OPI_TOP_ORD_WK_S is not referenced by any database object

[top of page]

View: ISC_RISK_INDICATORS_S

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the AR Risk Indicator table.

Columns
Name Datatype Length Mandatory Comments
OPER_UNIT_FK_KEY NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
OPER_UNIT_NAME VARCHAR2 (150)
Operating Unit name
SHIP_BKLG_AMT_G NUMBER

Total amount of shipping backlog in warehouse currency
DLQT_BKLG_AMT_G NUMBER

Total amount of delinquent backlog in warehouse currency
OPEN_REC_AMT_G NUMBER

Total amount of open receivables in warehouse currency
PASTDUE_REC_AMT_G NUMBER

Total amount of past due receivables in warehouse currency

[top of page]

APPS.ISC_RISK_INDICATORS_S references the following:

APPS
SYNONYM - FII_AR_RISK_INDICATOR_F

APPS.ISC_RISK_INDICATORS_S is not referenced by any database object

[top of page]

View: ISC_RISK_SHIP_DLQT_S

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

This view is designed to be used by Oracle Performance Measure Viewer (PMV). The _FK columns are mapping the dimension levels, while measures are retrieved from the Backlog Summary table.

Columns
Name Datatype Length Mandatory Comments
OPER_UNIT_FK_KEY NUMBER

Foreign key to the Internal Organization dimension, Operating Unit level
CUSTOMER_FK_KEY NUMBER

Foreign key to the customer level of Trading Partner dimension
ORDER_NUMBER VARCHAR2 (80)
Order Number
CUSTOMER_NAME VARCHAR2 (80)
Customer Name
BOOKED_DATE DATE

Date of the transaction when it has been booked
SHIP_BKLG_LINE_COUNT NUMBER

Total number of shipping backlog lines
SHIP_BKLG_AMT_G NUMBER

Total amount of shipping backlog in warehouse currency
DAYS_OPEN NUMBER

Total number of days between the booked date and today (sysdate) for backlog orders
DLQT_BKLG_LINE_COUNT NUMBER

Total number of delinquent backlog lines
DLQT_BKLG_AMT_G NUMBER

Total amount of delinquent backlog in warehouse currency
MAX_DAYS_LATE NUMBER

Total number of days between the scheduled date and today (sysdate) for delinquent backlog orders
HEADER_ID VARCHAR2 (80)
Unique identifier of the Header of an order

[top of page]

APPS.ISC_RISK_SHIP_DLQT_S references the following:

APPS
SYNONYM - ISC_EDW_BACKLOG_SUM1_F

APPS.ISC_RISK_SHIP_DLQT_S is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract