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.

[Home] [Help]

View: PMITS_OPERATION_ACTIVITIES_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	GMD Operation Activities View
Implementation/DBA Data:	APPS.PMITS_OPERATION_ACTIVITIES_V

View Text

SELECT OA.OPRN_LINE_ID
, OA.OPRN_ID
, OA.ACTIVITY
, OA.OFFSET_INTERVAL
, OA.ACTIVITY_FACTOR
, OA.DELETE_MARK
, OA.TEXT_CODE
, AM.ACTIVITY_DESC
FROM GMD_OPERATION_ACTIVITIES OA
, FM_ACTV_MST AM
WHERE OA.ACTIVITY = AM.ACTIVITY

Columns

Name
OPRN_LINE_ID
OPRN_ID
ACTIVITY
OFFSET_INTERVAL
ACTIVITY_FACTOR
DELETE_MARK
TEXT_CODE
ACTIVITY_DESC