MSC_ROUTING_OPERATIONSRC

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
PLAN_ID OPERATION_SEQUENCE_ID ROUTING_SEQUENCE_ID OPERATION_SEQ_NUM OPERATION_DESCRIPTION EFFECTIVITY_DATE DISABLE_DATE FROM_UNIT_NUMBER TO_UNIT_NUMBER OPTION_DEPENDENT_FLAG OPERATION_TYPE MINIMUM_TRANSFER_QUANTITY YIELD DEPARTMENT_ID DEPARTMENT_CODE OPERATION_LEAD_TIME_PERCENT CUMULATIVE_YIELD REVERSE_CUMULATIVE_YIELD NET_PLANNING_PERCENT SETUP_DURATION TEAR_DOWN_DURATION UOM_CODE STANDARD_OPERATION_CODE REFRESH_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN USE_IN_PLAN ORGANIZATION_ID STEP_QUANTITY STEP_QUANTITY_UOM

Name

PLAN_ID

OPERATION_SEQUENCE_ID

ROUTING_SEQUENCE_ID

OPERATION_SEQ_NUM

OPERATION_DESCRIPTION

EFFECTIVITY_DATE

DISABLE_DATE

FROM_UNIT_NUMBER

TO_UNIT_NUMBER

OPTION_DEPENDENT_FLAG

OPERATION_TYPE

MINIMUM_TRANSFER_QUANTITY

YIELD

DEPARTMENT_ID

DEPARTMENT_CODE

OPERATION_LEAD_TIME_PERCENT

CUMULATIVE_YIELD

REVERSE_CUMULATIVE_YIELD

NET_PLANNING_PERCENT

SETUP_DURATION

TEAR_DOWN_DURATION

UOM_CODE

STANDARD_OPERATION_CODE

REFRESH_NUMBER

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

USE_IN_PLAN

ORGANIZATION_ID

STEP_QUANTITY

STEP_QUANTITY_UOM

Query

SQL_Statement
select "PLAN_ID","OPERATION_SEQUENCE_ID","ROUTING_SEQUENCE_ID","OPERATION_SEQ_NUM","OPERATION_DESCRIPTION","EFFECTIVITY_DATE","DISABLE_DATE","FROM_UNIT_NUMBER","TO_UNIT_NUMBER","OPTION_DEPENDENT_FLAG","OPERATION_TYPE","MINIMUM_TRANSFER_QUANTITY","YIELD","DEPARTMENT_ID","DEPARTMENT_CODE","OPERATION_LEAD_TIME_PERCENT","CUMULATIVE_YIELD","REVERSE_CUMULATIVE_YIELD","NET_PLANNING_PERCENT","SETUP_DURATION","TEAR_DOWN_DURATION","UOM_CODE","STANDARD_OPERATION_CODE","REFRESH_NUMBER","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","USE_IN_PLAN","ORGANIZATION_ID","STEP_QUANTITY","STEP_QUANTITY_UOM" from msc_routing_operations as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))

SQL_Statement

select "PLAN_ID","OPERATION_SEQUENCE_ID","ROUTING_SEQUENCE_ID","OPERATION_SEQ_NUM","OPERATION_DESCRIPTION","EFFECTIVITY_DATE","DISABLE_DATE","FROM_UNIT_NUMBER","TO_UNIT_NUMBER","OPTION_DEPENDENT_FLAG","OPERATION_TYPE","MINIMUM_TRANSFER_QUANTITY","YIELD","DEPARTMENT_ID","DEPARTMENT_CODE","OPERATION_LEAD_TIME_PERCENT","CUMULATIVE_YIELD","REVERSE_CUMULATIVE_YIELD","NET_PLANNING_PERCENT","SETUP_DURATION","TEAR_DOWN_DURATION","UOM_CODE","STANDARD_OPERATION_CODE","REFRESH_NUMBER","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","USE_IN_PLAN","ORGANIZATION_ID","STEP_QUANTITY","STEP_QUANTITY_UOM" from msc_routing_operations as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))