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.CST_MATERIAL_OVHD_RULES

Object Details

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

This table stores the rules that will be used by transactions that earn material overhead to determine if material overhead cost is to be absorbed or not. The rules are defined by organization, transaction type and item type.
If there are no rules defined, i.e., the table contains no rows, then the default behavior is adopted - material overhead cost is always absorbed. However, when rules are defined they are used to determine absorption of material overhead costs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_MATERIAL_OVHD_RULES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID TRANSACTION_TYPE ITEM_TYPE

Columns

Name	Datatype	Mandatory	Comments
RULE_ID	NUMBER	Yes	Rule Identifier
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
ORGANIZATION_ID	NUMBER	Yes	Organization Identifier
TRANSACTION_TYPE	NUMBER	Yes	Transaction Type Identifier - determines the transaction type for which the rules is defined.
SELECTION_CRITERIA	NUMBER		Not currently used
CATEGORY_ID	NUMBER		Not currently used
ITEM_FROM	NUMBER		Not currently used
ITEM_TO	NUMBER		Not currently used
ITEM_TYPE	NUMBER	Yes	Item type
SHIP_FROM_ORG	NUMBER		Not currently used
COST_TYPE_ID	NUMBER		Identifies the cost type identifier against which material overhead is earned.
EARN_MOH	NUMBER	Yes	Identifies if material overhead should be earned or not.

Query Text

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


SELECT RULE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      ORGANIZATION_ID
,      TRANSACTION_TYPE
,      SELECTION_CRITERIA
,      CATEGORY_ID
,      ITEM_FROM
,      ITEM_TO
,      ITEM_TYPE
,      SHIP_FROM_ORG
,      COST_TYPE_ID
,      EARN_MOH
FROM BOM.CST_MATERIAL_OVHD_RULES;

Dependencies

[top of page]

BOM.CST_MATERIAL_OVHD_RULES does not reference any database object

BOM.CST_MATERIAL_OVHD_RULES is referenced by following:

APPS: CST_MATERIAL_OVHD_RULES