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

VIEW: FLM.FLM_EXE_PREFERENCES#

Object Details
Object Name: FLM_EXE_PREFERENCES#
Object Type: VIEW
Owner: FLM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PREFERENCE_ID NUMBER
Yes
ORGANIZATION_ID NUMBER

LINE_ID NUMBER

STANDARD_OPERATION_ID NUMBER

WORKSTATION_ENABLED VARCHAR2 (1)
DATA_ENTRY_MODE NUMBER

AUTO_SCHEDULE_TRANSITION VARCHAR2 (1)
LAST_OPERATION_ID NUMBER

PICK_RELEASE_OPERATION_ID NUMBER

LABEL_START_OPERATION_ID NUMBER

LABEL_END_OPERATION_ID NUMBER

AUTO_ECO_CHECK VARCHAR2 (1)
ECO_DAYS_PRIOR NUMBER

ECO_DAYS_AFTER NUMBER

INSTRUCTION_FRAME_HEIGHT NUMBER

CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
OBJECT_VERSION_NUMBER NUMBER
Yes
BACKFLUSH_OPTION NUMBER

VIEW_ALL_SCHEDULES VARCHAR2 (1)
Query Text

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


SELECT PREFERENCE_ID
,      ORGANIZATION_ID
,      LINE_ID
,      STANDARD_OPERATION_ID
,      WORKSTATION_ENABLED
,      DATA_ENTRY_MODE
,      AUTO_SCHEDULE_TRANSITION
,      LAST_OPERATION_ID
,      PICK_RELEASE_OPERATION_ID
,      LABEL_START_OPERATION_ID
,      LABEL_END_OPERATION_ID
,      AUTO_ECO_CHECK
,      ECO_DAYS_PRIOR
,      ECO_DAYS_AFTER
,      INSTRUCTION_FRAME_HEIGHT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      OBJECT_VERSION_NUMBER
,      BACKFLUSH_OPTION
,      VIEW_ALL_SCHEDULES
FROM FLM.FLM_EXE_PREFERENCES#;

Dependencies

[top of page]

FLM.FLM_EXE_PREFERENCES# references the following:

SchemaFLM
TableFLM_EXE_PREFERENCES
FLM.FLM_EXE_PREFERENCES# is referenced by following:

SchemaAPPS
SynonymFLM_EXE_PREFERENCES