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.PMITS_OPERATION_ACTIVITIES_V

Object Details

Object Name:	PMITS_OPERATION_ACTIVITIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMITS_OPERATION_ACTIVITIES_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OPRN_LINE_ID	NUMBER	(15)	Yes	Operation Line ID
OPRN_ID	NUMBER	(15)	Yes	Operation ID
ACTIVITY	VARCHAR2	(16)	Yes	Activity
OFFSET_INTERVAL	NUMBER		Yes	Offset Interval
ACTIVITY_FACTOR	NUMBER		Yes	Activity Factor
DELETE_MARK	NUMBER	(5)	Yes	Delete Mark
TEXT_CODE	NUMBER	(10)		Text Code
ACTIVITY_DESC	VARCHAR2	(40)	Yes	Activity Description

Query Text

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


SELECT OPRN_LINE_ID
,      OPRN_ID
,      ACTIVITY
,      OFFSET_INTERVAL
,      ACTIVITY_FACTOR
,      DELETE_MARK
,      TEXT_CODE
,      ACTIVITY_DESC
FROM APPS.PMITS_OPERATION_ACTIVITIES_V;

Dependencies

[top of page]

APPS.PMITS_OPERATION_ACTIVITIES_V references the following:

APPS: FM_ACTV_MST; GMD_OPERATION_ACTIVITIES

APPS.PMITS_OPERATION_ACTIVITIES_V is not referenced by any database object