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


VIEW: APPS.EAM_WO_DIRECT_ITEMS_LITE_V

Object Details
Object Name: EAM_WO_DIRECT_ITEMS_LITE_V
Object Type: VIEW
Owner: APPS
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

Wip Entity Id
OPERATION_SEQ_NUM NUMBER

operation sequence number
ORGANIZATION_ID NUMBER

organization id
ITEM_ID NUMBER

Inventory Item id (for non-stockable items)
DIRECT_ITEM_SEQUENCE_ID NUMBER

Direct_item_sequence_id
ITEM_NAME VARCHAR2 (40)
Item name
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
UOM_CODE VARCHAR2 (3)
Unit of Measure code
UNIT_PRICE NUMBER

Unit price
AUTO_REQUEST_MATERIAL VARCHAR2 (1)
Auto Request Material Flag
NEED_BY_DATE DATE

Required Date
CATEGORY_ID NUMBER

Category Id
QUANTITY_REQUIRED NUMBER

Required Quantity
RQL_QUANTITY_ORDERED NUMBER

Quantity Ordered on Requisition
QUANTITY_ORDERED NUMBER

Quantity Ordered
QUANTITY_RECEIVED NUMBER

Received quantity
PO_QUANTITY_ORDERED NUMBER

Quantity Ordered on PO
PO_QUANTITY_CANCELLED NUMBER

Quantity cancelled on PO
SUPPLIER_NAME VARCHAR2 (240)
Supplier name
DIRECT_ITEM_TYPE VARCHAR2 (80)
Direct Item Type
DIRECT_ITEM_TYPE_ID NUMBER

Direct Item type ID (Internal number)
DEPARTMENT_ID NUMBER

Department Id
EFFECTIVITY_CONTROL NUMBER

Effectivity control
EAM_ITEM_TYPE NUMBER

EAM Item Type
ORDER_TYPE_LOOKUP_CODE VARCHAR2 (25)
Order Type of Req or PO (Amount, Quantity etc)
AMOUNT NUMBER

Amount (If Line Type is Amount based)
AMOUNT_DELIVERED NUMBER

Amount Delivered (If line type is amount based)
RQL_AMOUNT_ORDERED NUMBER

Amount Ordered on Requisition
PO_AMOUNT_ORDERED NUMBER

Amount ordered on PO
Query Text

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


SELECT WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      ORGANIZATION_ID
,      ITEM_ID
,      DIRECT_ITEM_SEQUENCE_ID
,      ITEM_NAME
,      ITEM_DESCRIPTION
,      UOM_CODE
,      UNIT_PRICE
,      AUTO_REQUEST_MATERIAL
,      NEED_BY_DATE
,      CATEGORY_ID
,      QUANTITY_REQUIRED
,      RQL_QUANTITY_ORDERED
,      QUANTITY_ORDERED
,      QUANTITY_RECEIVED
,      PO_QUANTITY_ORDERED
,      PO_QUANTITY_CANCELLED
,      SUPPLIER_NAME
,      DIRECT_ITEM_TYPE
,      DIRECT_ITEM_TYPE_ID
,      DEPARTMENT_ID
,      EFFECTIVITY_CONTROL
,      EAM_ITEM_TYPE
,      ORDER_TYPE_LOOKUP_CODE
,      AMOUNT
,      AMOUNT_DELIVERED
,      RQL_AMOUNT_ORDERED
,      PO_AMOUNT_ORDERED
FROM APPS.EAM_WO_DIRECT_ITEMS_LITE_V;

Dependencies

[top of page]

APPS.EAM_WO_DIRECT_ITEMS_LITE_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMTL_DEFAULT_CATEGORY_SETS
SynonymMTL_ITEM_CATEGORIES
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_LINES_ALL
SynonymPO_REQUISITION_HEADERS_ALL
SynonymPO_REQUISITION_LINES_ALL
SynonymWIP_EAM_DIRECT_ITEMS
SynonymWIP_REQUIREMENT_OPERATIONS
APPS.EAM_WO_DIRECT_ITEMS_LITE_V is referenced by following:

SchemaAPPS
ViewEAM_DIRECT_ITEMS_RECS_LITE_V
Package BodyEAM_OP_VALIDATE_PVT - show dependent code