DBA Data[Home] [Help]

APPS.EAM_CREATEUPDATE_WO_PVT dependencies on WIP_OPERATION_RESOURCES

Line 992: FROM WIP_OPERATION_RESOURCES wor,MTL_UOM_CONVERSIONS con,BOM_RESOURCES br

988: AND woru.operation_seq_num = wor.operation_seq_num
989: AND woru.resource_seq_num = wor.resource_seq_num
990: AND woru.instance_id IS NOT NULL
991: AND woru.serial_number IS NULL) assigned_hours
992: FROM WIP_OPERATION_RESOURCES wor,MTL_UOM_CONVERSIONS con,BOM_RESOURCES br
993: WHERE wor.wip_entity_id = p_wip_entity_id
994: AND wor.resource_id = br.resource_id
995: AND br.resource_type = 2 --for person type resources only
996: AND con.uom_code = wor. uom_code