[Home] [Help] [Dependency Information]

TABLE: CRP.CRP_SIMULATION_SETS

Object Details

Object Name:	CRP_SIMULATION_SETS
Object Type:	TABLE
Owner:	CRP
FND Design Data:	CRP.CRP_SIMULATION_SETS
Subobject Name:
Status:	VALID

CRP_SIMULATION_SETS stores the names of the simulation sets.
Simulation sets are used to group multiple resource changes. Each
resource change defined in BOM_RESOURCE_CHANGES can be associated with
a simulation set. The USE_IN_WIP flag determines if the resource
change associated with a particular simulation set is used by the WIP
scheduler. The RCCP and CRP reports and inquiries can be run for a
particular simulation set.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CRP_SIMULATION_SETS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SIMULATION_SET ORGANIZATION_ID

Columns

Query Text

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

SELECT SIMULATION_SET
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      USE_IN_WIP_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM CRP.CRP_SIMULATION_SETS;

Dependencies

[top of page]

CRP.CRP_SIMULATION_SETS does not reference any database object

CRP.CRP_SIMULATION_SETS is referenced by following:

CRP

CRP_SIMULATION_SETS#