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: ABM.ABM_BOR_HIER

Object Details

Object Name:	ABM_BOR_HIER
Object Type:	TABLE
Owner:	ABM
Subobject Name:
Status:	VALID

Identifies a MODEL MATERIAL, MODEL ACTIVITY or MODEL COST OBJECT BILL OF RESOURCE to MODEL COST OBJECT BILL OF RESOURCE relationship (e.g., a MODEL RESOURCE used in the manufacture, development or attainment of a MODEL COST OBJECT).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: ABM_BOR_HIER_PK

M25_MODEL_ID
M18_BOR_TYPE_ID
O06_MASTER_LIST_SETS_ID
O09_TYPE_CODE
O09_RESOURCE_ID
M33_BOR_LINE_ID_CTR

Indexes

Index	Type	Uniqueness	Tablespace	Column
ABM_BOR_HIER_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	M25_MODEL_ID M18_BOR_TYPE_ID O06_MASTER_LIST_SETS_ID O09_TYPE_CODE O09_RESOURCE_ID M33_BOR_LINE_ID_CTR

Foreign Keys

Table		Foreign Table	Foreign Key Column
ABM_BOR_HIER		ABM_BORS	ABM_BOR_HIER M25_MODEL_ID ABM_BOR_HIER M18_BOR_TYPE_ID ABM_BOR_HIER O06_MASTER_LIST_SETS_ID ABM_BOR_HIER O09_TYPE_CODE ABM_BOR_HIER O09_RESOURCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
M25_MODEL_ID	VARCHAR2	(15)	Yes	Parent Node Model ID. User-defined relationship of master list components that describes a particular part of an organisation, such as a division, a plant, the corporation.
M18_BOR_TYPE_ID	VARCHAR2	(30)	Yes	Parent Node Bill Type Id. A Bill is a hierarchical list of resources that are needed to build a cost object. These include activities, materials and other cost objects.
O06_MASTER_LIST_SETS_ID	VARCHAR2	(15)	Yes	Parent Node Master List ID. Master List is a dictionary of valid components that can be shared across models.
O09_TYPE_CODE	VARCHAR2	(3)	Yes	Parent Node Resource Type Code
O09_RESOURCE_ID	VARCHAR2	(120)	Yes	Parent Node Resource ID
M33_BOR_LINE_ID_CTR	NUMBER		Yes	Bill line id counter.
M33_SEQ_NBR	NUMBER		Yes	Bill line sequence number.
M33_UNIT_CONSUMPTION_QUANT	NUMBER			Unit Consumption quantity. (Legacy column. No longer used in ABM11i).
M33_COST_OBJECT_REF_QUANT	NUMBER			Cost Object Reference Quantity. (Legacy column. No longer used in ABM11i).
M33_UNIT_YIELD_FACTOR_QUANT	NUMBER			Unit Yield Factor Quantity (Legacy column. No longer used in ABM11i).
ECO_NUMBER	VARCHAR2	(30)		Engineering Change Order Number.
BOM_LINE	VARCHAR2	(45)		Reference to Bill of Materials Line
EFFECTIVE_BEGIN_DATE	DATE		Yes	Effective Begin Date
EFFECTIVE_END_DATE	DATE		Yes	Effective End Date
MAINT_USER_ID	VARCHAR2	(11)		Legacy column. No longer used in ABM 11i.
MAINT_EFFECT_CODE	VARCHAR2	(1)		Legacy column. No longer used in ABM 11i.
MAINT_TIMESTAMP	DATE			Legacy column. No longer used in ABM 11i.
DFK_M25_MODEL_ID	VARCHAR2	(15)	Yes	Child Node Model ID.
DFK_M18_BOR_TYPE_ID	VARCHAR2	(30)		Child Node Bill Type ID
DFK_O06_MASTER_LIST_SETS_ID	VARCHAR2	(15)	Yes	Child Node Master List Set ID
DFK_O09_TYPE_CODE	VARCHAR2	(3)	Yes	Child Node Data Source Type Code.
DFK_O09_RESOURCE_ID	VARCHAR2	(120)	Yes	Child Node Resource ID
DFK_I01_DRIVER_SET_ID	VARCHAR2	(30)		Activity Rates Driver Set Attribute ID
DFK_I02_DRIVER_SET_ID	VARCHAR2	(30)		Activity Rates Driver Set Attribute Value.
DFK_M14_ACT_DRV_SET_BEGIN_DATE	DATE			Activity Rates Driver Set Begin Date.
VALUED_FLAG	VARCHAR2	(3)	Yes	Valued Flag Y or N
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

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


SELECT M25_MODEL_ID
,      M18_BOR_TYPE_ID
,      O06_MASTER_LIST_SETS_ID
,      O09_TYPE_CODE
,      O09_RESOURCE_ID
,      M33_BOR_LINE_ID_CTR
,      M33_SEQ_NBR
,      M33_UNIT_CONSUMPTION_QUANT
,      M33_COST_OBJECT_REF_QUANT
,      M33_UNIT_YIELD_FACTOR_QUANT
,      ECO_NUMBER
,      BOM_LINE
,      EFFECTIVE_BEGIN_DATE
,      EFFECTIVE_END_DATE
,      MAINT_USER_ID
,      MAINT_EFFECT_CODE
,      MAINT_TIMESTAMP
,      DFK_M25_MODEL_ID
,      DFK_M18_BOR_TYPE_ID
,      DFK_O06_MASTER_LIST_SETS_ID
,      DFK_O09_TYPE_CODE
,      DFK_O09_RESOURCE_ID
,      DFK_I01_DRIVER_SET_ID
,      DFK_I02_DRIVER_SET_ID
,      DFK_M14_ACT_DRV_SET_BEGIN_DATE
,      VALUED_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM ABM.ABM_BOR_HIER;

Dependencies

[top of page]

ABM.ABM_BOR_HIER does not reference any database object

ABM.ABM_BOR_HIER is not referenced by any database object