eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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
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:

MSC: MSC_DEMANDS

MSC.MSC_DEMANDS# is referenced by following:

APPS: MSC_DEMANDS