[Home] [Help]
[Dependency Information]
Object Name: | MSC_DEMANDS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
This table stores all the demands taken into account for planning. Disposition_id would be a foreign key to MSC_SUPPLIES for dependent demands. For independent demands, disposition_id holds MRP_SCHEDULE_DATES.MPS_TRANSACTION_ID.
Tablespace: | ![]() |
---|---|
PCT Free: | |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_DEMANDS_U1 | NORMAL | UNIQUE |
![]() |
![]() ![]() ![]() |
MSC_DEMANDS_N1 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() |
MSC_DEMANDS_N2 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() |
MSC_DEMANDS_N3 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() ![]() ![]() |
MSC_DEMANDS_N4 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() ![]() |
MSC_DEMANDS_N5 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() |
MSC_DEMANDS_N6 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() |
MSC_DEMANDS_N7 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() |
MSC_DEMANDS_N8 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() |
ORDER_PRIORITY | NUMBER | Order priority | ||
FORECAST_MAD | NUMBER | Forecash MAD | ||
DEMAND_ID | NUMBER | Yes | Demand identifier | |
SCHEDULE_DESIGNATOR_ID | NUMBER | Schedule designator identifier | ||
USING_REQUIREMENT_QUANTITY | NUMBER | Yes | Required quantity | |
ASSEMBLY_DEMAND_COMP_DATE | DATE | Using assembly completion date | ||
USING_ASSEMBLY_DEMAND_DATE | DATE | Yes | Demand date (due date) | |
DEMAND_TYPE | NUMBER | Yes | Demand type. Discrete Demand(1), Rate-based demand(2) | |
ORIGINATION_TYPE | NUMBER | Origin of the demand: Planned order, hard reservation, etc... | ||
DEMAND_PRIORITY | NUMBER | Demand priority. Used by scheduling heuristic | ||
SALES_ORDER_PRIORITY | NUMBER | Sales order quantity | ||
FORECAST_PRIORITY | NUMBER | Forecast priority | ||
PLANNING_GROUP | VARCHAR2 | (30) | Planning group | |
DAILY_DEMAND_RATE | NUMBER | Repetitive demand rate | ||
UNIT_NUMBER | VARCHAR2 | (30) | Unit number | |
DISPOSITION_ID | NUMBER | Disposition identifier, reference to the supply generating the demand. | ||
USING_ASSEMBLY_ITEM_ID | NUMBER | Yes | Using assembly iten identifier (item generating the demand for dependent demands) | |
PLAN_ID | NUMBER | Yes | Plan identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
INVENTORY_ITEM_ID | NUMBER | Yes | Demanded item identifier | |
PROJECT_ID | NUMBER | (15) | Project identifier to which the demand applies | |
TASK_ID | NUMBER | (15) | Task identifier to which the demand applies | |
CUSTOMER_ID | NUMBER | Customer identifier | ||
CUSTOMER_SITE_ID | NUMBER | Customer site identifier | ||
SR_INSTANCE_ID | NUMBER | Yes | Source application instance identifier | |
SHIP_TO_SITE_ID | NUMBER | Destination of the product | ||
PROMISE_DATE | DATE | Date promised to the customer | ||
SELLING_PRICE | NUMBER | Selling price | ||
DMD_LATENESS_COST | NUMBER | Demand lateness cost for independent demands | ||
DMD_SATISFIED_DATE | DATE | Date demand is satisfied | ||
OP_SEQ_NUM | NUMBER | Operation sequence number within the routing used by the source supply | ||
UPDATED | NUMBER | Flag to determine whether add workday modification was applied | ||
STATUS | NUMBER | Used for online replanning | ||
APPLIED | NUMBER | Used for online replanning | ||
DEMAND_CLASS | VARCHAR2 | (34) | Demand class code | |
FIRM_QUANTITY | NUMBER | Firm quantity | ||
FIRM_DATE | DATE | Firm quantity | ||
OLD_DEMAND_QUANTITY | NUMBER | Old demand quantity | ||
OLD_DEMAND_DATE | DATE | Old order due date | ||
SOURCE_ORGANIZATION_ID | NUMBER | Source application identifier | ||
RESERVATION_ID | NUMBER | Reservation identifier | ||
PARENT_ID | NUMBER | Demand identifier of the parent demand transaction | ||
LENDING_PROJECT_ID | NUMBER | Lending project identifier for Payback Demand | ||
LENDING_TASK_ID | NUMBER | Lending task identifier for Payback Demand | ||
SUBST_ITEM_FLAG | NUMBER | Flag indicating whether item is a substitute item | ||
ORDER_NUMBER | VARCHAR2 | (62) | Wip entity name | |
RESERVED_QUANTITY | NUMBER | Quantity reserved | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | 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 | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
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 | |
WIP_ENTITY_ID | NUMBER | WIP job identifier | ||
ISSUED_QUANTITY | NUMBER | Quantity issued | ||
REPETITIVE_SCHEDULE_ID | NUMBER | Repetitive schedule identifier | ||
REFRESH_NUMBER | NUMBER | Refresh number populated by the collection program | ||
REQUEST_DATE | DATE | Request date | ||
WIP_STATUS_CODE | NUMBER | WIP job status code | ||
WIP_SUPPLY_TYPE | NUMBER | WIP supply type | ||
SOURCE_ORG_INSTANCE_ID | NUMBER | Source Org Instance Identifier | ||
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 | ||
PROBABILITY | NUMBER | Probability | ||
FORECAST_SET_ID | NUMBER | Forecast set identifier | ||
GROUP_ID | NUMBER | Group identifier | ||
SERVICE_LEVEL | NUMBER | Service Level | ||
QUANTITY_BY_DUE_DATE | NUMBER | Quantity By Due Date | ||
TARGET_SAFETY_STOCK | NUMBER | Target Safety Stock | ||
SCENARIO_SET | NUMBER | Scenario Set | ||
DEMAND_SOURCE_TYPE | NUMBER | Forecast billing address identifier | ||
SUPPLY_ID | NUMBER | Forecast billing address identifier | ||
ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | Original System Reference | |
ORIGINAL_SYSTEM_LINE_REFERENCE | VARCHAR2 | (50) | Original System Line Reference | |
STOLEN_FLAG | VARCHAR2 | (1) | Stolen Flag | |
OLD_USING_REQUIREMENT_QUANTITY | NUMBER | Old requirement quantity for ATP Summary Calculation | ||
OLD_USING_ASSEMBLY_DEMAND_DATE | DATE | Old demand date for ATP Summary Calculation | ||
OLD_ASSEMBLY_DEMAND_COMP_DATE | DATE | For ATP Summary Calculation | ||
CUMMULATIVE_PROBABILITY | NUMBER | Cumulative Probaility | ||
ORIGINAL_ITEM_ID | NUMBER | Original Item Id | ||
UNMET_QUANTITY | NUMBER | Unmet Quantity for Independent Demands | ||
RECORD_SOURCE | NUMBER | For plan order demands generated by ATP this field will have value 2. If this field is 1 or null then the plan order is generated by MBP | ||
LINK_TO_LINE_ID | NUMBER | Parent Line Identifier | ||
ERROR_TYPE | NUMBER | 1=MAD, 2=MAPE, Null= Neither | ||
ATP_SYNCHRONIZATION_FLAG | NUMBER | ATP Synchronization Flag for 24x7 ATP | ||
COMP_SEQ_ID | NUMBER | Component Sequence Id | ||
QUANTITY_PER_ASSEMBLY | NUMBER | Part usage quantity | ||
RELEASE_STATUS | NUMBER | Release status | ||
RESCHEDULE_FLAG | NUMBER | Reschedule Flag | ||
LOAD_TYPE | NUMBER | Load Type | ||
IMPLEMENT_ORG_ID | NUMBER | Implement Org ID | ||
IMPLEMENT_INSTANCE_ID | NUMBER | Implement Source Instance ID | ||
IMPLEMENT_DATE | DATE | Implement Schedule Ship Date | ||
RELEASE_ERRORS | VARCHAR2 | (250) | Release Errors | |
ORG_FIRM_FLAG | NUMBER | Org Firm Flag | ||
ORIGINAL_ORG_ID | NUMBER | For Sales Orders : Original Organization Id on the Order | ||
ORIGINAL_INST_ID | NUMBER | For Sales Orders : Original Instance Id on the Sales Order | ||
ARRIVAL_SET_ID | NUMBER | Arrival Set Id | ||
SHIP_SET_ID | NUMBER | Ship Set Id | ||
ORDER_DATE_TYPE_CODE | NUMBER | For sales Order if type is Ship or Arrival | ||
SCHEDULE_ARRIVAL_DATE | DATE | Schedule Arrival Date of Demand | ||
LATEST_ACCEPTABLE_DATE | DATE | Latest Acceptable Date on Sales Order | ||
SHIPPING_METHOD_CODE | VARCHAR2 | (30) | Ship Method Code | |
PLANNED_ARRIVAL_DATE | DATE | Updated after Planning : the planned arrival date | ||
REQUEST_SHIP_DATE | DATE | Request Ship Date | ||
PROMISE_SHIP_DATE | DATE | Promise Ship Date | ||
SCHEDULE_SHIP_DATE | DATE | Shedule Ship Date | ||
ORIGINAL_DEMAND_ID | NUMBER | Original Demand Id refers to the Original Demand.This could be a Sales Order or a Forecast.In a Global Forecast Situation a Sales Order can get split into multiple demands satisfied indifferent organizations. When NULL, Original_Demand_Id is the same as Demand_Id. | ||
ZONE_ID | NUMBER | Zone id | ||
ORIG_SHIPPING_METHOD_CODE | VARCHAR2 | (30) | Original shipping method code on demand | |
INTRANSIT_LEAD_TIME | NUMBER | Intransit Lead Time | ||
ORIG_INTRANSIT_LEAD_TIME | NUMBER | Original Intransit Lead Time | ||
ATP_OVERRIDE_FLAG | NUMBER | atp_override_flag | ||
IMPLEMENT_FIRM | NUMBER | Implement FIrm Flag | ||
IMPLEMENT_EARLIEST_DATE | DATE | Implement Earliest Ship Date | ||
IMPLEMENT_ARRIVAL_DATE | DATE | Implement Schedule Arrival Date | ||
UNBUCKETED_DEMAND_DATE | DATE | Stores the unbucketed demand date | ||
ATO_LINE_ID | NUMBER | LINE ID of top ATO model | ||
TOP_MODEL_LINE_ID | NUMBER | Line id Of the Top Model | ||
PARENT_MODEL_LINE_ID | NUMBER | Line ID of parent model | ||
STD_MANDATORY_COMP_FLAG | NUMBER | Flag indicating whether the record if standard mandatory component or not. | ||
OLD_REFRESH_NUMBER | NUMBER | Old Refresh Number | ||
SHIP_METHOD | VARCHAR2 | (30) | Ship method | |
SHIP_CALENDAR | VARCHAR2 | (15) | Shipping calendar | |
RECEIVING_CALENDAR | VARCHAR2 | (15) | Receiving calendar | |
INTRANSIT_CALENDAR | VARCHAR2 | (15) | Intransit calendar | |
SHIP_TO_LOCATION_ID | NUMBER | Will store the external location id. | ||
ORIGINAL_QUANTITY | NUMBER | Original Quantity of the demand | ||
FINAL_USE_PRIORITY | NUMBER | Final use priority. Used in DRP allocation. | ||
FINAL_USE_DATE | DATE | Final use date | ||
ARRIVAL_SET_NAME | VARCHAR2 | (30) | To capture Arrival Set Name | |
SHIP_SET_NAME | VARCHAR2 | (30) | To capture Ship set name | |
SOURCE_PHANTOM_ID | NUMBER | Top Level Phantom Component Identifier | ||
PRIMARY_COMPONENT_ID | NUMBER | Component identifier of t he primary component for the current component | ||
ATP_SESSION_ID | NUMBER | Session Id for ATP inquiry | ||
IMPLEMENT_SHIP_DATE | DATE | Ship date entered by user during release. | ||
PLANNED_SHIP_DATE | DATE | Planned Ship Date | ||
PRIOR_ALLOCATION_QTY | NUMBER | |||
MANUAL_ALLOCATION_QTY | NUMBER | |||
MANUAL_ALLOCATION_DATE | DATE | |||
FIRM_ALLOCATION_FLAG | NUMBER | |||
ASSET_SERIAL_NUMBER | VARCHAR2 | (30) | Asset number or rebuild serial number | |
ASSET_ITEM_ID | NUMBER | Fk it item id. Asset group id or rebuild_item_id | ||
EXPIRATION_DATE | DATE | |||
SALES_ORDER_LINE_SPLIT | NUMBER | |||
PLANNED_INBOUND_DUE_DATE | DATE | Due date of the planned order created during the push down phase of DRP. | ||
FILL_KILL_FLAG | NUMBER | Flag to indicate whether a SO line has been killed. | ||
DEFINITION_LEVEL_USED | NUMBER | The most specific definition level used for the current demand record | ||
DEMAND_FULFILLMENT_LEAD_TIME | NUMBER | Demand Fulfillment Lead time | ||
COMPONENT_SCALING_TYPE | NUMBER | Whether required component quantity is item-based or lot-based | ||
COMPONENT_YIELD_FACTOR | NUMBER | Component Yield | ||
SPLIT_FROM_DEMAND_ID | NUMBER | |||
PREV_SUBST_ITEM | NUMBER | |||
PREV_SUBST_ORG | NUMBER | |||
ITEM_TYPE_ID | NUMBER | Code for Criterion on which this item is categorised into types | ||
ITEM_TYPE_VALUE | NUMBER | Item type code per classification per the criterion indicated by the item_type_id | ||
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 | |||
Name | Datatype | Length | Mandatory | Comments |
---|
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;
MSC.MSC_DEMANDS does not reference any database object
MSC.MSC_DEMANDS is referenced by following:
|
|
|