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

TABLE: ISC.ISC_DBI_PLAN_ORG_SNAPSHOTS

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


Base summary table for the Plan Mangement page, built mainly on the MSC_PLAN_ORGANIZATIONS table. It contains the organizations that participate to the plan in Oracle Advanced Planning and Scheduling (APS).


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

Plan Snapshot Identifier
ORGANIZATION_ID NUMBER

Organization Identifier
Query Text

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


SELECT SNAPSHOT_ID
,      ORGANIZATION_ID
FROM ISC.ISC_DBI_PLAN_ORG_SNAPSHOTS;

Dependencies

[top of page]

ISC.ISC_DBI_PLAN_ORG_SNAPSHOTS does not reference any database object

ISC.ISC_DBI_PLAN_ORG_SNAPSHOTS is referenced by following:

SchemaAPPS
SynonymISC_DBI_PLAN_ORG_SNAPSHOTS