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

TABLE: MSC.MSC_TEMP_ALLOC_DEMANDS

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


Child table to MSC_DEMANDS storing pre-allocated demands.


Storage Details
Tablespace: TablespaceAPPS_TS_NOLOGGING
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes Plan ID
INVENTORY_ITEM_ID NUMBER
Yes Item ID
ORGANIZATION_ID NUMBER
Yes Organization ID
SR_INSTANCE_ID NUMBER
Yes Source instance ID
DEMAND_CLASS VARCHAR2 (30) Yes Demand class
DEMAND_DATE DATE
Yes Demand date
PARENT_DEMAND_ID NUMBER
Yes Parent demand ID (for stealing)
ALLOCATED_QUANTITY NUMBER
Yes Allocated quantity
ORIGINATION_TYPE NUMBER
Yes Origin of demand. Discrete WIP demand, flow schedule_demand, etc
ORDER_NUMBER VARCHAR2 (62)
Order number
SALES_ORDER_LINE_ID NUMBER

Sales order line ID
OLD_DEMAND_DATE DATE

Old demand date (to undo changes when scheduling fails)
OLD_ALLOCATED_QUANTITY NUMBER

Old allocated quantity
CREATED_BY NUMBER
Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
Query Text

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


SELECT PLAN_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      DEMAND_CLASS
,      DEMAND_DATE
,      PARENT_DEMAND_ID
,      ALLOCATED_QUANTITY
,      ORIGINATION_TYPE
,      ORDER_NUMBER
,      SALES_ORDER_LINE_ID
,      OLD_DEMAND_DATE
,      OLD_ALLOCATED_QUANTITY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM MSC.MSC_TEMP_ALLOC_DEMANDS;

Dependencies

[top of page]

MSC.MSC_TEMP_ALLOC_DEMANDS does not reference any database object

MSC.MSC_TEMP_ALLOC_DEMANDS is referenced by following:

SchemaMSC
ViewMSC_TEMP_ALLOC_DEMANDS#