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

Object Details

Object Name:	OKX_INV_COMPONENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKX.OKX_INV_COMPONENTS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Displays information about bills of material components.

[View Source]

Columns

Name	Datatype	Mandatory	Comments
COMPONENT_SEQUENCE_ID	NUMBER	Yes	Component unique identifier
BILL_SEQUENCE_ID	NUMBER	Yes	Bill of material unique identifier
COMPONENT_QUANTITY	NUMBER	Yes	Quantity of component in bill of material
COMPONENT_ITEM_ID	NUMBER		Component item identifier
EFFECTIVITY_DATE	DATE	Yes	Effective date
DISABLE_DATE	DATE		Disable date

Query Text

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


SELECT COMPONENT_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      COMPONENT_QUANTITY
,      COMPONENT_ITEM_ID
,      EFFECTIVITY_DATE
,      DISABLE_DATE
FROM APPS.OKX_INV_COMPONENTS_V;

Dependencies

[top of page]

APPS.OKX_INV_COMPONENTS_V references the following:

APPS: BOM_INVENTORY_COMPONENTS

APPS.OKX_INV_COMPONENTS_V is not referenced by any database object