[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EAM_WO_DIRECT_ITEMS_LITE_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  EAM.EAM_WO_DIRECT_ITEMS_LITE_V
|
| Subobject Name: | |
| Status: | VALID |
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.
| 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) |
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;
APPS
MFG_LOOKUPS
MTL_DEFAULT_CATEGORY_SETS
MTL_ITEM_CATEGORIES
MTL_SYSTEM_ITEMS_KFV
PO_DISTRIBUTIONS_ALL
PO_LINES_ALL
PO_REQUISITION_HEADERS_ALL
PO_REQUISITION_LINES_ALL
WIP_EAM_DIRECT_ITEMS
WIP_REQUIREMENT_OPERATIONS
APPS
EAM_DIRECT_ITEMS_RECS_LITE_V
EAM_OP_VALIDATE_PVT
- show dependent code
|
|
|
|