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

VIEW: APPS.CSD_MOST_COMM_RES_USED_V

Object Details
Object Name: CSD_MOST_COMM_RES_USED_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSD.CSD_MOST_COMM_RES_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 Resource Transacted bin.


[View Source]

Columns
Name Datatype Length Mandatory Comments
RO_INVENTORY_ITEM_ID NUMBER
Yes Repair Order item identifier
RES_ONLY_RO_COUNT NUMBER

Count of repair orders in which the resource was used.
TOTAL_RO_COUNT NUMBER

Total count of repair orders.
FREQUENCY NUMBER

Frequency of occurance.
RESOURCE_ID NUMBER
Yes Resource identifier.
RES_PRIMARY_UOM_CODE VARCHAR2 (3) Yes Primary UOM for the resource.
TOTAL_RES_QUANTITY NUMBER

Total quantity of resource consumed.
RES_ONLY_RO_QUANTITY NUMBER

Total of repair orders quantities where the resource was consumed.
AVG_CONSUMPTION NUMBER

TOTAL_RES_QUANTITY divided by RES_ONLY_RO_QUANTITY.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RO_INVENTORY_ITEM_ID
,      RES_ONLY_RO_COUNT
,      TOTAL_RO_COUNT
,      FREQUENCY
,      RESOURCE_ID
,      RES_PRIMARY_UOM_CODE
,      TOTAL_RES_QUANTITY
,      RES_ONLY_RO_QUANTITY
,      AVG_CONSUMPTION
FROM APPS.CSD_MOST_COMM_RES_USED_V;

Dependencies

[top of page]

APPS.CSD_MOST_COMM_RES_USED_V references the following:

SchemaAPPS
TableCSD_RO_PER_ITEM_MV
TableCSD_WIP_RES_USED_MV

APPS.CSD_MOST_COMM_RES_USED_V is not referenced by any database object