VIEW: APPS.AHL_PP_RESRC_REQ_ASG_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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