MSC_DEMANDSRC

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
ORDER_PRIORITY FORECAST_MAD DEMAND_ID SCHEDULE_DESIGNATOR_ID USING_REQUIREMENT_QUANTITY ASSEMBLY_DEMAND_COMP_DATE USING_ASSEMBLY_DEMAND_DATE DEMAND_TYPE ORIGINATION_TYPE DEMAND_PRIORITY SALES_ORDER_PRIORITY FORECAST_PRIORITY PLANNING_GROUP DAILY_DEMAND_RATE UNIT_NUMBER DISPOSITION_ID USING_ASSEMBLY_ITEM_ID PLAN_ID ORGANIZATION_ID INVENTORY_ITEM_ID PROJECT_ID TASK_ID CUSTOMER_ID CUSTOMER_SITE_ID SHIP_TO_SITE_ID PROMISE_DATE SELLING_PRICE DMD_LATENESS_COST DMD_SATISFIED_DATE OP_SEQ_NUM UPDATED STATUS APPLIED DEMAND_CLASS FIRM_QUANTITY FIRM_DATE OLD_DEMAND_QUANTITY OLD_DEMAND_DATE SOURCE_ORGANIZATION_ID RESERVATION_ID PARENT_ID LENDING_PROJECT_ID LENDING_TASK_ID SUBST_ITEM_FLAG ORDER_NUMBER RESERVED_QUANTITY LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 WIP_ENTITY_ID ISSUED_QUANTITY REPETITIVE_SCHEDULE_ID REFRESH_NUMBER REQUEST_DATE WIP_STATUS_CODE WIP_SUPPLY_TYPE SOURCE_ORG_INSTANCE_ID SALES_ORDER_LINE_ID CONFIDENCE_PERCENTAGE BUCKET_TYPE BILL_ID PROBABILITY FORECAST_SET_ID GROUP_ID SERVICE_LEVEL QUANTITY_BY_DUE_DATE TARGET_SAFETY_STOCK SCENARIO_SET DEMAND_SOURCE_TYPE SUPPLY_ID ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE STOLEN_FLAG OLD_USING_REQUIREMENT_QUANTITY OLD_USING_ASSEMBLY_DEMAND_DATE OLD_ASSEMBLY_DEMAND_COMP_DATE CUMMULATIVE_PROBABILITY ORIGINAL_ITEM_ID UNMET_QUANTITY RECORD_SOURCE LINK_TO_LINE_ID ERROR_TYPE ATP_SYNCHRONIZATION_FLAG COMP_SEQ_ID UNBUCKETED_DEMAND_DATE QUANTITY_PER_ASSEMBLY RELEASE_STATUS RESCHEDULE_FLAG LOAD_TYPE IMPLEMENT_ORG_ID IMPLEMENT_INSTANCE_ID IMPLEMENT_DATE RELEASE_ERRORS ORG_FIRM_FLAG ORIGINAL_ORG_ID ORIGINAL_INST_ID ARRIVAL_SET_ID SHIP_SET_ID ORDER_DATE_TYPE_CODE SCHEDULE_ARRIVAL_DATE LATEST_ACCEPTABLE_DATE SHIPPING_METHOD_CODE PLANNED_ARRIVAL_DATE REQUEST_SHIP_DATE PROMISE_SHIP_DATE SCHEDULE_SHIP_DATE ORIGINAL_DEMAND_ID ZONE_ID ORIG_SHIPPING_METHOD_CODE INTRANSIT_LEAD_TIME ORIG_INTRANSIT_LEAD_TIME ATP_OVERRIDE_FLAG IMPLEMENT_FIRM IMPLEMENT_EARLIEST_DATE IMPLEMENT_ARRIVAL_DATE ATO_LINE_ID TOP_MODEL_LINE_ID PARENT_MODEL_LINE_ID STD_MANDATORY_COMP_FLAG OLD_REFRESH_NUMBER SHIP_METHOD SHIP_CALENDAR RECEIVING_CALENDAR INTRANSIT_CALENDAR SHIP_TO_LOCATION_ID ORIGINAL_QUANTITY FINAL_USE_PRIORITY FINAL_USE_DATE ARRIVAL_SET_NAME SHIP_SET_NAME SOURCE_PHANTOM_ID PRIMARY_COMPONENT_ID ATP_SESSION_ID IMPLEMENT_SHIP_DATE PLANNED_SHIP_DATE PRIOR_ALLOCATION_QTY MANUAL_ALLOCATION_QTY MANUAL_ALLOCATION_DATE FIRM_ALLOCATION_FLAG ASSET_SERIAL_NUMBER ASSET_ITEM_ID EXPIRATION_DATE SALES_ORDER_LINE_SPLIT PLANNED_INBOUND_DUE_DATE FILL_KILL_FLAG DEFINITION_LEVEL_USED DEMAND_FULFILLMENT_LEAD_TIME COMPONENT_SCALING_TYPE COMPONENT_YIELD_FACTOR SPLIT_FROM_DEMAND_ID OBJECT_VERSION_NUMBER

Name

ORDER_PRIORITY

FORECAST_MAD

DEMAND_ID

SCHEDULE_DESIGNATOR_ID

USING_REQUIREMENT_QUANTITY

ASSEMBLY_DEMAND_COMP_DATE

USING_ASSEMBLY_DEMAND_DATE

DEMAND_TYPE

ORIGINATION_TYPE

DEMAND_PRIORITY

SALES_ORDER_PRIORITY

FORECAST_PRIORITY

PLANNING_GROUP

DAILY_DEMAND_RATE

UNIT_NUMBER

DISPOSITION_ID

USING_ASSEMBLY_ITEM_ID

PLAN_ID

ORGANIZATION_ID

INVENTORY_ITEM_ID

PROJECT_ID

TASK_ID

CUSTOMER_ID

CUSTOMER_SITE_ID

SHIP_TO_SITE_ID

PROMISE_DATE

SELLING_PRICE

DMD_LATENESS_COST

DMD_SATISFIED_DATE

OP_SEQ_NUM

UPDATED

STATUS

APPLIED

DEMAND_CLASS

FIRM_QUANTITY

FIRM_DATE

OLD_DEMAND_QUANTITY

OLD_DEMAND_DATE

SOURCE_ORGANIZATION_ID

RESERVATION_ID

PARENT_ID

LENDING_PROJECT_ID

LENDING_TASK_ID

SUBST_ITEM_FLAG

ORDER_NUMBER

RESERVED_QUANTITY

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

WIP_ENTITY_ID

ISSUED_QUANTITY

REPETITIVE_SCHEDULE_ID

REFRESH_NUMBER

REQUEST_DATE

WIP_STATUS_CODE

WIP_SUPPLY_TYPE

SOURCE_ORG_INSTANCE_ID

SALES_ORDER_LINE_ID

CONFIDENCE_PERCENTAGE

BUCKET_TYPE

BILL_ID

PROBABILITY

FORECAST_SET_ID

GROUP_ID

SERVICE_LEVEL

QUANTITY_BY_DUE_DATE

TARGET_SAFETY_STOCK

SCENARIO_SET

DEMAND_SOURCE_TYPE

SUPPLY_ID

ORIGINAL_SYSTEM_REFERENCE

ORIGINAL_SYSTEM_LINE_REFERENCE

STOLEN_FLAG

OLD_USING_REQUIREMENT_QUANTITY

OLD_USING_ASSEMBLY_DEMAND_DATE

OLD_ASSEMBLY_DEMAND_COMP_DATE

CUMMULATIVE_PROBABILITY

ORIGINAL_ITEM_ID

UNMET_QUANTITY

RECORD_SOURCE

LINK_TO_LINE_ID

ERROR_TYPE

ATP_SYNCHRONIZATION_FLAG

COMP_SEQ_ID

UNBUCKETED_DEMAND_DATE

QUANTITY_PER_ASSEMBLY

RELEASE_STATUS

RESCHEDULE_FLAG

LOAD_TYPE

IMPLEMENT_ORG_ID

IMPLEMENT_INSTANCE_ID

IMPLEMENT_DATE

RELEASE_ERRORS

ORG_FIRM_FLAG

ORIGINAL_ORG_ID

ORIGINAL_INST_ID

ARRIVAL_SET_ID

SHIP_SET_ID

ORDER_DATE_TYPE_CODE

SCHEDULE_ARRIVAL_DATE

LATEST_ACCEPTABLE_DATE

SHIPPING_METHOD_CODE

PLANNED_ARRIVAL_DATE

REQUEST_SHIP_DATE

PROMISE_SHIP_DATE

SCHEDULE_SHIP_DATE

ORIGINAL_DEMAND_ID

ZONE_ID

ORIG_SHIPPING_METHOD_CODE

INTRANSIT_LEAD_TIME

ORIG_INTRANSIT_LEAD_TIME

ATP_OVERRIDE_FLAG

IMPLEMENT_FIRM

IMPLEMENT_EARLIEST_DATE

IMPLEMENT_ARRIVAL_DATE

ATO_LINE_ID

TOP_MODEL_LINE_ID

PARENT_MODEL_LINE_ID

STD_MANDATORY_COMP_FLAG

OLD_REFRESH_NUMBER

SHIP_METHOD

SHIP_CALENDAR

RECEIVING_CALENDAR

INTRANSIT_CALENDAR

SHIP_TO_LOCATION_ID

ORIGINAL_QUANTITY

FINAL_USE_PRIORITY

FINAL_USE_DATE

ARRIVAL_SET_NAME

SHIP_SET_NAME

SOURCE_PHANTOM_ID

PRIMARY_COMPONENT_ID

ATP_SESSION_ID

IMPLEMENT_SHIP_DATE

PLANNED_SHIP_DATE

PRIOR_ALLOCATION_QTY

MANUAL_ALLOCATION_QTY

MANUAL_ALLOCATION_DATE

FIRM_ALLOCATION_FLAG

ASSET_SERIAL_NUMBER

ASSET_ITEM_ID

EXPIRATION_DATE

SALES_ORDER_LINE_SPLIT

PLANNED_INBOUND_DUE_DATE

FILL_KILL_FLAG

DEFINITION_LEVEL_USED

DEMAND_FULFILLMENT_LEAD_TIME

COMPONENT_SCALING_TYPE

COMPONENT_YIELD_FACTOR

SPLIT_FROM_DEMAND_ID

OBJECT_VERSION_NUMBER

Query

SQL_Statement
select "ORDER_PRIORITY","FORECAST_MAD","DEMAND_ID","SCHEDULE_DESIGNATOR_ID","USING_REQUIREMENT_QUANTITY","ASSEMBLY_DEMAND_COMP_DATE","USING_ASSEMBLY_DEMAND_DATE","DEMAND_TYPE","ORIGINATION_TYPE","DEMAND_PRIORITY","SALES_ORDER_PRIORITY","FORECAST_PRIORITY","PLANNING_GROUP","DAILY_DEMAND_RATE","UNIT_NUMBER","DISPOSITION_ID","USING_ASSEMBLY_ITEM_ID","PLAN_ID","ORGANIZATION_ID","INVENTORY_ITEM_ID","PROJECT_ID","TASK_ID","CUSTOMER_ID","CUSTOMER_SITE_ID","SHIP_TO_SITE_ID","PROMISE_DATE","SELLING_PRICE","DMD_LATENESS_COST","DMD_SATISFIED_DATE","OP_SEQ_NUM","UPDATED","STATUS","APPLIED","DEMAND_CLASS","FIRM_QUANTITY","FIRM_DATE","OLD_DEMAND_QUANTITY","OLD_DEMAND_DATE","SOURCE_ORGANIZATION_ID","RESERVATION_ID","PARENT_ID","LENDING_PROJECT_ID","LENDING_TASK_ID","SUBST_ITEM_FLAG","ORDER_NUMBER","RESERVED_QUANTITY","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","WIP_ENTITY_ID","ISSUED_QUANTITY","REPETITIVE_SCHEDULE_ID","REFRESH_NUMBER","REQUEST_DATE","WIP_STATUS_CODE","WIP_SUPPLY_TYPE","SOURCE_ORG_INSTANCE_ID","SALES_ORDER_LINE_ID","CONFIDENCE_PERCENTAGE","BUCKET_TYPE","BILL_ID","PROBABILITY","FORECAST_SET_ID","GROUP_ID","SERVICE_LEVEL","QUANTITY_BY_DUE_DATE","TARGET_SAFETY_STOCK","SCENARIO_SET","DEMAND_SOURCE_TYPE","SUPPLY_ID","ORIGINAL_SYSTEM_REFERENCE","ORIGINAL_SYSTEM_LINE_REFERENCE","STOLEN_FLAG","OLD_USING_REQUIREMENT_QUANTITY","OLD_USING_ASSEMBLY_DEMAND_DATE","OLD_ASSEMBLY_DEMAND_COMP_DATE","CUMMULATIVE_PROBABILITY","ORIGINAL_ITEM_ID","UNMET_QUANTITY","RECORD_SOURCE","LINK_TO_LINE_ID","ERROR_TYPE","ATP_SYNCHRONIZATION_FLAG","COMP_SEQ_ID","UNBUCKETED_DEMAND_DATE","QUANTITY_PER_ASSEMBLY","RELEASE_STATUS","RESCHEDULE_FLAG","LOAD_TYPE","IMPLEMENT_ORG_ID","IMPLEMENT_INSTANCE_ID","IMPLEMENT_DATE","RELEASE_ERRORS","ORG_FIRM_FLAG","ORIGINAL_ORG_ID","ORIGINAL_INST_ID","ARRIVAL_SET_ID","SHIP_SET_ID","ORDER_DATE_TYPE_CODE","SCHEDULE_ARRIVAL_DATE","LATEST_ACCEPTABLE_DATE","SHIPPING_METHOD_CODE","PLANNED_ARRIVAL_DATE","REQUEST_SHIP_DATE","PROMISE_SHIP_DATE","SCHEDULE_SHIP_DATE","ORIGINAL_DEMAND_ID","ZONE_ID","ORIG_SHIPPING_METHOD_CODE","INTRANSIT_LEAD_TIME","ORIG_INTRANSIT_LEAD_TIME","ATP_OVERRIDE_FLAG","IMPLEMENT_FIRM","IMPLEMENT_EARLIEST_DATE","IMPLEMENT_ARRIVAL_DATE","ATO_LINE_ID","TOP_MODEL_LINE_ID","PARENT_MODEL_LINE_ID","STD_MANDATORY_COMP_FLAG","OLD_REFRESH_NUMBER","SHIP_METHOD","SHIP_CALENDAR","RECEIVING_CALENDAR","INTRANSIT_CALENDAR","SHIP_TO_LOCATION_ID","ORIGINAL_QUANTITY","FINAL_USE_PRIORITY","FINAL_USE_DATE","ARRIVAL_SET_NAME","SHIP_SET_NAME","SOURCE_PHANTOM_ID","PRIMARY_COMPONENT_ID","ATP_SESSION_ID","IMPLEMENT_SHIP_DATE","PLANNED_SHIP_DATE","PRIOR_ALLOCATION_QTY","MANUAL_ALLOCATION_QTY","MANUAL_ALLOCATION_DATE","FIRM_ALLOCATION_FLAG","ASSET_SERIAL_NUMBER","ASSET_ITEM_ID","EXPIRATION_DATE","SALES_ORDER_LINE_SPLIT","PLANNED_INBOUND_DUE_DATE","FILL_KILL_FLAG","DEFINITION_LEVEL_USED","DEMAND_FULFILLMENT_LEAD_TIME","COMPONENT_SCALING_TYPE","COMPONENT_YIELD_FACTOR","SPLIT_FROM_DEMAND_ID","OBJECT_VERSION_NUMBER" from msc_demands as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))

SQL_Statement

select "ORDER_PRIORITY","FORECAST_MAD","DEMAND_ID","SCHEDULE_DESIGNATOR_ID","USING_REQUIREMENT_QUANTITY","ASSEMBLY_DEMAND_COMP_DATE","USING_ASSEMBLY_DEMAND_DATE","DEMAND_TYPE","ORIGINATION_TYPE","DEMAND_PRIORITY","SALES_ORDER_PRIORITY","FORECAST_PRIORITY","PLANNING_GROUP","DAILY_DEMAND_RATE","UNIT_NUMBER","DISPOSITION_ID","USING_ASSEMBLY_ITEM_ID","PLAN_ID","ORGANIZATION_ID","INVENTORY_ITEM_ID","PROJECT_ID","TASK_ID","CUSTOMER_ID","CUSTOMER_SITE_ID","SHIP_TO_SITE_ID","PROMISE_DATE","SELLING_PRICE","DMD_LATENESS_COST","DMD_SATISFIED_DATE","OP_SEQ_NUM","UPDATED","STATUS","APPLIED","DEMAND_CLASS","FIRM_QUANTITY","FIRM_DATE","OLD_DEMAND_QUANTITY","OLD_DEMAND_DATE","SOURCE_ORGANIZATION_ID","RESERVATION_ID","PARENT_ID","LENDING_PROJECT_ID","LENDING_TASK_ID","SUBST_ITEM_FLAG","ORDER_NUMBER","RESERVED_QUANTITY","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","WIP_ENTITY_ID","ISSUED_QUANTITY","REPETITIVE_SCHEDULE_ID","REFRESH_NUMBER","REQUEST_DATE","WIP_STATUS_CODE","WIP_SUPPLY_TYPE","SOURCE_ORG_INSTANCE_ID","SALES_ORDER_LINE_ID","CONFIDENCE_PERCENTAGE","BUCKET_TYPE","BILL_ID","PROBABILITY","FORECAST_SET_ID","GROUP_ID","SERVICE_LEVEL","QUANTITY_BY_DUE_DATE","TARGET_SAFETY_STOCK","SCENARIO_SET","DEMAND_SOURCE_TYPE","SUPPLY_ID","ORIGINAL_SYSTEM_REFERENCE","ORIGINAL_SYSTEM_LINE_REFERENCE","STOLEN_FLAG","OLD_USING_REQUIREMENT_QUANTITY","OLD_USING_ASSEMBLY_DEMAND_DATE","OLD_ASSEMBLY_DEMAND_COMP_DATE","CUMMULATIVE_PROBABILITY","ORIGINAL_ITEM_ID","UNMET_QUANTITY","RECORD_SOURCE","LINK_TO_LINE_ID","ERROR_TYPE","ATP_SYNCHRONIZATION_FLAG","COMP_SEQ_ID","UNBUCKETED_DEMAND_DATE","QUANTITY_PER_ASSEMBLY","RELEASE_STATUS","RESCHEDULE_FLAG","LOAD_TYPE","IMPLEMENT_ORG_ID","IMPLEMENT_INSTANCE_ID","IMPLEMENT_DATE","RELEASE_ERRORS","ORG_FIRM_FLAG","ORIGINAL_ORG_ID","ORIGINAL_INST_ID","ARRIVAL_SET_ID","SHIP_SET_ID","ORDER_DATE_TYPE_CODE","SCHEDULE_ARRIVAL_DATE","LATEST_ACCEPTABLE_DATE","SHIPPING_METHOD_CODE","PLANNED_ARRIVAL_DATE","REQUEST_SHIP_DATE","PROMISE_SHIP_DATE","SCHEDULE_SHIP_DATE","ORIGINAL_DEMAND_ID","ZONE_ID","ORIG_SHIPPING_METHOD_CODE","INTRANSIT_LEAD_TIME","ORIG_INTRANSIT_LEAD_TIME","ATP_OVERRIDE_FLAG","IMPLEMENT_FIRM","IMPLEMENT_EARLIEST_DATE","IMPLEMENT_ARRIVAL_DATE","ATO_LINE_ID","TOP_MODEL_LINE_ID","PARENT_MODEL_LINE_ID","STD_MANDATORY_COMP_FLAG","OLD_REFRESH_NUMBER","SHIP_METHOD","SHIP_CALENDAR","RECEIVING_CALENDAR","INTRANSIT_CALENDAR","SHIP_TO_LOCATION_ID","ORIGINAL_QUANTITY","FINAL_USE_PRIORITY","FINAL_USE_DATE","ARRIVAL_SET_NAME","SHIP_SET_NAME","SOURCE_PHANTOM_ID","PRIMARY_COMPONENT_ID","ATP_SESSION_ID","IMPLEMENT_SHIP_DATE","PLANNED_SHIP_DATE","PRIOR_ALLOCATION_QTY","MANUAL_ALLOCATION_QTY","MANUAL_ALLOCATION_DATE","FIRM_ALLOCATION_FLAG","ASSET_SERIAL_NUMBER","ASSET_ITEM_ID","EXPIRATION_DATE","SALES_ORDER_LINE_SPLIT","PLANNED_INBOUND_DUE_DATE","FILL_KILL_FLAG","DEFINITION_LEVEL_USED","DEMAND_FULFILLMENT_LEAD_TIME","COMPONENT_SCALING_TYPE","COMPONENT_YIELD_FACTOR","SPLIT_FROM_DEMAND_ID","OBJECT_VERSION_NUMBER" from msc_demands as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))