VIEW: APPS.FM_OPRN_DTL_VW1

Source

View Text - Preformatted

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

View Text - HTML Formatted

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