VIEW: MSC.MSC_DEMANDS#

Source

View Text - Preformatted

select ORDER_PRIORITY ORDER_PRIORITY, FORECAST_MAD FORECAST_MAD, DEMAND_ID DEMAND_ID, SCHEDULE_DESIGNATOR_ID SCHEDULE_DESIGNATOR_ID, USING_REQUIREMENT_QUANTITY USING_REQUIREMENT_QUANTITY, ASSEMBLY_DEMAND_COMP_DATE ASSEMBLY_DEMAND_COMP_DATE, USING_ASSEMBLY_DEMAND_DATE USING_ASSEMBLY_DEMAND_DATE, DEMAND_TYPE DEMAND_TYPE, ORIGINATION_TYPE ORIGINATION_TYPE, DEMAND_PRIORITY DEMAND_PRIORITY, SALES_ORDER_PRIORITY SALES_ORDER_PRIORITY, FORECAST_PRIORITY FORECAST_PRIORITY, PLANNING_GROUP PLANNING_GROUP, DAILY_DEMAND_RATE DAILY_DEMAND_RATE, UNIT_NUMBER UNIT_NUMBER, DISPOSITION_ID DISPOSITION_ID, USING_ASSEMBLY_ITEM_ID USING_ASSEMBLY_ITEM_ID, PLAN_ID PLAN_ID, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, SR_INSTANCE_ID SR_INSTANCE_ID, SHIP_TO_SITE_ID SHIP_TO_SITE_ID, PROMISE_DATE PROMISE_DATE, SELLING_PRICE SELLING_PRICE, DMD_LATENESS_COST DMD_LATENESS_COST, DMD_SATISFIED_DATE DMD_SATISFIED_DATE, OP_SEQ_NUM OP_SEQ_NUM, UPDATED UPDATED, STATUS STATUS, APPLIED APPLIED, DEMAND_CLASS DEMAND_CLASS, FIRM_QUANTITY FIRM_QUANTITY, FIRM_DATE FIRM_DATE, OLD_DEMAND_QUANTITY OLD_DEMAND_QUANTITY, OLD_DEMAND_DATE OLD_DEMAND_DATE, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, RESERVATION_ID RESERVATION_ID, PARENT_ID PARENT_ID, LENDING_PROJECT_ID LENDING_PROJECT_ID, LENDING_TASK_ID LENDING_TASK_ID, SUBST_ITEM_FLAG SUBST_ITEM_FLAG, ORDER_NUMBER ORDER_NUMBER, RESERVED_QUANTITY RESERVED_QUANTITY, 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, 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, WIP_ENTITY_ID WIP_ENTITY_ID, ISSUED_QUANTITY ISSUED_QUANTITY, REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID, REFRESH_NUMBER REFRESH_NUMBER, REQUEST_DATE REQUEST_DATE, WIP_STATUS_CODE WIP_STATUS_CODE, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID, SALES_ORDER_LINE_ID SALES_ORDER_LINE_ID, CONFIDENCE_PERCENTAGE CONFIDENCE_PERCENTAGE, BUCKET_TYPE BUCKET_TYPE, BILL_ID BILL_ID, PROBABILITY PROBABILITY, FORECAST_SET_ID FORECAST_SET_ID, GROUP_ID GROUP_ID, SERVICE_LEVEL SERVICE_LEVEL, QUANTITY_BY_DUE_DATE QUANTITY_BY_DUE_DATE, TARGET_SAFETY_STOCK TARGET_SAFETY_STOCK, SCENARIO_SET SCENARIO_SET, DEMAND_SOURCE_TYPE DEMAND_SOURCE_TYPE, SUPPLY_ID SUPPLY_ID, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE, STOLEN_FLAG STOLEN_FLAG, OLD_USING_REQUIREMENT_QUANTITY OLD_USING_REQUIREMENT_QUANTITY, OLD_USING_ASSEMBLY_DEMAND_DATE OLD_USING_ASSEMBLY_DEMAND_DATE, OLD_ASSEMBLY_DEMAND_COMP_DATE OLD_ASSEMBLY_DEMAND_COMP_DATE, CUMMULATIVE_PROBABILITY CUMMULATIVE_PROBABILITY, ORIGINAL_ITEM_ID ORIGINAL_ITEM_ID, UNMET_QUANTITY UNMET_QUANTITY, RECORD_SOURCE RECORD_SOURCE, LINK_TO_LINE_ID LINK_TO_LINE_ID, ERROR_TYPE ERROR_TYPE, ATP_SYNCHRONIZATION_FLAG ATP_SYNCHRONIZATION_FLAG, COMP_SEQ_ID COMP_SEQ_ID, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY, RELEASE_STATUS RELEASE_STATUS, RESCHEDULE_FLAG RESCHEDULE_FLAG, LOAD_TYPE LOAD_TYPE, IMPLEMENT_ORG_ID IMPLEMENT_ORG_ID, IMPLEMENT_INSTANCE_ID IMPLEMENT_INSTANCE_ID, IMPLEMENT_DATE IMPLEMENT_DATE, RELEASE_ERRORS RELEASE_ERRORS, ORG_FIRM_FLAG ORG_FIRM_FLAG, ORIGINAL_ORG_ID ORIGINAL_ORG_ID, ORIGINAL_INST_ID ORIGINAL_INST_ID, ARRIVAL_SET_ID ARRIVAL_SET_ID, SHIP_SET_ID SHIP_SET_ID, ORDER_DATE_TYPE_CODE ORDER_DATE_TYPE_CODE, SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE, PLANNED_ARRIVAL_DATE PLANNED_ARRIVAL_DATE, REQUEST_SHIP_DATE REQUEST_SHIP_DATE, PROMISE_SHIP_DATE PROMISE_SHIP_DATE, SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE, ORIGINAL_DEMAND_ID ORIGINAL_DEMAND_ID, ZONE_ID ZONE_ID, ORIG_SHIPPING_METHOD_CODE ORIG_SHIPPING_METHOD_CODE, INTRANSIT_LEAD_TIME INTRANSIT_LEAD_TIME, ORIG_INTRANSIT_LEAD_TIME ORIG_INTRANSIT_LEAD_TIME, ATP_OVERRIDE_FLAG ATP_OVERRIDE_FLAG, IMPLEMENT_FIRM IMPLEMENT_FIRM, IMPLEMENT_EARLIEST_DATE IMPLEMENT_EARLIEST_DATE, IMPLEMENT_ARRIVAL_DATE IMPLEMENT_ARRIVAL_DATE, UNBUCKETED_DEMAND_DATE UNBUCKETED_DEMAND_DATE, ATO_LINE_ID ATO_LINE_ID, TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID, PARENT_MODEL_LINE_ID PARENT_MODEL_LINE_ID, STD_MANDATORY_COMP_FLAG STD_MANDATORY_COMP_FLAG, OLD_REFRESH_NUMBER OLD_REFRESH_NUMBER, SHIP_METHOD SHIP_METHOD, SHIP_CALENDAR SHIP_CALENDAR, RECEIVING_CALENDAR RECEIVING_CALENDAR, INTRANSIT_CALENDAR INTRANSIT_CALENDAR, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, ORIGINAL_QUANTITY ORIGINAL_QUANTITY, FINAL_USE_PRIORITY FINAL_USE_PRIORITY, FINAL_USE_DATE FINAL_USE_DATE, ARRIVAL_SET_NAME ARRIVAL_SET_NAME, SHIP_SET_NAME SHIP_SET_NAME, SOURCE_PHANTOM_ID SOURCE_PHANTOM_ID, PRIMARY_COMPONENT_ID PRIMARY_COMPONENT_ID, ATP_SESSION_ID ATP_SESSION_ID, IMPLEMENT_SHIP_DATE IMPLEMENT_SHIP_DATE, PLANNED_SHIP_DATE PLANNED_SHIP_DATE, PRIOR_ALLOCATION_QTY PRIOR_ALLOCATION_QTY, MANUAL_ALLOCATION_QTY MANUAL_ALLOCATION_QTY, MANUAL_ALLOCATION_DATE MANUAL_ALLOCATION_DATE, FIRM_ALLOCATION_FLAG FIRM_ALLOCATION_FLAG, ASSET_SERIAL_NUMBER ASSET_SERIAL_NUMBER, ASSET_ITEM_ID ASSET_ITEM_ID, EXPIRATION_DATE EXPIRATION_DATE, SALES_ORDER_LINE_SPLIT SALES_ORDER_LINE_SPLIT, PLANNED_INBOUND_DUE_DATE PLANNED_INBOUND_DUE_DATE, FILL_KILL_FLAG FILL_KILL_FLAG, DEFINITION_LEVEL_USED DEFINITION_LEVEL_USED, DEMAND_FULFILLMENT_LEAD_TIME DEMAND_FULFILLMENT_LEAD_TIME, COMPONENT_SCALING_TYPE COMPONENT_SCALING_TYPE, COMPONENT_YIELD_FACTOR COMPONENT_YIELD_FACTOR, SPLIT_FROM_DEMAND_ID SPLIT_FROM_DEMAND_ID, PREV_SUBST_ITEM PREV_SUBST_ITEM, PREV_SUBST_ORG PREV_SUBST_ORG, ITEM_TYPE_ID ITEM_TYPE_ID, ITEM_TYPE_VALUE ITEM_TYPE_VALUE, REPAIR_LINE_ID REPAIR_LINE_ID, OTM_ARRIVAL_DATE OTM_ARRIVAL_DATE, WIP_ENTITY_NAME WIP_ENTITY_NAME, MIN_REM_SHELF_LIFE_DAYS MIN_REM_SHELF_LIFE_DAYS, PARENT_MODEL_ITEM_ID PARENT_MODEL_ITEM_ID, TOP_MODEL_ITEM_ID TOP_MODEL_ITEM_ID, DAYS_LATE DAYS_LATE, REVISED_DMD_DATE REVISED_DMD_DATE, REVISED_DMD_PRIORITY REVISED_DMD_PRIORITY, OBJECT_TYPE OBJECT_TYPE, ORIG_FIRM_DATE ORIG_FIRM_DATE, ORIG_FIRM_QUANTITY ORIG_FIRM_QUANTITY, MAINTENANCE_OBJECT_SOURCE MAINTENANCE_OBJECT_SOURCE from "MSC"."MSC_DEMANDS"

View Text - HTML Formatted

SELECT ORDER_PRIORITY ORDER_PRIORITY
, FORECAST_MAD FORECAST_MAD
, DEMAND_ID DEMAND_ID
, SCHEDULE_DESIGNATOR_ID SCHEDULE_DESIGNATOR_ID
, USING_REQUIREMENT_QUANTITY USING_REQUIREMENT_QUANTITY
, ASSEMBLY_DEMAND_COMP_DATE ASSEMBLY_DEMAND_COMP_DATE
, USING_ASSEMBLY_DEMAND_DATE USING_ASSEMBLY_DEMAND_DATE
, DEMAND_TYPE DEMAND_TYPE
, ORIGINATION_TYPE ORIGINATION_TYPE
, DEMAND_PRIORITY DEMAND_PRIORITY
, SALES_ORDER_PRIORITY SALES_ORDER_PRIORITY
, FORECAST_PRIORITY FORECAST_PRIORITY
, PLANNING_GROUP PLANNING_GROUP
, DAILY_DEMAND_RATE DAILY_DEMAND_RATE
, UNIT_NUMBER UNIT_NUMBER
, DISPOSITION_ID DISPOSITION_ID
, USING_ASSEMBLY_ITEM_ID USING_ASSEMBLY_ITEM_ID
, PLAN_ID PLAN_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, SHIP_TO_SITE_ID SHIP_TO_SITE_ID
, PROMISE_DATE PROMISE_DATE
, SELLING_PRICE SELLING_PRICE
, DMD_LATENESS_COST DMD_LATENESS_COST
, DMD_SATISFIED_DATE DMD_SATISFIED_DATE
, OP_SEQ_NUM OP_SEQ_NUM
, UPDATED UPDATED
, STATUS STATUS
, APPLIED APPLIED
, DEMAND_CLASS DEMAND_CLASS
, FIRM_QUANTITY FIRM_QUANTITY
, FIRM_DATE FIRM_DATE
, OLD_DEMAND_QUANTITY OLD_DEMAND_QUANTITY
, OLD_DEMAND_DATE OLD_DEMAND_DATE
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, RESERVATION_ID RESERVATION_ID
, PARENT_ID PARENT_ID
, LENDING_PROJECT_ID LENDING_PROJECT_ID
, LENDING_TASK_ID LENDING_TASK_ID
, SUBST_ITEM_FLAG SUBST_ITEM_FLAG
, ORDER_NUMBER ORDER_NUMBER
, RESERVED_QUANTITY RESERVED_QUANTITY
, 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
, 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
, WIP_ENTITY_ID WIP_ENTITY_ID
, ISSUED_QUANTITY ISSUED_QUANTITY
, REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID
, REFRESH_NUMBER REFRESH_NUMBER
, REQUEST_DATE REQUEST_DATE
, WIP_STATUS_CODE WIP_STATUS_CODE
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID
, SALES_ORDER_LINE_ID SALES_ORDER_LINE_ID
, CONFIDENCE_PERCENTAGE CONFIDENCE_PERCENTAGE
, BUCKET_TYPE BUCKET_TYPE
, BILL_ID BILL_ID
, PROBABILITY PROBABILITY
, FORECAST_SET_ID FORECAST_SET_ID
, GROUP_ID GROUP_ID
, SERVICE_LEVEL SERVICE_LEVEL
, QUANTITY_BY_DUE_DATE QUANTITY_BY_DUE_DATE
, TARGET_SAFETY_STOCK TARGET_SAFETY_STOCK
, SCENARIO_SET SCENARIO_SET
, DEMAND_SOURCE_TYPE DEMAND_SOURCE_TYPE
, SUPPLY_ID SUPPLY_ID
, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE
, STOLEN_FLAG STOLEN_FLAG
, OLD_USING_REQUIREMENT_QUANTITY OLD_USING_REQUIREMENT_QUANTITY
, OLD_USING_ASSEMBLY_DEMAND_DATE OLD_USING_ASSEMBLY_DEMAND_DATE
, OLD_ASSEMBLY_DEMAND_COMP_DATE OLD_ASSEMBLY_DEMAND_COMP_DATE
, CUMMULATIVE_PROBABILITY CUMMULATIVE_PROBABILITY
, ORIGINAL_ITEM_ID ORIGINAL_ITEM_ID
, UNMET_QUANTITY UNMET_QUANTITY
, RECORD_SOURCE RECORD_SOURCE
, LINK_TO_LINE_ID LINK_TO_LINE_ID
, ERROR_TYPE ERROR_TYPE
, ATP_SYNCHRONIZATION_FLAG ATP_SYNCHRONIZATION_FLAG
, COMP_SEQ_ID COMP_SEQ_ID
, QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY
, RELEASE_STATUS RELEASE_STATUS
, RESCHEDULE_FLAG RESCHEDULE_FLAG
, LOAD_TYPE LOAD_TYPE
, IMPLEMENT_ORG_ID IMPLEMENT_ORG_ID
, IMPLEMENT_INSTANCE_ID IMPLEMENT_INSTANCE_ID
, IMPLEMENT_DATE IMPLEMENT_DATE
, RELEASE_ERRORS RELEASE_ERRORS
, ORG_FIRM_FLAG ORG_FIRM_FLAG
, ORIGINAL_ORG_ID ORIGINAL_ORG_ID
, ORIGINAL_INST_ID ORIGINAL_INST_ID
, ARRIVAL_SET_ID ARRIVAL_SET_ID
, SHIP_SET_ID SHIP_SET_ID
, ORDER_DATE_TYPE_CODE ORDER_DATE_TYPE_CODE
, SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE
, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE
, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE
, PLANNED_ARRIVAL_DATE PLANNED_ARRIVAL_DATE
, REQUEST_SHIP_DATE REQUEST_SHIP_DATE
, PROMISE_SHIP_DATE PROMISE_SHIP_DATE
, SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE
, ORIGINAL_DEMAND_ID ORIGINAL_DEMAND_ID
, ZONE_ID ZONE_ID
, ORIG_SHIPPING_METHOD_CODE ORIG_SHIPPING_METHOD_CODE
, INTRANSIT_LEAD_TIME INTRANSIT_LEAD_TIME
, ORIG_INTRANSIT_LEAD_TIME ORIG_INTRANSIT_LEAD_TIME
, ATP_OVERRIDE_FLAG ATP_OVERRIDE_FLAG
, IMPLEMENT_FIRM IMPLEMENT_FIRM
, IMPLEMENT_EARLIEST_DATE IMPLEMENT_EARLIEST_DATE
, IMPLEMENT_ARRIVAL_DATE IMPLEMENT_ARRIVAL_DATE
, UNBUCKETED_DEMAND_DATE UNBUCKETED_DEMAND_DATE
, ATO_LINE_ID ATO_LINE_ID
, TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID
, PARENT_MODEL_LINE_ID PARENT_MODEL_LINE_ID
, STD_MANDATORY_COMP_FLAG STD_MANDATORY_COMP_FLAG
, OLD_REFRESH_NUMBER OLD_REFRESH_NUMBER
, SHIP_METHOD SHIP_METHOD
, SHIP_CALENDAR SHIP_CALENDAR
, RECEIVING_CALENDAR RECEIVING_CALENDAR
, INTRANSIT_CALENDAR INTRANSIT_CALENDAR
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, ORIGINAL_QUANTITY ORIGINAL_QUANTITY
, FINAL_USE_PRIORITY FINAL_USE_PRIORITY
, FINAL_USE_DATE FINAL_USE_DATE
, ARRIVAL_SET_NAME ARRIVAL_SET_NAME
, SHIP_SET_NAME SHIP_SET_NAME
, SOURCE_PHANTOM_ID SOURCE_PHANTOM_ID
, PRIMARY_COMPONENT_ID PRIMARY_COMPONENT_ID
, ATP_SESSION_ID ATP_SESSION_ID
, IMPLEMENT_SHIP_DATE IMPLEMENT_SHIP_DATE
, PLANNED_SHIP_DATE PLANNED_SHIP_DATE
, PRIOR_ALLOCATION_QTY PRIOR_ALLOCATION_QTY
, MANUAL_ALLOCATION_QTY MANUAL_ALLOCATION_QTY
, MANUAL_ALLOCATION_DATE MANUAL_ALLOCATION_DATE
, FIRM_ALLOCATION_FLAG FIRM_ALLOCATION_FLAG
, ASSET_SERIAL_NUMBER ASSET_SERIAL_NUMBER
, ASSET_ITEM_ID ASSET_ITEM_ID
, EXPIRATION_DATE EXPIRATION_DATE
, SALES_ORDER_LINE_SPLIT SALES_ORDER_LINE_SPLIT
, PLANNED_INBOUND_DUE_DATE PLANNED_INBOUND_DUE_DATE
, FILL_KILL_FLAG FILL_KILL_FLAG
, DEFINITION_LEVEL_USED DEFINITION_LEVEL_USED
, DEMAND_FULFILLMENT_LEAD_TIME DEMAND_FULFILLMENT_LEAD_TIME
, COMPONENT_SCALING_TYPE COMPONENT_SCALING_TYPE
, COMPONENT_YIELD_FACTOR COMPONENT_YIELD_FACTOR
, SPLIT_FROM_DEMAND_ID SPLIT_FROM_DEMAND_ID
, PREV_SUBST_ITEM PREV_SUBST_ITEM
, PREV_SUBST_ORG PREV_SUBST_ORG
, ITEM_TYPE_ID ITEM_TYPE_ID
, ITEM_TYPE_VALUE ITEM_TYPE_VALUE
, REPAIR_LINE_ID REPAIR_LINE_ID
, OTM_ARRIVAL_DATE OTM_ARRIVAL_DATE
, WIP_ENTITY_NAME WIP_ENTITY_NAME
, MIN_REM_SHELF_LIFE_DAYS MIN_REM_SHELF_LIFE_DAYS
, PARENT_MODEL_ITEM_ID PARENT_MODEL_ITEM_ID
, TOP_MODEL_ITEM_ID TOP_MODEL_ITEM_ID
, DAYS_LATE DAYS_LATE
, REVISED_DMD_DATE REVISED_DMD_DATE
, REVISED_DMD_PRIORITY REVISED_DMD_PRIORITY
, OBJECT_TYPE OBJECT_TYPE
, ORIG_FIRM_DATE ORIG_FIRM_DATE
, ORIG_FIRM_QUANTITY ORIG_FIRM_QUANTITY
, MAINTENANCE_OBJECT_SOURCE MAINTENANCE_OBJECT_SOURCE
FROM "MSC"."MSC_DEMANDS"