[Home] [Help]
2187: (select awo.operation_id from AHL_WORKORDER_OPERATIONS AWO
2188: where AWO.workorder_id = wo.workorder_id
2189: and awo.operation_sequence_num = WOR.OPERATION_SEQ_NUM) operation_id
2190: FROM WIP_OPERATION_RESOURCES WOR,
2191: BOM_RESOURCES BOM, MFG_LOOKUPS MFG, AHL_WORKORDERS WO
2192: WHERE WO.workorder_id = c_wo_id
2193: AND WOR.resource_id = BOM.resource_id
2194: AND WO.wip_entity_id = WOR.wip_entity_id
2195: AND MFG.LOOKUP_TYPE(+) = 'BOM_RESOURCE_TYPE'
2805: RE.ATTRIBUTE12 "Attribute12" ,
2806: RE.ATTRIBUTE13 "Attribute13" ,
2807: RE.ATTRIBUTE14 "Attribute14" ,
2808: RE.ATTRIBUTE15 "Attribute15"
2809: FROM AHL_RT_OPER_RESOURCES RE, ahl_resource_mappings ar, bom_resources br
2810: WHERE br.organization_id = ar.BOM_ORG_ID
2811: AND br.resource_id = ar.BOM_RESOURCE_ID
2812: AND br.resource_id = :1
2813: AND ar.aso_resource_id = re.aso_resource_id
7974: (select awo.operation_id from AHL_WORKORDER_OPERATIONS AWO
7975: where AWO.workorder_id = wo.workorder_id
7976: and awo.operation_sequence_num = WOR.OPERATION_SEQ_NUM) operation_id
7977: FROM WIP_OPERATION_RESOURCES WOR,
7978: BOM_RESOURCES BOM, MFG_LOOKUPS MFG, AHL_WORKORDERS WO
7979: WHERE WO.workorder_id = c_wo_id
7980: AND WOR.resource_id = BOM.resource_id
7981: AND WO.wip_entity_id = WOR.wip_entity_id
7982: AND MFG.LOOKUP_TYPE(+) = 'BOM_RESOURCE_TYPE'
8274: RE.ATTRIBUTE12 "Attribute12" ,
8275: RE.ATTRIBUTE13 "Attribute13" ,
8276: RE.ATTRIBUTE14 "Attribute14" ,
8277: RE.ATTRIBUTE15 "Attribute15"
8278: FROM AHL_RT_OPER_RESOURCES RE, ahl_resource_mappings ar, bom_resources br
8279: WHERE br.organization_id = ar.BOM_ORG_ID
8280: AND br.resource_id = ar.BOM_RESOURCE_ID
8281: AND br.resource_id = :1
8282: AND ar.aso_resource_id = re.aso_resource_id