VIEW: APPS.BOM_STD_SUB_OP_RESOURCES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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