[Home] [Help] [Dependency Information]
Object Name: | CSD_MOST_COMM_MTL_USED_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSD.CSD_MOST_COMM_MTL_USED_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
View used in the Most Common Material Used bin.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RO_INVENTORY_ITEM_ID | NUMBER | Yes | Repair Order item identifier | |
PART_ONLY_RO_COUNT | NUMBER | Count of repair orders in which the parts was used. | ||
TOTAL_RO_COUNT | NUMBER | Total count of repair orders. | ||
FREQUENCY | NUMBER | Frequency of occurance. | ||
PART_INVENTORY_ITEM_ID | NUMBER | Yes | Part inventory identifier. | |
PART_PRIMARY_UOM_CODE | VARCHAR2 | (3) | Yes | Primary UOM for the part. |
TOTAL_PART_QUANTITY | NUMBER | Total quantity of part consumed. | ||
PART_ONLY_RO_QUANTITY | NUMBER | Total of repair orders quantities where the part was consumed. | ||
AVG_CONSUMPTION | NUMBER | TOTAL_PART_QUANTITY divided by PART_ONLY_RO_QUANTITY. |
Cut, paste (and edit) the following text to query this object:
SELECT RO_INVENTORY_ITEM_ID
, PART_ONLY_RO_COUNT
, TOTAL_RO_COUNT
, FREQUENCY
, PART_INVENTORY_ITEM_ID
, PART_PRIMARY_UOM_CODE
, TOTAL_PART_QUANTITY
, PART_ONLY_RO_QUANTITY
, AVG_CONSUMPTION
FROM APPS.CSD_MOST_COMM_MTL_USED_V;
APPS.CSD_MOST_COMM_MTL_USED_V is not referenced by any database object
|
|
|