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_SQL_STATEMENTS

Object Details

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

This table stores information about delete statements and constraints.
Oracle Bills of Material provides you with a pre-defined set of
constraints to maintain data integrity. You should not delete these
constraints. You can add your own constraints using the Define Delete
Constraints (BOMFDCON) window. Oracle Bills of Material also stores
delete sql statements that the Delete program (BMCDEL) uses to purge
data from the database.
.
.
.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BOM_DELETE_SQL_STATEMENTS_U1	NORMAL	UNIQUE	APPS_TS_SEED	SQL_STATEMENT_NAME ZD_EDITION_NAME
BOM_DELETE_SQL_STATEMENTS_U2	NORMAL	UNIQUE	APPS_TS_SEED	SQL_STATEMENT_TYPE DELETE_ENTITY_TYPE SEQUENCE_NUMBER ZD_EDITION_NAME
SYS_IL0000030237C00020$$	LOB	UNIQUE	APPS_TS_SEED

Columns

Name	Datatype	Length	Mandatory	Comments
SQL_STATEMENT_NAME	VARCHAR2	(10)	Yes	Name that uniquely identifies a sql statement
SQL_STATEMENT_TYPE	NUMBER		Yes	Type of sql statement
ACTIVE_FLAG	NUMBER		Yes	Indicates whether this sql statement is active
DELETE_ON_SUCCESS_FLAG	NUMBER			For a constraint, indicate whether delete should occur when sql statement succeeds (returns rows) or whether delete should occur when sql statement fails (returns no rows)
DELETE_ENTITY_TYPE	NUMBER		Yes	Type of delete entity
MESSAGE_NAME	VARCHAR2	(30)		Name of the message to be produced when the sql statement fails
DESCRIPTION	VARCHAR2	(240)		Description
SEQUENCE_NUMBER	NUMBER		Yes	Number that identifies the sequence in which the constraints or deletes for this delete entity type will execute
ARCHIVE_TABLE_NAME	VARCHAR2	(32)		For delete statements, name of table to archive deleted rows
PREDEFINED_FLAG	NUMBER		Yes	Indicates if constraint is seeded or user defined
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
SQL_STATEMENT	CLOB	(4000)		Sql statement
PRODUCT_NAME	VARCHAR2	(30)		Name of the product, in which this delere statement record will be used. Ex: "MFG" or "PLM"
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT SQL_STATEMENT_NAME
,      SQL_STATEMENT_TYPE
,      ACTIVE_FLAG
,      DELETE_ON_SUCCESS_FLAG
,      DELETE_ENTITY_TYPE
,      MESSAGE_NAME
,      DESCRIPTION
,      SEQUENCE_NUMBER
,      ARCHIVE_TABLE_NAME
,      PREDEFINED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SQL_STATEMENT
,      PRODUCT_NAME
,      ZD_EDITION_NAME
FROM BOM.BOM_DELETE_SQL_STATEMENTS;

Dependencies

[top of page]

BOM.BOM_DELETE_SQL_STATEMENTS does not reference any database object

BOM.BOM_DELETE_SQL_STATEMENTS is referenced by following:

BOM: BOM_DELETE_SQL_STATEMENTS#