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

TABLE: ISC.ISC_DBI_PLAN_SNAPSHOTS

Object Details
Object Name: ISC_DBI_PLAN_SNAPSHOTS
Object Type: TABLE
Owner: ISC
Subobject Name:
Status: VALID


Base summary table for the Plan Mangement page, built mainly on the MSC_PLANS table. It contains the basic plan snapshot information.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 30
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_ID NUMBER

Plan Snapshot Identifier
PLAN_ID NUMBER

Plan Identifier
ORGANIZATION_ID NUMBER

Organization Identifier
COMPILE_DESIGNATOR VARCHAR2 (30)
Name of the plan
CURR_PLAN_TYPE NUMBER

Specify whether the plan is MRP, DRP or MPS plan
CUTOFF_DATE DATE

End date of the planning horizon
DATA_START_DATE DATE

Data Start Date
DESCRIPTION VARCHAR2 (80)
Textual description of the plan
ORG_CNT NUMBER

A distinct count of the number of inventory organizations that are planned in the associated plan
PURGE_FLAG VARCHAR2 (1)
Flag to indicate whether the snapshot has been marked for deletion.
SNAPSHOT_DATE DATE

Date at which the Snapshot was taken
CONSTRAINED_FLAG NUMBER

Flag to indicate whether it is a constrained plan.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SNAPSHOT_ID
,      PLAN_ID
,      ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      CURR_PLAN_TYPE
,      CUTOFF_DATE
,      DATA_START_DATE
,      DESCRIPTION
,      ORG_CNT
,      PURGE_FLAG
,      SNAPSHOT_DATE
,      CONSTRAINED_FLAG
FROM ISC.ISC_DBI_PLAN_SNAPSHOTS;

Dependencies

[top of page]

ISC.ISC_DBI_PLAN_SNAPSHOTS does not reference any database object

ISC.ISC_DBI_PLAN_SNAPSHOTS is referenced by following:

SchemaAPPS
SynonymISC_DBI_PLAN_SNAPSHOTS