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

VIEW: APPS.CSD_SC_FREQUENCY_V

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

View Type

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


View used for the FREQUENCY column for Service Code in the Evaluation page.


[View Source]

Columns
Name Datatype Length Mandatory Comments
RO_INVENTORY_ITEM_ID NUMBER
Yes Repair item identifier.
TOTAL_RO_COUNT NUMBER

Total number of repair orders.
SERVICE_CODE_ID NUMBER
Yes Service Code identifier.
SERVICE_ITEM_ID NUMBER

Service item identifier.
SC_ONLY_RO_COUNT NUMBER

Count of repair orders having the same Service Code.
FREQUENCY NUMBER

Frequency.
Query Text

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


SELECT RO_INVENTORY_ITEM_ID
,      TOTAL_RO_COUNT
,      SERVICE_CODE_ID
,      SERVICE_ITEM_ID
,      SC_ONLY_RO_COUNT
,      FREQUENCY
FROM APPS.CSD_SC_FREQUENCY_V;

Dependencies

[top of page]

APPS.CSD_SC_FREQUENCY_V references the following:

SchemaAPPS
TableCSD_SC_FREQ_SUM_MV

APPS.CSD_SC_FREQUENCY_V is not referenced by any database object