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]

VIEW: APPS.BOM_BILL_OF_MATERIALS_ERV

Object Details

Object Name:	BOM_BILL_OF_MATERIALS_ERV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.BOM_BILL_OF_MATERIALS_ERV
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row identifier
ASSEMBLY_ITEM_ID	NUMBER			Inventory item identifier of manufactured assembly
UOM	VARCHAR2	(3)		Unit of measure
PICK_COMPONENTS_FLAG	VARCHAR2	(1)	Yes	Pick components flag
REPLENISH_TO_ORDER_FLAG	VARCHAR2	(1)	Yes	Replenish to order
BOM_ITEM_TYPE	NUMBER		Yes	BOM item type
BASE_ITEM_ID	NUMBER			Base item identifier
ASSEMBLY_ITEM_NO	VARCHAR2	(40)		Item number of manufactured assembly
ASSEMBLY_ITEM_DESCRIPTION	VARCHAR2	(240)		Item description of manufactured assembly
ASSEMBLY_ITEM_REVISION	VARCHAR2	(3)		Item revision of manufactured assembly
ITEM_CATALOG_GROUP_ID	NUMBER			Item catalog group identifier
ITEM_CATALOG_GROUP	VARCHAR2	(4000)		Item catalog group
ATP_COMPONENTS_FLAG	VARCHAR2	(1)	Yes	ATP component flag
WIP_SUPPLY_TYPE	NUMBER			Work in process supply type
ENG_ITEM_FLAG	VARCHAR2	(1)	Yes	Engineering item flag
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
ORGANIZATION_CODE	VARCHAR2	(3)		Organization code
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Organization name
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	(10)		Alternate BOM designator
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
COMMON_ASSEMBLY_ITEM_ID	NUMBER			Assembly item identifier of common bill
COMMON_ASSEMBLY_ITEM_NO	VARCHAR2	(40)		Assembly item number of common bill
COMMON_ASSEMBLY_DESCRIPTION	VARCHAR2	(240)		Assembly item description of common bill
SPECIFIC_ASSEMBLY_COMMENT	VARCHAR2	(240)		Comment on specific assembly
PENDING_FROM_ECN	VARCHAR2	(10)		Pending from ECN
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ASSEMBLY_TYPE	NUMBER		Yes	Assembly type
COMMON_BILL_SEQUENCE_ID	NUMBER		Yes	Sequence id for common bill
BILL_SEQUENCE_ID	NUMBER		Yes	Bill sequence id
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
COMMON_ORGANIZATION_ID	NUMBER			Organization identifier for common bill
COMMON_ORGANIZATION_CODE	VARCHAR2	(3)		organization code for common bill
COMMON_ORGANIZATION_NAME	VARCHAR2	(240)		Organization name for common bill
NEXT_EXPLODE_DATE	DATE			Next bill explosion date
ITEM_TYPE	VARCHAR2	(80)		Item type
BOM_ENABLED_FLAG	VARCHAR2	(1)	Yes	BOM enabled flag
EAM_ITEM_TYPE	NUMBER			EAM item type
EAM_ITEM_TYPE_VALUE	VARCHAR2	(80)		EAM item type value

Query Text

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


SELECT ROW_ID
,      ASSEMBLY_ITEM_ID
,      UOM
,      PICK_COMPONENTS_FLAG
,      REPLENISH_TO_ORDER_FLAG
,      BOM_ITEM_TYPE
,      BASE_ITEM_ID
,      ASSEMBLY_ITEM_NO
,      ASSEMBLY_ITEM_DESCRIPTION
,      ASSEMBLY_ITEM_REVISION
,      ITEM_CATALOG_GROUP_ID
,      ITEM_CATALOG_GROUP
,      ATP_COMPONENTS_FLAG
,      WIP_SUPPLY_TYPE
,      ENG_ITEM_FLAG
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      ALTERNATE_BOM_DESIGNATOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      COMMON_ASSEMBLY_ITEM_ID
,      COMMON_ASSEMBLY_ITEM_NO
,      COMMON_ASSEMBLY_DESCRIPTION
,      SPECIFIC_ASSEMBLY_COMMENT
,      PENDING_FROM_ECN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ASSEMBLY_TYPE
,      COMMON_BILL_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      COMMON_ORGANIZATION_ID
,      COMMON_ORGANIZATION_CODE
,      COMMON_ORGANIZATION_NAME
,      NEXT_EXPLODE_DATE
,      ITEM_TYPE
,      BOM_ENABLED_FLAG
,      EAM_ITEM_TYPE
,      EAM_ITEM_TYPE_VALUE
FROM APPS.BOM_BILL_OF_MATERIALS_ERV;

Dependencies

[top of page]

APPS.BOM_BILL_OF_MATERIALS_ERV references the following:

APPS: BOM_BILL_OF_MATERIALS; FND_COMMON_LOOKUPS; FND_FLEX_SERVER - show dependent code; FND_GLOBAL - show dependent code; HR_ALL_ORGANIZATION_UNITS_TL; MFG_LOOKUPS; MTL_ITEM_CATALOG_GROUPS; MTL_ITEM_REVISIONS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_VL

APPS.BOM_BILL_OF_MATERIALS_ERV is not referenced by any database object