VIEW: MSC.MSC_ST_JOB_REQUIREMENT_OPS#

Source

View Text - Preformatted

select WIP_ENTITY_ID WIP_ENTITY_ID, SR_INSTANCE_ID SR_INSTANCE_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, COMPONENT_ITEM_ID COMPONENT_ITEM_ID, PRIMARY_COMPONENT_ID PRIMARY_COMPONENT_ID, SOURCE_PHANTOM_ID SOURCE_PHANTOM_ID, RECOMMENDED RECOMMENDED, RECO_DATE_REQUIRED RECO_DATE_REQUIRED, ORGANIZATION_ID ORGANIZATION_ID, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, COMPONENT_PRIORITY COMPONENT_PRIORITY, DEPARTMENT_ID DEPARTMENT_ID, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY, COMPONENT_YIELD_FACTOR COMPONENT_YIELD_FACTOR, EFFECTIVITY_DATE EFFECTIVITY_DATE, DISABLE_DATE DISABLE_DATE, PLANNING_FACTOR PLANNING_FACTOR, LOW_QUANTITY LOW_QUANTITY, HIGH_QUANTITY HIGH_QUANTITY, OPERATION_LEAD_TIME_PERCENT OPERATION_LEAD_TIME_PERCENT, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER, TO_END_ITEM_UNIT_NUMBER TO_END_ITEM_UNIT_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REFRESH_ID REFRESH_ID, DELETED_FLAG DELETED_FLAG, SR_INSTANCE_CODE SR_INSTANCE_CODE, COMPANY_NAME COMPANY_NAME, WIP_ENTITY_NAME WIP_ENTITY_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, OPERATION_SEQ_CODE OPERATION_SEQ_CODE, ROUTING_NAME ROUTING_NAME, COMPONENT_NAME COMPONENT_NAME, ASSEMBLY_ITEM_NAME ASSEMBLY_ITEM_NAME, PRIMARY_COMPONENT_NAME PRIMARY_COMPONENT_NAME, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID, DEPARTMENT_CODE DEPARTMENT_CODE, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, BATCH_ID BATCH_ID, ST_TRANSACTION_ID ST_TRANSACTION_ID, MESSAGE_ID MESSAGE_ID, ERROR_TEXT ERROR_TEXT, PROCESS_FLAG PROCESS_FLAG, OP_EFFECTIVITY_DATE OP_EFFECTIVITY_DATE, SOURCE_PHANTOM_NAME SOURCE_PHANTOM_NAME, COMPONENT_SCALING_TYPE COMPONENT_SCALING_TYPE from "MSC"."MSC_ST_JOB_REQUIREMENT_OPS"

View Text - HTML Formatted

SELECT WIP_ENTITY_ID WIP_ENTITY_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, COMPONENT_ITEM_ID COMPONENT_ITEM_ID
, PRIMARY_COMPONENT_ID PRIMARY_COMPONENT_ID
, SOURCE_PHANTOM_ID SOURCE_PHANTOM_ID
, RECOMMENDED RECOMMENDED
, RECO_DATE_REQUIRED RECO_DATE_REQUIRED
, ORGANIZATION_ID ORGANIZATION_ID
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, COMPONENT_PRIORITY COMPONENT_PRIORITY
, DEPARTMENT_ID DEPARTMENT_ID
, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY
, COMPONENT_YIELD_FACTOR COMPONENT_YIELD_FACTOR
, EFFECTIVITY_DATE EFFECTIVITY_DATE
, DISABLE_DATE DISABLE_DATE
, PLANNING_FACTOR PLANNING_FACTOR
, LOW_QUANTITY LOW_QUANTITY
, HIGH_QUANTITY HIGH_QUANTITY
, OPERATION_LEAD_TIME_PERCENT OPERATION_LEAD_TIME_PERCENT
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER
, TO_END_ITEM_UNIT_NUMBER TO_END_ITEM_UNIT_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REFRESH_ID REFRESH_ID
, DELETED_FLAG DELETED_FLAG
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, COMPANY_NAME COMPANY_NAME
, WIP_ENTITY_NAME WIP_ENTITY_NAME
, ORGANIZATION_CODE ORGANIZATION_CODE
, OPERATION_SEQ_CODE OPERATION_SEQ_CODE
, ROUTING_NAME ROUTING_NAME
, COMPONENT_NAME COMPONENT_NAME
, ASSEMBLY_ITEM_NAME ASSEMBLY_ITEM_NAME
, PRIMARY_COMPONENT_NAME PRIMARY_COMPONENT_NAME
, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR
, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID
, DEPARTMENT_CODE DEPARTMENT_CODE
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, BATCH_ID BATCH_ID
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, MESSAGE_ID MESSAGE_ID
, ERROR_TEXT ERROR_TEXT
, PROCESS_FLAG PROCESS_FLAG
, OP_EFFECTIVITY_DATE OP_EFFECTIVITY_DATE
, SOURCE_PHANTOM_NAME SOURCE_PHANTOM_NAME
, COMPONENT_SCALING_TYPE COMPONENT_SCALING_TYPE
FROM "MSC"."MSC_ST_JOB_REQUIREMENT_OPS"