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.HXTFV_SHIFTS

Object Details

Object Name:	HXTFV_SHIFTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	HXT.HXTFV_SHIFTS
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
WEEKLY_SCHEDULE	VARCHAR2	(80)	Yes	Work plan name
WEEK_DAY	VARCHAR2	(3)		Day of the week
SEQ_NO	NUMBER	(1)	Yes	Work shift day sequence
EARLY_START	NUMBER	(4)		Work shift early start time
LATE_STOP	NUMBER	(4)		Work shift late stop time
SHIFT	VARCHAR2	(80)	Yes	Work shift name
HOURS	NUMBER	(7)		Work shift hours
STANDARD_START	NUMBER	(4)		Work shift start time
STANDARD_STOP	NUMBER	(4)		Work shift stop time
SHIFT_CODE	VARCHAR2	(5)		Work Shift code
SHIFT_DESCRIPTION	VARCHAR2	(255)		Work Shift description
SHIFT_EARLY_START	NUMBER	(4)		Start of time period that overtime is not paid
SHIFT_LATE_STOP	NUMBER	(4)		End of time period that overtime is not paid
SHIFT_DIFF_ELEMENT	VARCHAR2	(80)		Name of the shift differential policy element
SHIFT_PREM_ELEMENT	VARCHAR2	(80)		Name of the shift premium policy element
OFF_SHIFT_PREMIUM_ID	NUMBER	(9)
SHIFT_DIFF_ID	NUMBER	(9)
SHIFT_ID	NUMBER	(15)	Yes
WORK_SCHEDULE_ID	NUMBER	(15)	Yes

Query Text

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


SELECT WEEKLY_SCHEDULE
,      WEEK_DAY
,      SEQ_NO
,      EARLY_START
,      LATE_STOP
,      SHIFT
,      HOURS
,      STANDARD_START
,      STANDARD_STOP
,      SHIFT_CODE
,      SHIFT_DESCRIPTION
,      SHIFT_EARLY_START
,      SHIFT_LATE_STOP
,      SHIFT_DIFF_ELEMENT
,      SHIFT_PREM_ELEMENT
,      OFF_SHIFT_PREMIUM_ID
,      SHIFT_DIFF_ID
,      SHIFT_ID
,      WORK_SCHEDULE_ID
FROM APPS.HXTFV_SHIFTS;

Dependencies

[top of page]

APPS.HXTFV_SHIFTS references the following:

APPS: HXT_SHIFTS; HXT_WEEKLY_WORK_SCHEDULES; HXT_WORK_SHIFTS; PAY_ELEMENT_TYPES_F

APPS.HXTFV_SHIFTS is not referenced by any database object