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

VIEW: APPS.CSD_MOST_COMM_MTL_USED_V

Object Details
Object Name: CSD_MOST_COMM_MTL_USED_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSD.CSD_MOST_COMM_MTL_USED_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


View used in the Most Common Material Used bin.


[View Source]

Columns
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.
Query Text

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;

Dependencies

[top of page]

APPS.CSD_MOST_COMM_MTL_USED_V references the following:

SchemaAPPS
TableCSD_RO_PER_ITEM_MV
TableCSD_WIP_MTL_USED_MV

APPS.CSD_MOST_COMM_MTL_USED_V is not referenced by any database object