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_LINES

Object Details

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

bom cto order lines

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BOM_CTO_ORDER_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_ID
BOM_CTO_ORDER_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TOP_MODEL_LINE_ID
BOM_CTO_ORDER_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_ATO_LINE_ID
BOM_CTO_ORDER_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATO_LINE_ID
BOM_CTO_ORDER_LINES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LINK_TO_LINE_ID LINE_ID
BOM_CTO_ORDER_LINES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONFIG_ITEM_ID
BOM_CTO_ORDER_LINES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID SHIP_FROM_ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ATO_LINE_ID	NUMBER			ATO_LINE_ID
BATCH_ID	VARCHAR2	(30)		BATCH_ID
BOM_ITEM_TYPE	VARCHAR2	(30)		BOM_ITEM_TYPE
COMPONENT_CODE	VARCHAR2	(1000)		COMPONENT_CODE
COMPONENT_SEQUENCE_ID	NUMBER			COMPONENT_SEQUENCE_ID
CONFIG_ITEM_ID	NUMBER			CONFIG_ITEM_ID
INVENTORY_ITEM_ID	NUMBER			INVENTORY_ITEM_ID
ITEM_TYPE_CODE	VARCHAR2	(30)		ITEM_TYPE_CODE
LINE_ID	NUMBER		Yes	LINE_ID
LINK_TO_LINE_ID	NUMBER			LINK_TO_LINE_ID
ORDERED_QUANTITY	NUMBER			ORDERED_QUANTITY
ORDER_QUANTITY_UOM	VARCHAR2	(3)		ORDER_QUANTITY_UOM
PARENT_ATO_LINE_ID	NUMBER			PARENT_ATO_LINE_ID
PERFORM_MATCH	VARCHAR2	(1)		PERFORM_MATCH
PLAN_LEVEL	NUMBER			PLAN_LEVEL
SCHEDULE_SHIP_DATE	DATE			SCHEDULE_SHIP_DATE
SHIP_FROM_ORG_ID	NUMBER			SHIP_FROM_ORG_ID
TOP_MODEL_LINE_ID	NUMBER		Yes	TOP_MODEL_LINE_ID
WIP_SUPPLY_TYPE	VARCHAR2	(30)		WIP_SUPPLY_TYPE
HEADER_ID	NUMBER		Yes	HEADER_ID
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
REUSE_CONFIG	VARCHAR2	(1)		Reuse Config Flag
OPTION_SPECIFIC	VARCHAR2	(1)		Option Specific Flag
QTY_PER_PARENT_MODEL	NUMBER			Qty Per parent model
CONFIG_CREATION	VARCHAR2	(30)		config creation attribute

Query Text

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


SELECT ATO_LINE_ID
,      BATCH_ID
,      BOM_ITEM_TYPE
,      COMPONENT_CODE
,      COMPONENT_SEQUENCE_ID
,      CONFIG_ITEM_ID
,      INVENTORY_ITEM_ID
,      ITEM_TYPE_CODE
,      LINE_ID
,      LINK_TO_LINE_ID
,      ORDERED_QUANTITY
,      ORDER_QUANTITY_UOM
,      PARENT_ATO_LINE_ID
,      PERFORM_MATCH
,      PLAN_LEVEL
,      SCHEDULE_SHIP_DATE
,      SHIP_FROM_ORG_ID
,      TOP_MODEL_LINE_ID
,      WIP_SUPPLY_TYPE
,      HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REUSE_CONFIG
,      OPTION_SPECIFIC
,      QTY_PER_PARENT_MODEL
,      CONFIG_CREATION
FROM BOM.BOM_CTO_ORDER_LINES;

Dependencies

[top of page]

BOM.BOM_CTO_ORDER_LINES does not reference any database object

BOM.BOM_CTO_ORDER_LINES is referenced by following:

BOM: BOM_CTO_ORDER_LINES#