[Home] [Help]
[Dependency Information]
VIEW: WIP.WIP_BIS_MNRA_TEMP#
Object Details
Object Name: | WIP_BIS_MNRA_TEMP# |
Object Type: | VIEW |
Owner: | WIP |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
SHIFT_DATE |
DATE |
|
|
|
RESOURCE_ID |
NUMBER |
|
|
|
DEPARTMENT_ID |
NUMBER |
|
|
|
ORGANIZATION_ID |
NUMBER |
|
|
|
SIMULATION_SET |
VARCHAR2 |
(32) |
|
|
AVAILABLE_HOURS |
NUMBER |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT SHIFT_DATE
, RESOURCE_ID
, DEPARTMENT_ID
, ORGANIZATION_ID
, SIMULATION_SET
, AVAILABLE_HOURS
FROM WIP.WIP_BIS_MNRA_TEMP#;
Dependencies
[top of page]
WIP.WIP_BIS_MNRA_TEMP# references the following:
-
WIP
-
WIP_BIS_MNRA_TEMP
WIP.WIP_BIS_MNRA_TEMP# is referenced by following:
-
APPS
-
WIP_BIS_MNRA_TEMP