[Home] [Help] [Dependency Information]
Object Name: | HXTFV_SHIFTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | HXT.HXTFV_SHIFTS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
APPS.HXTFV_SHIFTS is not referenced by any database object
|
|
|