[Home] [Help] [Dependency Information]
Object Name: | MSC_ST_NET_RESOURCE_AVAIL |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | MSC.MSC_ST_NET_RESOURCE_AVAIL |
Subobject Name: | |
Status: | VALID |
The staging table used by the collection program to validate and process data for table MSC_NET_RESOURCE_AVAIL.
Tablespace: | |
---|---|
PCT Free: | |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Organization identifier | ||
DEPARTMENT_ID | NUMBER | Department identifier (-1 for lines) | ||
RESOURCE_ID | NUMBER | Resource identifier | ||
SHIFT_NUM | NUMBER | Shift number | ||
SHIFT_DATE | DATE | Calendar date | ||
FROM_TIME | NUMBER | Shift start time | ||
TO_TIME | NUMBER | Shift end time | ||
CAPACITY_UNITS | NUMBER | Number of units available during the time interval | ||
SIMULATION_SET | VARCHAR2 | (10) | Simulation set identifier | |
AGGREGATE_RESOURCE_ID | NUMBER | Reference to aggregate resource, if resource aggregated (denormalized column) | ||
DELETED_FLAG | NUMBER | Yes/No flag indicating whether the row will be deleted | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Concurrent Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
PROGRAM_ID | NUMBER | Concurrent Who column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
SR_INSTANCE_ID | NUMBER | Source application instance identifier | ||
REFRESH_ID | NUMBER | Refresh identifier populate by the collection program |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, DEPARTMENT_ID
, RESOURCE_ID
, SHIFT_NUM
, SHIFT_DATE
, FROM_TIME
, TO_TIME
, CAPACITY_UNITS
, SIMULATION_SET
, AGGREGATE_RESOURCE_ID
, DELETED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SR_INSTANCE_ID
, REFRESH_ID
FROM MSC.MSC_ST_NET_RESOURCE_AVAIL;
MSC.MSC_ST_NET_RESOURCE_AVAIL does not reference any database object
MSC.MSC_ST_NET_RESOURCE_AVAIL is referenced by following:
|
|
|