View: AHL_PP_RESRC_REQ_ASG_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:
Implementation/DBA Data:	APPS.AHL_PP_RESRC_REQ_ASG_V

View Text

SELECT DISTINCT(BR.RESOURCE_CODE)
, FLVT.MEANING "ALT_PRIM_TYPE"
, TO_CHAR(1) "PRIORITY"
, BR.RESOURCE_ID
, BR.DESCRIPTION
, BDR.DEPARTMENT_ID
, AWO.WORKORDER_ID
, AWO.OPERATION_ID
, AWO.OPERATION_SEQUENCE_NUM
, MFGL.LOOKUP_CODE "RESOURCE_TYPE_CODE"
, MFGL.MEANING "RESOURCE_TYPE_NAME"
, BR.UNIT_OF_MEASURE UOM_CODE
, UOM.UNIT_OF_MEASURE UOM_NAME
FROM BOM_RESOURCES BR
, BOM_DEPARTMENT_RESOURCES BDR
, AHL_RESOURCE_MAPPINGS ARM
, AHL_RT_OPER_RESOURCES AROR
, AHL_WORKORDER_OPERATIONS_V AWO
, FND_LOOKUP_VALUES_VL FLVT
, MFG_LOOKUPS MFGL
, AHL_WORKORDERS_V WO
, MTL_UNITS_OF_MEASURE UOM
WHERE BR.RESOURCE_ID = BDR.RESOURCE_ID
AND BDR.RESOURCE_ID = ARM.BOM_RESOURCE_ID
AND AROR.ASO_RESOURCE_ID = ARM.ASO_RESOURCE_ID
AND AWO.OPERATION_ID = AROR.OBJECT_ID
AND AROR.ASSOCIATION_TYPE_CODE = 'OPERATION'
AND AWO.WORKORDER_ID = WO.WORKORDER_ID
AND WO.DEPARTMENT_ID = BDR.DEPARTMENT_ID
AND FLVT.LOOKUP_TYPE(+) = 'AHL_PP_RESOURCE_TYPE'
AND FLVT.LOOKUP_CODE(+) = 'PRIMARY'
AND MFGL.LOOKUP_TYPE(+) = 'BOM_RESOURCE_TYPE'
AND MFGL.LOOKUP_CODE(+) = BR.RESOURCE_TYPE
AND UOM.UOM_CODE(+) = BR.UNIT_OF_MEASURE UNION SELECT DISTINCT(BR.RESOURCE_CODE)
, FLVT.MEANING "ALT_PRIM_TYPE"
, TO_CHAR( ARR.PRIORITY) "PRIORITY"
, BR.RESOURCE_ID
, BR.DESCRIPTION
, BDR.DEPARTMENT_ID
, AWO.WORKORDER_ID
, AWO.OPERATION_ID
, AWO.OPERATION_SEQUENCE_NUM
, MFGL.LOOKUP_CODE "RESOURCE_TYPE_CODE"
, MFGL.MEANING "RESOURCE_TYPE_NAME"
, BR.UNIT_OF_MEASURE UOM_CODE
, UOM.UNIT_OF_MEASURE UOM_NAME
FROM BOM_RESOURCES BR
, BOM_DEPARTMENT_RESOURCES BDR
, AHL_RESOURCE_MAPPINGS ARM
, AHL_ALTERNATE_RESOURCES ARR
, AHL_RT_OPER_RESOURCES AROR
, AHL_WORKORDER_OPERATIONS_V AWO
, FND_LOOKUP_VALUES_VL FLVT
, MFG_LOOKUPS MFGL
, AHL_WORKORDERS_V WO
, MTL_UNITS_OF_MEASURE UOM
WHERE BR.RESOURCE_ID = BDR.RESOURCE_ID
AND BDR.RESOURCE_ID = ARM.BOM_RESOURCE_ID
AND ARR.ASO_RESOURCE_ID = ARM.ASO_RESOURCE_ID
AND ARR.RT_OPER_RESOURCE_ID = AROR.RT_OPER_RESOURCE_ID
AND AWO.OPERATION_ID = AROR.OBJECT_ID
AND AROR.ASSOCIATION_TYPE_CODE = 'OPERATION'
AND AWO.WORKORDER_ID = WO.WORKORDER_ID
AND WO.DEPARTMENT_ID = BDR.DEPARTMENT_ID
AND FLVT.LOOKUP_TYPE(+) = 'AHL_PP_RESOURCE_TYPE'
AND FLVT.LOOKUP_CODE(+) = 'ALTERNATE'
AND MFGL.LOOKUP_TYPE(+) = 'BOM_RESOURCE_TYPE'
AND MFGL.LOOKUP_CODE(+) = BR.RESOURCE_TYPE
AND UOM.UOM_CODE(+) = BR.UNIT_OF_MEASURE

Columns