VIEW: APPS.BOM_OPERATION_RESOURCES_V

Source

View Text - Preformatted

SELECT BOR.ROWID ROW_ID , BOR.OPERATION_SEQUENCE_ID , BOR.RESOURCE_SEQ_NUM , BR.RESOURCE_CODE , BR.UNIT_OF_MEASURE UOM , BOR.RESOURCE_ID , CA.ACTIVITY , BOR.ACTIVITY_ID , BOR.STANDARD_RATE_FLAG , BOR.ASSIGNED_UNITS , BOR.USAGE_RATE_OR_AMOUNT , BOR.USAGE_RATE_OR_AMOUNT_INVERSE , BOR.BASIS_TYPE , BOR.SCHEDULE_FLAG , BDR.AVAILABLE_24_HOURS_FLAG , BOR.LAST_UPDATE_DATE , BOR.LAST_UPDATED_BY , BOR.CREATION_DATE , BOR.CREATED_BY , BOR.LAST_UPDATE_LOGIN , BOR.RESOURCE_OFFSET_PERCENT , BOR.AUTOCHARGE_TYPE , BOR.ATTRIBUTE_CATEGORY , BOR.ATTRIBUTE1 , BOR.ATTRIBUTE2 , BOR.ATTRIBUTE3 , BOR.ATTRIBUTE4 , BOR.ATTRIBUTE5 , BOR.ATTRIBUTE6 , BOR.ATTRIBUTE7 , BOR.ATTRIBUTE8 , BOR.ATTRIBUTE9 , BOR.ATTRIBUTE10 , BOR.ATTRIBUTE11 , BOR.ATTRIBUTE12 , BOR.ATTRIBUTE13 , BOR.ATTRIBUTE14 , BOR.ATTRIBUTE15 , BOR.REQUEST_ID , BOR.PROGRAM_APPLICATION_ID , BOR.PROGRAM_ID , BOR.PROGRAM_UPDATE_DATE , BOR.SCHEDULE_SEQ_NUM , BOR.SUBSTITUTE_GROUP_NUM , nvl( BOR.PRINCIPLE_FLAG,2) , BOR.SETUP_ID , BOR.CHANGE_NOTICE , BOR.ACD_TYPE , BOR.ORIGINAL_SYSTEM_REFERENCE , BST.SETUP_CODE FROM BOM_OPERATION_RESOURCES BOR , BOM_OPERATION_SEQUENCES BOS , BOM_RESOURCES BR , BOM_DEPARTMENT_RESOURCES BDR , CST_ACTIVITIES CA , BOM_SETUP_TYPES BST WHERE BR.RESOURCE_ID = BOR.RESOURCE_ID AND BDR.DEPARTMENT_ID = BOS.DEPARTMENT_ID AND BDR.RESOURCE_ID = BOR.RESOURCE_ID AND BOR.OPERATION_SEQUENCE_ID = BOS.OPERATION_SEQUENCE_ID AND NVL(BOS.OPERATION_TYPE, 1) = 1 AND BOR.ACTIVITY_ID = CA.ACTIVITY_ID (+) AND BOR.SETUP_ID = BST.SETUP_ID(+) UNION SELECT BOR.ROWID ROW_ID , BOR.OPERATION_SEQUENCE_ID , BOR.RESOURCE_SEQ_NUM , BR.RESOURCE_CODE , BR.UNIT_OF_MEASURE UOM , BOR.RESOURCE_ID , CA.ACTIVITY , BOR.ACTIVITY_ID , BOR.STANDARD_RATE_FLAG, BOR.ASSIGNED_UNITS , BOR.USAGE_RATE_OR_AMOUNT , BOR.USAGE_RATE_OR_AMOUNT_INVERSE , BOR.BASIS_TYPE , BOR.SCHEDULE_FLAG , BDR.AVAILABLE_24_HOURS_FLAG , BOR.LAST_UPDATE_DATE , BOR.LAST_UPDATED_BY, BOR.CREATION_DATE , BOR.CREATED_BY , BOR.LAST_UPDATE_LOGIN , BOR.RESOURCE_OFFSET_PERCENT , BOR.AUTOCHARGE_TYPE , BOR.ATTRIBUTE_CATEGORY , BOR.ATTRIBUTE1 , BOR.ATTRIBUTE2 , BOR.ATTRIBUTE3 , BOR.ATTRIBUTE4 , BOR.ATTRIBUTE5 , BOR.ATTRIBUTE6 , BOR.ATTRIBUTE7 , BOR.ATTRIBUTE8 , BOR.ATTRIBUTE9 , BOR.ATTRIBUTE10 , BOR.ATTRIBUTE11 , BOR.ATTRIBUTE12 , BOR.ATTRIBUTE13 , BOR.ATTRIBUTE14 , BOR.ATTRIBUTE15 , BOR.REQUEST_ID , BOR.PROGRAM_APPLICATION_ID , BOR.PROGRAM_ID , BOR.PROGRAM_UPDATE_DATE , BOR.SCHEDULE_SEQ_NUM , BOR.SUBSTITUTE_GROUP_NUM , nvl( BOR.PRINCIPLE_FLAG,2) , BOR.SETUP_ID , BOR.CHANGE_NOTICE , BOR.ACD_TYPE , BOR.ORIGINAL_SYSTEM_REFERENCE , BST.SETUP_CODE FROM BOM_OPERATION_RESOURCES BOR , ENG_REVISED_OPERATIONS ERO , BOM_RESOURCES BR , BOM_DEPARTMENT_RESOURCES BDR , CST_ACTIVITIES CA , BOM_SETUP_TYPES BST WHERE BR.RESOURCE_ID = BOR.RESOURCE_ID AND BDR.DEPARTMENT_ID =ERO.DEPARTMENT_ID AND BDR.RESOURCE_ID = BOR.RESOURCE_ID AND BOR.OPERATION_SEQUENCE_ID = ERO.OPERATION_SEQUENCE_ID AND BOR.ACD_TYPE IS NOT NULL AND NVL(ERO.OPERATION_TYPE, 1) = 1 AND BOR.ACTIVITY_ID = CA.ACTIVITY_ID (+) AND BOR.SETUP_ID = BST.SETUP_ID(+)

View Text - HTML Formatted

SELECT BOR.ROWID ROW_ID
, BOR.OPERATION_SEQUENCE_ID
, BOR.RESOURCE_SEQ_NUM
, BR.RESOURCE_CODE
, BR.UNIT_OF_MEASURE UOM
, BOR.RESOURCE_ID
, CA.ACTIVITY
, BOR.ACTIVITY_ID
, BOR.STANDARD_RATE_FLAG
, BOR.ASSIGNED_UNITS
, BOR.USAGE_RATE_OR_AMOUNT
, BOR.USAGE_RATE_OR_AMOUNT_INVERSE
, BOR.BASIS_TYPE
, BOR.SCHEDULE_FLAG
, BDR.AVAILABLE_24_HOURS_FLAG
, BOR.LAST_UPDATE_DATE
, BOR.LAST_UPDATED_BY
, BOR.CREATION_DATE
, BOR.CREATED_BY
, BOR.LAST_UPDATE_LOGIN
, BOR.RESOURCE_OFFSET_PERCENT
, BOR.AUTOCHARGE_TYPE
, BOR.ATTRIBUTE_CATEGORY
, BOR.ATTRIBUTE1
, BOR.ATTRIBUTE2
, BOR.ATTRIBUTE3
, BOR.ATTRIBUTE4
, BOR.ATTRIBUTE5
, BOR.ATTRIBUTE6
, BOR.ATTRIBUTE7
, BOR.ATTRIBUTE8
, BOR.ATTRIBUTE9
, BOR.ATTRIBUTE10
, BOR.ATTRIBUTE11
, BOR.ATTRIBUTE12
, BOR.ATTRIBUTE13
, BOR.ATTRIBUTE14
, BOR.ATTRIBUTE15
, BOR.REQUEST_ID
, BOR.PROGRAM_APPLICATION_ID
, BOR.PROGRAM_ID
, BOR.PROGRAM_UPDATE_DATE
, BOR.SCHEDULE_SEQ_NUM
, BOR.SUBSTITUTE_GROUP_NUM
, NVL( BOR.PRINCIPLE_FLAG
, 2)
, BOR.SETUP_ID
, BOR.CHANGE_NOTICE
, BOR.ACD_TYPE
, BOR.ORIGINAL_SYSTEM_REFERENCE
, BST.SETUP_CODE
FROM BOM_OPERATION_RESOURCES BOR
, BOM_OPERATION_SEQUENCES BOS
, BOM_RESOURCES BR
, BOM_DEPARTMENT_RESOURCES BDR
, CST_ACTIVITIES CA
, BOM_SETUP_TYPES BST
WHERE BR.RESOURCE_ID = BOR.RESOURCE_ID
AND BDR.DEPARTMENT_ID = BOS.DEPARTMENT_ID
AND BDR.RESOURCE_ID = BOR.RESOURCE_ID
AND BOR.OPERATION_SEQUENCE_ID = BOS.OPERATION_SEQUENCE_ID
AND NVL(BOS.OPERATION_TYPE
, 1) = 1
AND BOR.ACTIVITY_ID = CA.ACTIVITY_ID (+)
AND BOR.SETUP_ID = BST.SETUP_ID(+) UNION SELECT BOR.ROWID ROW_ID
, BOR.OPERATION_SEQUENCE_ID
, BOR.RESOURCE_SEQ_NUM
, BR.RESOURCE_CODE
, BR.UNIT_OF_MEASURE UOM
, BOR.RESOURCE_ID
, CA.ACTIVITY
, BOR.ACTIVITY_ID
, BOR.STANDARD_RATE_FLAG
, BOR.ASSIGNED_UNITS
, BOR.USAGE_RATE_OR_AMOUNT
, BOR.USAGE_RATE_OR_AMOUNT_INVERSE
, BOR.BASIS_TYPE
, BOR.SCHEDULE_FLAG
, BDR.AVAILABLE_24_HOURS_FLAG
, BOR.LAST_UPDATE_DATE
, BOR.LAST_UPDATED_BY
, BOR.CREATION_DATE
, BOR.CREATED_BY
, BOR.LAST_UPDATE_LOGIN
, BOR.RESOURCE_OFFSET_PERCENT
, BOR.AUTOCHARGE_TYPE
, BOR.ATTRIBUTE_CATEGORY
, BOR.ATTRIBUTE1
, BOR.ATTRIBUTE2
, BOR.ATTRIBUTE3
, BOR.ATTRIBUTE4
, BOR.ATTRIBUTE5
, BOR.ATTRIBUTE6
, BOR.ATTRIBUTE7
, BOR.ATTRIBUTE8
, BOR.ATTRIBUTE9
, BOR.ATTRIBUTE10
, BOR.ATTRIBUTE11
, BOR.ATTRIBUTE12
, BOR.ATTRIBUTE13
, BOR.ATTRIBUTE14
, BOR.ATTRIBUTE15
, BOR.REQUEST_ID
, BOR.PROGRAM_APPLICATION_ID
, BOR.PROGRAM_ID
, BOR.PROGRAM_UPDATE_DATE
, BOR.SCHEDULE_SEQ_NUM
, BOR.SUBSTITUTE_GROUP_NUM
, NVL( BOR.PRINCIPLE_FLAG
, 2)
, BOR.SETUP_ID
, BOR.CHANGE_NOTICE
, BOR.ACD_TYPE
, BOR.ORIGINAL_SYSTEM_REFERENCE
, BST.SETUP_CODE
FROM BOM_OPERATION_RESOURCES BOR
, ENG_REVISED_OPERATIONS ERO
, BOM_RESOURCES BR
, BOM_DEPARTMENT_RESOURCES BDR
, CST_ACTIVITIES CA
, BOM_SETUP_TYPES BST
WHERE BR.RESOURCE_ID = BOR.RESOURCE_ID
AND BDR.DEPARTMENT_ID =ERO.DEPARTMENT_ID
AND BDR.RESOURCE_ID = BOR.RESOURCE_ID
AND BOR.OPERATION_SEQUENCE_ID = ERO.OPERATION_SEQUENCE_ID
AND BOR.ACD_TYPE IS NOT NULL
AND NVL(ERO.OPERATION_TYPE
, 1) = 1
AND BOR.ACTIVITY_ID = CA.ACTIVITY_ID (+)
AND BOR.SETUP_ID = BST.SETUP_ID(+)