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: INV.MTL_DEMAND#

Object Details

Object Name:	MTL_DEMAND#
Object Type:	VIEW
Owner:	INV
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
DEMAND_ID	NUMBER		Yes
ORGANIZATION_ID	NUMBER		Yes
INVENTORY_ITEM_ID	NUMBER		Yes
DEMAND_SOURCE_TYPE	NUMBER		Yes
DEMAND_SOURCE_HEADER_ID	NUMBER		Yes
DEMAND_SOURCE_LINE	VARCHAR2	(30)
DEMAND_SOURCE_DELIVERY	VARCHAR2	(30)
DEMAND_SOURCE_NAME	VARCHAR2	(30)
UOM_CODE	VARCHAR2	(3)	Yes
LINE_ITEM_QUANTITY	NUMBER		Yes
PRIMARY_UOM_QUANTITY	NUMBER		Yes
LINE_ITEM_RESERVATION_QTY	NUMBER
RESERVATION_QUANTITY	NUMBER
COMPLETED_QUANTITY	NUMBER		Yes
REQUIREMENT_DATE	DATE		Yes
RESERVATION_TYPE	NUMBER		Yes
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
PARENT_DEMAND_ID	NUMBER
EXTERNAL_SOURCE_CODE	VARCHAR2	(30)
EXTERNAL_SOURCE_LINE_ID	NUMBER
USER_LINE_NUM	VARCHAR2	(30)
USER_DELIVERY	VARCHAR2	(30)
SCHEDULE_ID	NUMBER
AUTODETAIL_GROUP_ID	NUMBER
SUPPLY_SOURCE_TYPE	NUMBER
SUPPLY_SOURCE_HEADER_ID	NUMBER
SUPPLY_GROUP_ID	NUMBER
UPDATED_FLAG	NUMBER
REVISION	VARCHAR2	(3)
LOT_NUMBER	VARCHAR2	(80)
SERIAL_NUMBER	VARCHAR2	(30)
SUBINVENTORY	VARCHAR2	(10)
LOCATOR_ID	NUMBER
COMPONENT_SEQUENCE_ID	NUMBER
PARENT_COMPONENT_SEQ_ID	NUMBER
RTO_MODEL_SOURCE_LINE	VARCHAR2	(30)
RTO_PREVIOUS_QTY	NUMBER
CONFIG_STATUS	NUMBER
AVAILABLE_TO_MRP	NUMBER
AVAILABLE_TO_ATP	NUMBER
ESTIMATED_RELEASE_DATE	DATE
DEMAND_CLASS	VARCHAR2	(30)
ROW_STATUS_FLAG	NUMBER	(2)
ORDER_CHANGE_REPORT_FLAG	NUMBER
ATP_LEAD_TIME	NUMBER	(22)
EXPLOSION_EFFECTIVITY_DATE	DATE
BOM_LEVEL	NUMBER
MRP_DATE	DATE
MRP_QUANTITY	NUMBER
CUSTOMER_ID	NUMBER
TERRITORY_ID	NUMBER
BILL_TO_SITE_USE_ID	NUMBER
SHIP_TO_SITE_USE_ID	NUMBER
MASTER_RESERVATION_QTY	NUMBER
DESCRIPTION	VARCHAR2	(50)
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)
DEMAND_TYPE	NUMBER
DUPLICATED_CONFIG_ITEM_ID	NUMBER
DUPLICATED_CONFIG_DEMAND_ID	NUMBER
EXPLOSION_GROUP_ID	NUMBER
ORDERED_ITEM_ID	NUMBER
CONFIG_GROUP_ID	NUMBER
OPERATION_SEQ_NUM	NUMBER
N_COLUMN1	NUMBER

Query Text

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


SELECT DEMAND_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      DEMAND_SOURCE_TYPE
,      DEMAND_SOURCE_HEADER_ID
,      DEMAND_SOURCE_LINE
,      DEMAND_SOURCE_DELIVERY
,      DEMAND_SOURCE_NAME
,      UOM_CODE
,      LINE_ITEM_QUANTITY
,      PRIMARY_UOM_QUANTITY
,      LINE_ITEM_RESERVATION_QTY
,      RESERVATION_QUANTITY
,      COMPLETED_QUANTITY
,      REQUIREMENT_DATE
,      RESERVATION_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PARENT_DEMAND_ID
,      EXTERNAL_SOURCE_CODE
,      EXTERNAL_SOURCE_LINE_ID
,      USER_LINE_NUM
,      USER_DELIVERY
,      SCHEDULE_ID
,      AUTODETAIL_GROUP_ID
,      SUPPLY_SOURCE_TYPE
,      SUPPLY_SOURCE_HEADER_ID
,      SUPPLY_GROUP_ID
,      UPDATED_FLAG
,      REVISION
,      LOT_NUMBER
,      SERIAL_NUMBER
,      SUBINVENTORY
,      LOCATOR_ID
,      COMPONENT_SEQUENCE_ID
,      PARENT_COMPONENT_SEQ_ID
,      RTO_MODEL_SOURCE_LINE
,      RTO_PREVIOUS_QTY
,      CONFIG_STATUS
,      AVAILABLE_TO_MRP
,      AVAILABLE_TO_ATP
,      ESTIMATED_RELEASE_DATE
,      DEMAND_CLASS
,      ROW_STATUS_FLAG
,      ORDER_CHANGE_REPORT_FLAG
,      ATP_LEAD_TIME
,      EXPLOSION_EFFECTIVITY_DATE
,      BOM_LEVEL
,      MRP_DATE
,      MRP_QUANTITY
,      CUSTOMER_ID
,      TERRITORY_ID
,      BILL_TO_SITE_USE_ID
,      SHIP_TO_SITE_USE_ID
,      MASTER_RESERVATION_QTY
,      DESCRIPTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DEMAND_TYPE
,      DUPLICATED_CONFIG_ITEM_ID
,      DUPLICATED_CONFIG_DEMAND_ID
,      EXPLOSION_GROUP_ID
,      ORDERED_ITEM_ID
,      CONFIG_GROUP_ID
,      OPERATION_SEQ_NUM
,      N_COLUMN1
FROM INV.MTL_DEMAND#;

Dependencies

[top of page]

INV.MTL_DEMAND# references the following:

INV: MTL_DEMAND

INV.MTL_DEMAND# is referenced by following:

APPS: MTL_DEMAND; MTL_DEMAND_T