[Home] [Help] [Dependency Information]
Object Name: | EAM_WORK_ORDER_DIRECT_ITEMS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EAM.EAM_WORK_ORDER_DIRECT_ITEMS_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 | Work order number | ||
OPERATION_SEQ_NUM | NUMBER | Operation sequence number | ||
ORGANIZATION_ID | NUMBER | Organization ID | ||
ITEM_ID | NUMBER | Inventory item id | ||
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 | Need by date | ||
CATEGORY_ID | NUMBER | Category id | ||
QUANTITY_REQUIRED | NUMBER | Quantity ordered in the requisition | ||
RQL_QUANTITY_ORDERED | NUMBER | Quantity ordered in requisition | ||
RQL_QUANTITY_CANCELLED | NUMBER | Cancelled Quantity | ||
QUANTITY_ORDERED | NUMBER | Quantity ordered in the purchase order | ||
QUANTITY_RECEIVED | NUMBER | Quantity received for a purchase order | ||
PO_QUANTITY_ORDERED | NUMBER | Actual quantity ordered as recorded in purchase order distributions | ||
PO_QUANTITY_CANCELLED | NUMBER | Quantity canceled as recorded in the purchase order distributions | ||
VENDOR_ID | NUMBER | Vendor id | ||
SUPPLIER_NAME | VARCHAR2 | (240) | Name of the supplier | |
DIRECT_ITEM_TYPE | VARCHAR2 | (80) | Type of direct item being represented | |
DIRECT_ITEM_TYPE_ID | NUMBER | Type ID of direct item being represented | ||
SUGGESTED_VENDOR_SITE | VARCHAR2 | (15) | Suggested vendor site name for the direct item | |
SUGGESTED_VENDOR_SITE_ID | NUMBER | Suggested vendor site ID for the direct item | ||
SUGGESTED_VENDOR_CONTACT | VARCHAR2 | (80) | NULL Suggested vendor contact for the direct item | |
SUGGESTED_VENDOR_CONTACT_ID | NUMBER | Suggested vendor contact ID for the direct item | ||
SUGGESTED_VENDOR_PHONE | VARCHAR2 | (40) | Suggested vendor phone number for the direct item | |
SUGGESTED_VENDOR_ITEM_NUM | VARCHAR2 | (25) | Suggested vendor item number for the direct item | |
DEPARTMENT_ID | NUMBER | The department ID of the operation | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Standard flexfield column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Standard flexfield column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Standard flexfield column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Standard flexfield column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Standard flexfield column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Standard flexfield column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Standard flexfield column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Standard flexfield column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Standard flexfield column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Standard flexfield column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Standard flexfield column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Standard flexfield column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Standard flexfield column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Standard flexfield column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Standard flexfield column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Standard flexfield column | |
EFFECTIVITY_CONTROL | NUMBER | Effectivity Control of the item | ||
EAM_ITEM_TYPE | NUMBER | EAM Item Type | ||
ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | order type of PO/Req line | |
AMOUNT | NUMBER | amount of Req/PO when order type is Amount | ||
AMOUNT_DELIVERED | NUMBER | Amount Received | ||
RQL_AMOUNT_ORDERED | NUMBER | Amount on Requistion Line | ||
PO_AMOUNT_ORDERED | NUMBER | Amount on PO Line |
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
, VENDOR_ID
, SUPPLIER_NAME
, DIRECT_ITEM_TYPE
, DIRECT_ITEM_TYPE_ID
, SUGGESTED_VENDOR_SITE
, SUGGESTED_VENDOR_SITE_ID
, SUGGESTED_VENDOR_CONTACT
, SUGGESTED_VENDOR_CONTACT_ID
, SUGGESTED_VENDOR_PHONE
, SUGGESTED_VENDOR_ITEM_NUM
, DEPARTMENT_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, EFFECTIVITY_CONTROL
, EAM_ITEM_TYPE
, ORDER_TYPE_LOOKUP_CODE
, AMOUNT
, AMOUNT_DELIVERED
, RQL_AMOUNT_ORDERED
, PO_AMOUNT_ORDERED
FROM APPS.EAM_WORK_ORDER_DIRECT_ITEMS_V;
|
|
|