eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
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®,
OracleDevConnect SM, Oracle® Discoverer™,
Oracle® Expert™, Oracle Financials®, OracleGOLD SM,
OracleIncident SM, OracleJSP™,
OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURY SM,
OracleMetaLink SM, Oraclemetals SM, OracleMobile™, Oracle Names®,
Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®,
Oracle OpenWorld®, OraclePLATINUM SM,
Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®,
Oracle Quality®, Oracle Secure Network Services®, OracleSILVER SM,
Oracle® SQL/Services™, Oracle® SQL*TutorSM,
OracleSTERLING SM, 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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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
[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]