DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.EAM_MATERIALS_V

Object Details
Object Name: EAM_MATERIALS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEAM.EAM_MATERIALS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER
Yes Work Order identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
OPERATIONS_DEPT_ID NUMBER

Operations department identifier
OPERATIONS_SEQ_NUM NUMBER

Operation sequence number
OPERATION_DEPT_CODE VARCHAR2 (10) Yes Operation department code
CONCATENATED_SEGMENTS VARCHAR2 (40)
Item name
REQUIRED_QUANTITY NUMBER

Required quantity for the material
ITEM_COST NUMBER

Item cost of material
TOTAL_ITEM_COST NUMBER

Total item cost
Query Text

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


SELECT WIP_ENTITY_ID
,      ORGANIZATION_ID
,      OPERATIONS_DEPT_ID
,      OPERATIONS_SEQ_NUM
,      OPERATION_DEPT_CODE
,      CONCATENATED_SEGMENTS
,      REQUIRED_QUANTITY
,      ITEM_COST
,      TOTAL_ITEM_COST
FROM APPS.EAM_MATERIALS_V;

Dependencies

[top of page]

APPS.EAM_MATERIALS_V references the following:

SchemaAPPS
SynonymBOM_DEPARTMENTS
SynonymCST_EAM_WO_ESTIMATE_DETAILS
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.EAM_MATERIALS_V is not referenced by any database object