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

TABLE: MSC.MSC_ST_DEMANDS

Object Details
Object Name: MSC_ST_DEMANDS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_ST_DEMANDS
Subobject Name:
Status: VALID

The staging table used by the collection program to validate and process data for table MSC_DEMANDS.

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ORDER_PRIORITY NUMBER

Order priority
DEMAND_ID NUMBER

Demand identifier
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
ORGANIZATION_ID NUMBER

Organization identifier
USING_ASSEMBLY_ITEM_ID NUMBER

Using assembly iten identifier (item generates demand for dependent demands)
USING_ASSEMBLY_DEMAND_DATE DATE

Demand date (due date)
USING_REQUIREMENT_QUANTITY NUMBER

Required quantity
ASSEMBLY_DEMAND_COMP_DATE DATE

Using assembly completion date
DEMAND_TYPE NUMBER

Discrete Demand(1), Rate-based demand(2)
DAILY_DEMAND_RATE NUMBER

Repetitive demand rate
ORIGINATION_TYPE NUMBER

Origin of the demand: Planned order, hard reversation, etc...
SOURCE_ORGANIZATION_ID NUMBER

Source organization identifier
DISPOSITION_ID NUMBER

Identifier reference to the supply generating the demand
RESERVATION_ID NUMBER

Reservation identitfier
DEMAND_SCHEDULE_NAME VARCHAR2 (10)
Demand schedule name
PROJECT_ID NUMBER (15)
Project identifier to which the demand applies
TASK_ID NUMBER (15)
Task identifier to which the demand applies
PLANNING_GROUP VARCHAR2 (30)
Planning group
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
End item unit number
SCHEDULE_DATE DATE

Schedule date
OPERATION_SEQ_NUM NUMBER

Operation sequence number
QUANTITY_ISSUED NUMBER

Quantity issued
DEMAND_CLASS VARCHAR2 (34)
Demand class code
SALES_ORDER_NUMBER VARCHAR2 (122)
Sales order number
SALES_ORDER_PRIORITY NUMBER

Sales order priority
FORECAST_PRIORITY NUMBER

Forecast priority
MPS_DATE_REQUIRED DATE

MPS date required
PO_NUMBER VARCHAR2 (62)
Purchase order number
WIP_ENTITY_NAME VARCHAR2 (240)
Wip job name
DELETED_FLAG NUMBER

Yes/No flag indicating whether the row will be deleted
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
SR_INSTANCE_ID NUMBER

Source application instance identifier
REFRESH_ID NUMBER

Refresh identifier populated by the collection program
REPETITIVE_SCHEDULE_ID NUMBER

Repetitive schedule identifier
WIP_ENTITY_ID NUMBER

WIP job identifier
SELLING_PRICE NUMBER

Selling price
DMD_LATENESS_COST NUMBER

Demand lateness cost for independent demands
DMD_SATISFIED_DATE DATE

Date demand is satisfied
DMD_SPLIT_FLAG NUMBER

Demand split flag
REQUEST_DATE DATE

Request date
ORDER_NUMBER VARCHAR2 (240)
WIP entity name
WIP_STATUS_CODE NUMBER

WIP job status code
WIP_SUPPLY_TYPE NUMBER

WIP supply type
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
SALES_ORDER_LINE_ID NUMBER

Sales order line identifier
CONFIDENCE_PERCENTAGE NUMBER

Forecast confidence percentage
BUCKET_TYPE NUMBER

Bucket type
BILL_ID NUMBER

Forecast billing address identifier
CUSTOMER_ID NUMBER

Customer Id
PROBABILITY NUMBER

Demand probability
SERVICE_LEVEL NUMBER

Service Level
FORECAST_MAD NUMBER

Forecast Mad
FORECAST_DESIGNATOR VARCHAR2 (10)
Forecast Designator
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
Original System Reference
ORIGINAL_SYSTEM_LINE_REFERENCE VARCHAR2 (50)
Original System Line Reference
DEMAND_SOURCE_TYPE NUMBER

Demand Source Type
SHIP_TO_SITE_ID NUMBER

Destination of the product
COMPANY_ID NUMBER

Company identifier
COMPANY_NAME VARCHAR2 (255)
Company name
CUSTOMER_NAME VARCHAR2 (255)
Customer Name
CUSTOMER_SITE_ID NUMBER

Customer Site Id
CUSTOMER_SITE_CODE VARCHAR2 (30)
Customer Site Code
BILL_CODE VARCHAR2 (30)
Bill to site code
ITEM_NAME VARCHAR2 (250)
Item for which MDS is given
ROUTING_NAME VARCHAR2 (250)
Routing Name
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate Routing Designator
OPERATION_EFFECTIVITY_DATE DATE

Effectivity Date
USING_ASSEMBLY_ITEM_NAME VARCHAR2 (250)
Assembly Item name for which job is created in WIP
PROJECT_NUMBER VARCHAR2 (25)
Project Identifier
TASK_NUMBER VARCHAR2 (25)
Task Identifier
SCHEDULE_LINE_NUM VARCHAR2 (10)
Schedule Line Number. This would be used to uniqely identify a demand record for a schedule during batch loads.
OPERATION_SEQ_CODE VARCHAR2 (10)
Operation Sequence Code
ORGANIZATION_CODE VARCHAR2 (7)
Organization Code
SR_INSTANCE_CODE VARCHAR2 (3)
Source Instance code
MESSAGE_ID NUMBER

This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML
PROCESS_FLAG NUMBER

Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed
BATCH_ID NUMBER

Batch identifier generated during pre-processing
DATA_SOURCE_TYPE VARCHAR2 (15)
Source Type indicating the source of data
ST_TRANSACTION_ID NUMBER

Transaction ID generated during pre-processing to uniquely identify a record in the staging table
ERROR_TEXT VARCHAR2 (2000)
If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error
COMMENTS VARCHAR2 (1000)
Comments
PROMISE_DATE DATE

Date promised to the customer
LINK_TO_LINE_ID NUMBER

Parent Line Identifier
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)
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
FROM MSC.MSC_ST_DEMANDS;

Dependencies

[top of page]

MSC.MSC_ST_DEMANDS does not reference any database object

MSC.MSC_ST_DEMANDS is referenced by following:

SchemaAPPS
SynonymMSC_ST_DEMANDS