[Home] [Help]
[Dependency Information]
VIEW: APPS.MTH_SHIFT_REFERENCE_MV#
Object Details
Object Name: | MTH_SHIFT_REFERENCE_MV# |
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
PLANT_FK_KEY |
NUMBER |
|
Yes |
|
SHIFT_DATE |
DATE |
|
|
|
TO_DATE |
DATE |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT PLANT_FK_KEY
, SHIFT_DATE
, TO_DATE
FROM APPS.MTH_SHIFT_REFERENCE_MV#;
Dependencies
[top of page]
APPS.MTH_SHIFT_REFERENCE_MV# references the following:
-
APPS
-
MTH_ENTITY_SUSTAIN_ASPECT
-
MTH_ENTITY_SUSTAIN_ASPECT_HOUR
-
MTH_EQUIPMENTS_EXT_B
-
MTH_EQUIP_OUTPUT
-
MTH_EQUIP_OUTPUT_SUMMARY
-
MTH_EQUIP_PROD_PERFORMANCE_F
-
MTH_EQUIP_PROD_PERF_DETAIL_F
-
MTH_EQUIP_PROD_SCHEDULE_F
-
MTH_EQUIP_STANDARD_RATES_F
-
MTH_EQUIP_STATUSES
-
MTH_EQUIP_STATUS_SUMMARY
-
MTH_EVENTS
-
MTH_PROD_MTL_CONSUMED_TXN_F
-
MTH_PROD_MTL_PRODUCED_TXN_F
-
MTH_PROD_SEGMENTS_TXN_F
-
MTH_RESOURCE_TXN_F
-
MTH_TAG_READINGS
-
MTH_TAG_READINGS_ERR
-
MTH_TAG_READINGS_T_STG
-
MTH_USER_ENTITIES_EXT_B
-
MTH_WORKDAY_SHIFTS_D
APPS.MTH_SHIFT_REFERENCE_MV# is not referenced by any database object