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_ECO_REVISED_COMPONENTS

Object Details

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

View Type

A Business Intelligence System view

This shows a component on an ECO which is either being added, deleted or
undergoing a revision change.

[View Source]

Columns

Name	Datatype	Length	Mandatory
START_EFFECTIVE_DATE	DATE		Yes
OPERATION_SEQUNECE_NUMBER	NUMBER		Yes
ORGANIZATION_NAME	VARCHAR2	(240)	Yes
ORGANIZATION_CODE	VARCHAR2	(3)
ALTERNATE_BOM_CODE	VARCHAR2	(10)
_KF:COMPONENT_ITEM_NAME	CHAR	(16)
_KF:BILL_ITEM_NAME	CHAR	(16)
ITEM_SEQUNECE_NUMBER	NUMBER
QUANTITY_PER_ASSEMBLY	NUMBER		Yes
PROJECTED_YIELD	NUMBER		Yes
COMMENTS	VARCHAR2	(240)
CHANGE_NOTICE	VARCHAR2	(10)
IMPLEMENTATION_DATE	DATE
END_EFFECTIVE_DATE	DATE
FROM_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)
TO_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)
PLANNING_FACTOR	NUMBER		Yes
MINIMUM_ALLOWED_QUANTITY	NUMBER
MAXIMUM_ALLOWED_QUANTITY	NUMBER
OPERATION_OFFSET_IN_ROUTING	NUMBER
SUPPLY_SUBINVENTORY	VARCHAR2	(10)
_LA:BOM_ITEM_TYPE	CHAR	(55)
_LA:INCLUDE_IN_COST_ROLLUP	CHAR	(61)
_LA:CHECK_ATP	CHAR	(48)
_LA:INCLUDE_ON_SHIP_DOCS	CHAR	(59)
_LA:MUTUALLY_EXCLUSIVE_OPT	CHAR	(65)
_LA:OPTIONAL	CHAR	(47)
_LA:QUANTITY_RELATED	CHAR	(55)
_LA:REQUIRED_FOR_REVENUE	CHAR	(59)
_LA:REQUIRED_TO_SHIP	CHAR	(55)
_LA:SHIPPING_ALLOWED	CHAR	(55)
_LA:SO_BASIS	CHAR	(49)
_LA:WIP_SUPPLY_TYPE	CHAR	(54)
_LA:ACD_TYPE	CHAR	(47)
_KF:REVISED_ITEM_NAME	CHAR	(16)
_KF:SUPPLY_LOCATOR_NAME	CHAR	(15)
_DF	CHAR	(36)
COMPONENT_SEQUENCE_ID	NUMBER		Yes
COMPONENT_ITEM_ID	NUMBER
OLD_COMPONENT_SEQUENCE_ID	NUMBER
SUPPLY_LOCATOR_ID	NUMBER		Yes
BILL_SEQUENCE_ID	NUMBER
REVISED_ITEM_SEQUENCE_ID	NUMBER
ASSEMBLY_ITEM_ID	NUMBER
ORGANIZATION_ID	NUMBER		Yes
CREATED_ON	DATE		Yes
CREATED_BY	NUMBER		Yes
UPDATED_ON	DATE		Yes
UPDATED_BY	NUMBER		Yes

Query Text

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


SELECT START_EFFECTIVE_DATE
,      OPERATION_SEQUNECE_NUMBER
,      ORGANIZATION_NAME
,      ORGANIZATION_CODE
,      ALTERNATE_BOM_CODE
,      _KF:COMPONENT_ITEM_NAME
,      _KF:BILL_ITEM_NAME
,      ITEM_SEQUNECE_NUMBER
,      QUANTITY_PER_ASSEMBLY
,      PROJECTED_YIELD
,      COMMENTS
,      CHANGE_NOTICE
,      IMPLEMENTATION_DATE
,      END_EFFECTIVE_DATE
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      PLANNING_FACTOR
,      MINIMUM_ALLOWED_QUANTITY
,      MAXIMUM_ALLOWED_QUANTITY
,      OPERATION_OFFSET_IN_ROUTING
,      SUPPLY_SUBINVENTORY
,      _LA:BOM_ITEM_TYPE
,      _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
,      _LA:ACD_TYPE
,      _KF:REVISED_ITEM_NAME
,      _KF:SUPPLY_LOCATOR_NAME
,      _DF
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_ITEM_ID
,      OLD_COMPONENT_SEQUENCE_ID
,      SUPPLY_LOCATOR_ID
,      BILL_SEQUENCE_ID
,      REVISED_ITEM_SEQUENCE_ID
,      ASSEMBLY_ITEM_ID
,      ORGANIZATION_ID
,      CREATED_ON
,      CREATED_BY
,      UPDATED_ON
,      UPDATED_BY
FROM APPS.BOMFV_ECO_REVISED_COMPONENTS;

Dependencies

[top of page]

APPS.BOMFV_ECO_REVISED_COMPONENTS references the following:

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

APPS.BOMFV_ECO_REVISED_COMPONENTS is not referenced by any database object