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_ST_DEMANDS#

Object Details

Object Name:	MSC_ST_DEMANDS#
Object Type:	VIEW
Owner:	MSC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ORDER_PRIORITY	NUMBER
DEMAND_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER
ORGANIZATION_ID	NUMBER
USING_ASSEMBLY_ITEM_ID	NUMBER
USING_ASSEMBLY_DEMAND_DATE	DATE
USING_REQUIREMENT_QUANTITY	NUMBER
ASSEMBLY_DEMAND_COMP_DATE	DATE
DEMAND_TYPE	NUMBER
DAILY_DEMAND_RATE	NUMBER
ORIGINATION_TYPE	NUMBER
SOURCE_ORGANIZATION_ID	NUMBER
DISPOSITION_ID	NUMBER
RESERVATION_ID	NUMBER
DEMAND_SCHEDULE_NAME	VARCHAR2	(10)
PROJECT_ID	NUMBER	(15)
TASK_ID	NUMBER	(15)
PLANNING_GROUP	VARCHAR2	(30)
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)
SCHEDULE_DATE	DATE
OPERATION_SEQ_NUM	NUMBER
QUANTITY_ISSUED	NUMBER
DEMAND_CLASS	VARCHAR2	(34)
SALES_ORDER_NUMBER	VARCHAR2	(122)
SALES_ORDER_PRIORITY	NUMBER
FORECAST_PRIORITY	NUMBER
MPS_DATE_REQUIRED	DATE
PO_NUMBER	VARCHAR2	(62)
WIP_ENTITY_NAME	VARCHAR2	(240)
DELETED_FLAG	NUMBER
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
CREATION_DATE	DATE
CREATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
SR_INSTANCE_ID	NUMBER
REFRESH_ID	NUMBER
REPETITIVE_SCHEDULE_ID	NUMBER
WIP_ENTITY_ID	NUMBER
SELLING_PRICE	NUMBER
DMD_LATENESS_COST	NUMBER
DMD_SATISFIED_DATE	DATE
DMD_SPLIT_FLAG	NUMBER
REQUEST_DATE	DATE
ORDER_NUMBER	VARCHAR2	(240)
WIP_STATUS_CODE	NUMBER
WIP_SUPPLY_TYPE	NUMBER
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)
SALES_ORDER_LINE_ID	NUMBER
CONFIDENCE_PERCENTAGE	NUMBER
BUCKET_TYPE	NUMBER
BILL_ID	NUMBER
CUSTOMER_ID	NUMBER
PROBABILITY	NUMBER
SERVICE_LEVEL	NUMBER
FORECAST_MAD	NUMBER
FORECAST_DESIGNATOR	VARCHAR2	(10)
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(50)
ORIGINAL_SYSTEM_LINE_REFERENCE	VARCHAR2	(50)
DEMAND_SOURCE_TYPE	NUMBER
SHIP_TO_SITE_ID	NUMBER
COMPANY_ID	NUMBER
COMPANY_NAME	VARCHAR2	(255)
CUSTOMER_NAME	VARCHAR2	(255)
CUSTOMER_SITE_ID	NUMBER
CUSTOMER_SITE_CODE	VARCHAR2	(30)
BILL_CODE	VARCHAR2	(30)
ITEM_NAME	VARCHAR2	(250)
ROUTING_NAME	VARCHAR2	(250)
ALTERNATE_ROUTING_DESIGNATOR	VARCHAR2	(10)
OPERATION_EFFECTIVITY_DATE	DATE
USING_ASSEMBLY_ITEM_NAME	VARCHAR2	(250)
PROJECT_NUMBER	VARCHAR2	(25)
TASK_NUMBER	VARCHAR2	(25)
SCHEDULE_LINE_NUM	VARCHAR2	(10)
OPERATION_SEQ_CODE	VARCHAR2	(10)
ORGANIZATION_CODE	VARCHAR2	(7)
SR_INSTANCE_CODE	VARCHAR2	(3)
MESSAGE_ID	NUMBER
PROCESS_FLAG	NUMBER
BATCH_ID	NUMBER
DATA_SOURCE_TYPE	VARCHAR2	(15)
ST_TRANSACTION_ID	NUMBER
ERROR_TEXT	VARCHAR2	(2000)
COMMENTS	VARCHAR2	(1000)
PROMISE_DATE	DATE
LINK_TO_LINE_ID	NUMBER
QUANTITY_PER_ASSEMBLY	NUMBER
ORDER_DATE_TYPE_CODE	NUMBER
LATEST_ACCEPTABLE_DATE	DATE
SHIPPING_METHOD_CODE	VARCHAR2	(30)
SCHEDULE_SHIP_DATE	DATE
SCHEDULE_ARRIVAL_DATE	DATE
REQUEST_SHIP_DATE	DATE
PROMISE_SHIP_DATE	DATE
SOURCE_ORG_ID	NUMBER
SOURCE_INVENTORY_ITEM_ID	NUMBER
SOURCE_USING_ASSEMBLY_ITEM_ID	NUMBER
SOURCE_SALES_ORDER_LINE_ID	NUMBER
SOURCE_PROJECT_ID	NUMBER
SOURCE_TASK_ID	NUMBER
SOURCE_CUSTOMER_SITE_ID	NUMBER
SOURCE_BILL_ID	NUMBER
SOURCE_DISPOSITION_ID	NUMBER
SOURCE_CUSTOMER_ID	NUMBER
SOURCE_OPERATION_SEQ_NUM	NUMBER
SOURCE_WIP_ENTITY_ID	NUMBER
ROUTING_SEQUENCE_ID	NUMBER
ASSET_SERIAL_NUMBER	VARCHAR2	(30)
ASSET_ITEM_ID	NUMBER
COMPONENT_SCALING_TYPE	NUMBER
COMPONENT_YIELD_FACTOR	NUMBER
ITEM_TYPE_ID	NUMBER
ITEM_TYPE_VALUE	NUMBER
REPAIR_LINE_ID	NUMBER	(15)
RO_STATUS_CODE	VARCHAR2	(30)
REPAIR_NUMBER	VARCHAR2	(30)
ENTITY	VARCHAR2	(240)
REVISED_DMD_DATE	DATE
REVISED_DMD_PRIORITY	NUMBER
SCHEDULE_DESIGNATOR_ID	NUMBER
OBJECT_TYPE	VARCHAR2	(3)
MAINTENANCE_OBJECT_SOURCE	NUMBER
OPERATING_FLEET	NUMBER
MAINTENANCE_REQUIREMENT	VARCHAR2	(30)
CLASS_CODE	VARCHAR2	(10)

Query Text

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


SELECT ORDER_PRIORITY
,      DEMAND_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      USING_ASSEMBLY_ITEM_ID
,      USING_ASSEMBLY_DEMAND_DATE
,      USING_REQUIREMENT_QUANTITY
,      ASSEMBLY_DEMAND_COMP_DATE
,      DEMAND_TYPE
,      DAILY_DEMAND_RATE
,      ORIGINATION_TYPE
,      SOURCE_ORGANIZATION_ID
,      DISPOSITION_ID
,      RESERVATION_ID
,      DEMAND_SCHEDULE_NAME
,      PROJECT_ID
,      TASK_ID
,      PLANNING_GROUP
,      END_ITEM_UNIT_NUMBER
,      SCHEDULE_DATE
,      OPERATION_SEQ_NUM
,      QUANTITY_ISSUED
,      DEMAND_CLASS
,      SALES_ORDER_NUMBER
,      SALES_ORDER_PRIORITY
,      FORECAST_PRIORITY
,      MPS_DATE_REQUIRED
,      PO_NUMBER
,      WIP_ENTITY_NAME
,      DELETED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SR_INSTANCE_ID
,      REFRESH_ID
,      REPETITIVE_SCHEDULE_ID
,      WIP_ENTITY_ID
,      SELLING_PRICE
,      DMD_LATENESS_COST
,      DMD_SATISFIED_DATE
,      DMD_SPLIT_FLAG
,      REQUEST_DATE
,      ORDER_NUMBER
,      WIP_STATUS_CODE
,      WIP_SUPPLY_TYPE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SALES_ORDER_LINE_ID
,      CONFIDENCE_PERCENTAGE
,      BUCKET_TYPE
,      BILL_ID
,      CUSTOMER_ID
,      PROBABILITY
,      SERVICE_LEVEL
,      FORECAST_MAD
,      FORECAST_DESIGNATOR
,      ORIGINAL_SYSTEM_REFERENCE
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      DEMAND_SOURCE_TYPE
,      SHIP_TO_SITE_ID
,      COMPANY_ID
,      COMPANY_NAME
,      CUSTOMER_NAME
,      CUSTOMER_SITE_ID
,      CUSTOMER_SITE_CODE
,      BILL_CODE
,      ITEM_NAME
,      ROUTING_NAME
,      ALTERNATE_ROUTING_DESIGNATOR
,      OPERATION_EFFECTIVITY_DATE
,      USING_ASSEMBLY_ITEM_NAME
,      PROJECT_NUMBER
,      TASK_NUMBER
,      SCHEDULE_LINE_NUM
,      OPERATION_SEQ_CODE
,      ORGANIZATION_CODE
,      SR_INSTANCE_CODE
,      MESSAGE_ID
,      PROCESS_FLAG
,      BATCH_ID
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      ERROR_TEXT
,      COMMENTS
,      PROMISE_DATE
,      LINK_TO_LINE_ID
,      QUANTITY_PER_ASSEMBLY
,      ORDER_DATE_TYPE_CODE
,      LATEST_ACCEPTABLE_DATE
,      SHIPPING_METHOD_CODE
,      SCHEDULE_SHIP_DATE
,      SCHEDULE_ARRIVAL_DATE
,      REQUEST_SHIP_DATE
,      PROMISE_SHIP_DATE
,      SOURCE_ORG_ID
,      SOURCE_INVENTORY_ITEM_ID
,      SOURCE_USING_ASSEMBLY_ITEM_ID
,      SOURCE_SALES_ORDER_LINE_ID
,      SOURCE_PROJECT_ID
,      SOURCE_TASK_ID
,      SOURCE_CUSTOMER_SITE_ID
,      SOURCE_BILL_ID
,      SOURCE_DISPOSITION_ID
,      SOURCE_CUSTOMER_ID
,      SOURCE_OPERATION_SEQ_NUM
,      SOURCE_WIP_ENTITY_ID
,      ROUTING_SEQUENCE_ID
,      ASSET_SERIAL_NUMBER
,      ASSET_ITEM_ID
,      COMPONENT_SCALING_TYPE
,      COMPONENT_YIELD_FACTOR
,      ITEM_TYPE_ID
,      ITEM_TYPE_VALUE
,      REPAIR_LINE_ID
,      RO_STATUS_CODE
,      REPAIR_NUMBER
,      ENTITY
,      REVISED_DMD_DATE
,      REVISED_DMD_PRIORITY
,      SCHEDULE_DESIGNATOR_ID
,      OBJECT_TYPE
,      MAINTENANCE_OBJECT_SOURCE
,      OPERATING_FLEET
,      MAINTENANCE_REQUIREMENT
,      CLASS_CODE
FROM MSC.MSC_ST_DEMANDS#;

Dependencies

[top of page]

MSC.MSC_ST_DEMANDS# references the following:

MSC: MSC_ST_DEMANDS

MSC.MSC_ST_DEMANDS# is referenced by following:

APPS: MSC_ST_DEMANDS