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_INVENTORY_COMPONENTS_ERV

Object Details

Object Name:	BOM_INVENTORY_COMPONENTS_ERV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.BOM_INVENTORY_COMPONENTS_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
OPERATION_SEQ_NUM	NUMBER		Yes	Sequence number of the operation
COMPONENT_ITEM_ID	NUMBER			COmponent item id
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
ITEM_NUM	NUMBER			Item number
COMPONENT_QUANTITY	NUMBER		Yes	Component quantity
COMPONENT_YIELD_FACTOR	NUMBER		Yes	Component yield factor
COMPONENT_REMARKS	VARCHAR2	(240)		Component remarks
EFFECTIVITY_DATE	DATE		Yes	Effective date
FROM_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		From end item unit number
TO_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		To end item unit number
CHANGE_NOTICE	VARCHAR2	(10)		Engineering change notice
IMPLEMENTATION_DATE	DATE			Implementation date
IMPL_CB	NUMBER
DISABLE_DATE	DATE			Disable date
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Flex structure defining columns
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
PLANNING_FACTOR	NUMBER		Yes	Planning factor
QUANTITY_RELATED	NUMBER		Yes	Related quantity
SO_BASIS	NUMBER			QUantity basis used by Oracle Order Mgmt to determine how many units of components to put on an order
OPTIONAL	NUMBER			indicating if quantity is optional in bill
MUTUALLY_EXCLUSIVE_OPTIONS	NUMBER			Flag indicating if one or more children of component can be picked up when taking an order
INCLUDE_IN_COST_ROLLUP	NUMBER		Yes	Flag indicating if component is to be used when rolling up cost
CHECK_ATP	NUMBER		Yes	Flag indicating if ATP check is required
SHIPPING_ALLOWED	NUMBER			Flag indicating if component is allowed to be shipped
REQUIRED_TO_SHIP	NUMBER			Flag indicating if component is required to be shipped
REQUIRED_FOR_REVENUE	NUMBER			Flag indicatinf if component s required for revenue
INCLUDE_ON_SHIP_DOCS	NUMBER			Flag indicating if component is required for shipping documents
INCLUDE_ON_BILL_DOCS	NUMBER			not used
LOW_QUANTITY	NUMBER			Minimum quantity allowed on an order
HIGH_QUANTITY	NUMBER			Maximum quantity allowed on an order
ACD_TYPE	NUMBER			ACD type
OLD_COMPONENT_SEQUENCE_ID	NUMBER			Sequnce id of original component record in ECO
COMPONENT_SEQUENCE_ID	NUMBER		Yes	Sequence id of the component
BILL_SEQUENCE_ID	NUMBER		Yes	Sequence id of the BILL
REQUEST_ID	NUMBER			Concurrent WHO columns
PROGRAM_APPLICATION_ID	NUMBER			Concurrent WHO columns
PROGRAM_ID	NUMBER			Concurrent WHO columns
PROGRAM_UPDATE_DATE	DATE			Concurrent WHO columns
WIP_SUPPLY_TYPE	NUMBER			Work in process supply type
SUPPLY_TYPE	VARCHAR2	(80)		Supply type
PICK_COMPONENTS	NUMBER			not used
SUPPLY_SUBINVENTORY	VARCHAR2	(10)		Supplu subinventory
SUPPLY_LOCATOR_ID	NUMBER			Supply locator type
SUPPLY_LOCATOR	CHAR	(1)		Supply locator
OPERATION_LEAD_TIME_PERCENT	NUMBER			Operation lead time percentage
REVISED_ITEM_SEQUENCE_ID	NUMBER			Revised item sequence id
COST_FACTOR	NUMBER			not used
BOM_ITEM_TYPE	NUMBER			BOM item type
PRIMARY_UOM_CODE	VARCHAR2	(3)		Primary unit of measure
DESCRIPTION	VARCHAR2	(240)		Description
ENG_ITEM_FLAG	VARCHAR2	(1)	Yes	Flag indicating if the item is an engineering item
INVENTORY_ITEM_STATUS_CODE	VARCHAR2	(10)	Yes	Status code of the item
SHIPPABLE_ITEM_FLAG	VARCHAR2	(1)	Yes	Flag indicating if the item is shippable
ITEM_LOCATOR_CONTROL	NUMBER			Item locator control
RESTRICT_LOCATORS_FLAG	NUMBER			Restrict locators flag
RESTRICT_SUBINVENTORIES_FLAG	VARCHAR2	(1)		Restrict subinventories flag
ITEM_TYPE	VARCHAR2	(80)		Item type
REPLENISH_TO_ORDER_FLAG	VARCHAR2	(1)	Yes	Replenish to order flag
ATP_COMPONENTS_FLAG	VARCHAR2	(1)	Yes	ATP components flag
PICK_COMPONENTS_FLAG	VARCHAR2	(1)	Yes	Pick components flag
INVENTORY_ASSET_FLAG	VARCHAR2	(1)	Yes	Inventory assets flag
ATP_FLAG	VARCHAR2	(1)	Yes	ATP flag
FORECAST_CONTROL	NUMBER			Forecast control
DISABLE_CB	NUMBER
ECO_FOR_PRODUCTION	NUMBER			Engineering change ordre for production
ENFORCE_INT_REQUIREMENTS	NUMBER			Enforce initial requirements
ENFORCE_INT_REQUIREMENTS_DESC	VARCHAR2	(80)		Enforce initial requirements description
AUTO_REQUEST_MATERIAL	VARCHAR2	(1)		Auto request material
EFFECTIVITY_CONTROL	NUMBER			Effectivity control
CURRENT_REVISION	VARCHAR2	(3)		Current revision
COMPONENT_ITEM_NAME	VARCHAR2	(40)		Component item name

Query Text

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


SELECT ROW_ID
,      OPERATION_SEQ_NUM
,      COMPONENT_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ITEM_NUM
,      COMPONENT_QUANTITY
,      COMPONENT_YIELD_FACTOR
,      COMPONENT_REMARKS
,      EFFECTIVITY_DATE
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      CHANGE_NOTICE
,      IMPLEMENTATION_DATE
,      IMPL_CB
,      DISABLE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PLANNING_FACTOR
,      QUANTITY_RELATED
,      SO_BASIS
,      OPTIONAL
,      MUTUALLY_EXCLUSIVE_OPTIONS
,      INCLUDE_IN_COST_ROLLUP
,      CHECK_ATP
,      SHIPPING_ALLOWED
,      REQUIRED_TO_SHIP
,      REQUIRED_FOR_REVENUE
,      INCLUDE_ON_SHIP_DOCS
,      INCLUDE_ON_BILL_DOCS
,      LOW_QUANTITY
,      HIGH_QUANTITY
,      ACD_TYPE
,      OLD_COMPONENT_SEQUENCE_ID
,      COMPONENT_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WIP_SUPPLY_TYPE
,      SUPPLY_TYPE
,      PICK_COMPONENTS
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      SUPPLY_LOCATOR
,      OPERATION_LEAD_TIME_PERCENT
,      REVISED_ITEM_SEQUENCE_ID
,      COST_FACTOR
,      BOM_ITEM_TYPE
,      PRIMARY_UOM_CODE
,      DESCRIPTION
,      ENG_ITEM_FLAG
,      INVENTORY_ITEM_STATUS_CODE
,      SHIPPABLE_ITEM_FLAG
,      ITEM_LOCATOR_CONTROL
,      RESTRICT_LOCATORS_FLAG
,      RESTRICT_SUBINVENTORIES_FLAG
,      ITEM_TYPE
,      REPLENISH_TO_ORDER_FLAG
,      ATP_COMPONENTS_FLAG
,      PICK_COMPONENTS_FLAG
,      INVENTORY_ASSET_FLAG
,      ATP_FLAG
,      FORECAST_CONTROL
,      DISABLE_CB
,      ECO_FOR_PRODUCTION
,      ENFORCE_INT_REQUIREMENTS
,      ENFORCE_INT_REQUIREMENTS_DESC
,      AUTO_REQUEST_MATERIAL
,      EFFECTIVITY_CONTROL
,      CURRENT_REVISION
,      COMPONENT_ITEM_NAME
FROM APPS.BOM_INVENTORY_COMPONENTS_ERV;

Dependencies

[top of page]

APPS.BOM_INVENTORY_COMPONENTS_ERV references the following:

APPS: BOM_BILL_OF_MATERIALS; BOM_INVENTORY_COMPONENTS; FND_COMMON_LOOKUPS; FND_GLOBAL - show dependent code; MFG_LOOKUPS; MTL_ITEM_LOCATIONS_KFV; MTL_ITEM_REVISIONS; MTL_ITEM_REVISIONS_B; MTL_SYSTEM_ITEMS_B_KFV; MTL_SYSTEM_ITEMS_TL

APPS.BOM_INVENTORY_COMPONENTS_ERV is not referenced by any database object