VIEW: MSC.MSC_WIP_JOB_DTLS_INTERFACE#

Source

View Text - Preformatted

select INTERFACE_ID INTERFACE_ID, GROUP_ID GROUP_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM, RESOURCE_ID_OLD RESOURCE_ID_OLD, RESOURCE_ID_NEW RESOURCE_ID_NEW, USAGE_RATE_OR_AMOUNT USAGE_RATE_OR_AMOUNT, SCHEDULED_FLAG SCHEDULED_FLAG, ASSIGNED_UNITS ASSIGNED_UNITS, APPLIED_RESOURCE_UNITS APPLIED_RESOURCE_UNITS, APPLIED_RESOURCE_VALUE APPLIED_RESOURCE_VALUE, UOM_CODE UOM_CODE, BASIS_TYPE BASIS_TYPE, ACTIVITY_ID ACTIVITY_ID, AUTOCHARGE_TYPE AUTOCHARGE_TYPE, STANDARD_RATE_FLAG STANDARD_RATE_FLAG, START_DATE START_DATE, COMPLETION_DATE COMPLETION_DATE, INVENTORY_ITEM_ID_OLD INVENTORY_ITEM_ID_OLD, INVENTORY_ITEM_ID_NEW INVENTORY_ITEM_ID_NEW, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY, DEPARTMENT_ID DEPARTMENT_ID, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, DATE_REQUIRED DATE_REQUIRED, REQUIRED_QUANTITY REQUIRED_QUANTITY, QUANTITY_ISSUED QUANTITY_ISSUED, SUPPLY_SUBINVENTORY SUPPLY_SUBINVENTORY, SUPPLY_LOCATOR_ID SUPPLY_LOCATOR_ID, MRP_NET_FLAG MRP_NET_FLAG, MPS_REQUIRED_QUANTITY MPS_REQUIRED_QUANTITY, MPS_DATE_REQUIRED MPS_DATE_REQUIRED, LOAD_TYPE LOAD_TYPE, SUBSTITUTION_TYPE SUBSTITUTION_TYPE, PROCESS_PHASE PROCESS_PHASE, PROCESS_STATUS PROCESS_STATUS, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PARENT_HEADER_ID PARENT_HEADER_ID, DESCRIPTION DESCRIPTION, STANDARD_OPERATION_ID STANDARD_OPERATION_ID, FIRST_UNIT_START_DATE FIRST_UNIT_START_DATE, FIRST_UNIT_COMPLETION_DATE FIRST_UNIT_COMPLETION_DATE, LAST_UNIT_START_DATE LAST_UNIT_START_DATE, LAST_UNIT_COMPLETION_DATE LAST_UNIT_COMPLETION_DATE, COUNT_POINT_TYPE COUNT_POINT_TYPE, BACKFLUSH_FLAG BACKFLUSH_FLAG, MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY, WIP_ENTITY_ID WIP_ENTITY_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, ORGANIZATION_TYPE ORGANIZATION_TYPE, ALTERNATE_NUM ALTERNATE_NUM, CFM_ROUTING_FLAG CFM_ROUTING_FLAG, FIRM_FLAG FIRM_FLAG, OPERATION_SEQ_ID OPERATION_SEQ_ID, RESOURCE_HOURS RESOURCE_HOURS, JOB_OP_SEQ_NUM JOB_OP_SEQ_NUM, NEXT_ROUTING_OP_SEQ_NUM NEXT_ROUTING_OP_SEQ_NUM, COMPONENT_SEQ_ID COMPONENT_SEQ_ID, SOURCE_PHANTOM_ID SOURCE_PHANTOM_ID, PRIMARY_COMPONENT_ID PRIMARY_COMPONENT_ID, SCHEDULED_QUANTITY SCHEDULED_QUANTITY, SERIAL_NUMBER SERIAL_NUMBER, SETUP_ID SETUP_ID, GROUP_SEQUENCE_ID GROUP_SEQUENCE_ID, GROUP_SEQUENCE_NUMBER GROUP_SEQUENCE_NUMBER, BATCH_ID BATCH_ID, RESOURCE_INSTANCE_ID RESOURCE_INSTANCE_ID, CHARGE_NUMBER CHARGE_NUMBER, MAXIMUM_ASSIGNED_UNITS MAXIMUM_ASSIGNED_UNITS, PARENT_SEQ_NUM PARENT_SEQ_NUM, SCHEDULE_SEQ_NUM SCHEDULE_SEQ_NUM, ORIG_RESOURCE_SEQ_NUM ORIG_RESOURCE_SEQ_NUM, EAM_FLAG EAM_FLAG, COMPONENT_YIELD_FACTOR COMPONENT_YIELD_FACTOR from "MSC"."MSC_WIP_JOB_DTLS_INTERFACE"

View Text - HTML Formatted

SELECT INTERFACE_ID INTERFACE_ID
, GROUP_ID GROUP_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM
, RESOURCE_ID_OLD RESOURCE_ID_OLD
, RESOURCE_ID_NEW RESOURCE_ID_NEW
, USAGE_RATE_OR_AMOUNT USAGE_RATE_OR_AMOUNT
, SCHEDULED_FLAG SCHEDULED_FLAG
, ASSIGNED_UNITS ASSIGNED_UNITS
, APPLIED_RESOURCE_UNITS APPLIED_RESOURCE_UNITS
, APPLIED_RESOURCE_VALUE APPLIED_RESOURCE_VALUE
, UOM_CODE UOM_CODE
, BASIS_TYPE BASIS_TYPE
, ACTIVITY_ID ACTIVITY_ID
, AUTOCHARGE_TYPE AUTOCHARGE_TYPE
, STANDARD_RATE_FLAG STANDARD_RATE_FLAG
, START_DATE START_DATE
, COMPLETION_DATE COMPLETION_DATE
, INVENTORY_ITEM_ID_OLD INVENTORY_ITEM_ID_OLD
, INVENTORY_ITEM_ID_NEW INVENTORY_ITEM_ID_NEW
, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY
, DEPARTMENT_ID DEPARTMENT_ID
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, DATE_REQUIRED DATE_REQUIRED
, REQUIRED_QUANTITY REQUIRED_QUANTITY
, QUANTITY_ISSUED QUANTITY_ISSUED
, SUPPLY_SUBINVENTORY SUPPLY_SUBINVENTORY
, SUPPLY_LOCATOR_ID SUPPLY_LOCATOR_ID
, MRP_NET_FLAG MRP_NET_FLAG
, MPS_REQUIRED_QUANTITY MPS_REQUIRED_QUANTITY
, MPS_DATE_REQUIRED MPS_DATE_REQUIRED
, LOAD_TYPE LOAD_TYPE
, SUBSTITUTION_TYPE SUBSTITUTION_TYPE
, PROCESS_PHASE PROCESS_PHASE
, PROCESS_STATUS PROCESS_STATUS
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PARENT_HEADER_ID PARENT_HEADER_ID
, DESCRIPTION DESCRIPTION
, STANDARD_OPERATION_ID STANDARD_OPERATION_ID
, FIRST_UNIT_START_DATE FIRST_UNIT_START_DATE
, FIRST_UNIT_COMPLETION_DATE FIRST_UNIT_COMPLETION_DATE
, LAST_UNIT_START_DATE LAST_UNIT_START_DATE
, LAST_UNIT_COMPLETION_DATE LAST_UNIT_COMPLETION_DATE
, COUNT_POINT_TYPE COUNT_POINT_TYPE
, BACKFLUSH_FLAG BACKFLUSH_FLAG
, MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY
, WIP_ENTITY_ID WIP_ENTITY_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, ORGANIZATION_TYPE ORGANIZATION_TYPE
, ALTERNATE_NUM ALTERNATE_NUM
, CFM_ROUTING_FLAG CFM_ROUTING_FLAG
, FIRM_FLAG FIRM_FLAG
, OPERATION_SEQ_ID OPERATION_SEQ_ID
, RESOURCE_HOURS RESOURCE_HOURS
, JOB_OP_SEQ_NUM JOB_OP_SEQ_NUM
, NEXT_ROUTING_OP_SEQ_NUM NEXT_ROUTING_OP_SEQ_NUM
, COMPONENT_SEQ_ID COMPONENT_SEQ_ID
, SOURCE_PHANTOM_ID SOURCE_PHANTOM_ID
, PRIMARY_COMPONENT_ID PRIMARY_COMPONENT_ID
, SCHEDULED_QUANTITY SCHEDULED_QUANTITY
, SERIAL_NUMBER SERIAL_NUMBER
, SETUP_ID SETUP_ID
, GROUP_SEQUENCE_ID GROUP_SEQUENCE_ID
, GROUP_SEQUENCE_NUMBER GROUP_SEQUENCE_NUMBER
, BATCH_ID BATCH_ID
, RESOURCE_INSTANCE_ID RESOURCE_INSTANCE_ID
, CHARGE_NUMBER CHARGE_NUMBER
, MAXIMUM_ASSIGNED_UNITS MAXIMUM_ASSIGNED_UNITS
, PARENT_SEQ_NUM PARENT_SEQ_NUM
, SCHEDULE_SEQ_NUM SCHEDULE_SEQ_NUM
, ORIG_RESOURCE_SEQ_NUM ORIG_RESOURCE_SEQ_NUM
, EAM_FLAG EAM_FLAG
, COMPONENT_YIELD_FACTOR COMPONENT_YIELD_FACTOR
FROM "MSC"."MSC_WIP_JOB_DTLS_INTERFACE"