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_DELETE_ENTITIES

Object Details

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

BOM_DELETE_ENTITIES stores information about items, bills, or routings
you choose to delete in your delete group.
.
Oracle Bills of Material stores the item number and description of the
item you delete in ITEM_CONCAT_SEGMENTS and ITEM_DESCRIPTION. These
values are stored to report and query on if you delete the item.
.
PRIOR_PROCESS_FLAG stores whether the row originates from the user or
is automatically created by Oracle Bills of Material. If a user
entered the row, the Delete Item User-exit process does not affect the
row.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BOM_DELETE_ENTITIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DELETE_ENTITY_SEQUENCE_ID
BOM_DELETE_ENTITIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELETE_GROUP_SEQUENCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DELETE_ENTITY_SEQUENCE_ID	NUMBER		Yes	Delete entity unique identifier
DELETE_GROUP_SEQUENCE_ID	NUMBER		Yes	Delete group unique identifier
DELETE_ENTITY_TYPE	NUMBER			Type of delete entity
BILL_SEQUENCE_ID	NUMBER			Bill of material unique identifier
ROUTING_SEQUENCE_ID	NUMBER			Routing unique identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Item unique identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
ALTERNATE_DESIGNATOR	VARCHAR2	(10)		Alternate designator of bom or routing being deleted
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description
ITEM_CONCAT_SEGMENTS	VARCHAR2	(240)	Yes	Item concatenated key flexfield segments
DELETE_STATUS_TYPE	NUMBER			Delete entity status
DELETE_DATE	DATE			Date entity was deleted
PRIOR_PROCESS_FLAG	NUMBER		Yes	Indicates whether this row has been exploded into its bill or routings for child organizations
PRIOR_COMMIT_FLAG	NUMBER		Yes	Indicates if the row is user entered or loaded automatically
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

Query Text

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


SELECT DELETE_ENTITY_SEQUENCE_ID
,      DELETE_GROUP_SEQUENCE_ID
,      DELETE_ENTITY_TYPE
,      BILL_SEQUENCE_ID
,      ROUTING_SEQUENCE_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ALTERNATE_DESIGNATOR
,      ITEM_DESCRIPTION
,      ITEM_CONCAT_SEGMENTS
,      DELETE_STATUS_TYPE
,      DELETE_DATE
,      PRIOR_PROCESS_FLAG
,      PRIOR_COMMIT_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM BOM.BOM_DELETE_ENTITIES;

Dependencies

[top of page]

BOM.BOM_DELETE_ENTITIES does not reference any database object

BOM.BOM_DELETE_ENTITIES is referenced by following:

BOM: BOM_DELETE_ENTITIES#