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

VIEW: BOM.BOM_OPERATION_SEQUENCES#

Object Details
Object Name: BOM_OPERATION_SEQUENCES#
Object Type: VIEW
Owner: BOM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
OPERATION_SEQUENCE_ID NUMBER
Yes
ROUTING_SEQUENCE_ID NUMBER
Yes
OPERATION_SEQ_NUM NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

STANDARD_OPERATION_ID NUMBER

DEPARTMENT_ID NUMBER
Yes
OPERATION_LEAD_TIME_PERCENT NUMBER

MINIMUM_TRANSFER_QUANTITY NUMBER

COUNT_POINT_TYPE NUMBER
Yes
OPERATION_DESCRIPTION VARCHAR2 (240)
EFFECTIVITY_DATE DATE
Yes
DISABLE_DATE DATE

BACKFLUSH_FLAG NUMBER
Yes
OPTION_DEPENDENT_FLAG NUMBER
Yes
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

OPERATION_TYPE NUMBER

REFERENCE_FLAG NUMBER

PROCESS_OP_SEQ_ID NUMBER

LINE_OP_SEQ_ID NUMBER

YIELD NUMBER

CUMULATIVE_YIELD NUMBER

REVERSE_CUMULATIVE_YIELD NUMBER

LABOR_TIME_CALC NUMBER

MACHINE_TIME_CALC NUMBER

TOTAL_TIME_CALC NUMBER

LABOR_TIME_USER NUMBER

MACHINE_TIME_USER NUMBER

TOTAL_TIME_USER NUMBER

NET_PLANNING_PERCENT NUMBER

X_COORDINATE NUMBER

Y_COORDINATE NUMBER

INCLUDE_IN_ROLLUP NUMBER

OPERATION_YIELD_ENABLED NUMBER

OLD_OPERATION_SEQUENCE_ID NUMBER

ACD_TYPE NUMBER

REVISED_ITEM_SEQUENCE_ID NUMBER

ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
CHANGE_NOTICE VARCHAR2 (10)
IMPLEMENTATION_DATE DATE

ECO_FOR_PRODUCTION NUMBER

SHUTDOWN_TYPE VARCHAR2 (30)
ACTUAL_IPK NUMBER

CRITICAL_TO_QUALITY VARCHAR2 (1)
VALUE_ADDED VARCHAR2 (1)
MACHINE_PROCESS_EFFICIENCY NUMBER

LABOR_PROCESS_EFFICIENCY NUMBER

TOTAL_PROCESS_EFFICIENCY NUMBER

LONG_DESCRIPTION VARCHAR2 (4000)
CONFIG_ROUTING_ID NUMBER

MODEL_OP_SEQ_ID NUMBER

LOWEST_ACCEPTABLE_YIELD NUMBER

USE_ORG_SETTINGS NUMBER

QUEUE_MANDATORY_FLAG NUMBER

RUN_MANDATORY_FLAG NUMBER

TO_MOVE_MANDATORY_FLAG NUMBER

SHOW_NEXT_OP_BY_DEFAULT NUMBER

SHOW_SCRAP_CODE NUMBER

SHOW_LOT_ATTRIB NUMBER

TRACK_MULTIPLE_RES_USAGE_DATES NUMBER

CHECK_SKILL NUMBER

Query Text

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


SELECT OPERATION_SEQUENCE_ID
,      ROUTING_SEQUENCE_ID
,      OPERATION_SEQ_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      STANDARD_OPERATION_ID
,      DEPARTMENT_ID
,      OPERATION_LEAD_TIME_PERCENT
,      MINIMUM_TRANSFER_QUANTITY
,      COUNT_POINT_TYPE
,      OPERATION_DESCRIPTION
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      BACKFLUSH_FLAG
,      OPTION_DEPENDENT_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OPERATION_TYPE
,      REFERENCE_FLAG
,      PROCESS_OP_SEQ_ID
,      LINE_OP_SEQ_ID
,      YIELD
,      CUMULATIVE_YIELD
,      REVERSE_CUMULATIVE_YIELD
,      LABOR_TIME_CALC
,      MACHINE_TIME_CALC
,      TOTAL_TIME_CALC
,      LABOR_TIME_USER
,      MACHINE_TIME_USER
,      TOTAL_TIME_USER
,      NET_PLANNING_PERCENT
,      X_COORDINATE
,      Y_COORDINATE
,      INCLUDE_IN_ROLLUP
,      OPERATION_YIELD_ENABLED
,      OLD_OPERATION_SEQUENCE_ID
,      ACD_TYPE
,      REVISED_ITEM_SEQUENCE_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      CHANGE_NOTICE
,      IMPLEMENTATION_DATE
,      ECO_FOR_PRODUCTION
,      SHUTDOWN_TYPE
,      ACTUAL_IPK
,      CRITICAL_TO_QUALITY
,      VALUE_ADDED
,      MACHINE_PROCESS_EFFICIENCY
,      LABOR_PROCESS_EFFICIENCY
,      TOTAL_PROCESS_EFFICIENCY
,      LONG_DESCRIPTION
,      CONFIG_ROUTING_ID
,      MODEL_OP_SEQ_ID
,      LOWEST_ACCEPTABLE_YIELD
,      USE_ORG_SETTINGS
,      QUEUE_MANDATORY_FLAG
,      RUN_MANDATORY_FLAG
,      TO_MOVE_MANDATORY_FLAG
,      SHOW_NEXT_OP_BY_DEFAULT
,      SHOW_SCRAP_CODE
,      SHOW_LOT_ATTRIB
,      TRACK_MULTIPLE_RES_USAGE_DATES
,      CHECK_SKILL
FROM BOM.BOM_OPERATION_SEQUENCES#;

Dependencies

[top of page]

BOM.BOM_OPERATION_SEQUENCES# references the following:

SchemaBOM
TableBOM_OPERATION_SEQUENCES
BOM.BOM_OPERATION_SEQUENCES# is referenced by following:

SchemaAPPS
SynonymBOM_OPERATION_SEQUENCES