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_EAM_DEPT_APPROVERS

Object Details

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

This table stores notification hierarchy associated with BOM departments. Users who has responsibility associated with a BOM department will receive work flow notifications.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BOM_EAM_DEPT_APPROVERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DEPT_ID ORGANIZATION_ID RESPONSIBILITY_APPLICATION_ID RESPONSIBILITY_ID

Columns

Name	Datatype	Mandatory	Comments
DEPT_ID	NUMBER	Yes	Internal identifier of the department
ORGANIZATION_ID	NUMBER	Yes	Manufacturing Organization
LAST_UPDATE_DATE	DATE	Yes	Standard WHO Columns
LAST_UPDATED_BY	NUMBER	Yes	Standard WHO Columns
CREATION_DATE	DATE	Yes	Standard WHO Columns
CREATED_BY	NUMBER	Yes	Standard WHO Columns
LAST_UPDATE_LOGIN	NUMBER		Standard WHO Columns
RESPONSIBILITY_APPLICATION_ID	NUMBER	Yes	Internal identifier of the appliation with which the responsibility is tied to
RESPONSIBILITY_ID	NUMBER	Yes	Internal identifier of the responsibility associated with a department
PRIMARY_APPROVER_ID	NUMBER		Primary approver id

Query Text

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


SELECT DEPT_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RESPONSIBILITY_APPLICATION_ID
,      RESPONSIBILITY_ID
,      PRIMARY_APPROVER_ID
FROM BOM.BOM_EAM_DEPT_APPROVERS;

Dependencies

[top of page]

BOM.BOM_EAM_DEPT_APPROVERS does not reference any database object

BOM.BOM_EAM_DEPT_APPROVERS is referenced by following:

APPS: BOM_EAM_DEPT_APPROVERS