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

Object Details

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

View Type

A Business Intelligence System view

This shows individual item components in a engineering or manufacturing
bill of material.

[View Source]

Columns

Name	Datatype	Length	Mandatory
START_EFFECTIVE_DATE	DATE		Yes
OPERATION_SEQUENCE_NUMBER	NUMBER		Yes
_KF:COMPONENT_ITEM_NAME	CHAR	(16)
_KF:BILL_ITEM_NAME	CHAR	(16)
ORGANIZATION_CODE	VARCHAR2	(3)
ORGANIZATION_NAME	VARCHAR2	(240)	Yes
ALTERNATE_BOM_CODE	VARCHAR2	(10)
ITEM_SEQUENCE_NUMBER	NUMBER
QUANTITY_PER_ASSEMBLY	NUMBER		Yes
PROJECTED_YIELD	NUMBER		Yes
CHANGE_NOTICE	VARCHAR2	(10)
COMMENTS	VARCHAR2	(240)
ECO_IMPLEMENTATION_DATE	DATE
PLANNING_PERCENT	NUMBER		Yes
MINIMUM_ALLOWED_QUANTITY	NUMBER
MAXIMUM_ALLOWED_QUANTITY	NUMBER
END_EFFECTIVE_DATE	DATE
SUPPLY_SUBINVENTORY	VARCHAR2	(10)
FROM_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)
TO_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)
OPERATION_OFFSET_IN_ROUTING	NUMBER
_KF:SUPPLY_LOCATOR_NAME	CHAR	(15)
_LA:INCLUDE_IN_COST_ROLLUP	CHAR	(60)
_LA:CHECK_ATP	CHAR	(47)
_LA:INCLUDE_ON_SHIP_DOCS	CHAR	(58)
_LA:MUTUALLY_EXCLUSIVE_OPT	CHAR	(64)
_LA:OPTIONAL	CHAR	(46)
_LA:QUANTITY_RELATED	CHAR	(54)
_LA:REQUIRED_FOR_REVENUE	CHAR	(58)
_LA:REQUIRED_TO_SHIP	CHAR	(54)
_LA:SHIPPING_ALLOWED	CHAR	(54)
_LA:SO_BASIS	CHAR	(46)
_LA:WIP_SUPPLY_TYPE	CHAR	(53)
_DF	CHAR	(35)
SUPPLY_LOCATOR_ID	NUMBER
ORGANIZATION_ID	NUMBER		Yes
ASSEMBLY_ITEM_ID	NUMBER
BILL_SEQUENCE_ID	NUMBER		Yes
COMPONENT_ITEM_ID	NUMBER
COMPONENT_SEQUENCE_ID	NUMBER		Yes
UPDATED_ON	DATE		Yes
UPDATED_BY	NUMBER		Yes
CREATED_ON	DATE		Yes
CREATED_BY	NUMBER		Yes

Query Text

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


SELECT START_EFFECTIVE_DATE
,      OPERATION_SEQUENCE_NUMBER
,      _KF:COMPONENT_ITEM_NAME
,      _KF:BILL_ITEM_NAME
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      ALTERNATE_BOM_CODE
,      ITEM_SEQUENCE_NUMBER
,      QUANTITY_PER_ASSEMBLY
,      PROJECTED_YIELD
,      CHANGE_NOTICE
,      COMMENTS
,      ECO_IMPLEMENTATION_DATE
,      PLANNING_PERCENT
,      MINIMUM_ALLOWED_QUANTITY
,      MAXIMUM_ALLOWED_QUANTITY
,      END_EFFECTIVE_DATE
,      SUPPLY_SUBINVENTORY
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      OPERATION_OFFSET_IN_ROUTING
,      _KF:SUPPLY_LOCATOR_NAME
,      _LA:INCLUDE_IN_COST_ROLLUP
,      _LA:CHECK_ATP
,      _LA:INCLUDE_ON_SHIP_DOCS
,      _LA:MUTUALLY_EXCLUSIVE_OPT
,      _LA:OPTIONAL
,      _LA:QUANTITY_RELATED
,      _LA:REQUIRED_FOR_REVENUE
,      _LA:REQUIRED_TO_SHIP
,      _LA:SHIPPING_ALLOWED
,      _LA:SO_BASIS
,      _LA:WIP_SUPPLY_TYPE
,      _DF
,      SUPPLY_LOCATOR_ID
,      ORGANIZATION_ID
,      ASSEMBLY_ITEM_ID
,      BILL_SEQUENCE_ID
,      COMPONENT_ITEM_ID
,      COMPONENT_SEQUENCE_ID
,      UPDATED_ON
,      UPDATED_BY
,      CREATED_ON
,      CREATED_BY
FROM APPS.BOMFV_BOM_COMPONENTS;

Dependencies

[top of page]

APPS.BOMFV_BOM_COMPONENTS references the following:

APPS: BOM_BILL_OF_MATERIALS; BOM_INVENTORY_COMPONENTS; FND_GLOBAL - show dependent code; HR_ALL_ORGANIZATION_UNITS; MTL_ITEM_LOCATIONS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_B

APPS.BOMFV_BOM_COMPONENTS is not referenced by any database object