eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.MTH_SRC_WORKDAY_SHIFTS_V

Object Details

Object Name:	MTH_SRC_WORKDAY_SHIFTS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SHIFT_DATE	DATE		Yes	Shift date
SOURCE_ORG_CODE	VARCHAR2	(3)		Organization Code
USER_ATTR1	VARCHAR2	(150)		User-defined attribute
USER_ATTR2	VARCHAR2	(150)		User-defined attribute
USER_ATTR3	VARCHAR2	(150)		User-defined attribute
USER_ATTR4	VARCHAR2	(150)		User-defined attribute
USER_ATTR5	VARCHAR2	(150)		User-defined attribute
USER_MEASURE1	NUMBER			User-defined measure
USER_MEASURE2	NUMBER			User-defined measure
USER_MEASURE3	NUMBER			User-defined measure
USER_MEASURE4	NUMBER			User-defined measure
USER_MEASURE5	NUMBER			User-defined measure
SHIFT_WORKDAY_PK	VARCHAR2	(150)		Shift workday identifier
SYSTEM_FK	VARCHAR2	(4000)		Reference to source system
FROM_DATE	DATE			Start date of the shift including timestamp
SHIFT_NUM	NUMBER		Yes	Shift number
TO_DATE	DATE			End date of shift including timestamp
SHIFT_NAME	VARCHAR2	(240)		Shift name
SHIFT_TYPE	VARCHAR2	(80)	Yes	Value are Both, Prod-shift, or Non-prod-shift
GRAVEYARD_SHIFT	VARCHAR2	(150)		Value is the Meaning from FND_LOOKUP
FROM_TIME	NUMBER		Yes	From Time
TO_TIME	NUMBER		Yes	To Time

Query Text

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


SELECT SHIFT_DATE
,      SOURCE_ORG_CODE
,      USER_ATTR1
,      USER_ATTR2
,      USER_ATTR3
,      USER_ATTR4
,      USER_ATTR5
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      SHIFT_WORKDAY_PK
,      SYSTEM_FK
,      FROM_DATE
,      SHIFT_NUM
,      TO_DATE
,      SHIFT_NAME
,      SHIFT_TYPE
,      GRAVEYARD_SHIFT
,      FROM_TIME
,      TO_TIME
FROM APPS.MTH_SRC_WORKDAY_SHIFTS_V;

Dependencies

[top of page]

APPS.MTH_SRC_WORKDAY_SHIFTS_V references the following:

APPS: BOM_CALENDAR_SHIFTS; BOM_SHIFT_DATES; BOM_SHIFT_TIMES; FND_LOOKUP_VALUES; FND_PROFILE - show dependent code; MTL_PARAMETERS

APPS.MTH_SRC_WORKDAY_SHIFTS_V is not referenced by any database object