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

VIEW: APPS.EAM_DIRECT_ITEMS_V

Object Details
Object Name: EAM_DIRECT_ITEMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEAM.EAM_DIRECT_ITEMS_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 Wip entity id
ORGANIZATION_ID NUMBER
Yes Organization id
OPERATIONS_DEPT_ID NUMBER

Operations department identifier
OPERATIONS_SEQ_NUM NUMBER

Operation sequence number
OPERATION_DEPT_CODE VARCHAR2 (10) Yes Department code
ITEM_DESCRIPTION VARCHAR2 (240)
Direct item description
ITEM_COST NUMBER

Cost of direct item
REQUIRED_QUANTITY NUMBER

Required quantity
REQUISITION_NUMBER VARCHAR2 (20)
Requisition number
PO_NUMBER VARCHAR2 (20)
Purchase order number
TOTAL_DIRECT_COST NUMBER
Yes Total direct item cost
ITEM_NAME VARCHAR2 (40)
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
,      ITEM_DESCRIPTION
,      ITEM_COST
,      REQUIRED_QUANTITY
,      REQUISITION_NUMBER
,      PO_NUMBER
,      TOTAL_DIRECT_COST
,      ITEM_NAME
FROM APPS.EAM_DIRECT_ITEMS_V;

Dependencies

[top of page]

APPS.EAM_DIRECT_ITEMS_V references the following:

SchemaAPPS
SynonymBOM_DEPARTMENTS
SynonymCST_EAM_WO_ESTIMATE_DETAILS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymPO_HEADERS_ALL
SynonymPO_REQUISITION_HEADERS_ALL

APPS.EAM_DIRECT_ITEMS_V is not referenced by any database object