[Home] [Help]
VIEW: APPS.PMITS_OPERATION_ACTIVITIES_V
Source
View Text - Preformatted
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
View Text - HTML Formatted
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