eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.CSD_DC_FREQUENCY_V

Object Details

Object Name:	CSD_DC_FREQUENCY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSD.CSD_DC_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 Diagnostic Code in the Evaluation page.

[View Source]

Columns

Name	Datatype	Mandatory	Comments
RO_INVENTORY_ITEM_ID	NUMBER	Yes	Repair Order item idetifier.
TOTAL_RO_COUNT	NUMBER		Total number of repair orders.
DIAGNOSTIC_CODE_ID	NUMBER	Yes	Diagnostic Code identifier.
DIAGNOSTIC_ITEM_ID	NUMBER		Diagnostic item identifier.
DC_ONLY_RO_COUNT	NUMBER		Count of repair orders having the same Diagnostic 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
,      DIAGNOSTIC_CODE_ID
,      DIAGNOSTIC_ITEM_ID
,      DC_ONLY_RO_COUNT
,      FREQUENCY
FROM APPS.CSD_DC_FREQUENCY_V;

Dependencies

[top of page]

APPS.CSD_DC_FREQUENCY_V references the following:

APPS: CSD_DC_FREQ_SUM_MV

APPS.CSD_DC_FREQUENCY_V is not referenced by any database object