DBA Data[Home] [Help] [Dependency Information]

TABLE: BOM.BOM_DELETE_GROUPS

Object Details
Object Name: BOM_DELETE_GROUPS
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.BOM_DELETE_GROUPS
Subobject Name:
Status: VALID


BOM_DELETE_GROUPS stores header information about the group of
entities you want to delete.
.
You can group items, bills, routings , operations, components, bill
and routings, or items, bills and routings in a single group.
.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BOM_DELETE_GROUPS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDELETE_GROUP_SEQUENCE_ID
BOM_DELETE_GROUPS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnDELETE_GROUP_NAME
Columns
Name Datatype Length Mandatory Comments
DELETE_GROUP_SEQUENCE_ID NUMBER
Yes Group unique identifier
DELETE_GROUP_NAME VARCHAR2 (10) Yes Name of the delete group
ORGANIZATION_ID NUMBER
Yes Organization identifier
DELETE_TYPE NUMBER
Yes Type of delete
ACTION_TYPE NUMBER
Yes Type of action
DATE_LAST_SUBMITTED DATE

Date the concurrent program was last submitted
DESCRIPTION VARCHAR2 (240)
Description
ENGINEERING_FLAG NUMBER
Yes Whether the delete group is for engineering or manufacturing entities
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
DELETE_COMMON_BILL_FLAG NUMBER (1)
Common Bill Flag
DELETE_ORG_TYPE NUMBER

Organization Type
ORGANIZATION_HIERARCHY VARCHAR2 (30)
Organization Hierarchy Name
Query Text

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


SELECT DELETE_GROUP_SEQUENCE_ID
,      DELETE_GROUP_NAME
,      ORGANIZATION_ID
,      DELETE_TYPE
,      ACTION_TYPE
,      DATE_LAST_SUBMITTED
,      DESCRIPTION
,      ENGINEERING_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DELETE_COMMON_BILL_FLAG
,      DELETE_ORG_TYPE
,      ORGANIZATION_HIERARCHY
FROM BOM.BOM_DELETE_GROUPS;

Dependencies

[top of page]

BOM.BOM_DELETE_GROUPS does not reference any database object

BOM.BOM_DELETE_GROUPS is referenced by following:

SchemaAPPS
SynonymBOM_DELETE_GROUPS