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_UPG

Object Details

Object Name:	BOM_CTO_ORDER_LINES_UPG
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.BOM_CTO_ORDER_LINES_UPG
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_UPG_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_ID
BOM_CTO_ORDER_LINES_UPG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONFIG_ITEM_ID
BOM_CTO_ORDER_LINES_UPG_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS CONFIG_ITEM_ID
BOM_CTO_ORDER_LINES_UPG_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS LINE_ID INVENTORY_ITEM_ID CONFIG_ITEM_ID
BOM_CTO_ORDER_LINES_UPG_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATO_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ATO_LINE_ID	NUMBER	(10)		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	(20)		CONFIG_ITEM_ID
INVENTORY_ITEM_ID	NUMBER	(20)		INVENTORY_ITEM_ID
ITEM_TYPE_CODE	VARCHAR2	(30)		ITEM_TYPE_CODE
LINE_ID	NUMBER	(10)	Yes	LINE_ID
LINK_TO_LINE_ID	NUMBER	(10)		LINK_TO_LINE_ID
ORDERED_QUANTITY	NUMBER			ORDERED_QUANTITY
ORDER_QUANTITY_UOM	VARCHAR2	(3)		ORDER_QUANTITY_UOM
PARENT_ATO_LINE_ID	NUMBER	(10)		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	(10)		SHIP_FROM_ORG_ID
TOP_MODEL_LINE_ID	NUMBER	(10)	Yes	TOP_MODEL_LINE_ID
WIP_SUPPLY_TYPE	VARCHAR2	(30)		WIP_SUPPLY_TYPE
HEADER_ID	NUMBER	(10)	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)		Resuse 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
SEQUENCE	NUMBER	(10)		Sequence
STATUS	VARCHAR2	(30)		Status

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
,      SEQUENCE
,      STATUS
FROM BOM.BOM_CTO_ORDER_LINES_UPG;

Dependencies

[top of page]

BOM.BOM_CTO_ORDER_LINES_UPG does not reference any database object

BOM.BOM_CTO_ORDER_LINES_UPG is referenced by following:

APPS: BOM_CTO_ORDER_LINES_UPG