VIEW: MSC.MSC_ST_DEMANDS#

Source

View Text - Preformatted

select ORDER_PRIORITY ORDER_PRIORITY, DEMAND_ID DEMAND_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, USING_ASSEMBLY_ITEM_ID USING_ASSEMBLY_ITEM_ID, USING_ASSEMBLY_DEMAND_DATE USING_ASSEMBLY_DEMAND_DATE, USING_REQUIREMENT_QUANTITY USING_REQUIREMENT_QUANTITY, ASSEMBLY_DEMAND_COMP_DATE ASSEMBLY_DEMAND_COMP_DATE, DEMAND_TYPE DEMAND_TYPE, DAILY_DEMAND_RATE DAILY_DEMAND_RATE, ORIGINATION_TYPE ORIGINATION_TYPE, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, DISPOSITION_ID DISPOSITION_ID, RESERVATION_ID RESERVATION_ID, DEMAND_SCHEDULE_NAME DEMAND_SCHEDULE_NAME, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PLANNING_GROUP PLANNING_GROUP, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, SCHEDULE_DATE SCHEDULE_DATE, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, QUANTITY_ISSUED QUANTITY_ISSUED, DEMAND_CLASS DEMAND_CLASS, SALES_ORDER_NUMBER SALES_ORDER_NUMBER, SALES_ORDER_PRIORITY SALES_ORDER_PRIORITY, FORECAST_PRIORITY FORECAST_PRIORITY, MPS_DATE_REQUIRED MPS_DATE_REQUIRED, PO_NUMBER PO_NUMBER, WIP_ENTITY_NAME WIP_ENTITY_NAME, DELETED_FLAG DELETED_FLAG, 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, SR_INSTANCE_ID SR_INSTANCE_ID, REFRESH_ID REFRESH_ID, REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID, WIP_ENTITY_ID WIP_ENTITY_ID, SELLING_PRICE SELLING_PRICE, DMD_LATENESS_COST DMD_LATENESS_COST, DMD_SATISFIED_DATE DMD_SATISFIED_DATE, DMD_SPLIT_FLAG DMD_SPLIT_FLAG, REQUEST_DATE REQUEST_DATE, ORDER_NUMBER ORDER_NUMBER, WIP_STATUS_CODE WIP_STATUS_CODE, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, 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, SALES_ORDER_LINE_ID SALES_ORDER_LINE_ID, CONFIDENCE_PERCENTAGE CONFIDENCE_PERCENTAGE, BUCKET_TYPE BUCKET_TYPE, BILL_ID BILL_ID, CUSTOMER_ID CUSTOMER_ID, PROBABILITY PROBABILITY, SERVICE_LEVEL SERVICE_LEVEL, FORECAST_MAD FORECAST_MAD, FORECAST_DESIGNATOR FORECAST_DESIGNATOR, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE, DEMAND_SOURCE_TYPE DEMAND_SOURCE_TYPE, SHIP_TO_SITE_ID SHIP_TO_SITE_ID, COMPANY_ID COMPANY_ID, COMPANY_NAME COMPANY_NAME, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, CUSTOMER_SITE_CODE CUSTOMER_SITE_CODE, BILL_CODE BILL_CODE, ITEM_NAME ITEM_NAME, ROUTING_NAME ROUTING_NAME, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, OPERATION_EFFECTIVITY_DATE OPERATION_EFFECTIVITY_DATE, USING_ASSEMBLY_ITEM_NAME USING_ASSEMBLY_ITEM_NAME, PROJECT_NUMBER PROJECT_NUMBER, TASK_NUMBER TASK_NUMBER, SCHEDULE_LINE_NUM SCHEDULE_LINE_NUM, OPERATION_SEQ_CODE OPERATION_SEQ_CODE, ORGANIZATION_CODE ORGANIZATION_CODE, SR_INSTANCE_CODE SR_INSTANCE_CODE, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, BATCH_ID BATCH_ID, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, ERROR_TEXT ERROR_TEXT, COMMENTS COMMENTS, PROMISE_DATE PROMISE_DATE, LINK_TO_LINE_ID LINK_TO_LINE_ID, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY, ORDER_DATE_TYPE_CODE ORDER_DATE_TYPE_CODE, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE, SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE, SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE, REQUEST_SHIP_DATE REQUEST_SHIP_DATE, PROMISE_SHIP_DATE PROMISE_SHIP_DATE, SOURCE_ORG_ID SOURCE_ORG_ID, SOURCE_INVENTORY_ITEM_ID SOURCE_INVENTORY_ITEM_ID, SOURCE_USING_ASSEMBLY_ITEM_ID SOURCE_USING_ASSEMBLY_ITEM_ID, SOURCE_SALES_ORDER_LINE_ID SOURCE_SALES_ORDER_LINE_ID, SOURCE_PROJECT_ID SOURCE_PROJECT_ID, SOURCE_TASK_ID SOURCE_TASK_ID, SOURCE_CUSTOMER_SITE_ID SOURCE_CUSTOMER_SITE_ID, SOURCE_BILL_ID SOURCE_BILL_ID, SOURCE_DISPOSITION_ID SOURCE_DISPOSITION_ID, SOURCE_CUSTOMER_ID SOURCE_CUSTOMER_ID, SOURCE_OPERATION_SEQ_NUM SOURCE_OPERATION_SEQ_NUM, SOURCE_WIP_ENTITY_ID SOURCE_WIP_ENTITY_ID, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID, ASSET_SERIAL_NUMBER ASSET_SERIAL_NUMBER, ASSET_ITEM_ID ASSET_ITEM_ID, COMPONENT_SCALING_TYPE COMPONENT_SCALING_TYPE, COMPONENT_YIELD_FACTOR COMPONENT_YIELD_FACTOR, ITEM_TYPE_ID ITEM_TYPE_ID, ITEM_TYPE_VALUE ITEM_TYPE_VALUE, REPAIR_LINE_ID REPAIR_LINE_ID, RO_STATUS_CODE RO_STATUS_CODE, REPAIR_NUMBER REPAIR_NUMBER, ENTITY ENTITY, REVISED_DMD_DATE REVISED_DMD_DATE, REVISED_DMD_PRIORITY REVISED_DMD_PRIORITY, SCHEDULE_DESIGNATOR_ID SCHEDULE_DESIGNATOR_ID, OBJECT_TYPE OBJECT_TYPE, MAINTENANCE_OBJECT_SOURCE MAINTENANCE_OBJECT_SOURCE, OPERATING_FLEET OPERATING_FLEET, MAINTENANCE_REQUIREMENT MAINTENANCE_REQUIREMENT, CLASS_CODE CLASS_CODE from "MSC"."MSC_ST_DEMANDS"

View Text - HTML Formatted

SELECT ORDER_PRIORITY ORDER_PRIORITY
, DEMAND_ID DEMAND_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, USING_ASSEMBLY_ITEM_ID USING_ASSEMBLY_ITEM_ID
, USING_ASSEMBLY_DEMAND_DATE USING_ASSEMBLY_DEMAND_DATE
, USING_REQUIREMENT_QUANTITY USING_REQUIREMENT_QUANTITY
, ASSEMBLY_DEMAND_COMP_DATE ASSEMBLY_DEMAND_COMP_DATE
, DEMAND_TYPE DEMAND_TYPE
, DAILY_DEMAND_RATE DAILY_DEMAND_RATE
, ORIGINATION_TYPE ORIGINATION_TYPE
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, DISPOSITION_ID DISPOSITION_ID
, RESERVATION_ID RESERVATION_ID
, DEMAND_SCHEDULE_NAME DEMAND_SCHEDULE_NAME
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, PLANNING_GROUP PLANNING_GROUP
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
, SCHEDULE_DATE SCHEDULE_DATE
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, QUANTITY_ISSUED QUANTITY_ISSUED
, DEMAND_CLASS DEMAND_CLASS
, SALES_ORDER_NUMBER SALES_ORDER_NUMBER
, SALES_ORDER_PRIORITY SALES_ORDER_PRIORITY
, FORECAST_PRIORITY FORECAST_PRIORITY
, MPS_DATE_REQUIRED MPS_DATE_REQUIRED
, PO_NUMBER PO_NUMBER
, WIP_ENTITY_NAME WIP_ENTITY_NAME
, DELETED_FLAG DELETED_FLAG
, 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
, SR_INSTANCE_ID SR_INSTANCE_ID
, REFRESH_ID REFRESH_ID
, REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, SELLING_PRICE SELLING_PRICE
, DMD_LATENESS_COST DMD_LATENESS_COST
, DMD_SATISFIED_DATE DMD_SATISFIED_DATE
, DMD_SPLIT_FLAG DMD_SPLIT_FLAG
, REQUEST_DATE REQUEST_DATE
, ORDER_NUMBER ORDER_NUMBER
, WIP_STATUS_CODE WIP_STATUS_CODE
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, 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
, SALES_ORDER_LINE_ID SALES_ORDER_LINE_ID
, CONFIDENCE_PERCENTAGE CONFIDENCE_PERCENTAGE
, BUCKET_TYPE BUCKET_TYPE
, BILL_ID BILL_ID
, CUSTOMER_ID CUSTOMER_ID
, PROBABILITY PROBABILITY
, SERVICE_LEVEL SERVICE_LEVEL
, FORECAST_MAD FORECAST_MAD
, FORECAST_DESIGNATOR FORECAST_DESIGNATOR
, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE
, DEMAND_SOURCE_TYPE DEMAND_SOURCE_TYPE
, SHIP_TO_SITE_ID SHIP_TO_SITE_ID
, COMPANY_ID COMPANY_ID
, COMPANY_NAME COMPANY_NAME
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, CUSTOMER_SITE_CODE CUSTOMER_SITE_CODE
, BILL_CODE BILL_CODE
, ITEM_NAME ITEM_NAME
, ROUTING_NAME ROUTING_NAME
, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, OPERATION_EFFECTIVITY_DATE OPERATION_EFFECTIVITY_DATE
, USING_ASSEMBLY_ITEM_NAME USING_ASSEMBLY_ITEM_NAME
, PROJECT_NUMBER PROJECT_NUMBER
, TASK_NUMBER TASK_NUMBER
, SCHEDULE_LINE_NUM SCHEDULE_LINE_NUM
, OPERATION_SEQ_CODE OPERATION_SEQ_CODE
, ORGANIZATION_CODE ORGANIZATION_CODE
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, BATCH_ID BATCH_ID
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, ERROR_TEXT ERROR_TEXT
, COMMENTS COMMENTS
, PROMISE_DATE PROMISE_DATE
, LINK_TO_LINE_ID LINK_TO_LINE_ID
, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY
, ORDER_DATE_TYPE_CODE ORDER_DATE_TYPE_CODE
, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE
, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE
, SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE
, SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE
, REQUEST_SHIP_DATE REQUEST_SHIP_DATE
, PROMISE_SHIP_DATE PROMISE_SHIP_DATE
, SOURCE_ORG_ID SOURCE_ORG_ID
, SOURCE_INVENTORY_ITEM_ID SOURCE_INVENTORY_ITEM_ID
, SOURCE_USING_ASSEMBLY_ITEM_ID SOURCE_USING_ASSEMBLY_ITEM_ID
, SOURCE_SALES_ORDER_LINE_ID SOURCE_SALES_ORDER_LINE_ID
, SOURCE_PROJECT_ID SOURCE_PROJECT_ID
, SOURCE_TASK_ID SOURCE_TASK_ID
, SOURCE_CUSTOMER_SITE_ID SOURCE_CUSTOMER_SITE_ID
, SOURCE_BILL_ID SOURCE_BILL_ID
, SOURCE_DISPOSITION_ID SOURCE_DISPOSITION_ID
, SOURCE_CUSTOMER_ID SOURCE_CUSTOMER_ID
, SOURCE_OPERATION_SEQ_NUM SOURCE_OPERATION_SEQ_NUM
, SOURCE_WIP_ENTITY_ID SOURCE_WIP_ENTITY_ID
, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID
, ASSET_SERIAL_NUMBER ASSET_SERIAL_NUMBER
, ASSET_ITEM_ID ASSET_ITEM_ID
, COMPONENT_SCALING_TYPE COMPONENT_SCALING_TYPE
, COMPONENT_YIELD_FACTOR COMPONENT_YIELD_FACTOR
, ITEM_TYPE_ID ITEM_TYPE_ID
, ITEM_TYPE_VALUE ITEM_TYPE_VALUE
, REPAIR_LINE_ID REPAIR_LINE_ID
, RO_STATUS_CODE RO_STATUS_CODE
, REPAIR_NUMBER REPAIR_NUMBER
, ENTITY ENTITY
, REVISED_DMD_DATE REVISED_DMD_DATE
, REVISED_DMD_PRIORITY REVISED_DMD_PRIORITY
, SCHEDULE_DESIGNATOR_ID SCHEDULE_DESIGNATOR_ID
, OBJECT_TYPE OBJECT_TYPE
, MAINTENANCE_OBJECT_SOURCE MAINTENANCE_OBJECT_SOURCE
, OPERATING_FLEET OPERATING_FLEET
, MAINTENANCE_REQUIREMENT MAINTENANCE_REQUIREMENT
, CLASS_CODE CLASS_CODE
FROM "MSC"."MSC_ST_DEMANDS"