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
FND Design Data: ViewEAM.EAM_WO_DIRECT_ITEMS_LITE_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

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
RQL_QUANTITY_CANCELLED NUMBER

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
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
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
,      RQL_QUANTITY_CANCELLED
,      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
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
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