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]

TABLE: BOM.BOM_CTO_ORDER_DEMAND

Object Details

Object Name:	BOM_CTO_ORDER_DEMAND
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.BOM_CTO_ORDER_DEMAND
Subobject Name:
Status:	VALID

BOM_CTO_ORDER_DEMAND stores the demand information for ATO model, Option class and Option item. It stores the demand only for Mulit level/Multi org ATO models. It also stores the demand of Multi org ATO items.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BOM_CTO_ORDER_DEMAND_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BCOD_LINE_ID
BOM_CTO_ORDER_DEMAND_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OE_LINE_ID
BOM_CTO_ORDER_DEMAND_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATO_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BCOD_LINE_ID	NUMBER	(10)	Yes	Bom cto order demand Line Identifier
OE_LINE_ID	NUMBER	(10)	Yes	OE_Order_lines_all line identifier
ATO_LINE_ID	NUMBER	(10)	Yes	ATO_LINE_ID
INVENTORY_ITEM_ID	NUMBER		Yes	INVENTORY Item Identifier
ORGANIZATION_ID	NUMBER	(10)	Yes	ORGANIZATION_ID
REQUIRED_DATE	DATE		Yes	REQUIRED_DATE
REQUIRED_QTY	NUMBER	(10)	Yes	REQUIRED_QTY
ORDER_QUANTITY_UOM	VARCHAR2	(3)		ORDER_QUANTITY_UOM
HEADER_ID	NUMBER		Yes	HEADER_ID
PARENT_DEMAND_TYPE	NUMBER	(1)		PARENT_DEMAND_TYPE
FORECAST_VISIBLE	VARCHAR2	(1)	Yes	FORECAST VISIBLE Flag
DEMAND_VISIBLE	VARCHAR2	(1)	Yes	DEMAND_VISIBLE Flag
CREATED_BY	NUMBER		Yes	CREATED_BY
LAST_UPDATED_BY	NUMBER		Yes	LAST_UPDATE_BY
LAST_UPDATED_DATE	DATE		Yes	LAST_UPDATED_DATE
LAST_UPDATE_LOGIN	NUMBER			LAST_UPDATE_LOGIN
PROGRAM_APPLICATION_ID	NUMBER			PROGRAM_APPLICATION_ID
PROGRAM_UPDATE_DATE	DATE			PROGRAM_UPDATE_DATE

Query Text

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


SELECT BCOD_LINE_ID
,      OE_LINE_ID
,      ATO_LINE_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      REQUIRED_DATE
,      REQUIRED_QTY
,      ORDER_QUANTITY_UOM
,      HEADER_ID
,      PARENT_DEMAND_TYPE
,      FORECAST_VISIBLE
,      DEMAND_VISIBLE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
FROM BOM.BOM_CTO_ORDER_DEMAND;

Dependencies

[top of page]

BOM.BOM_CTO_ORDER_DEMAND does not reference any database object

BOM.BOM_CTO_ORDER_DEMAND is referenced by following:

APPS: BOM_CTO_ORDER_DEMAND