Product: | GMD - Process Manufacturing Product Development |
---|---|
Description: | Operation detail view |
Implementation/DBA Data: | APPS.FM_OPRN_DTL_VW1 |
SELECT OA.OPRN_ID
, OA.ACTIVITY
, GOR.RESOURCES
, GOR.OPRN_LINE_ID
, GOR.PROCESS_QTY
, NULL
, NULL
, GOR.PRIM_RSRC_IND
, GOR.SCALE_TYPE
, GOR.COST_ANALYSIS_CODE
, GOR.COST_CMPNTCLS_ID
, GOR.RESOURCE_COUNT
, GOR.RESOURCE_USAGE
, GOR.USAGE_UM
, GOR.OFFSET_INTERVAL
, OA.TEXT_CODE
, OA.LAST_UPDATED_BY
, OA.CREATED_BY
, OA.LAST_UPDATE_DATE
, OA.CREATION_DATE
, OA.LAST_UPDATE_LOGIN
, OA.ATTRIBUTE1
, OA.ATTRIBUTE2
, OA.ATTRIBUTE3
, OA.ATTRIBUTE4
, OA.ATTRIBUTE5
, OA.ATTRIBUTE6
, OA.ATTRIBUTE7
, OA.ATTRIBUTE8
, OA.ATTRIBUTE9
, OA.ATTRIBUTE10
, OA.ATTRIBUTE11
, OA.ATTRIBUTE12
, OA.ATTRIBUTE13
, OA.ATTRIBUTE14
, OA.ATTRIBUTE15
, OA.ATTRIBUTE16
, OA.ATTRIBUTE17
, OA.ATTRIBUTE18
, OA.ATTRIBUTE19
, OA.ATTRIBUTE20
, OA.ATTRIBUTE21
, OA.ATTRIBUTE22
, OA.ATTRIBUTE23
, OA.ATTRIBUTE24
, OA.ATTRIBUTE25
, OA.ATTRIBUTE26
, OA.ATTRIBUTE27
, OA.ATTRIBUTE28
, OA.ATTRIBUTE29
, OA.ATTRIBUTE30
, OA.ATTRIBUTE_CATEGORY
FROM GMD_OPERATION_ACTIVITIES OA
, GMD_OPERATION_RESOURCES GOR
WHERE OA.OPRN_LINE_ID(+) = GOR.OPRN_LINE_ID