MSC_ROUTINGSRC

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
PLAN_ID ROUTING_SEQUENCE_ID ROUTING_TYPE ROUTING_COMMENT ALTERNATE_ROUTING_DESIGNATOR PROJECT_ID TASK_ID LINE_ID UOM_CODE CFM_ROUTING_FLAG CTP_FLAG ASSEMBLY_ITEM_ID ORGANIZATION_ID ROUTING_QUANTITY REFRESH_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN FIRST_OP_SEQ_NUM LAST_OP_SEQ_NUM COMMON_ROUTING_SEQUENCE_ID AUTO_STEP_QTY_FLAG ROUTING_NAME COMMON_ROUTING_NAME

Name

PLAN_ID

ROUTING_SEQUENCE_ID

ROUTING_TYPE

ROUTING_COMMENT

ALTERNATE_ROUTING_DESIGNATOR

PROJECT_ID

TASK_ID

LINE_ID

UOM_CODE

CFM_ROUTING_FLAG

CTP_FLAG

ASSEMBLY_ITEM_ID

ORGANIZATION_ID

ROUTING_QUANTITY

REFRESH_NUMBER

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

FIRST_OP_SEQ_NUM

LAST_OP_SEQ_NUM

COMMON_ROUTING_SEQUENCE_ID

AUTO_STEP_QTY_FLAG

ROUTING_NAME

COMMON_ROUTING_NAME

Query

SQL_Statement
select "PLAN_ID","ROUTING_SEQUENCE_ID","ROUTING_TYPE","ROUTING_COMMENT","ALTERNATE_ROUTING_DESIGNATOR","PROJECT_ID","TASK_ID","LINE_ID","UOM_CODE","CFM_ROUTING_FLAG","CTP_FLAG","ASSEMBLY_ITEM_ID","ORGANIZATION_ID","ROUTING_QUANTITY","REFRESH_NUMBER","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","FIRST_OP_SEQ_NUM","LAST_OP_SEQ_NUM","COMMON_ROUTING_SEQUENCE_ID","AUTO_STEP_QTY_FLAG","ROUTING_NAME","COMMON_ROUTING_NAME" from msc_routings as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))

SQL_Statement

select "PLAN_ID","ROUTING_SEQUENCE_ID","ROUTING_TYPE","ROUTING_COMMENT","ALTERNATE_ROUTING_DESIGNATOR","PROJECT_ID","TASK_ID","LINE_ID","UOM_CODE","CFM_ROUTING_FLAG","CTP_FLAG","ASSEMBLY_ITEM_ID","ORGANIZATION_ID","ROUTING_QUANTITY","REFRESH_NUMBER","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","FIRST_OP_SEQ_NUM","LAST_OP_SEQ_NUM","COMMON_ROUTING_SEQUENCE_ID","AUTO_STEP_QTY_FLAG","ROUTING_NAME","COMMON_ROUTING_NAME" from msc_routings as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))