DBA Data[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