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: GMD.FM_IBOM_HDR

Object Details

Object Name:	FM_IBOM_HDR
Object Type:	TABLE
Owner:	GMD
FND Design Data:	GMD.FM_IBOM_HDR
Subobject Name:
Status:	VALID

Header table used for Indented Bill Of Materials report. Includes information relative to entire formula.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FM_IBOM_HDR_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TOP_FORMULA_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TOP_FORMULA_ID	NUMBER	(10)	Yes	Surrogate key to fm_form_mst for top level formula being exploded
ITEM_ID	NUMBER	(10)		Surrogate key used to reference ic_item_mst for product number
SCALE_PERCENT	NUMBER		Yes	Percentage used to scale formula up or down
FORMULA_USE	NUMBER	(1)	Yes	The purpose for which the formula/routing can be used. 0=Prod, 1=MRP, 2=Costing, 3=MSDS.
EFFECTIVITY_DATE	DATE		Yes	Date used to select for selection of appropriate effectivity record
FORMULA_QTY	NUMBER		Yes	Quantity from formula line
REPORT_QTY	NUMBER		Yes	Quantity for which the report is run - Quantity for top level formula
REPORT_UOM	VARCHAR2	(4)	Yes	Unit of measure in which report_qty is expressed
USE_INACTIVE_FLAG	NUMBER	(1)		0 = Don't use inactive flag; 1 = Use inactive flag
MAX_EXPLODE_LEVELS	NUMBER	(2)	Yes	Maximum level that formula can be exploded out to.
EXPLODED_BY	NUMBER	(15)	Yes	Name of person who ran the formula explosion
EXPLODED_DATE	DATE		Yes	Date formula was exploded
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
STATUS_CODE	VARCHAR2	(30)		Stores the formulae statuses
ORGN_CODE	VARCHAR2	(4)		Organization code for the IBOM report
VALIDITY_ORGANIZATION_TYPE	NUMBER	(1)		Column indicates the validity level of the Organization for the IBOM report
ORGANIZATION_ID	NUMBER	(15)		This is the inv organization ID
INVENTORY_ITEM_ID	NUMBER	(15)		This is the inv item id
DISPLAY_QTY	NUMBER	(5)		To indicate whether to display the qty or not
EXPLODE_IND	NUMBER	(5)		To indicate explode all ingredients or phantom ingredients only
SCALE_ALLOWED	NUMBER	(5)		To indicate whether scaling is allowed

Query Text

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


SELECT TOP_FORMULA_ID
,      ITEM_ID
,      SCALE_PERCENT
,      FORMULA_USE
,      EFFECTIVITY_DATE
,      FORMULA_QTY
,      REPORT_QTY
,      REPORT_UOM
,      USE_INACTIVE_FLAG
,      MAX_EXPLODE_LEVELS
,      EXPLODED_BY
,      EXPLODED_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      STATUS_CODE
,      ORGN_CODE
,      VALIDITY_ORGANIZATION_TYPE
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      DISPLAY_QTY
,      EXPLODE_IND
,      SCALE_ALLOWED
FROM GMD.FM_IBOM_HDR;

Dependencies

[top of page]

GMD.FM_IBOM_HDR does not reference any database object

GMD.FM_IBOM_HDR is referenced by following:

APPS: FM_IBOM_HDR