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
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:

SchemaAPPS
SynonymBOM_DEPARTMENTS
PL/SQL PackageEAM_MATERIAL_ALLOCQTY_PKG - show dependent code
ViewMFG_LOOKUPS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymWIP_REQUIREMENT_OPERATIONS

APPS.EAM_CFR_MATERIALS_V is not referenced by any database object