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

Object Details

Object Name:	EAM_CFR_MATERIALS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EAM.EAM_CFR_MATERIALS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER		Yes	Item identifier
CONCATENATED_SEGMENTS	VARCHAR2	(40)		Item concatenated segments
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description
PRIMARY_UOM_CODE	VARCHAR2	(3)		Primary Unit of measure code
INVENTORY_ASSET_FLAG	VARCHAR2	(1)	Yes	Flag indicating item is an inventory asset
LOCATION_CONTROL_CODE	NUMBER			Stock Locator Control Code
RESTRICT_LOCATORS_CODE	NUMBER			Locators restrictions type
RESTRICT_SUBINVENTORIES_CODE	NUMBER			Subinventory restrictions type
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier
WIP_ENTITY_ID	NUMBER		Yes	WIP job or repetitive assembly Identifier
OPERATION_SEQ_NUM	NUMBER		Yes	Operation sequence number within a routing
DEPARTMENT_ID	NUMBER			Department Identifier
DEPARTMENT_CODE	VARCHAR2	(10)		Department Code
WIP_SUPPLY_TYPE	NUMBER		Yes	Method of material consumption within WIP
WIP_SUPPLY_DISP	VARCHAR2	(80)	Yes	Description for method of material consumption within WIP
DATE_REQUIRED	DATE			Operation requirement start date
REQUIRED_QUANTITY	NUMBER		Yes	Part quantity required
QUANTITY_ISSUED	NUMBER			Part quantity issued
QUANTITY_OPEN	NUMBER			Open quantity
QUANTITY_PER_ASSEMBLY	NUMBER		Yes	Part usage quantity
COMMENTS	VARCHAR2	(240)		Component comment descriptive text
SUPPLY_SUBINVENTORY	VARCHAR2	(10)		Subinventory used to supply component to WIP
SUPPLY_LOCATOR_ID	NUMBER			Locator used to supply component to WIP
MRP_NET_FLAG	NUMBER		Yes	Determines whether or not MRP should consider the component requirement in its netting process
MRP_NET_DISP	VARCHAR2	(80)	Yes	Description for MRP Net Flag
MPS_REQUIRED_QUANTITY	NUMBER			Quantity used by MPS relief process
MPS_DATE_REQUIRED	DATE			Date used by MPS relief process
QUANTITY_ALLOCATED	NUMBER			Quantity allocated
AUTO_REQUEST_MATERIAL	VARCHAR2	(1)		auto request material, used by EAM
RELEASED_QUANTITY	NUMBER			This column stores material requirement at released time
COMPONENT_SEQUENCE_ID	NUMBER			Bill of materials component sequence Identifier
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Standard DFF Column
ATTRIBUTE1	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE2	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE3	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE4	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE5	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE6	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE7	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE8	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE9	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE10	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE11	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE12	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE13	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE14	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE15	VARCHAR2	(150)		Standard DFF Column

Query Text

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


SELECT INVENTORY_ITEM_ID
,      CONCATENATED_SEGMENTS
,      ITEM_DESCRIPTION
,      PRIMARY_UOM_CODE
,      INVENTORY_ASSET_FLAG
,      LOCATION_CONTROL_CODE
,      RESTRICT_LOCATORS_CODE
,      RESTRICT_SUBINVENTORIES_CODE
,      ORGANIZATION_ID
,      WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      WIP_SUPPLY_TYPE
,      WIP_SUPPLY_DISP
,      DATE_REQUIRED
,      REQUIRED_QUANTITY
,      QUANTITY_ISSUED
,      QUANTITY_OPEN
,      QUANTITY_PER_ASSEMBLY
,      COMMENTS
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      MRP_NET_FLAG
,      MRP_NET_DISP
,      MPS_REQUIRED_QUANTITY
,      MPS_DATE_REQUIRED
,      QUANTITY_ALLOCATED
,      AUTO_REQUEST_MATERIAL
,      RELEASED_QUANTITY
,      COMPONENT_SEQUENCE_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.EAM_CFR_MATERIALS_V;

Dependencies

[top of page]

APPS.EAM_CFR_MATERIALS_V references the following:

APPS: BOM_DEPARTMENTS; EAM_MATERIAL_ALLOCQTY_PKG - show dependent code; MFG_LOOKUPS; MTL_SYSTEM_ITEMS_KFV; WIP_REQUIREMENT_OPERATIONS

APPS.EAM_CFR_MATERIALS_V is not referenced by any database object