DBA Data[Home] [Help] [Dependency Information]

VIEW: MSC.MSC_DEMANDS#

Object Details
Object Name: MSC_DEMANDS#
Object Type: VIEW
Owner: MSC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORDER_PRIORITY NUMBER

FORECAST_MAD NUMBER

DEMAND_ID NUMBER
Yes
SCHEDULE_DESIGNATOR_ID NUMBER

USING_REQUIREMENT_QUANTITY NUMBER
Yes
ASSEMBLY_DEMAND_COMP_DATE DATE

USING_ASSEMBLY_DEMAND_DATE DATE
Yes
DEMAND_TYPE NUMBER
Yes
ORIGINATION_TYPE NUMBER

DEMAND_PRIORITY NUMBER

SALES_ORDER_PRIORITY NUMBER

FORECAST_PRIORITY NUMBER

PLANNING_GROUP VARCHAR2 (30)
DAILY_DEMAND_RATE NUMBER

UNIT_NUMBER VARCHAR2 (30)
DISPOSITION_ID NUMBER

USING_ASSEMBLY_ITEM_ID NUMBER
Yes
PLAN_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
CUSTOMER_ID NUMBER

CUSTOMER_SITE_ID NUMBER

SR_INSTANCE_ID NUMBER
Yes
SHIP_TO_SITE_ID NUMBER

PROMISE_DATE DATE

SELLING_PRICE NUMBER

DMD_LATENESS_COST NUMBER

DMD_SATISFIED_DATE DATE

OP_SEQ_NUM NUMBER

UPDATED NUMBER

STATUS NUMBER

APPLIED NUMBER

DEMAND_CLASS VARCHAR2 (34)
FIRM_QUANTITY NUMBER

FIRM_DATE DATE

OLD_DEMAND_QUANTITY NUMBER

OLD_DEMAND_DATE DATE

SOURCE_ORGANIZATION_ID NUMBER

RESERVATION_ID NUMBER

PARENT_ID NUMBER

LENDING_PROJECT_ID NUMBER

LENDING_TASK_ID NUMBER

SUBST_ITEM_FLAG NUMBER

ORDER_NUMBER VARCHAR2 (62)
RESERVED_QUANTITY NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
WIP_ENTITY_ID NUMBER

ISSUED_QUANTITY NUMBER

REPETITIVE_SCHEDULE_ID NUMBER

REFRESH_NUMBER NUMBER

REQUEST_DATE DATE

WIP_STATUS_CODE NUMBER

WIP_SUPPLY_TYPE NUMBER

SOURCE_ORG_INSTANCE_ID NUMBER

SALES_ORDER_LINE_ID NUMBER

CONFIDENCE_PERCENTAGE NUMBER

BUCKET_TYPE NUMBER

BILL_ID NUMBER

PROBABILITY NUMBER

FORECAST_SET_ID NUMBER

GROUP_ID NUMBER

SERVICE_LEVEL NUMBER

QUANTITY_BY_DUE_DATE NUMBER

TARGET_SAFETY_STOCK NUMBER

SCENARIO_SET NUMBER

DEMAND_SOURCE_TYPE NUMBER

SUPPLY_ID NUMBER

ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
ORIGINAL_SYSTEM_LINE_REFERENCE VARCHAR2 (50)
STOLEN_FLAG VARCHAR2 (1)
OLD_USING_REQUIREMENT_QUANTITY NUMBER

OLD_USING_ASSEMBLY_DEMAND_DATE DATE

OLD_ASSEMBLY_DEMAND_COMP_DATE DATE

CUMMULATIVE_PROBABILITY NUMBER

ORIGINAL_ITEM_ID NUMBER

UNMET_QUANTITY NUMBER

RECORD_SOURCE NUMBER

LINK_TO_LINE_ID NUMBER

ERROR_TYPE NUMBER

ATP_SYNCHRONIZATION_FLAG NUMBER

COMP_SEQ_ID NUMBER

QUANTITY_PER_ASSEMBLY NUMBER

RELEASE_STATUS NUMBER

RESCHEDULE_FLAG NUMBER

LOAD_TYPE NUMBER

IMPLEMENT_ORG_ID NUMBER

IMPLEMENT_INSTANCE_ID NUMBER

IMPLEMENT_DATE DATE

RELEASE_ERRORS VARCHAR2 (250)
ORG_FIRM_FLAG NUMBER

ORIGINAL_ORG_ID NUMBER

ORIGINAL_INST_ID NUMBER

ARRIVAL_SET_ID NUMBER

SHIP_SET_ID NUMBER

ORDER_DATE_TYPE_CODE NUMBER

SCHEDULE_ARRIVAL_DATE DATE

LATEST_ACCEPTABLE_DATE DATE

SHIPPING_METHOD_CODE VARCHAR2 (30)
PLANNED_ARRIVAL_DATE DATE

REQUEST_SHIP_DATE DATE

PROMISE_SHIP_DATE DATE

SCHEDULE_SHIP_DATE DATE

ORIGINAL_DEMAND_ID NUMBER

ZONE_ID NUMBER

ORIG_SHIPPING_METHOD_CODE VARCHAR2 (30)
INTRANSIT_LEAD_TIME NUMBER

ORIG_INTRANSIT_LEAD_TIME NUMBER

ATP_OVERRIDE_FLAG NUMBER

IMPLEMENT_FIRM NUMBER

IMPLEMENT_EARLIEST_DATE DATE

IMPLEMENT_ARRIVAL_DATE DATE

UNBUCKETED_DEMAND_DATE DATE

ATO_LINE_ID NUMBER

TOP_MODEL_LINE_ID NUMBER

PARENT_MODEL_LINE_ID NUMBER

STD_MANDATORY_COMP_FLAG NUMBER

OLD_REFRESH_NUMBER NUMBER

SHIP_METHOD VARCHAR2 (30)
SHIP_CALENDAR VARCHAR2 (15)
RECEIVING_CALENDAR VARCHAR2 (15)
INTRANSIT_CALENDAR VARCHAR2 (15)
SHIP_TO_LOCATION_ID NUMBER

ORIGINAL_QUANTITY NUMBER

FINAL_USE_PRIORITY NUMBER

FINAL_USE_DATE DATE

ARRIVAL_SET_NAME VARCHAR2 (30)
SHIP_SET_NAME VARCHAR2 (30)
SOURCE_PHANTOM_ID NUMBER

PRIMARY_COMPONENT_ID NUMBER

ATP_SESSION_ID NUMBER

IMPLEMENT_SHIP_DATE DATE

PLANNED_SHIP_DATE DATE

PRIOR_ALLOCATION_QTY NUMBER

MANUAL_ALLOCATION_QTY NUMBER

MANUAL_ALLOCATION_DATE DATE

FIRM_ALLOCATION_FLAG NUMBER

ASSET_SERIAL_NUMBER VARCHAR2 (30)
ASSET_ITEM_ID NUMBER

EXPIRATION_DATE DATE

SALES_ORDER_LINE_SPLIT NUMBER

PLANNED_INBOUND_DUE_DATE DATE

FILL_KILL_FLAG NUMBER

DEFINITION_LEVEL_USED NUMBER

DEMAND_FULFILLMENT_LEAD_TIME NUMBER

COMPONENT_SCALING_TYPE NUMBER

COMPONENT_YIELD_FACTOR NUMBER

SPLIT_FROM_DEMAND_ID NUMBER

PREV_SUBST_ITEM NUMBER

PREV_SUBST_ORG NUMBER

ITEM_TYPE_ID NUMBER

ITEM_TYPE_VALUE NUMBER

REPAIR_LINE_ID NUMBER (15)
OTM_ARRIVAL_DATE DATE

WIP_ENTITY_NAME VARCHAR2 (240)
MIN_REM_SHELF_LIFE_DAYS NUMBER

PARENT_MODEL_ITEM_ID NUMBER

TOP_MODEL_ITEM_ID NUMBER

DAYS_LATE NUMBER

REVISED_DMD_DATE DATE

REVISED_DMD_PRIORITY NUMBER

OBJECT_TYPE VARCHAR2 (3)
ORIG_FIRM_DATE DATE

ORIG_FIRM_QUANTITY NUMBER

MAINTENANCE_OBJECT_SOURCE NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


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
,      SR_INSTANCE_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
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      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
,      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
,      UNBUCKETED_DEMAND_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
,      PREV_SUBST_ITEM
,      PREV_SUBST_ORG
,      ITEM_TYPE_ID
,      ITEM_TYPE_VALUE
,      REPAIR_LINE_ID
,      OTM_ARRIVAL_DATE
,      WIP_ENTITY_NAME
,      MIN_REM_SHELF_LIFE_DAYS
,      PARENT_MODEL_ITEM_ID
,      TOP_MODEL_ITEM_ID
,      DAYS_LATE
,      REVISED_DMD_DATE
,      REVISED_DMD_PRIORITY
,      OBJECT_TYPE
,      ORIG_FIRM_DATE
,      ORIG_FIRM_QUANTITY
,      MAINTENANCE_OBJECT_SOURCE
FROM MSC.MSC_DEMANDS#;

Dependencies

[top of page]

MSC.MSC_DEMANDS# references the following:

SchemaMSC
TableMSC_DEMANDS
MSC.MSC_DEMANDS# is referenced by following:

SchemaAPPS
SynonymMSC_DEMANDS