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_V

Object Details

Object Name:	BOM_INVENTORY_COMPONENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.BOM_INVENTORY_COMPONENTS_V
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)		Record unqiue identifier
OPERATION_SEQ_NUM	NUMBER		Yes	Operation sequence number
COMPONENT_ITEM_ID	NUMBER			Component item 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
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
ITEM_NUM	NUMBER			Item sequence within bill of material structure
BASIS_TYPE	NUMBER
COMPONENT_QUANTITY	NUMBER		Yes	Quantity of component in bill of material
COMPONENT_YIELD_FACTOR	NUMBER		Yes	Factor used to multiply component quantity with to obtain component quantity
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 order number
IMPLEMENTATION_DATE	DATE			Date on which engineering change order was implemented
IMPL_CB	NUMBER			Implementation flag
DISABLE_DATE	DATE			Disable date
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
PLANNING_FACTOR	NUMBER		Yes	Factor used to multiply component quantity with to obtain planning quantity
QUANTITY_RELATED	NUMBER		Yes	Identifier to indicate if this component has quantity related reference designators
SO_BASIS	NUMBER			Quantity basis used by Oracle Order Entry to determine how many units of component to put on an order
OPTIONAL	NUMBER			Flag indicating if component is optional in bill
MUTUALLY_EXCLUSIVE_OPTIONS	NUMBER			Flag indicating if one or more children of component can be picked when taking an order
INCLUDE_IN_COST_ROLLUP	NUMBER		Yes	Flag indicating if this component is to be used when rolling up costs
CHECK_ATP	NUMBER		Yes	Flag indicating if ATP check is required
SHIPPING_ALLOWED	NUMBER			Flag indicating if component is allowed to ship
REQUIRED_TO_SHIP	NUMBER			Flag indicating if component is required to ship
REQUIRED_FOR_REVENUE	NUMBER			Flag indicating if component is required for revenue
INCLUDE_ON_SHIP_DOCS	NUMBER			Flag indicating if component is displayed on shipping documents
INCLUDE_ON_BILL_DOCS	NUMBER			(not currently used)
LOW_QUANTITY	NUMBER			Minimum quantity allowed on an order
HIGH_QUANTITY	NUMBER			Maximum quantity allowed on an order
ACD_TYPE	NUMBER			Add, change or disable code for component on an engineering change order
OLD_COMPONENT_SEQUENCE_ID	NUMBER			Identifier of original component row an ECO affects
COMPONENT_SEQUENCE_ID	NUMBER		Yes	Component unique identifier
BILL_SEQUENCE_ID	NUMBER		Yes	Bill of material unique identifier
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
WIP_SUPPLY_TYPE	NUMBER			WIP supply type code
SUPPLY_TYPE	VARCHAR2	(80)		Supply type code
PICK_COMPONENTS	NUMBER			(not currently used)
SUPPLY_SUBINVENTORY	VARCHAR2	(10)		Supply subinventory
SUPPLY_LOCATOR_ID	NUMBER			Supply locator identifier
OPERATION_LEAD_TIME_PERCENT	NUMBER			Operation offset from first operation in routing
REVISED_ITEM_SEQUENCE_ID	NUMBER			Engineering change order revised item identifier
COST_FACTOR	NUMBER			(not currently used)
BOM_ITEM_TYPE	NUMBER			Type of item
PRIMARY_UOM_CODE	VARCHAR2	(3)		Primary unit of measure code
DESCRIPTION	VARCHAR2	(240)		Item description
ENG_ITEM_FLAG	VARCHAR2	(1)	Yes	Flag indicating engineering item
INVENTORY_ITEM_STATUS_CODE	VARCHAR2	(10)	Yes	Material status code
SHIPPABLE_ITEM_FLAG	VARCHAR2	(1)	Yes	Flag indicating shippable item
ITEM_LOCATOR_CONTROL	NUMBER			Stock locator control code
RESTRICT_LOCATORS_FLAG	NUMBER			Locators restrictions type
RESTRICT_SUBINVENTORIES_FLAG	VARCHAR2	(1)		Subinventories restrictions type
ITEM_TYPE	VARCHAR2	(80)		QuickCode meaning
REPLENISH_TO_ORDER_FLAG	VARCHAR2	(1)	Yes	Assemble to Order flag
ATP_COMPONENTS_FLAG	VARCHAR2	(1)	Yes	Flag indicating whether item may have components requiring ATP check
PICK_COMPONENTS_FLAG	VARCHAR2	(1)	Yes	Flag indicating all shippable components of should be picked
INVENTORY_ASSET_FLAG	VARCHAR2	(1)	Yes	Flag indicating item is an inventory asset
ATP_FLAG	VARCHAR2	(1)	Yes	Flag indicating ATP must be checked when item is ordered
FORECAST_CONTROL	NUMBER			Type of forecast control for ATO
DISABLE_CB	NUMBER
ECO_FOR_PRODUCTION	NUMBER
ENFORCE_INT_REQUIREMENTS	NUMBER			Enforce Integer Requirements
ENFORCE_INT_REQUIREMENTS_DESC	VARCHAR2	(80)		Enforce Integer Requirements Description
FROM_BILL_REVISION_ID	NUMBER			From Bill Revision Id
TO_BILL_REVISION_ID	NUMBER			To Bill Revision Id
AUTO_REQUEST_MATERIAL	VARCHAR2	(1)
SUGGESTED_VENDOR_NAME	VARCHAR2	(240)
VENDOR_ID	NUMBER
UNIT_PRICE	NUMBER
COMMON_COMPONENT_SEQUENCE_ID	NUMBER			Common Component Sequence Id

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
,      BASIS_TYPE
,      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
,      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
,      FROM_BILL_REVISION_ID
,      TO_BILL_REVISION_ID
,      AUTO_REQUEST_MATERIAL
,      SUGGESTED_VENDOR_NAME
,      VENDOR_ID
,      UNIT_PRICE
,      COMMON_COMPONENT_SEQUENCE_ID
FROM APPS.BOM_INVENTORY_COMPONENTS_V;

Dependencies

[top of page]

APPS.BOM_INVENTORY_COMPONENTS_V references the following:

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

APPS.BOM_INVENTORY_COMPONENTS_V is referenced by following:

APPS: CSD_REPAIR_ESTIMATE_PVT - show dependent code