VIEW: WSM.WSM_LOT_JOB_DTL_INTERFACE#

Source

View Text - Preformatted

select RECORD_ID RECORD_ID, INTERFACE_ID INTERFACE_ID, GROUP_ID GROUP_ID, PARENT_HEADER_ID PARENT_HEADER_ID, LOAD_TYPE LOAD_TYPE, SUBSTITUTION_TYPE SUBSTITUTION_TYPE, PROCESS_PHASE PROCESS_PHASE, PROCESS_STATUS PROCESS_STATUS, JOB_NAME JOB_NAME, WIP_ENTITY_ID WIP_ENTITY_ID, ORGANIZATION_ID ORGANIZATION_ID, ORGANIZATION_CODE ORGANIZATION_CODE, DEPARTMENT_ID DEPARTMENT_ID, DEPARTMENT_CODE DEPARTMENT_CODE, DESCRIPTION DESCRIPTION, JOB_OP_SEQ_NUM JOB_OP_SEQ_NUM, ROUTING_OP_SEQ_NUM ROUTING_OP_SEQ_NUM, NEXT_ROUTING_OP_SEQ_NUM NEXT_ROUTING_OP_SEQ_NUM, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM, RESOURCE_ID_OLD RESOURCE_ID_OLD, RESOURCE_ID_NEW RESOURCE_ID_NEW, RESOURCE_CODE_OLD RESOURCE_CODE_OLD, RESOURCE_CODE_NEW RESOURCE_CODE_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, SCHEDULE_SEQ_NUM SCHEDULE_SEQ_NUM, SUBSTITUTE_GROUP_NUM SUBSTITUTE_GROUP_NUM, REPLACEMENT_GROUP_NUM REPLACEMENT_GROUP_NUM, SETUP_ID SETUP_ID, BATCH_ID BATCH_ID, INVENTORY_ITEM_ID_OLD INVENTORY_ITEM_ID_OLD, INVENTORY_ITEM_ID_NEW INVENTORY_ITEM_ID_NEW, INVENTORY_ITEM_OLD INVENTORY_ITEM_OLD, INVENTORY_ITEM_NEW INVENTORY_ITEM_NEW, PRIMARY_ITEM_ID PRIMARY_ITEM_ID, PRIMARY_ITEM PRIMARY_ITEM, SRC_PHANTOM_ITEM_ID SRC_PHANTOM_ITEM_ID, SRC_PHANTOM_ITEM SRC_PHANTOM_ITEM, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY, 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, STANDARD_OPERATION_ID STANDARD_OPERATION_ID, SCHEDULED_QUANTITY SCHEDULED_QUANTITY, OPERATION_YIELD OPERATION_YIELD, OPERATION_START_DATE OPERATION_START_DATE, OPERATION_COMPLETION_DATE OPERATION_COMPLETION_DATE, MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY, BACKFLUSH_FLAG BACKFLUSH_FLAG, COUNT_POINT_TYPE COUNT_POINT_TYPE, PLANNING_PCT PLANNING_PCT, TRANSACTION_DATE TRANSACTION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY_NAME LAST_UPDATED_BY_NAME, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY_NAME CREATED_BY_NAME, 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, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, INSTANCE_ID_NEW INSTANCE_ID_NEW, INSTANCE_ID_OLD INSTANCE_ID_OLD, SERIAL_NUMBER_NEW SERIAL_NUMBER_NEW, SERIAL_NUMBER_OLD SERIAL_NUMBER_OLD, AUTO_REQUEST_MATERIAL AUTO_REQUEST_MATERIAL, COMMENTS COMMENTS, ERROR_CODE ERROR_CODE, ERROR_MSG ERROR_MSG, FIRM_TYPE FIRM_TYPE, GROUP_SEQUENCE_ID GROUP_SEQUENCE_ID, GROUP_SEQUENCE_NUM GROUP_SEQUENCE_NUM, MAX_ASSIGNED_UNITS MAX_ASSIGNED_UNITS, PARENT_RESOURCE_SEQ_NUM PARENT_RESOURCE_SEQ_NUM, RESOURCE_HOURS RESOURCE_HOURS, SETUP_CODE SETUP_CODE, INCLUDE_IN_ROLLUP INCLUDE_IN_ROLLUP, OPTION_DEPENDENT_FLAG OPTION_DEPENDENT_FLAG, OPERATION_YIELD_ENABLED OPERATION_YIELD_ENABLED, RECOMMENDED RECOMMENDED, STANDARD_OPERATION_CODE STANDARD_OPERATION_CODE, CUMULATIVE_YIELD CUMULATIVE_YIELD, REVERSE_CUMULATIVE_YIELD REVERSE_CUMULATIVE_YIELD from "WSM"."WSM_LOT_JOB_DTL_INTERFACE"

View Text - HTML Formatted

SELECT RECORD_ID RECORD_ID
, INTERFACE_ID INTERFACE_ID
, GROUP_ID GROUP_ID
, PARENT_HEADER_ID PARENT_HEADER_ID
, LOAD_TYPE LOAD_TYPE
, SUBSTITUTION_TYPE SUBSTITUTION_TYPE
, PROCESS_PHASE PROCESS_PHASE
, PROCESS_STATUS PROCESS_STATUS
, JOB_NAME JOB_NAME
, WIP_ENTITY_ID WIP_ENTITY_ID
, ORGANIZATION_ID ORGANIZATION_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, DEPARTMENT_ID DEPARTMENT_ID
, DEPARTMENT_CODE DEPARTMENT_CODE
, DESCRIPTION DESCRIPTION
, JOB_OP_SEQ_NUM JOB_OP_SEQ_NUM
, ROUTING_OP_SEQ_NUM ROUTING_OP_SEQ_NUM
, NEXT_ROUTING_OP_SEQ_NUM NEXT_ROUTING_OP_SEQ_NUM
, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM
, RESOURCE_ID_OLD RESOURCE_ID_OLD
, RESOURCE_ID_NEW RESOURCE_ID_NEW
, RESOURCE_CODE_OLD RESOURCE_CODE_OLD
, RESOURCE_CODE_NEW RESOURCE_CODE_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
, SCHEDULE_SEQ_NUM SCHEDULE_SEQ_NUM
, SUBSTITUTE_GROUP_NUM SUBSTITUTE_GROUP_NUM
, REPLACEMENT_GROUP_NUM REPLACEMENT_GROUP_NUM
, SETUP_ID SETUP_ID
, BATCH_ID BATCH_ID
, INVENTORY_ITEM_ID_OLD INVENTORY_ITEM_ID_OLD
, INVENTORY_ITEM_ID_NEW INVENTORY_ITEM_ID_NEW
, INVENTORY_ITEM_OLD INVENTORY_ITEM_OLD
, INVENTORY_ITEM_NEW INVENTORY_ITEM_NEW
, PRIMARY_ITEM_ID PRIMARY_ITEM_ID
, PRIMARY_ITEM PRIMARY_ITEM
, SRC_PHANTOM_ITEM_ID SRC_PHANTOM_ITEM_ID
, SRC_PHANTOM_ITEM SRC_PHANTOM_ITEM
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY
, 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
, STANDARD_OPERATION_ID STANDARD_OPERATION_ID
, SCHEDULED_QUANTITY SCHEDULED_QUANTITY
, OPERATION_YIELD OPERATION_YIELD
, OPERATION_START_DATE OPERATION_START_DATE
, OPERATION_COMPLETION_DATE OPERATION_COMPLETION_DATE
, MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY
, BACKFLUSH_FLAG BACKFLUSH_FLAG
, COUNT_POINT_TYPE COUNT_POINT_TYPE
, PLANNING_PCT PLANNING_PCT
, TRANSACTION_DATE TRANSACTION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY_NAME LAST_UPDATED_BY_NAME
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY_NAME CREATED_BY_NAME
, 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
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, INSTANCE_ID_NEW INSTANCE_ID_NEW
, INSTANCE_ID_OLD INSTANCE_ID_OLD
, SERIAL_NUMBER_NEW SERIAL_NUMBER_NEW
, SERIAL_NUMBER_OLD SERIAL_NUMBER_OLD
, AUTO_REQUEST_MATERIAL AUTO_REQUEST_MATERIAL
, COMMENTS COMMENTS
, ERROR_CODE ERROR_CODE
, ERROR_MSG ERROR_MSG
, FIRM_TYPE FIRM_TYPE
, GROUP_SEQUENCE_ID GROUP_SEQUENCE_ID
, GROUP_SEQUENCE_NUM GROUP_SEQUENCE_NUM
, MAX_ASSIGNED_UNITS MAX_ASSIGNED_UNITS
, PARENT_RESOURCE_SEQ_NUM PARENT_RESOURCE_SEQ_NUM
, RESOURCE_HOURS RESOURCE_HOURS
, SETUP_CODE SETUP_CODE
, INCLUDE_IN_ROLLUP INCLUDE_IN_ROLLUP
, OPTION_DEPENDENT_FLAG OPTION_DEPENDENT_FLAG
, OPERATION_YIELD_ENABLED OPERATION_YIELD_ENABLED
, RECOMMENDED RECOMMENDED
, STANDARD_OPERATION_CODE STANDARD_OPERATION_CODE
, CUMULATIVE_YIELD CUMULATIVE_YIELD
, REVERSE_CUMULATIVE_YIELD REVERSE_CUMULATIVE_YIELD
FROM "WSM"."WSM_LOT_JOB_DTL_INTERFACE"