VIEW: APPS.AHL_RT_OPER_RESOURCES_V

Source

View Text - Preformatted

SELECT ARO.RT_OPER_RESOURCE_ID, ARO.OBJECT_VERSION_NUMBER, ARO.LAST_UPDATE_DATE, ARO.LAST_UPDATED_BY, ARO.CREATION_DATE, ARO.CREATED_BY, ARO.LAST_UPDATE_LOGIN, ARO.ASSOCIATION_TYPE_CODE, ARO.OBJECT_ID, ARO.ASO_RESOURCE_ID, ASO.NAME, ASO.DESCRIPTION, ASO.RESOURCE_TYPE_ID, ASO.RESOURCE_TYPE, ARO.COST_BASIS_ID, CB.MEANING, ARO.SCHEDULED_TYPE_ID, ST.MEANING, ARO.ACTIVITY_ID, CST.ACTIVITY, ARO.AUTOCHARGE_TYPE_ID, ACT.MEANING, ARO.STANDARD_RATE_FLAG, SR.MEANING, ARO.QUANTITY, ARO.DURATION, ARO.SCHEDULE_SEQ, ARO.ATTRIBUTE_CATEGORY, ARO.ATTRIBUTE1, ARO.ATTRIBUTE2, ARO.ATTRIBUTE3, ARO.ATTRIBUTE4, ARO.ATTRIBUTE5, ARO.ATTRIBUTE6, ARO.ATTRIBUTE7, ARO.ATTRIBUTE8, ARO.ATTRIBUTE9, ARO.ATTRIBUTE10, ARO.ATTRIBUTE11, ARO.ATTRIBUTE12, ARO.ATTRIBUTE13, ARO.ATTRIBUTE14, ARO.ATTRIBUTE15 FROM AHL_RT_OPER_RESOURCES ARO, AHL_RESOURCES_V ASO, MFG_LOOKUPS CB, MFG_LOOKUPS ST, MFG_LOOKUPS ACT, MFG_LOOKUPS SR, CST_ACTIVITIES CST WHERE ASO.RESOURCE_ID = ARO.ASO_RESOURCE_ID AND CST.ACTIVITY_ID (+) = ARO.ACTIVITY_ID AND SR.LOOKUP_CODE (+) = ARO.STANDARD_RATE_FLAG AND SR.LOOKUP_TYPE (+) = 'SYS_YES_NO' AND ACT.LOOKUP_CODE (+) = ARO.AUTOCHARGE_TYPE_ID AND ACT.LOOKUP_TYPE (+) = 'BOM_AUTOCHARGE_TYPE' AND ST.LOOKUP_CODE (+) = ARO.SCHEDULED_TYPE_ID AND ST.LOOKUP_TYPE (+) = 'BOM_RESOURCE_SCHEDULE_TYPE' AND CB.LOOKUP_CODE (+) = ARO.COST_BASIS_ID AND CB.LOOKUP_TYPE (+) = 'CST_BASIS'

View Text - HTML Formatted

SELECT ARO.RT_OPER_RESOURCE_ID
, ARO.OBJECT_VERSION_NUMBER
, ARO.LAST_UPDATE_DATE
, ARO.LAST_UPDATED_BY
, ARO.CREATION_DATE
, ARO.CREATED_BY
, ARO.LAST_UPDATE_LOGIN
, ARO.ASSOCIATION_TYPE_CODE
, ARO.OBJECT_ID
, ARO.ASO_RESOURCE_ID
, ASO.NAME
, ASO.DESCRIPTION
, ASO.RESOURCE_TYPE_ID
, ASO.RESOURCE_TYPE
, ARO.COST_BASIS_ID
, CB.MEANING
, ARO.SCHEDULED_TYPE_ID
, ST.MEANING
, ARO.ACTIVITY_ID
, CST.ACTIVITY
, ARO.AUTOCHARGE_TYPE_ID
, ACT.MEANING
, ARO.STANDARD_RATE_FLAG
, SR.MEANING
, ARO.QUANTITY
, ARO.DURATION
, ARO.SCHEDULE_SEQ
, ARO.ATTRIBUTE_CATEGORY
, ARO.ATTRIBUTE1
, ARO.ATTRIBUTE2
, ARO.ATTRIBUTE3
, ARO.ATTRIBUTE4
, ARO.ATTRIBUTE5
, ARO.ATTRIBUTE6
, ARO.ATTRIBUTE7
, ARO.ATTRIBUTE8
, ARO.ATTRIBUTE9
, ARO.ATTRIBUTE10
, ARO.ATTRIBUTE11
, ARO.ATTRIBUTE12
, ARO.ATTRIBUTE13
, ARO.ATTRIBUTE14
, ARO.ATTRIBUTE15
FROM AHL_RT_OPER_RESOURCES ARO
, AHL_RESOURCES_V ASO
, MFG_LOOKUPS CB
, MFG_LOOKUPS ST
, MFG_LOOKUPS ACT
, MFG_LOOKUPS SR
, CST_ACTIVITIES CST
WHERE ASO.RESOURCE_ID = ARO.ASO_RESOURCE_ID
AND CST.ACTIVITY_ID (+) = ARO.ACTIVITY_ID
AND SR.LOOKUP_CODE (+) = ARO.STANDARD_RATE_FLAG
AND SR.LOOKUP_TYPE (+) = 'SYS_YES_NO'
AND ACT.LOOKUP_CODE (+) = ARO.AUTOCHARGE_TYPE_ID
AND ACT.LOOKUP_TYPE (+) = 'BOM_AUTOCHARGE_TYPE'
AND ST.LOOKUP_CODE (+) = ARO.SCHEDULED_TYPE_ID
AND ST.LOOKUP_TYPE (+) = 'BOM_RESOURCE_SCHEDULE_TYPE'
AND CB.LOOKUP_CODE (+) = ARO.COST_BASIS_ID
AND CB.LOOKUP_TYPE (+) = 'CST_BASIS'