VIEW: APPS.BOM_STD_OP_RESOURCES_V

Source

View Text - Preformatted

SELECT BSO.OPERATION_TYPE , BSOR.ROWID ROW_ID , BSOR.STANDARD_OPERATION_ID , BSOR.RESOURCE_ID , BR.RESOURCE_CODE RESOURCE_CODE , BR.UNIT_OF_MEASURE UNIT_OF_MEASURE , BSOR.ACTIVITY_ID , CA.ACTIVITY ACTIVITY , BSOR.LAST_UPDATE_DATE , BSOR.LAST_UPDATED_BY , BSOR.CREATION_DATE , BSOR.CREATED_BY , BSOR.LAST_UPDATE_LOGIN , BSOR.RESOURCE_SEQ_NUM , BSOR.USAGE_RATE_OR_AMOUNT , BSOR.USAGE_RATE_OR_AMOUNT_INVERSE , BSOR.BASIS_TYPE , BSOR.AUTOCHARGE_TYPE , BSOR.STANDARD_RATE_FLAG , BSOR.ASSIGNED_UNITS , BSOR.SCHEDULE_FLAG , BDR.AVAILABLE_24_HOURS_FLAG AVAILABLE_24_HOURS_FLAG , BSOR.ATTRIBUTE_CATEGORY , BSOR.ATTRIBUTE1 , BSOR.ATTRIBUTE2 , BSOR.ATTRIBUTE3 , BSOR.ATTRIBUTE4 , BSOR.ATTRIBUTE5 , BSOR.ATTRIBUTE6 , BSOR.ATTRIBUTE7 , BSOR.ATTRIBUTE8 , BSOR.ATTRIBUTE9 , BSOR.ATTRIBUTE10 , BSOR.ATTRIBUTE11 , BSOR.ATTRIBUTE12 , BSOR.ATTRIBUTE13 , BSOR.ATTRIBUTE14 , BSOR.ATTRIBUTE15 , BSOR.REQUEST_ID , BSOR.PROGRAM_APPLICATION_ID , BSOR.PROGRAM_ID , BSOR.PROGRAM_UPDATE_DATE , BSOR.SUBSTITUTE_GROUP_NUM , BSOR.SCHEDULE_SEQ_NUM , BSOR.PRINCIPLE_FLAG FROM BOM_STD_OP_RESOURCES BSOR , BOM_RESOURCES BR , BOM_STANDARD_OPERATIONS BSO , BOM_DEPARTMENT_RESOURCES BDR , CST_ACTIVITIES CA WHERE BSOR.RESOURCE_ID = BR.RESOURCE_ID AND BDR.DEPARTMENT_ID = BSO.DEPARTMENT_ID AND BDR.RESOURCE_ID = BSOR.RESOURCE_ID AND BSOR.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID AND NVL(BSO.OPERATION_TYPE,1)=1 AND BSOR.ACTIVITY_ID = CA.ACTIVITY_ID(+)

View Text - HTML Formatted

SELECT BSO.OPERATION_TYPE
, BSOR.ROWID ROW_ID
, BSOR.STANDARD_OPERATION_ID
, BSOR.RESOURCE_ID
, BR.RESOURCE_CODE RESOURCE_CODE
, BR.UNIT_OF_MEASURE UNIT_OF_MEASURE
, BSOR.ACTIVITY_ID
, CA.ACTIVITY ACTIVITY
, BSOR.LAST_UPDATE_DATE
, BSOR.LAST_UPDATED_BY
, BSOR.CREATION_DATE
, BSOR.CREATED_BY
, BSOR.LAST_UPDATE_LOGIN
, BSOR.RESOURCE_SEQ_NUM
, BSOR.USAGE_RATE_OR_AMOUNT
, BSOR.USAGE_RATE_OR_AMOUNT_INVERSE
, BSOR.BASIS_TYPE
, BSOR.AUTOCHARGE_TYPE
, BSOR.STANDARD_RATE_FLAG
, BSOR.ASSIGNED_UNITS
, BSOR.SCHEDULE_FLAG
, BDR.AVAILABLE_24_HOURS_FLAG AVAILABLE_24_HOURS_FLAG
, BSOR.ATTRIBUTE_CATEGORY
, BSOR.ATTRIBUTE1
, BSOR.ATTRIBUTE2
, BSOR.ATTRIBUTE3
, BSOR.ATTRIBUTE4
, BSOR.ATTRIBUTE5
, BSOR.ATTRIBUTE6
, BSOR.ATTRIBUTE7
, BSOR.ATTRIBUTE8
, BSOR.ATTRIBUTE9
, BSOR.ATTRIBUTE10
, BSOR.ATTRIBUTE11
, BSOR.ATTRIBUTE12
, BSOR.ATTRIBUTE13
, BSOR.ATTRIBUTE14
, BSOR.ATTRIBUTE15
, BSOR.REQUEST_ID
, BSOR.PROGRAM_APPLICATION_ID
, BSOR.PROGRAM_ID
, BSOR.PROGRAM_UPDATE_DATE
, BSOR.SUBSTITUTE_GROUP_NUM
, BSOR.SCHEDULE_SEQ_NUM
, BSOR.PRINCIPLE_FLAG
FROM BOM_STD_OP_RESOURCES BSOR
, BOM_RESOURCES BR
, BOM_STANDARD_OPERATIONS BSO
, BOM_DEPARTMENT_RESOURCES BDR
, CST_ACTIVITIES CA
WHERE BSOR.RESOURCE_ID = BR.RESOURCE_ID
AND BDR.DEPARTMENT_ID = BSO.DEPARTMENT_ID
AND BDR.RESOURCE_ID = BSOR.RESOURCE_ID
AND BSOR.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID
AND NVL(BSO.OPERATION_TYPE
, 1)=1
AND BSOR.ACTIVITY_ID = CA.ACTIVITY_ID(+)